I was testing Create Order from within the admin backend and added a "service" type item. The service was added, but this error appeared at the bottom of the admin page:
1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german2_ci,IMPLICIT) for operation '='
select ab.*,z.zone_id from customers_basket_address ab left join zones z on z.zone_name =ab.billing_state where ab.customers_id = '1' and orders_id=0
I was testing Create Order from within the admin backend and added a "service" type item. The service was added, but this error appeared at the bottom of the admin page:
1267 - Illegal mix of collations (latin1_ swedish_ ci,IMPLICIT) and (latin1_ german2_ ci,IMPLICIT) for operation '='
select ab.*,z.zone_id from customers_ basket_ address ab left join zones z on z.zone_name =ab.billing_state where ab.customers_id = '1' and orders_id=0