CE Phoenix Upgrader Utility

Error following update - CE Phoenix Upgrader Utility

Error following update

by RAC » Sun Jan 02, 2022 6:06 am

Hello.

I have just updated to the latest version 1.0.8.9 using zipurman’s excellent Upgrader utility.

In my Admin- Security Checks there is an error :

The MySQL utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)

Some database tables need to be converted to four-byte UTF-8 (utf8mb4 unicode ci). Please review the tables under Tools-Database Tables.

When I check the Database Tables there are no obvious errors!

What do I need to do to convert the tables, and what tables do I need to convert.

TIA Shaun
User avatar
RAC
Posts: 35
Joined: Mon Apr 19, 2021 5:36 am
Contact:

Re: Error following update

by zipurman » Sun Jan 02, 2022 10:56 pm

That has nothing to do with the upgrader utility. After an upgrade, some new tables maybe created. They will use the default schema for your MySQL install. The utf8mb4 is recommended by Phoneix, so you you can select all tables that are not of that character set and convert them using the admin database tool ;)

Do a backup first, just in case ... but it shouldn't create any issues.
zipurman
aka Preston Lord
-----------
Happy to help where I can ;)

https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
Image
User avatar
zipurman
PhoenixCart Developer
PhoenixCart Developer
Posts: 470
Joined: Tue Oct 13, 2020 5:20 pm
Contact:

Re: Error following update

by RAC » Mon Jan 03, 2022 5:28 am

Hello Preston.
Sorry, I was not implying that the Updater utility was at fault!

I was asking how to convert from utf8 to utf8mb4.
The admin database tool only offers to convert to utf8, there seems to be no option to convert to utf8mb4.
User avatar
RAC
Posts: 35
Joined: Mon Apr 19, 2021 5:36 am
Contact:

Re: Error following update

by zipurman » Mon Jan 03, 2022 6:46 am

No problem ;) When you post on an addon thread, it usually implied the issue is with the addon ;)

If you convert to utf8 ... it will actually convert to utf8mb4 ;)
zipurman
aka Preston Lord
-----------
Happy to help where I can ;)

https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
Image
User avatar
zipurman
PhoenixCart Developer
PhoenixCart Developer
Posts: 470
Joined: Tue Oct 13, 2020 5:20 pm
Contact:

Re: Error following update

by RAC » Mon Jan 03, 2022 10:10 am

:oops: :oops:
I do apologise again, the initial post was supposed to be in the general discussion :oops: :oops:

I will now creep quietly away while I update to UTF8. :roll:
User avatar
RAC
Posts: 35
Joined: Mon Apr 19, 2021 5:36 am
Contact:

Re: Error following update

by zipurman » Mon Jan 03, 2022 10:16 pm

LOL, no worries ;)
zipurman
aka Preston Lord
-----------
Happy to help where I can ;)

https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
Image
User avatar
zipurman
PhoenixCart Developer
PhoenixCart Developer
Posts: 470
Joined: Tue Oct 13, 2020 5:20 pm
Contact: