Sorry, I should have been more specific. When I ran that sql file all at once, I got a blank screen in admin. So I backed up and ran the first statement in it successfully, then the second gave me a blank screen again, then the third statement ran successfully. So it's definitely that second statement, which I quoted above, that wouldn't run. And after all the other sql files were run, all successfully, and the other install steps were performed, the site front end wouldn't load, giving me a blank screen. Reverting to the Winchester template restores the test site. No other edits - of files or admin settings - have been performed yet.
Checking the logs, I see...
Code:
[11-Oct-2015 01:49:13 UTC] PHP Fatal error: 1048:Column 'configuration_group_id' cannot be null :: INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, '<font color="#0044ff">ACTIVATE Responsive Template by selecting Column Widths</font>', 'COLUMN_WIDTH', '2', 'Width of the Left and Right Columns<br />0 = Use Default Template Settings<br />1 = 75px<br />2 = 180px<br />3 = 225px',@configuration_group_id, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),'); ==> (as called by) /home/horseman/public_html/NewZC2/[admin folder]/sqlpatch.php on line 304 <== in /home/horseman/public_html/NewZC2/includes/classes/db/mysql/query_factory.php on line 155
Rob
Bookmarks