Originally Posted by
swguy
If you get this, error
> --> PHP Fatal error: 1054:Unknown column 'c.customers_secret' in 'field list' ...
It means part of the zc_install failed during the upgrade process.
If you go to phpMyAdmin and run the command
ALTER TABLE customers ADD customers_secret varchar(64) NOT NULL default '';
(adding a prefix if your store uses one)
You'll see the message that tells you why this failed. Fix that issue, then rerun the ALTER TABLE command above.
The *most likely* cause of the failure is that you added a date field to the customers table but didn't correctly upgrade it.
This page tells you how to fix this, if this is indeed the root cause:
https://docs.zen-cart.com/user/upgra...andardization/
Originally Posted by
Jabbawocky
JS WEB have said that it would cost too much to upgrade our existing site and quoted more than I can afford to transfer everything on to new software. Peejay from Zenofobe used to do the trouble shooting for me. He is no longer on here, so struggling on alone.
Selected the correct database and it now says.
#1064 - you have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' " ' at line 1
It would appear (guessing here) that the above SQL statement was not entered correctly. It is most helpful to post the sql statement that was entered in addition to the error response.
I am **ASSUMING** that the following was entered:
Code:
ALTER TABLE customers ADD customers_secret varchar(64) NOT NULL default ";
When instead this should have been entered:
Code:
ALTER TABLE customers ADD customers_secret varchar(64) NOT NULL default '';
Note the difference in the *TWO* characters before the semicolon(;): " versus ''
The second is two single quotes (') the first is a single double quote("). Based on the content of the above error message, the character captured between the quotes associated to "near ' " '" indicates a single double quote as I am not able to highlight/select one side or the other....
As to the "order delivery date" issue, there is this post associated to this issue in the associated forum thread and the change made to the install/upgrade of that module which suggests something like the following SQL command which can be executed through the admin screen->Tools->Install SQL Patches:
Code:
ALTER TABLE orders ALTER order_delivery_date SET DEFAULT '0001-01-01 00:00:00';
(The above was to ensure future date entries were of an "appropriate" value, while there was a second query in the linked post to correct/modify existing incorrect entries.)
A little background to that issue was that the initial implementation didn't include a default. On servers where mysql settings permitted, the value captured when none was entered was effectively a 0 filled date/datetime. Later implementations of mysql prohibit such value. The "upgrade" process of the plugin did not account for that old (incorrect) history. The issue has been documented in the forum and aspects of the issue have been captured, though I would certainly agree more could be done to help the user(s). I haven't closed the issue in github yet basically because of situations described above still occurring...
Bookmarks