Back In Stock Notifications

[chabbu]

Installed on v1.3.7, all works well apart from when the customer logs into their accoutn to unsubscribe to notifications. The following error is displayed:

1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
in:
[ SELECT bisns.id, bisns.product_id, pd.products_name, bisns.date_subscribed FROM back_in_stock_notification_subscriptions bisns LEFT JOIN products_description pd ON bisns.product_id = pd.products_id LEFT JOIN customers c ON c.customers_id = bisns.customer_id WHERE (bisns.customer_id = '2' OR c.customers_email_address = bisns.email_address) AND pd.language_id = '1';]

Mean anything to anyone?

[chabbu]

Installed on v1.3.7, all works well apart from when the customer logs into their accoutn to unsubscribe to notifications. The following error is displayed:

1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
in:
[ SELECT bisns.id, bisns.product_id, pd.products_name, bisns.date_subscribed FROM back_in_stock_notification_subscriptions bisns LEFT JOIN products_description pd ON bisns.product_id = pd.products_id LEFT JOIN customers c ON c.customers_id = bisns.customer_id WHERE (bisns.customer_id = '2' OR c.customers_email_address = bisns.email_address) AND pd.language_id = '1';]

Mean anything to anyone?

Don't worry, managed to fix it. It was due to differences in table and field collations. Changed them to latin1 general, just hope it doesn't have any adverse affects!

[conor]

Hi,

Don't worry, managed to fix it. It was due to differences in table and field collations. Changed them to latin1 general, just hope it doesn't have any adverse affects!

That's what I was about to suggest! I don't there'll be any problems using latin1. :)

All the best...

Conor
Ceon

[xordox]

Hello Ceon,
Thank you for this mod!
please tell me how I can fix this issue:
I have a multilanguage site: www.usim.co.il and in english pages all works ok, but in russian and hebrew ( UTF-8) instead product name I have : “Ð�окиÑ� N73” (instead "нокиа N73")
link : http://www.usim.co.il/ru/nokia/%D0%9...1%8F-n73-p-859
same in hebrew
Thanks!