+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: utf8 warning won't go away (/thread-5623.html)
utf8 warning won't go away - Rafe - 2009-08-06
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.
utf8 warning won't go away - sbillard - 2009-08-06
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.
utf8 warning won't go away - acrylian - 2009-08-07
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.
utf8 warning won't go away - Rafe - 2009-08-07
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!