Product Notification Error

[Lackew]

newsletters & emails work fine
but when trying to send product notification it will let me select which products but when you click on send this messages comes...

Newsletter and Product Notifications Manager
Customers receiving this Product Notification: 0

help!

[haredo]

Lackew,
What modules have you loaded over the core files of zen cart..
If so so you check with Winmerge and munge them together..
Go to your root directory and click on the Cache folder to find any error logs please..

[Lackew]

the only thing added is about us & extra define pages
checked the cache folder with 5 files all with 0 bytes !!!???

[Lackew]

help?????????????

[Lackew]

after doing some checking am now able to get an error message:

Newsletter and Product Notifications Manager

1064 You have an error in your SQL syntax; check the manual that corresponds to your SQL server version for the right syntax to use near ')' at line 3
in:
[select distinct customers_id from zen_products_notifications where products_id in ()]

[Lackew]

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 '000000 where products_id = '1'' at line 1 in: [update zen_products set products_ordered = products_ordered + 1,000000 where products_id = '1']

Print
Save to list
Subscribe
Rate Article Helpful Not Helpful

When placing an order, the following error appears:

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 '000000 where products_id = '1'' at line 1
in:
[update zen_products set products_ordered = products_ordered + 1,000000 where products_id = '1']



Solution:
Edit the language-file for your active language. For "english", it's english.php

You'll see a line that says:

@setlocale(LC_ALL, '<something-here>');


The problem is on LC_ALL

Change it to LC_TIME instead. Example for portuguese:

@setlocale(LC_TIME, 'pt_PT.ISO8859-15');

I found the above but my settings are good
Still need help