Site maintenance: Sun 15 Nov, from 12:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Plugin Library / Other Modules / Zen Cart Database Conversion Tool

Zen Cart Database Conversion Tool

Other Modules

Plugin ID 2367

Overview

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.

Releases

  • v2.0.1 Not Encapsulated Release ID #7203
    16 Aug 2023 · Compatible with 1.5.6, 1.5.7, 1.5.8, 2.0.0, 2.1.0 Release by lat9 · 286 downloads · 27.9 KB ZIP

    This release contains a BUGFIX (see GitHub issue #8) that enables interoperability with PHP versions 8.0 and later.

Author
Updated
16 Aug 2023
Releases
1
Plugin ID
2367