Tried to upgrade again after running this sql of Dr. Bytes and have these errors from store Log to report below.
Appears to be similar and with no sign of AUTO_INCREMENT showing up in the EXTRA column in database Structure has me wondering if anything really happened.
Code:
---------------
Apr 15 2018 19:22 -- upgradeException
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Telephone - Customer Service', 'STORE_TELEPHONE_CUSTSERVICE', '', 'Enter a telephone number for customers to reach your Customer Service department. This number may be sent as part of payment transaction details.', 1, 7, now()); 1364: Field 'configuration_id' doesn't have a default value
---------------
Apr 15 2018 19:22 -- upgradeException
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('login mode https', 'SSLPWSTATUSCHECK', '', 'System setting. Do not edit.', 6, 99, now()); 1364: Field 'configuration_id' doesn't have a default value
---------------
Apr 15 2018 19:22 -- upgradeException
ALTER TABLE admin_activity_log CHANGE COLUMN log_id log_id bigint(15) NOT NULL auto_increment; 1075: Incorrect table definition; there can be only one auto column and it must be defined as a key
---------------
Apr 15 2018 19:22 -- upgradeException
ALTER TABLE admin_activity_log DROP INDEX page_accessed; 1091: Can't DROP 'page_accessed'; check that column/key exists
---------------
Apr 15 2018 19:22 -- upgradeException
ALTER TABLE admin_activity_log DROP INDEX access_date; 1091: Can't DROP 'access_date'; check that column/key exists
---------------
Apr 15 2018 19:22 -- upgradeException
FROM project_version; 1364: Field 'project_version_id' doesn't have a default value
Bookmarks