Zen Cart Database Conversion Tool

Description
This tool is based on v4.1 of convert_db2utf8.php authored by Andrew Berezin and r1.2 of utf8mb4-conversion.php authored by DrByte, essentially combining those two plugins' processing (https://www.zen-cart.com/downloads.php?do=file&id=1318).

This tool can be used to:

1. Convert your database to a utf8 or utf8mb4 character-set while retaining the integrity of non-ASCII characters, e.g. emojis and extended-ASCII like отслеживание дополнительных элементов.
2. Find (and correct) date, datetime and timestamp fields in the database that have invalid '0000-00-00 [00:00:00]' defaults and/or field values. These defaults are no longer supported by strict MySQL servers.
3. Find (and correct) mixed-collation issues in the database, where a table and/or fields in the database have different collations. If a database query compares two fields that have different collations, a MySQL fatal error will result in strict MySQL servers.

Forum Support Thread

Zen Cart® Versions v1.5.6, v1.5.7, v1.5.8
Original Author lat9
Last Updated by lat9 - 16 Aug 2023
Downloads 217

Version History

Zen Cart Database Conversion Tool   -   Version: v2.0.1
This release contains a BUGFIX (see GitHub issue #8) that enables interoperability with PHP versions 8.0 and later.  
Zen Cart® Versions v1.5.6, v1.5.7, v1.5.8
Date Added 16 Aug 2023
Author lat9
File Size 27.9 KB
Encapsulated? No
Downloads 149
 
Zen Cart Database Conversion Tool   -   Version: v2.0.0
 
Zen Cart® Versions v1.5.6, v1.5.7, v1.5.8
Date Added 14 Mar 2023
Author lat9
File Size 27.7 KB
Encapsulated? No
Downloads 68
 


disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR