表中每一行的非法字符串偏移量 'Data_length'/'Index_length'

问题描述

学习 PHP/mySQL 等，当我使用 xampp 使用 phpmyadmin 创建表时，每一行都会出现此错误:

Learning PHP/mySQL etc, When I create a table with phpmyadmin using xampp I get this error for every single row:

警告在 .\libraries\classes\Controllers\Table\TableStructureController.php#1339非法字符串偏移量 'Data_length'

回溯

.\libraries\classes\Controllers\Table\TableStructureController.php#1278: PhpMyAdmin\Controllers\Table\TableStructureController->getTableStats().\libraries\classes\Controllers\Table\TableStructureController.php#377: PhpMyAdmin\Controllers\Table\TableStructureController->displayStructure(大批，大批，大批，,大批，大批，).\tbl_structure.php#57: PhpMyAdmin\Controllers\Table\TableStructureController->indexAction().\libraries\classes\Controllers\Table\TableStructureController.php#1342 中的警告非法字符串偏移量 'Index_length'回溯

.\libraries\classes\Controllers\Table\TableStructureController.php#1278: PhpMyAdmin\Controllers\Table\TableStructureController->getTableStats() .\libraries\classes\Controllers\Table\TableStructureController.php#377: PhpMyAdmin\Controllers\Table\TableStructureController->displayStructure( array, array, array, , array, array, ) .\tbl_structure.php#57: PhpMyAdmin\Controllers\Table\TableStructureController->indexAction() Warning in .\libraries\classes\Controllers\Table\TableStructureController.php#1342 Illegal string offset 'Index_length' Backtrace

.\libraries\classes\Controllers\Table\TableStructureController.php#1278: PhpMyAdmin\Controllers\Table\TableStructureController->getTableStats().\libraries\classes\Controllers\Table\TableStructureController.php#377: PhpMyAdmin\Controllers\Table\TableStructureController->displayStructure(大批，大批，大批，,大批，大批，).\tbl_structure.php#57: PhpMyAdmin\Controllers\Table\TableStructureController->indexAction()

.\libraries\classes\Controllers\Table\TableStructureController.php#1278: PhpMyAdmin\Controllers\Table\TableStructureController->getTableStats() .\libraries\classes\Controllers\Table\TableStructureController.php#377: PhpMyAdmin\Controllers\Table\TableStructureController->displayStructure( array, array, array, , array, array, ) .\tbl_structure.php#57: PhpMyAdmin\Controllers\Table\TableStructureController->indexAction()

我似乎无法弄清楚，每当我尝试创建表时都会发生这种情况.我的桌子看起来像这样:

I can't seem to figure it out, this occurs whenever I try create a table.My table looks like this:

推荐答案

执行以下步骤:

1. 打开你的 MySQL 配置文件:[drive]\xampp\mysql\bin\my.ini

1. Open your MySQL configuration file: [drive]\xampp\mysql\bin\my.ini

或

在 MySQL 行的 XAMMP 面板上 > config > my.ini

On XAMMP panel in MySQL row > config > my.ini

查找:#MySQL服务器[mysqld]

Look up for: # The MySQL server [mysqld]

这篇关于表中每一行的非法字符串偏移量 'Data_length'/'Index_length'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！