Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2006
    Posts
    74
    Plugin Contributions
    0

    Default 1146 MySql error using newsletter/email

    Hi,

    The following error occurs when using: Admin>Tools>Send email or Admin>Tools>Newsletter and ....

    1146 Table 'saxbase.TABLE_CUSTOMERS' doesn't exist
    in:
    [select customers_firstname, customers_lastname, customers_email_address from TABLE_CUSTOMERS where customers_newsletter = '1' ]


    yes, the table-prefixes are allright

    Further, there are no problems concerning customers, I can delete, edit them a.s.o.

    Zen Cart 1.3.5
    Database Patch Level: 1.3.5

    Addons:
    Super orders
    Pdfdoc
    Cross-sell

    thanks in advance!

  2. #2
    Join Date
    Aug 2006
    Posts
    74
    Plugin Contributions
    0

    Default Re: 1146 MySql error using newsletter/email

    I have fixed it myself in the hard way...

    In table called '****_query_builder' I found querystrings using the names TABLE_CUSTOMER and TABLE_ORDERS.

    I replaced them with the right tablenames like 'zen_customers' and 'zen_orders'.

    I don't know if this is the right way but everything is now working fine


    greetz

  3. #3
    Join Date
    Jan 2006
    Posts
    5
    Plugin Contributions
    0

    Default Re: 1146 MySql error using newsletter/email

    Quote Originally Posted by mrtorrez View Post
    I have fixed it myself in the hard way...

    In table called '****_query_builder' I found querystrings using the names TABLE_CUSTOMER and TABLE_ORDERS.

    I replaced them with the right tablenames like 'zen_customers' and 'zen_orders'.

    I don't know if this is the right way but everything is now working fine


    greetz
    Same problem, same solution. Is it the right way ?

  4. #4
    Join Date
    Aug 2006
    Posts
    74
    Plugin Contributions
    0

    Default Re: 1146 MySql error using newsletter/email

    I think so, I do not not know another way to fix it.

    grmx

 

 

Similar Threads

  1. MYSQL error #1146 table doesn't exist - help!
    By TheKenster in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 20 Jan 2012, 01:48 PM
  2. Newsletter didn't seem to send, mySQL error?
    By redpanda in forum General Questions
    Replies: 3
    Last Post: 3 Mar 2010, 06:23 AM
  3. Using external email newsletter system
    By mtndan in forum General Questions
    Replies: 10
    Last Post: 20 Sep 2009, 03:23 AM
  4. using Newsletter Subscribe contribution, having email problem from admin section
    By lucianman in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 16 Mar 2008, 11:06 PM
  5. Replies: 3
    Last Post: 30 Mar 2007, 12:56 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