search

lat9 / dbio

Database Input/Output for Zen Cart
GNU General Public License v3.0
3 stars 1 forks source link

install sql error for table dbio_reports with collation utf8mb4_unicode_520_ci: max key length is 1000 bytes #190

Closed torvista closed 2 years ago

torvista commented 3 years ago

1071 Specified key was too long; max key length is 1000 bytes in: [CREATE TABLE dbio_reports ( dbio_reports_id int(11) NOT NULL auto_increment, handler_name varchar(255) NOT NULL, report_name varchar(32) NOT NULL, admin_id int(11) NOT NULL default 0, last_updated_by int(11) NOT NULL default 0, last_updated datetime default '0001-01-01 00:00:00', field_info mediumblob, PRIMARY KEY (dbio_reports_id), KEY idx_dbio_handler_name (handler_name), KEY idx_dbio_admin_id (admin_id) ) ENGINE=MyISAM] If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you entered valid data.

collation utf8mb4_unicode_520_ci

Server Host: www.dev.test (127.0.0.1) Database: zencart-158_local Server OS: Windows NT E590 10.0 build 19043 (Windows 10) AMD64 Server Date: 07/16/2021 16:48:46
Server Up Time: Unsupported HTTP Server: Apache PHP Version: 8.0.8 (Zend: 4.0.8) PHP File Uploads: On Upload Max Size: 2G PHP Memory Limit: 512M POST Max Size: 2G Database Engine: MySQL 5.7.32 Database Host: localhost (127.0.0.1) Database Date: 07/16/2021 16:48:46 Database Data Size: 525 kB Database Index Size: 641 kB MySQL Slow Query Log Status: On MySQL Slow Query Log File: C:\laragon\data\mysql\E590-slow.log MySQL Mode: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION

torvista commented 3 years ago

handler_name varchar(250) NOT NULL,

is the largest value that works.