This time I selected yes to view full output of the installer. The following SQL errors are listed:
Code: Select all
Done!
No Schema Changes!
SQL Errors:
Array
(
[0] => Array
(
[0] => 1292
[1] => Incorrect datetime value: '0000-00-00 00:00:00' for column 'zzzsys_access_level_log_added_at' at row 1
[2] => INSERT INTO `template_zzzsys_access_level` VALUES ('nufastformlevel','FF','Fast Forms','nuhome','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00','')
)
[1] => Array
(
[0] => 1292
[1] => Incorrect datetime value: '0000-00-00 00:00:00' for column 'zzzsys_browse_log_added_at' at row 1
[2] => INSERT INTO `template_zzzsys_browse` VALUES ('5164d859900a861','nureport','Description','sre_description','','','1','sre_description',NULL,'1',30,750,'0000-00-00 00:00:00','','2014-09-24 12:40:47','globeadmin','2014-09-24 12:40:48','globeadmin'),('1459200e0c7e5b','nulevel','Code','sal_code','l','','1','sal_code','1','1',10,200,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2015-04-14 11:40:59','globeadmin'),('5269d98ab51acb5','5269ae8512ebfd3','Description','sre_description','l','',NULL,'sre_description',NULL,NULL,20,350,'2013-10-25 13:08:03','globeadmin','2014-06-23 10:15:25','globeadmin','2014-10-21 09:36:20','globeadmin'),('5164af4c1c1ff69','nuphp','Code','slp_code','','','1','slp_code',NULL,'1',10,150,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2013-11-08 11:19:18','globeadmin'),('51678957453334b','nurunphp','Group','slp_group','','','1','slp_group',NULL,'1',30,200,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('1455245046b9fz','nuobject','Type','sob_all_type','l','','1','sob_all_type','1','1',40,90,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-02-05 10:30:57','globeadmin'),('51678705c49ea7f','nurunphp','Code','slp_code','','','1','slp_code',NULL,'1',10,150,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('1455245046b9fd','nuobject','Field Name','sob_all_name','l','','1','sob_all_name','1','1',20,200,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-02-05 10:30:57','globeadmin'),('1487ae96ca1b0f','nuobject','fid','sob_zzzsys_form_id','l','','1','form_id',NULL,'0',111,1,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-02-05 10:30:58','globeadmin'),('5164dfff1e25e91','nureport','PHP Description','slp_description','','','1','slp_description',NULL,'1',40,250,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-09-24 12:40:48','globeadmin'),('51678e2f28e6c6b','nurunreport','Code','sre_code','','','1','sre_code',NULL,'1',10,150,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-09-24 12:40:23','globeadmin'),('14575f7c3aad70','nuobject','Tab','sob_all_tab_number','c','','1','sob_all_tab_number','1','1',70,90,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-02-05 10:30:58','globeadmin'),('145935537761ee','nuuser','User Group','sug_code','l','','1','sug_code','1','1',20,300,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('1502303e4b43aa','nutranslate','Language','trl_language','l','','1','trl_language',NULL,'1',10,100,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('5269ea1a1ca5a58','nudebug','Added','deb_added','l','6',NULL,'deb_added',NULL,NULL,10,100,'2013-10-25 14:18:42','globeadmin','2013-10-25 14:20:41','globeadmin','2014-01-10 13:05:23','globeadmin'),('5164d44fa4daaad','nureport','Code','sre_code','','','1','sre_code',NULL,'1',10,200,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-09-24 12:40:47','globeadmin'),('1455393203f209','nuform','Table','sfo_table','l','','1','sfo_table','1','1',30,300,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2015-04-14 11:42:50','globeadmin'),('1459354088ccef','nuuser','Name','sus_name','l','','1','sus_name','1','1',10,300,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('1502303e4b57df','nutranslate','English','trl_english','l','','1','trl_english',NULL,'1',20,450,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('5164af4c21a5c00','nuphp','Group','slp_group','','','1','slp_group',NULL,'1',30,200,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2013-11-08 11:19:18','globeadmin'),('51661887c9dae99','nuformsandsubforms','Description','thedesc','','','1','thedesc',NULL,'1',20,250,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2013-10-10 14:10:12','globeadmin'),('5164df2fe66185c','nureport','Group','sre_group','','','1','sre_group',NULL,'1',20,200,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-09-24 12:40:47','globeadmin'),('52f440e9d0a6ebf','nunoaccess','Title','sfo_title','l',NULL,NULL,'sfo_title',NULL,NULL,20,300,'2014-02-07 13:11:53','globeadmin','2014-02-07 13:11:53','globeadmin','2014-02-07 14:06:07','globeadmin'),('5269d98acc454c4','5269ae8512ebfd3','Group','sre_group','l','',NULL,'sre_group',NULL,NULL,30,250,'2013-10-25 13:08:03','globeadmin','2013-10-25 13:08:03','globeadmin','2014-10-21 09:36:20','globeadmin'),('52f440e9cd1e25c','nunoaccess','Code','sfo_name','l',NULL,NULL,'sfo_name',NULL,NULL,10,300,'2014-02-07 13:11:53','globeadmin','2014-02-07 13:11:53','globeadmin','2014-02-07 14:06:07','globeadmin'),('51661887c6fe74e','nuformsandsubforms','Name','thecode','','','1','thecode',NULL,'1',10,150,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2013-10-10 14:10:12','globeadmin'),('54ffbe3eeab22dd','nufastform','Description','sfo_title','l',NULL,NULL,'sfo_title',NULL,NULL,20,300,'2015-03-11 14:32:06','globeadmin','2015-03-16 14:49:14','globeadmin','2015-04-15 12:04:02','globeadmin'),('1455245046b9ff','nuobject','Tab Title','sob_all_tab_title','l','','1','sob_all_tab_title','1','1',50,100,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-02-05 10:30:57','globeadmin'),('1472e8ca61083f','nuimage','Code','sfi_code','l','','1','sfi_code','1','1',10,100,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-01-17 13:36:18','globeadmin'),('51678957425d78f','nurunphp','Description','slp_description','','','1','slp_description',NULL,'1',20,500,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52f440e9d60d3e9','nunoaccess','Table','sfo_table','l',NULL,NULL,'sfo_table',NULL,NULL,30,300,'2014-02-07 13:11:53','globeadmin','2014-02-07 13:11:53','globeadmin','2014-02-07 14:06:07','globeadmin'),('1459200e0c810b','nulevel','Description','sal_description','l','','1','sal_description','1','1',20,300,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2015-04-14 11:40:59','globeadmin'),('14624594549f6d','nugroup','Access Level','sal_description','l','','1','sal_description','1','1',30,300,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2013-10-22 14:59:13','globeadmin'),('51678e2f2e9396c','nurunreport','Group','sre_group','','','1','sre_group',NULL,'1',30,200,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-09-24 12:40:23','globeadmin'),('14575d67f6e508','nuobject','Column','sob_all_column_number','c','','1','sob_all_column_number','1','1',80,90,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-02-05 10:30:58','globeadmin'),('5269ea1a33db4c6','nudebug','Time','SUBSTR(deb_added,11,9)','l','',NULL,'SUBSTR(deb_added,11,9)',NULL,NULL,20,100,'2013-10-25 14:18:42','globeadmin','2013-10-25 14:20:41','globeadmin','2014-01-10 13:05:23','globeadmin'),('1472e8ca611470','nuimage','Description','sfi_description','l','','1','sfi_description','1','1',20,300,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-01-17 13:36:18','globeadmin'),('521aa4a50c3e360','nudebug','Message','deb_message','l',NULL,NULL,'deb_message',NULL,NULL,30,500,'0000-00-00 00:00:00','','2013-10-25 14:20:41','globeadmin','2014-01-10 13:05:23','globeadmin'),('14589b1adedddc','nuform','Name','sfo_name','l','','1','sfo_name','1','1',10,300,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2015-04-14 11:42:50','globeadmin'),('1455245046b9fe','nuobject','Order','sob_all_order_number','c','','1','sob_all_order_number','1','1',90,90,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-02-05 10:30:58','globeadmin'),('147312293cf2e2','nuimage','Group','sfi_group','l','','1','sfi_group','1','1',30,200,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-01-17 13:36:18','globeadmin'),('1455393203f20c','nuobject','Title','sob_all_title','l','','1','sob_all_title','1','1',30,240,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-02-05 10:30:57','globeadmin'),('145934f0f1a899','nugroup','Description','sug_description','l','','1','sug_description','1','1',20,400,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2013-10-22 14:59:13','globeadmin'),('14624598331c6a','nuuser','Access Level','sal_description','l','','1','sal_description','1','1',30,300,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('514b90e7ac33aef','nuobject','Form','form_name','l','','1','form_name',NULL,'1',10,250,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2014-02-05 10:30:57','globeadmin'),('1502303e4b6c07','nutranslate','Translation','trl_translation','l','','1','trl_translation',NULL,'1',30,450,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('145934bea29f5d','nugroup','Name','sug_code','l','','1','sug_code','1','1',10,300,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2013-10-22 14:59:13','globeadmin'),('5164af4c1ee805b','nuphp','Description','slp_description','','','1','slp_description',NULL,'1',20,600,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2013-11-08 11:19:18','globeadmin'),('54ffbe3ee418f7a','nufastform','Code','sfo_name','l',NULL,NULL,'sfo_name',NULL,NULL,10,150,'2015-03-11 14:32:06','globeadmin','2015-03-11 14:32:06','globeadmin','2015-04-15 12:04:02','globeadmin'),('1455393203f208','nuform','Title','sfo_title','l','','1','sfo_title','1','1',20,300,'0000-00-00 00:00:00','','0000-00-00 00:00:00','','2015-04-14 11:42:50','globeadmin'),('5269d98a9d3e17b','5269ae8512ebfd3','Code','sre_code','l',NULL,NULL,'sre_code',NULL,NULL,10,150,'2013-10-25 13:08:02','globeadmin','2013-10-25 13:08:03','globeadmin','2014-10-21 09:36:20','globeadmin'),('51678e2f2bc0e29','nurunreport','Description','sre_description','','','0','sre_description',NULL,'1',20,700,'0000-00-00 00:00:00','','2014-09-24 12:40:23','globeadmin','2014-09-24 12:40:23','globeadmin')
)
[2] => Array
(
[0] => 1292
[1] => Incorrect datetime value: '0000-00-00 00:00:00' for column 'zzzsys_event_log_added_at' at row 1
[2] => INSERT INTO `template_zzzsys_event` VALUES ('542b88536f19d87','5164b0fcc6e8515','ondblclick','nuOpenAce(\"PHP\", this.id, \"PHP Code\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('542b88536cb4132','537d4266d97ca33','ondblclick','nuOpenAce(\"SQL\", this.id, \"\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('545ad9ff30910d2','545ad8a397d734d','onclick','window.nuControlKey=true;nuOpenForm($(\'#sal_zzzsys_form_id\').val(), \'-1\', $(\'#sal_zzzsys_form_id\').val(), \'-1\', \'Home Form\');window.nuControlKey=false;','2014-11-06 12:46:31','globeadmin','2014-11-06 12:50:19','globeadmin','2014-11-06 12:51:42','globeadmin'),('52e993b3a5b7624','52e1cd8771f75fd','onchange','$(\'#fw_form_title\').val($(\'option:selected\', $(this)).attr(\'nu_ed_title\'));\n$(\'#fw_form_width\').val($(\'option:selected\', $(this)).attr(\'nu_ed_width\'));\n$(\'#fw_form_lookup\').val($(\'option:selected\', $(this)).attr(\'nu_lookup\'));\n\n$(\'#fw_form_lookup\').change();\n','2014-01-30 10:50:11','globeadmin','2014-02-06 15:02:04','globeadmin','2014-02-06 15:28:39','globeadmin'),('542b885369aa18a','5186d40c2a32069','ondblclick','nuOpenAce(\"SQL\", this.id, \"\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('542b88537077b9a','1455245046ba67','ondblclick','nuOpenAce(\"HTML\", this.id, \"HTML Code\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52f300034c5c21e','52f2f869865117b','onchange','$(\"select option:selected\").attr(\'nu_lookup_code\', $(\'#fw_code_field\').val());','2014-02-06 14:22:43','globeadmin','2014-02-06 14:22:43','globeadmin','2014-02-06 15:36:30','globeadmin'),('542b88536884bff','1455245046ba15','ondblclick','nuOpenAce(\"SQL\", this.id, \"Display Object Condition\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('542b885368e1802','145787f999fb2e','ondblclick','nuOpenAce(\"SQL\", this.id, \"Button Display Condition\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('542b88536d58c7e','146bc0d39135da','ondblclick','nuOpenAce(\"PHP\", this.id, \"Before Browse\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52f309795235cd1','52f2f8ca88a7888','onchange','$(\"select option:selected\").attr(\'nu_lookup_description\', $(\'#fw_description_field\').val());','2014-02-06 15:03:05','globeadmin','2014-02-06 15:03:05','globeadmin','2014-02-06 15:03:05','globeadmin'),('52e1fe0088d891f','52e1d83f5e35df5','onclick','$(\'#fw_table_listbox option:selected\').each( function() {\n if( $(\'#fw_browse_listbox option[nu_bw_title=\"\'+$(this).attr(\'nuTitle\')+\'\"]\').length === 0 ) {\n $(\'#fw_browse_listbox\').append(\"\");\n }\n});','2014-01-24 16:45:36','globeadmin','2014-01-31 09:48:37','globeadmin','2014-02-20 09:41:46','globeadmin'),('542b88536e23ac5','14580c11db5271','ondblclick','nuOpenAce(\"PHP\", this.id, \"After Save\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('51ad723caea1dbe','145d3d46168a33','onblur','if(Number(this.value) < 1){alert(\'Must be Over 1 Minute\');this.focus();}','0000-00-00 00:00:00','','0000-00-00 00:00:00','','2013-11-12 13:03:13','globeadmin'),('522025e89afabb3','522025e88174a00','onclick','nuOpenFormInFrame(\'nuphp\',$(\'#sre_zzzsys_php_id\').val(), \'PHP Code\')','0000-00-00 00:00:00','','2014-02-05 11:04:36','globeadmin','2014-02-05 11:04:36','globeadmin'),('542b88536b92a57','1455245046ba87','ondblclick','nuOpenAce(\"SQL\", this.id, \"\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('542b88536687889','145773a500ebd8','ondblclick','nuOpenAce(\"SQL\", this.id, \"Save Button Display Condition\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('54ffad929659858','54ffad928488d6e','onclick','nuFastFormObject(this);','2015-03-11 13:20:58','globeadmin','2015-03-16 14:08:01','globeadmin','2015-03-23 11:57:47','globeadmin'),('542b8853682057d','decafc0ffee003','ondblclick','nuOpenAce(\"SQL\", this.id, \"Print Button Display Condition\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52e1e232212e7fc','52e1d7bbc29ca2c','onchange','fetch_columns();\nvar table = $(\'#fw_table_name\').val();\n\n$(\"select[id$=\'listbox\']\").empty();\n$(\"input[id$=\'title\'], input[id$=\'width\'], input[id$=\'lookup\']\").val(\'\');\nvar column_length = window.columns.length;\n\nvar titleList = new Array();\nfor(var i = 0; i < column_length; i++) {\n if( window.columns[i][0] == table && window.columns[i][2] != \"PRI\" ) {\n titleList.push(window.columns[i][1]);\n } \n}\n\n\n\n\nfor(var idx = 0; idx < column_length; idx++) {\n var width = (window.columns[idx][6] == \'\' ) ? window.columns[idx][5] : window.columns[idx][6];\n width = Math.ceil(width*2.5);\n \n if( width <= 125 ) {\n width = 100;\n }\n else if( width > 125 && width <= 175 ) {\n width = 150;\n }\n else if( width > 175 && width <= 225 ) {\n width = 200;\n }\n else if( width > 225 && width <= 275 ) {\n width = 250;\n }\n else {\n width = 300;\n }\n \n \n \n if( window.columns[idx][0] == table && window.columns[idx][2] != \"PRI\") {\n console.log(idx);\n console.log(window.columns[idx][1]);\n var title = nuFieldTitle(window.columns[idx][1], titleList);\n $(\'#fw_table_listbox\').append(\"\");\n }\n else if (window.columns[idx][0] == table && window.columns[idx][2] == \"PRI\") {\n $(\'#fw_hidden_primary\').val(window.columns[idx][1]);\n }\n}\n','2014-01-24 14:46:58','globeadmin','2014-02-11 13:58:52','globeadmin','2014-02-20 10:41:39','globeadmin'),('542b88536d0b1e8','14b171429ee70d','ondblclick','nuOpenAce(\"PHP\", this.id, \"Before Save\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('542b88536f629a2','14580c19159999','ondblclick','nuOpenAce(\"Javascript\", this.id, \"Form Javascript\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('51c3cb0b084a86b','51678f239d70019','onclick','window.open(\'nureportbuilder.php\');','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('526d9c4829d58cf','1455245046ba36','onchange','nuHideTabs();','2013-10-28 09:35:44','globeadmin','2014-02-10 14:55:33','globeadmin','2014-02-10 14:55:33','globeadmin'),('52e1fcf3b9704df','52e1d823b7e73e1','onclick','$(\'#fw_table_listbox option:selected\').each( function() {\n if( $(\'#fw_form_listbox option[nu_ed_title=\"\'+$(this).attr(\'nuTitle\')+\'\"]\').length === 0 ) {\n $(\'#fw_form_listbox\').append(\"\");\n }\n});','2014-01-24 16:41:07','globeadmin','2014-02-06 14:15:20','globeadmin','2014-02-11 09:53:45','globeadmin'),('52eb2bb51da6241','52eb2bb50ee12a7','onchange','$(\'#sfw_form_title\').val($(\'option:selected\', $(this)).attr(\'nu_ed_title\'));\n$(\'#sfw_form_width\').val($(\'option:selected\', $(this)).attr(\'nu_ed_width\'));\n$(\'#sfw_form_lookup\').val($(\'option:selected\', $(this)).attr(\'nu_lookup\'));\n$(\'#sfw_form_lookup\').change();','2014-01-31 15:51:01','globeadmin','2014-02-06 15:29:05','globeadmin','2014-02-06 15:40:31','globeadmin'),('542b8853703a40a','145787f625367a','ondblclick','nuOpenAce(\"Javascript\", this.id, \"Button Javascript\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('53bce0521a5b0c9','53bce051e2777b4','onclick','loadUpdater();','2014-07-09 16:25:22','globeadmin','2014-07-09 16:25:22','globeadmin','2014-07-09 16:25:33','globeadmin'),('542b88536945c9e','14575e368d59f9','ondblclick','nuOpenAce(\"SQL\", this.id, \"Form SQL\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('542b88536da5268','14580c083db4cb','ondblclick','nuOpenAce(\"PHP\", this.id, \"Before Open\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52eb2bcf9fd4193','52eb2bcf8e9043d','onchange','var width = $(\'#sfw_form_width\').val();\nwidth = (width > 300) ? 300 : width;\n$(\'#sfw_form_width\').val(width);\n$(\'#sfw_form_listbox option:selected\').each(function() {\n $(this).attr(\'nu_ed_width\',width);\n});','2014-01-31 15:51:27','globeadmin','2014-02-11 10:08:24','globeadmin','2014-02-11 10:08:25','globeadmin'),('5164d542dc3c65a','1455245046c006','onblur','nuPopulateSort(this);','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52eb2be115838cb','52eb2be10a06e51','onclick','$(\'#fw_form_listbox option:selected\').each(function() {\n $(this).remove()\n});\n$(\'#fw_form_title\').val(\'\');\n$(\'#fw_form_width\').val(\'\');\n$(\'#fw_form_lookup\').val(\'\');\n$(\'#fw_form_lookup\').change();','2014-01-31 15:51:45','globeadmin','2014-02-11 13:06:35','globeadmin','2014-02-11 13:06:35','globeadmin'),('52eec5635165b18','52eec5634507ad5','onchange','fetch_columns();\nvar table = $(\'#sfw_table_name\').val();\n\n$(\"select[id$=\'listbox\']\").empty();\n$(\"input[id$=\'title\'], input[id$=\'width\']\").val(\'\');\nvar column_length = window.columns.length;\n\nfor(var idx = 0; idx < column_length; idx++) {\n var width = (window.columns[idx][6] == \'\' ) ? window.columns[idx][5] : window.columns[idx][6];\n width = Math.ceil(width*2.5);\n if( width == 0 ) {\n width = \'100\';\n }\n if( window.columns[idx][0] == table && window.columns[idx][2] != \"PRI\") {\n $(\'#sfw_table_listbox\').append(\"\");\n }\n}','2014-02-03 09:23:31','globeadmin','2014-02-03 09:23:31','globeadmin','2014-02-03 14:00:44','globeadmin'),('542b88536c55120','1455245046bfb5','ondblclick','nuOpenAce(\"SQL\", this.id, \"\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52e1f5d8b7c0f19','52e1d6b61a8c8cd','onclick','selectAll(\'fw_browse_listbox\');\n$(\'#fw_browse_listbox\').focus();','2014-01-24 16:10:48','globeadmin','2014-01-30 11:22:59','globeadmin','2014-02-06 09:45:10','globeadmin'),('52e8773f37e8b05','52e86699bf261e8','onchange','$(\'#fw_browse_listbox option:selected\').each(function() {\n $(this).attr(\'nu_bw_title\', $(\'#fw_browse_title\').val());\n});','2014-01-29 14:36:31','globeadmin','2014-01-29 15:16:03','globeadmin','2014-02-06 09:49:45','globeadmin'),('52eb2bb530b39a4','52eb2bb50ee12a7','onkeyup','if(event.which === 46 ) {\n $(\'option:selected\', $(this)).remove();\n $(this).change();\n}','2014-01-31 15:51:01','globeadmin','2014-01-31 15:51:01','globeadmin','2014-02-06 15:40:31','globeadmin'),('52e992fc76f9a42','52e1d895e6fd1c0','onchange','$(\'#fw_browse_title\').val($(\'option:selected\', $(this)).attr(\'nu_bw_title\'));\n$(\'#fw_browse_width\').val($(\'option:selected\', $(this)).attr(\'nu_bw_width\'));\n','2014-01-30 10:47:08','globeadmin','2014-01-30 11:21:46','globeadmin','2014-02-06 09:49:19','globeadmin'),('530aa199ebad5b2','15087459201b94','onclick','nuRunPHP(\'TESTEMAIL\');','2014-02-24 12:34:17','globeadmin','2014-02-24 12:51:35','globeadmin','2014-02-24 12:51:36','globeadmin'),('520427b0487ce90','520421ea5f5cfc9','onClick','captureImageClip();','0000-00-00 00:00:00','','0000-00-00 00:00:00','','2013-12-30 13:24:08','globeadmin'),('52eb2b82419ba8d','52eb2b822843d25','onclick','$(\'#sfw_table_listbox option:selected\').each( function() {\n if( $(\'#sfw_form_listbox option[nu_ed_title=\"\'+$(this).attr(\'nuTitle\')+\'\"]\').length === 0 ) {\n $(\'#sfw_form_listbox\').append(\"\");\n }\n});','2014-01-31 15:50:10','globeadmin','2014-02-06 15:31:21','globeadmin','2014-02-07 09:26:42','globeadmin'),('54ffa1a24ebf8a4','54ffa1a22a1b5de','onclick','nuFastFormForm();','2015-03-11 12:30:02','globeadmin','2015-03-16 14:16:38','globeadmin','2015-03-30 10:53:13','globeadmin'),('542b88536e9a062','542b41a007a0d02','ondblclick','nuOpenAce(\"PHP\", this.id, \"Before Delete\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52eb2bc0f0859b8','52eb2bc0e407dcc','onchange','$(\'#sfw_form_listbox option:selected\').each(function() {\n $(this).attr(\'nu_ed_title\', $(\'#sfw_form_title\').val());\n});','2014-01-31 15:51:13','globeadmin','2014-02-11 10:08:41','globeadmin','2014-02-11 10:08:41','globeadmin'),('52e999db414516c','52e1d895e6fd1c0','onkeyup','if(event.which === 46 ) {\n $(\'option:selected\', $(this)).remove();\n $(this).change();\n}','2014-01-30 11:16:27','globeadmin','2014-01-30 11:21:46','globeadmin','2014-02-06 09:49:19','globeadmin'),('52818c8420c2c7d','52818c84074eb82','onblur','if(Number(this.value) < 1){alert(\'Must be Over 1 Minute\');this.focus();}','2013-11-12 13:03:48','globeadmin','2013-11-12 13:03:48','globeadmin','2013-11-12 14:44:48','globeadmin'),('52eb2afb7e3a3de','52eb2afb7363ada','onclick','selectAll(\'sfw_table_listbox\');','2014-01-31 15:47:55','globeadmin','2014-01-31 16:06:14','globeadmin','2014-02-07 09:25:49','globeadmin'),('542b88536ffb790','525b1a7d7714972','ondblclick','nuOpenAce(\"Javascript\", this.id, \"Lookup Javascript\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52e877fb99ec063','52e866facf32940','onchange','var width = $(\'#fw_browse_width\').val();\nwidth = (width > 300) ? 300 : width;\n$(\'#fw_browse_width\').val(width); \n\n$(\'#fw_browse_listbox option:selected\').each(function() {\n $(this).attr(\'nu_bw_width\', width);\n});','2014-01-29 14:39:39','globeadmin','2014-02-11 09:49:54','globeadmin','2014-02-11 09:49:54','globeadmin'),('52e87d227886d41','52e87d2262e7976','onchange','$(\'#fw_form_listbox option:selected\').each(function() {\n $(this).attr(\'nu_ed_title\', $(\'#fw_form_title\').val());\n});','2014-01-29 15:01:38','globeadmin','2014-01-29 15:16:30','globeadmin','2014-02-06 10:19:53','globeadmin'),('542b885366ef498','145773ab7798d4','ondblclick','nuOpenAce(\"SQL\", this.id, \"Delete Button Display Condition\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52eb2b9d48f101e','52eb2b9d3b96d77','onclick','selectAll(\'sfw_form_listbox\');\n$(\'#sfw_form_listbox\').focus();','2014-01-31 15:50:37','globeadmin','2014-01-31 16:08:09','globeadmin','2014-02-07 09:26:06','globeadmin'),('542b8853675862f','145773ba26e1b9','ondblclick','nuOpenAce(\"SQL\", this.id, \"Clone Button Display Condition\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('551897918632c0d','5518979176fd7ad','onclick','nuFastFormFormView();','2015-03-30 10:53:45','globeadmin','2015-04-15 12:02:23','globeadmin','2015-04-15 12:04:13','globeadmin'),('52eb2aec7108cdf','52eb2aec64b5abd','onchange','fetch_columns();\r\n\r\nvar table = $(\'#sfw_table_name\').val();\r\n\r\n$(\"select[id$=\'listbox\']\").empty();\r\n$(\"#sfw_foreign_key\").empty();\r\n$(\"input[id$=\'title\'], input[id$=\'width\'], input[id$=\'lookup\']\").val(\'\');\r\nvar column_length = window.columns.length;\r\n\r\nvar titleList = new Array();\r\nfor(var i = 0; i < column_length; i++) {\r\n if( window.columns[i][0] == table && window.columns[i][2] != \"PRI\" ) {\r\n titleList.push(window.columns[i][1]);\r\n } \r\n}\r\n\r\n\r\n\r\n$(\'#sfw_foreign_key\').append(\"\");\r\n\r\nfor(var idx = 0; idx < column_length; idx++) {\r\n var width = (window.columns[idx][6] == \'\' ) ? window.columns[idx][5] : window.columns[idx][6];\r\n width = Math.ceil(width*2.5);\r\n \r\n if( width <= 125 ) {\r\n width = 100;\r\n }\r\n else if( width > 125 && width <= 175 ) {\r\n width = 150;\r\n }\r\n else if( width > 175 && width <= 225 ) {\r\n width = 200;\r\n }\r\n else if( width > 225 && width <= 275 ) {\r\n width = 250;\r\n }\r\n else {\r\n width = 300;\r\n }\r\n \r\n \r\n \r\n if( window.columns[idx][0] == table && window.columns[idx][2] != \"PRI\") {\r\n console.log(idx);\r\n console.log(window.columns[idx][1]);\r\n var title = nuFieldTitle(window.columns[idx][1], titleList);\r\n $(\'#sfw_table_listbox\').append(\"\");\r\n $(\'#sfw_foreign_key\').append(\"\");\r\n }\r\n else if (window.columns[idx][0] == table && window.columns[idx][2] == \"PRI\") {\r\n $(\'#sfw_hidden_primary\').val(window.columns[idx][1]);\r\n }\r\n}\r\n','2014-01-31 15:47:40','globeadmin','2014-02-11 13:58:37','globeadmin','2014-02-11 13:58:38','globeadmin'),('542b88536a9b92e','1455245046ba4c','ondblclick','nuOpenAce(\"SQL\", this.id, \"\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('542b8853662339b','1457739571a2f3','ondblclick','nuOpenAce(\"SQL\", this.id, \"Add Button Display Condition\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52e6f19d79b9777','52e6e3db34cf668','onclick','var selected = $(\'#fw_form_listbox option:selected\');\n\nif(selected.length === 1 && selected.is(\':not(:first-child)\') ) {\n var before = selected[0].index - 1;\n selected.insertBefore($(\'#fw_form_listbox option:eq(\'+before+\')\'));\n}','2014-01-28 10:54:05','globeadmin','2014-01-28 10:54:05','globeadmin','2014-02-11 10:21:02','globeadmin'),('542b88536a215a5','516340b344b54b4','ondblclick','nuOpenAce(\"SQL\", this.id, \"Default Value\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('542b885367be798','145beab28ce1bb','ondblclick','nuOpenAce(\"SQL\", this.id, \"New Button Display Condition\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52e6f5a7b18688b','52e6f46bb695a82','onclick','$(\'#fw_browse_listbox option:selected\').each(function() {\n $(this).remove()\n});\n$(\'#fw_browse_title\').val(\'\');\n$(\'#fw_browse_width\').val(\'\');','2014-01-28 11:11:19','globeadmin','2014-02-11 13:07:23','globeadmin','2014-02-11 13:07:23','globeadmin'),('phpMyAdminevt','phpMyAdminbtn','onClick','window.open(\"nupmalogin.php?sessid=#session_id#\");','2014-06-27 10:37:31','globeadmin','2014-06-27 10:37:31','globeadmin','2014-07-15 13:32:12','globeadmin'),('52e1f6159c7ef91','52e1d6c72bec014','onclick','selectAll(\'fw_form_listbox\');\n$(\'#fw_form_listbox\').focus();','2014-01-24 16:11:49','globeadmin','2014-01-30 11:24:04','globeadmin','2014-02-06 09:52:56','globeadmin'),('52f3119171d02f5','52f30e3b96640a4','onchange','$(\"#sfw_form_listbox option:selected\").attr(\'nu_lookup_description\', $(\'#sfw_description_field\').val());','2014-02-06 15:37:37','globeadmin','2014-02-06 15:39:28','globeadmin','2014-02-06 15:39:28','globeadmin'),('542b885370b728c','51db33e43a91032','ondblclick','nuOpenAce(\"HTML\", this.id, \"Header\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('542b88536fb06c5','515223cfd1c36e2','ondblclick','nuOpenAce(\"Javascript\", this.id, \"Event Javascript\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('542b88536b1e758','1455245046ba5e','ondblclick','nuOpenAce(\"SQL\", this.id, \"\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('52f310e337835f5','52f30df94b69637','onchange','$(\"#sfw_form_listbox option:selected\").attr(\'nu_lookup_code\', $(\'#sfw_code_field\').val());','2014-02-06 15:34:43','globeadmin','2014-02-06 15:38:22','globeadmin','2014-02-06 15:38:22','globeadmin'),('52ef266d89d8a8a','52ef2592bc39a21','onclick','var selected = $(\'#sfw_form_listbox option:selected\');\n\nif( selected.length === 1 && selected.is(\':not(:last-child)\') ) {\n var after = selected[0].index + 1;\n selected.insertAfter($(\'#sfw_form_listbox option:eq(\'+after+\')\'));\n}','2014-02-03 16:17:33','globeadmin','2014-02-03 16:17:33','globeadmin','2014-02-11 10:21:31','globeadmin'),('52e87d7b7cf0424','52e87d7b7100d14','onchange','var width = $(\'#fw_form_width\').val();\nwidth = (width > 300) ? 300 : width;\n$(\'#fw_form_width\').val(width);\n\n$(\'#fw_form_listbox option:selected\').each(function() {\n $(this).attr(\'nu_ed_width\', width);\n});','2014-01-29 15:03:07','globeadmin','2014-02-11 09:51:02','globeadmin','2014-02-11 09:51:02','globeadmin'),('52e1f5be868c8d0','52e1d677888a8c8','onclick','selectAll(\'fw_table_listbox\');','2014-01-24 16:10:22','globeadmin','2014-01-24 16:11:12','globeadmin','2014-02-06 09:45:56','globeadmin'),('552dcd64bb1a94e','552dcd64ad5bf49','onclick','nuFastFormBrowseView();','2015-04-15 12:01:00','globeadmin','2015-04-15 12:02:39','globeadmin','2015-04-15 12:02:39','globeadmin'),('52e99b8b3de6ea3','52e1cd8771f75fd','onkeyup','if(event.which === 46 ) {\n $(\'option:selected\', $(this)).remove();\n $(this).change();\n}','2014-01-30 11:23:39','globeadmin','2014-01-30 11:23:39','globeadmin','2014-02-06 15:28:40','globeadmin'),('52e6f55b15d8c85','52e6f4bf935ab8d','onclick','$(\'#sfw_form_listbox option:selected\').each(function() {\n $(this).remove()\n});\n$(\'#sfw_form_title\').val(\'\');\n$(\'#sfw_form_width\').val(\'\');\n$(\'#sfw_form_lookup\').val(\'\');\n$(\'#sfw_form_lookup\').change();','2014-01-28 11:10:03','globeadmin','2014-02-11 13:09:20','globeadmin','2014-02-11 13:09:21','globeadmin'),('52ef264fc68ea31','52ef2584e7b33c3','onclick','var selected = $(\'#sfw_form_listbox option:selected\');\n\nif(selected.length === 1 && selected.is(\':not(:first-child)\') ) {\n var before = selected[0].index - 1;\n selected.insertBefore($(\'#sfw_form_listbox option:eq(\'+before+\')\'));\n}','2014-02-03 16:17:03','globeadmin','2014-02-03 16:17:03','globeadmin','2014-02-11 10:21:16','globeadmin'),('552dd635973ae30','552dd5e743157ed','onclick','alert(\'Coming Soon!\');','2015-04-15 12:38:37','globeadmin','2015-04-15 12:38:37','globeadmin','2015-04-15 12:38:37','globeadmin'),('542b88536ed92bc','1455245046bab3','ondblclick','nuOpenAce(\"PHP\", this.id, \"Lookup PHP\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00',''),('542b88536e600a8','14580c12e28024','ondblclick','nuOpenAce(\"PHP\", this.id, \"After Delete\");','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00','')
)
[3] => Array
(
[0] => 1292
[1] => Incorrect datetime value: '0000-00-00 00:00:00' for column 'zzzsys_setup_log_added_at' at row 1
[2] => INSERT INTO `template_zzzsys_setup` VALUES ('1','NOT USED DELETED THIS FIELD',120,'Australia/Adelaide','','','','','',0,'','','','\n\n\n\n\n','nu%','','','0000-00-00 00:00:00','','2014-11-06 13:18:22','globeadmin','2015-06-09 12:35:32','globeadmin'),('default','NOT USED DELETED THIS FIELD',120,'Australia/Adelaide','','','','','',0,'','','','\n\n\n\n\n','nu%','','','0000-00-00 00:00:00','','2014-11-06 13:18:22','globeadmin','2015-06-09 12:35:32','globeadmin')
)
[4] => Array
(
[0] => 1292
[1] => Incorrect datetime value: '0000-00-00 00:00:00' for column 'zzzsys_user_group_log_added_at' at row 1
[2] => INSERT INTO `template_zzzsys_user_group` VALUES ('nufastformgroup','FF','Fast Form Group','nufastformlevel','0000-00-00 00:00:00','','0000-00-00 00:00:00','','0000-00-00 00:00:00','')
)
)
Any help would be appreciated.