1.5.8a Missing customer_groups field in DB

[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.

[lat9]

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.

[Lance Turner]

Post says it needs MariaDB 10.2.7 or newer, mine is MariaDB 10.3.39, which would be newer would it not?

[lat9]

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?

[Lance Turner]

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.

[Lance Turner]

Ok, ran those and all worked fine, thanks.

[lat9]

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?

[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.

[lat9]

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.

[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.