Upgrade Error - Incorrect String Value

[Robert Angle]

My upgrade is frozen with this on the screen....

Incorrect string value: '\xED\xA0\xBD\xED\xB8\xB4' for column 'mt_title' at row 2678

/home/MySite/public_html/applications/core/setup/upg_107600/queries.json - query #2

ALTER TABLE `ipb_core_message_topics` ADD KEY `mt_alert` (`mt_alert`)

 

What should I do? 

 

 

Edited June 26, 2023 by Robert Angle

[Marc]

We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. 

We look forward to further assisting you. 

 

[Robert Angle]

10 minutes ago, Marc Stridgen said:

Could you please update these details

Good morning Marc. Everything should be up to date now.

[Marc]

Looking at your database there, it appears that table is the only one in your database which is not INNODB. Please change that and check again. If that's still then an issue (I suspect it may be) let us know and we can get this looked into further.

[Robert Angle]

7 minutes ago, Marc Stridgen said:

it appears that table is the only one in your database which is not INNODB

So most of them were MyIsam, but I changed them to INNODB last night. I realized Tech Support was closed and started trying to find other topics that encountered similar issues.

However, I am unable to change 2 tables to INNODB

ALTER TABLE `ipb_core_message_topics` ENGINE = INNODB;

MySQL said: 

#1366 - Incorrect string value: '\xED\xA0\xBD\xED\xB8\xB4' for column 'mt_title' at row 2678

and

ALTER TABLE `ipb_tapatalk_push_data` ENGINE = INNODB;

MySQL said: 

#1366 - Incorrect string value: '\xED\xA0\xBD\xED\xB1\x8B...' for column 'title' at row 4284

 

If relevant, my conf_global.php remains unchanged with the following lines...

$INFO['mysql_tbl_type']        =    'MyISAM';
$INFO['sql_utf8mb4']         = true;

[Robert Angle]

@Marc Stridgen - anything?

The community has been down for 14 hours now. I need to get it back online, even if it means abandoning the upgrade process.

[Marc]

There has been a ticket created for you on this so we can take a closer look at what is going on. However the latter one of those 2 would be an issue with tapatalk, rather than ourselves. It looks like an issue with mb4 conversion. Someone will be in contact as soon as possible

[Robert Angle]

We're back online!

I'm sharing this so that others can use it for reference.

@Marc Stridgen said in the email support ticket:

Quote

The issue here is an issue somewhere with the char set settings on the database somewhere, which is, unfortunately, an issue which is hosting side, rather than with the software itself.... We have found in the past that, while not the most elegant solution, exporting and reimporting your database, ensuring to import it using the UTF8MB4 charset has been something that some have had success with in the past.

 

For mysterious reasons, I was unable to change 2 tables from MYISAM to INNODB. So my VPS host created a backup of the database, made the change to the dump file and imported it. We reran the upgrade utility and everything finished successfully.

 

The solution was to change all tables from MYISAM to INNODB.

 

Edited June 26, 2023 by Robert Angle

[Marc]

Very glad to hear you have everything resolved 🙂