Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Location
    Illinois, USA
    Posts
    312
    Plugin Contributions
    0

    help question 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?
    NTO: building a better network thru collaboration
    www.needtoorder.com | www.coffeewitheinstein.com

  2. #2
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,684
    Plugin Contributions
    123

    Default 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"
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  3. #3
    Join Date
    Jan 2007
    Location
    Illinois, USA
    Posts
    312
    Plugin Contributions
    0

    Default 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!
    NTO: building a better network thru collaboration
    www.needtoorder.com | www.coffeewitheinstein.com

 

 

Similar Threads

  1. v157 Fatal error: 1146:Table plugin_control' doesn't exist
    By picandnix in forum Upgrading to 1.5.x
    Replies: 17
    Last Post: 15 Feb 2022, 04:39 PM
  2. v155 PHP Fatal error: 1146:, table doesn't exist
    By cubmanky in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 4 Nov 2018, 02:10 PM
  3. v154 fatal error 1101 on fresh local install of 1.5.4
    By keneso in forum Installing on a Windows Server
    Replies: 6
    Last Post: 4 Jan 2015, 01:50 AM
  4. v150 PHP Fatal error: 1146:Table 'products_attrib_cross_validation' doesn't exist
    By diamondminer in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 24 Feb 2013, 03:42 PM
  5. Replies: 3
    Last Post: 27 Jul 2011, 08:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR