Welcome, Guest
Username: Password: Remember me

TOPIC: [CLOSED] Incorrect Linux default value in SQL

Component not working in new sandbox!: 20 Aug 2015 02:06 #13387

  • jonathanbell
  • jonathanbell's Avatar
  • Offline
  • Premium Member
  • Posts: 147
  • Thank you received: 5
  • Karma: 1
When trying to test one of my components safety101 I get the following error. This error is new.

Invalid default value for 'incident' SQL=-- - 8< - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Create table : Incident Actions -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - >8 - CREATE TABLE IF NOT EXISTS `abcde_demo12153_incidentactions` ( `id` BIGINT(20) UNSIGNED NOT NULL auto_increment, `person_responsible` BIGINT(20) UNSIGNED COMMENT '240887' , `action_due_date` DATE COMMENT '240888' , `action_title` VARCHAR(255) COMMENT '240889' , `full_description` TEXT COMMENT '244511' , `action_completed_date` DATE COMMENT '240891' , `completed_yn` TINYINT COMMENT '240892' , `incident` INT DEFAULT '-2208954600' COMMENT '246581' , `incidentid` INT(11) COMMENT '250197' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='32348';

Please help, this component is an important piece of one of my service offerings.
The administrator has disabled public write access.

Component not working in new sandbox!: 20 Aug 2015 08:39 #13391

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
I answered you in other post : Here is your problem:

`incident` INT DEFAULT '-2208954600'
Coding is now a piece of cake
The administrator has disabled public write access.
Time to create page: 0.064 seconds

Get Started