Re: 1.5.8a Missing customer_groups field in DB
Have noticed this as well on my recent 1.5.8a install, and my server is running MySQL 10.3.39...
--> PHP Fatal error: 1146:Table 'ledsales_zc_158.6d6_customer_groups' doesn't exist :: SELECT count(*) as total FROM (SELECT cg.*, count(ctg.customer_id) as customer_count FROM 6d6_customer_groups cg LEFT JOIN 6d6_customers_to_groups ctg USING (group_id) GROUP BY cg.group_id ORDER BY group_name, group_id) countresults ==> (as called by) /[admin]/includes/classes/split_page_results.php on line 220 <== in /includes/classes/db/mysql/query_factory.php on line 667.
Re: 1.5.8a Missing customer_groups field in DB
Quote:
Originally Posted by
Lance Turner
Have noticed this as well on my recent 1.5.8a install, and my server is running MySQL 10.3.39...
--> PHP Fatal error: 1146:Table 'ledsales_zc_158.6d6_customer_groups' doesn't exist :: SELECT count(*) as total FROM (SELECT cg.*, count(ctg.customer_id) as customer_count FROM 6d6_customer_groups cg LEFT JOIN 6d6_customers_to_groups ctg USING (group_id) GROUP BY cg.group_id ORDER BY group_name, group_id) countresults ==> (as called by) /[admin]/includes/classes/split_page_results.php on line 220 <== in /includes/classes/db/mysql/query_factory.php on line 667.
See the posts above in this thread, starting with post #7.
Short answer: Your site's MySQL server version requires update.
Re: 1.5.8a Missing customer_groups field in DB
Post says it needs MariaDB 10.2.7 or newer, mine is MariaDB 10.3.39, which would be newer would it not?
Re: 1.5.8a Missing customer_groups field in DB
Did you try running the two SQL table-inserts identified in posts #4 and #5 in this thread (either via phpMyAdmin or the admins Tools :: Install SQL Patches)?
Was the site a fresh install or an upgrade? Are there any zcInstall*.log files in the site's /logs sub-directory?
Re: 1.5.8a Missing customer_groups field in DB
No, haven't done those yet, just wondered why the table was missing, seems an odd thing to happen. It was an update from 1.5.7, but the upgrade script ran ok, no issues.
Re: 1.5.8a Missing customer_groups field in DB
Ok, ran those and all worked fine, thanks.
Re: 1.5.8a Missing customer_groups field in DB
Quote:
Originally Posted by
Lance Turner
Ok, ran those and all worked fine, thanks.
Were there any zcInstall*.log files generated?
How about the database's upgrade_exceptions table? Any records in there on/around the time of the zc158 upgrade?
Re: 1.5.8a Missing customer_groups field in DB
The upgrade exceptions table had two for this upgrade, both the same:
1293: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Logs autodelete after 7 days, so no log file unfortunately.
Re: 1.5.8a Missing customer_groups field in DB
Quote:
Originally Posted by
Lance Turner
The upgrade exceptions table had two for this upgrade, both the same:
1293: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Logs autodelete after 7 days, so no log file unfortunately.
From that saved 'exception', it appears that the version of MySQL that was in use when you upgraded was less than that with which you're running with now.
That's the same message that the OP received, running MySQL 5.5.68-MariaDB.
Re: 1.5.8a Missing customer_groups field in DB
Quote:
Originally Posted by
lat9
From that saved 'exception', it appears that the version of MySQL that was in use when you upgraded was less than that with which you're running with now.
That's the same message that the OP received, running MySQL 5.5.68-MariaDB.
FWIW, I've created an issue on the Zen Cart GitHub (https://github.com/zencart/zencart/issues/6002) so that, hopefully, this and other issues of the like will be corrected in the future.
