Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

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

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.

Please Log in or Create an account to join the conversation.

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

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

`incident` INT DEFAULT '-2208954600'
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.077 seconds

This is what you call a component builder. I was able to master using this in a very short time and the resulting component works like a charm. Not just a basic component builder but a fully working component builder with forms fields tables all ready to go. You can make the list and item views to display in the front and back end. Also there is a great forum just starting to evolve and I'm sure this will grow very rapidly when you all realise how good this tool is.
Kevin (JED)

         

Get Started