Home› General support

utf8 warning won't go away

Rafe Member
in General support
I keep getting the following error from setup.php:

MySQL field collations [Image and Album tables]
Warning!

You should consider porting your data to UTF-8 and changing the collation of the database fields to utf8_unicode_ci

I have changed the database to UTF-8, every table to UTF-8 and made sure every field is UTF-8, but I still get the error.

Note my database originates from years and years ago, but I've upgraded ZenPhoto over the years. Am trying to install 1.2.6 RC2

Many thanks for your assistance.

Comments

  • sbillard Member
    The warning is telling you that it is the `images` and `albums` tables that have these collations. Check again, you must have missed one somewhere. The report is coming directly from a query of the tables and their collations.
  • acrylian Administrator, Developer
    Again, not that if a tool like phpmyadmin reports "UTF8" for a table does not necessarily mean that all fields of this table actually are. They still can have mixed encodings! I had this issue myself. Check that by looking into this table.
  • Rafe Member
    I've checked and double-checked all fields plus the collations for the table itself. All using MySQLYog.

    These tables are very old (from the first release of ZenPhoto) I think.

    No big deal then, I'll just leave them alone!
Sign In or Register to comment.