Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2014
    Posts
    216
    Plugin Contributions
    0

    Default PHP Fatal error: 1146:, table doesn't exist

    Started building a new site.
    I get the following error
    [04-Nov-2018 03:58:16 UTC] PHP Fatal error: 1146:Table 'i1031916_zc5.zc_TABLE_CUSTOMERS' doesn't exist :: select max(o.date_purchased) as date_purchased, c.customers_email_address, c.customers_lastname, c.customers_firstname from zc_TABLE_CUSTOMERS c, zc_orders o WHERE c.customers_id = o.customers_id AND c.customers_newsletter = 1 GROUP BY c.customers_email_address, c.customers_lastname, c.customers_firstname HAVING max(o.date_purchased) <= subdate(now(),INTERVAL 3 MONTH) ORDER BY c.customers_lastname, c.customers_firstname ASC ==> (as called by)
    i1031916_zc5 is my db in sql.

    zc_CUSTOMERS is my customer table, and I was able to add a customer to it.

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,478
    Plugin Contributions
    88

    Default Re: PHP Fatal error: 1146:, table doesn't exist

    You appear to have a corrupt version of /includes/database_tables.php. That's where all the built-in database table names are defined.

  3. #3
    Join Date
    Jan 2014
    Posts
    216
    Plugin Contributions
    0

    Default Re: PHP Fatal error: 1146:, table doesn't exist

    I came across this form So I went into my db and copied
    query_builder table
    from another db into the one for my site and it now works and the error is gone. I compared the two tables and noticed that it was making reference to table
    zc_TABLE_CUSTOMERS
    when it should have been
    TABLE_CUSTOMERS

 

 

Similar Threads

  1. v139h SQL Error 1146 Table TABLE_CUSTOMERS_ADMIN_NOTES doesn't exist
    By utefan in forum General Questions
    Replies: 4
    Last Post: 3 Mar 2016, 07:45 PM
  2. 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
  3. v151 upgrading error 1146 table doesn't exist
    By scottrdj in forum Upgrading to 1.5.x
    Replies: 4
    Last Post: 31 Dec 2012, 03:05 PM
  4. Replies: 3
    Last Post: 27 Jul 2011, 08:32 PM
  5. 1146 Table error zenconfiguration doesn't exist
    By gayelston in forum Installing on a Linux/Unix Server
    Replies: 6
    Last Post: 1 Dec 2007, 10:26 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