Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

OS X Local Install - Blank Screen

Post Reply
tomw
Posts: 3
Joined: Mon Feb 22, 2016 7:00 pm

OS X Local Install - Blank Screen

Unread post by tomw »

I followed the instructions for getting Apache, MySQL, PHP and phpMyAdmin working on OSX 10.11 El Capitan found here:
http://coolestguidesontheplanet.com/get ... l-capitan/

Verified that myPhpAdmin is working.
Started mysql server.

Followed the nuBuilder installation instructions here:
https://www.nubuilder.net/downloads.php

After logging in as globeadmin, I have a blank screen using both Safari and Chrome with popup blocking turned off.

I've searched through forum posts here for "blank screen" for possible answers.

Any suggestions?

Thanks,
Tom
tomw
Posts: 3
Joined: Mon Feb 22, 2016 7:00 pm

Re: OS X Local Install - Blank Screen

Unread post by tomw »

I installed again according to the instructions here:
https://www.nubuilder.net/downloads.php

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.

Thanks,
Tom
tomw
Posts: 3
Joined: Mon Feb 22, 2016 7:00 pm

Re: OS X Local Install - Blank Screen

Unread post by tomw »

This is resolved now.

Copied my-default.cnf from /usr/local/mysql-5.7.9-osx10.9-x86/support-files to /etc/my.cnf
Changed line
from: sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
to: set sql-mode=NO_ENGINE_SUBSTITUTION

Changed permissions to read only.

Modified /etc/php.ini
Added timezone:
date.timezone = "America/Los Angeles"

Restarted mysql server.
Deleted nuBuilder table in phpmyadmin
Created a new nuBuilder table
re-ran the nuBuilder Pro Schema installer. No errors this time!

Able to login and start working on my nuBuilder Pro project.

Tom
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: OS X Local Install - Blank Screen

Unread post by admin »

.
gmonge
Posts: 1
Joined: Thu Feb 23, 2017 1:10 pm

Re: OS X Local Install - Blank Screen

Unread post by gmonge »

Tom:

Thanks for your post !!!
I have been for more than a week, trying to solve the same problem.
Today I just accomplish the installation process.

My last fight was trying to get ride of the strict mode.
Initially I changed my.cnf in the support-files directory, but mysql was just ignoring all the changes.

Then I copied the modified my.cnf file to the /etc/directory, following your instructions,
restarted the server and then re-installed nubuilder,
and everything went well.

For any other reader, there is also another post for the MacOs Sierra as well, presented by the same author.

Once again, Thanks

Gustavo Monge
Post Reply