WARNING: An Error occurred, please refresh the page and try again.

Hi all,

The Send Email (mail.php) inside the tools menu no longer works.

The only error displayed is:

WARNING: An Error occurred, please refresh the page and try again.

When I upgraded this site, I did a fresh set of files, with the exception of one language file which I've fixed. So no files have been mixed.

Anyone having the same issue?

A quick search for your error message brings up this FAQ article: http://www.zen-cart.com/content.php?311-warning-an-error-occurred-please-refresh-the-page-and-try-again

Sounds like you've got yourself some database errors.

And I'm guessing it's probably related to your use of an old "Newsletter Subscribe" mod that's no longer installed?

Follow the FAQ article's instructions to sort out your next steps

DrByte:

A quick search for your error message brings up this FAQ article: http://www.zen-cart.com/content.php?311-warning-an-error-occurred-please-refresh-the-page-and-try-again

Sounds like you've got yourself some database errors.

And I'm guessing it's probably related to your use of an old "Newsletter Subscribe" mod that's no longer installed?

Follow the FAQ article's instructions to sort out your next steps

You nailed it again, below is the debug log after clearing it and accessing the page. However, I was receiving this error before I added any 1.5 compatible mods. Any ideas, this is probably over my head.

[14-Jun-2012 16:32:47] PHP Warning: constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant TABLE_SUBSCRIBERS in /home/xxxx/public_html/includes/functions/audience.php on line 113
[14-Jun-2012 16:32:47] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as s left join customers as c on c.customers_id = s.customers_id' at line 1 :: select c.customers_firstname, c.customers_lastname, s.email_address as customers_email_address from as s left join customers as c on c.customers_id = s.customers_id in /home/xxxxc/public_html/includes/classes/db/mysql/query_factory.php on line 101

I compared both audience.php and query_factory.php on my live shop and in the zen-cart-v150-full-release-12302011 fileset and they are exactly the same.

Fixed it, added the following inside database-tables.php.

define('TABLE_SUBSCRIBERS', DB_PREFIX . 'subscribers');

Hello Everyone: I have a similar problem with my Zencart v1.51 . I am installing a new installation and for 2nd time I have the same problem when I am trying to access my option name manager in my admin and also, now is not allowing me access my admin at all.
The first time I reinstall everything from cero, second time the same thing, but now I have to find a solution. I lose 2 days working with this. I read about the solution is read the manual and rewrite the SQL somewhere, but I am not a SQL programmer.

In the browser the error code that appear is :
WARNING: An Error occurred, please refresh the page and try again.

Inside myLOG says:
PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT')' at line 1 :: INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT') in /home/buymiami/public_html/includes/classes/db/mysql/query_factory.php on line 120

My domain name is https://www.buymiami.us if someone has any better idea then start everything from scratch like I did the last 2 times, would be very nice. Thank you and Happy New Year!

That exact problem was reported and fixed here: http://www.zen-cart.com/showthread.php?200688-Known-Bugs-%28and-fixes%29-with-v1-5-1&p=1154025#post1154025