UTF-8 converter stuck on posts table

[Brad Olson]

Trying to do a test upgrade of our board from 3 to 4 and after it passes the system checks, it starts the UTF-8 conversion tool.

Gets to the posts table and never gets any further. I've restarted the tool multiple times and the same thing happens.

We have just over a million posts but I've given it 2+ hours and it never moves beyond that table.

Looking at the actual database in phpMyAdmin, the new x_utf_posts table appears to be full and has the number or records it should.

Any ideas what could be causing it to hang on this table?

[Brad Olson]

Just an update. Tried the CLI converter and it got past the posts table but when it gets to rss_imported it gives this error:

Processing: rss_imported                                                                 43%
Error: Specified key was too long; max key length is 1000 bytes
File: /system/Db/Db.php
Line: 198

[Brad Olson]

Fixed this issue and got the DB converted but now I hit a known bug:

Help would be appreciated  

 

[Marc]

4 hours ago, Brad Olson said:

Fixed this issue and got the DB converted but now I hit a known bug:

Help would be appreciated  

 

Just looked at that for you now