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 :smartass:

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!

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:yes:

greetz

mrtorrez:

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:yes:

greetz

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

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

grmx