paul banks Posted January 24, 2015 Posted January 24, 2015 Step 1Some or all of the tables or columns in your database are not using a utf8 collation (ipb3backup_vars is latin1_swedish_ci). You must convert your database to UTF-8 in order to continue Step 2You have 338 table(s) in this database that are not UTF-8. You must convert these tables to UTF-8 before you can proceed with the upgrade. Step 3 Try starting Converter every time says: Error: COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'utf8mb4' File: /system/Db/Db.php Line: 186 I do not know more, can anybody help me?
bfarber Posted January 26, 2015 Posted January 26, 2015 This is a bug we noticed in the converter that should be fixed in the next release.
TheSonic Posted January 26, 2015 Posted January 26, 2015 @bfarber Is this a bug in the UTF8-Convert or UTF8mb4? Paul banks is running MySQL 5.1, see http://www.ips-community.de/index.php?/topic/47-upgrade-von-347-auf-40/&do=findComment&comment=389This version does not support utf8mb4.
bfarber Posted January 27, 2015 Posted January 27, 2015 He has a utf8mb4 table in his database, but chose utf8 when he converted - the software did not correctly account for this and tried to fix a utf8mb4 collation to utf8_unicode_ci on a utf8mb4 character set table which isn't allowed. It's a bug - we have seen it ourselves recently and fixed it for the next release.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.