Database error 1267 while doing query Illegal mix of collati

Once you've installed phpList... ask questions here!
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation.

Database error 1267 while doing query Illegal mix of collati

Postby celiac101 » 4:11pm, Mon 25 Aug, 2014

After upgrading from 2.x to 3.0.7 I am seeing these errors when processing bounces:

Processed messages will be deleted from mailbox
Database error 1267 while doing query Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Database error 1267 while doing query Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Database error 1267 while doing query Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Database error 1267 while doing query Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Database error 1267 while doing query Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Any idea how to fix this?
celiac101
PL Nut
 
Posts: 29
Joined: 10:47pm, Sat 28 Dec, 2013

Re: Database error 1267 while doing query Illegal mix of col

Postby danwaterloo » 7:14pm, Sun 31 Aug, 2014

It looks like your tables were not all converted.

If you know how to alter a table using PHPmyadmin, or MySQLWorkbench, you can do it that way...

Dan
danwaterloo
PL Master
 
Posts: 276
Joined: 3:51am, Wed 30 Oct, 2013
Location: http://www.phplistsupport.com


Return to Questions and Problems after Installing

Who is online

Users browsing this forum: No registered users and 1 guest

cron