Member
Member
Rafe   2009-08-06, 18:11
#1

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.

Member
Member
sbillard   2009-08-06, 23:20
#2

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.

Administrator
Administrator
acrylian   2009-08-07, 07:57
#3

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.

Member
Member
Rafe   2009-08-07, 09:07
#4

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!

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.