feadmin_zc1.zc_TABLE_CUSTOMERS' doesn't exist fatal error on fresh install
psdinnersready.com zc 1.5.7 php7.3
went to use the send email function and received warning note
debug file:
[24-Oct-2020 20:42:32 UTC] Request URI: /(removed)/index.php?cmd=mail, IP address: 184.170.174.172 #1 trigger_error() called at [/home/feadmin/public_html/psdinnersready/includes/classes/db/mysql/query_factory.php:170] #2 queryFactory->show_error() called at [/home/feadmin/public_html/psdinnersready/includes/classes/db/mysql/query_factory.php:142] #3 queryFactory->set_error() called at [/home/feadmin/public_html/psdinnersready/includes/classes/db/mysql/query_factory.php:269] #4 queryFactory->Execute() called at [/home/feadmin/public_html/psdinnersready/includes/functions/audience.php:40] #5 get_audiences_list() called at [/home/feadmin/public_html/psdinnersready/(removed)/mail.php:278] #6 require(/home/feadmin/public_html/psdinnersready/(removed)/mail.php) called at [/home/feadmin/public_html/psdinnersready/(removed)/index.php:11] --> PHP Fatal error: 1146:Table 'feadmin_zc1.zc_TABLE_CUSTOMERS' doesn't exist :: SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM zc_TABLE_CUSTOMERS c LEFT JOIN zc_orders o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL ==> (as called by) /home/feadmin/public_html/psdinnersready/includes/functions/audience.php on line 40 <== in /home/feadmin/public_html/psdinnersready/includes/classes/db/mysql/query_factory.php on line 170.
any thoughts on what might be missing or file needing edited?
Re: feadmin_zc1.zc_TABLE_CUSTOMERS' doesn't exist fatal error on fresh install
Looks like you might have modified the query_builder table using Admin > Tools > Install SQL Patches rather than using phpMyAdmin. Go ahead into phpMyAdmin and fix the table. You'll see an entry with a reference to "zc_TABLE_CUSTOMERS" that should be "TABLE_CUSTOMERS"
Re: feadmin_zc1.zc_TABLE_CUSTOMERS' doesn't exist fatal error on fresh install
That was the fix. I think is was from installatron. I have found several files it failed to instal as well. Appreciate the fix!