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
CE Phoenix Upgrader Utility
Error following update - CE Phoenix Upgrader Utility
Re: Error following update
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.
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 **
aka Preston Lord
-----------
Happy to help where I can
https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
- zipurman
- PhoenixCart Developer
- Posts: 470
- Joined: Tue Oct 13, 2020 5:20 pm
- : Buy Me A Beverage
- Contact:
Re: Error following update
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.
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.
- RAC
- Posts: 35
- Joined: Mon Apr 19, 2021 5:36 am
- Contact:
Re: Error following update
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
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 **
aka Preston Lord
-----------
Happy to help where I can
https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
- zipurman
- PhoenixCart Developer
- Posts: 470
- Joined: Tue Oct 13, 2020 5:20 pm
- : Buy Me A Beverage
- Contact:
Re: Error following update
I do apologise again, the initial post was supposed to be in the general discussion
I will now creep quietly away while I update to UTF8.
- RAC
- Posts: 35
- Joined: Mon Apr 19, 2021 5:36 am
- Contact:
Re: Error following update
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 **
aka Preston Lord
-----------
Happy to help where I can
https://phoenixaddons.com
https://www.youtube.com/zipurman/ ** PHOENIX HOW-TO VIDEOS **
- zipurman
- PhoenixCart Developer
- Posts: 470
- Joined: Tue Oct 13, 2020 5:20 pm
- : Buy Me A Beverage
- Contact: