Quote Originally Posted by chabbu View Post
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!