To post a new support question, click the Post New Topic button below.
Current Version: 4.9.3 | Sytist Manual | Common Issues | Feature Requests
Please log in or Create an account to post or reply to topics.
You will still receive notifications of replies to topics you are part of even if you do not subscribe to new topic emails.
Shipping Sql Error
G
Graham Warwick
29 posts
Tue Nov 22, 16 12:40 PM CST
Hi. I have noticed that the only countries I have available are the USA and Canada.
If I go to settings and shipping I get the following error;
MENU
MYSQL ERROR: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation '='
Query: SELECT * FROM ms_states WHERE state_name=' Esp?rito Santo' AND state_country='Brazil'
Can someone help please
Ta
If I go to settings and shipping I get the following error;
MENU
MYSQL ERROR: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation '='
Query: SELECT * FROM ms_states WHERE state_name=' Esp?rito Santo' AND state_country='Brazil'
Can someone help please
Ta
Tim - PicturesPro.com
16,262 posts
(admin)
Tue Nov 22, 16 3:06 PM CST
Try this.
Click on Settings in the main menu.
Then click MySQL query under the left menu.
In the query box, copy and paste this in there and click run:
ALTER TABLE ms_states CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Then return to Settings -> Shipping and see if the error goes away.
Click on Settings in the main menu.
Then click MySQL query under the left menu.
In the query box, copy and paste this in there and click run:
ALTER TABLE ms_states CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Then return to Settings -> Shipping and see if the error goes away.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
My Email Address: info@picturespro.com
G
Graham Warwick
29 posts
Tue Nov 22, 16 3:24 PM CST
Amazing, cheers tim.
m
mja
23 posts
Wed Jul 03, 19 10:55 AM CST
Hi Tim
Just had a similar error:
MYSQL ERROR: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation '='
Query: SELECT * FROM ms_sub_galleries WHERE sub_date_id='1452' AND sub_under='' AND sub_name='03 Gruppenfotos Apéro'
03 Gruppenfotos Apéro = there should be a & between. did you change some setups after last update? before it wasn't any problem. ;).
regards,
Michael
Just had a similar error:
MYSQL ERROR: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation '='
Query: SELECT * FROM ms_sub_galleries WHERE sub_date_id='1452' AND sub_under='' AND sub_name='03 Gruppenfotos Apéro'
03 Gruppenfotos Apéro = there should be a & between. did you change some setups after last update? before it wasn't any problem. ;).
regards,
Michael
Wedding Photographer living in Switzerland
Tim - PicturesPro.com
16,262 posts
(admin)
Fri Jul 05, 19 4:10 AM CST
It's because of the é in the gallery name.
Click on Settings in the main menu.
Then click MySQL query under the left menu.
In the query box, copy and paste this in there and click run and see if this makes a difference.
ALTER TABLE ms_sub_galleries CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Click on Settings in the main menu.
Then click MySQL query under the left menu.
In the query box, copy and paste this in there and click run and see if this makes a difference.
ALTER TABLE ms_sub_galleries CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
My Email Address: info@picturespro.com
Please log in or Create an account to post or reply to topics.
Loading more pages