Database Conversion Tools [Support Thread]

[swguy]

Fix submitted for this issue.

[lat9]

Fix submitted for this issue.

Thanks for that; the update will be included in v2.0.1.

[lat9]

Thanks for that; the update will be included in v2.0.1.

v2.0.1 of the Database Conversion tool is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2367

This release contains a BUGFIX (see GitHub issue #8) that enables interoperability with PHP versions 8.0 and later. Thanks to @swguy for the identification and correction of the issue.

[swguy]

The use of the new converter plugin at https://www.zen-cart.com/downloads.php?do=file&id=2367 is now the recommended approach for UTF-8 conversions.

[cubmanky]

So I just garbed the new one. I do not see how or where to pick to convert to just utf8 its all utf8mb4 something

[swguy]

You want utf8mb4.

[cubmanky]

You want utf8mb4.

ok I guess i missed ready something where utf8 was what it should be

[gothstone]

The converter fails out for me at Processing table [address_book]:
Error log says:
[19-Sep-2023 13:16:26 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Data too long for column 'address_title' at row 19641 in /home/pcs/dev/utf8mb4-conversion.php:170
Stack trace:
#0 /home/pcs/dev/utf8mb4-conversion.php(170): mysqli_query(Object(mysqli), 'ALTER TABLE `ad...')
#1 {main}
thrown in /home/pcs/dev/utf8mb4-conversion.php on line 170

I don't know the sort order, how can I find row 19641 to fix the address?

[swguy]

That's not a default field. You'll have to adjust your database to allow for the greater length required by UTF8MB4.

[gothstone]

Ya, I had just figured out it's leftover garbage from an old mod. The uninstall SQL didn't clean up what it added. Yay, now I get to dig through the whole DB for extra garbage.