[Solved] Illegal string offset ‘Data_length’/’Index_length’ for every row of table

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

Warning in .librariesclassesControllersTableTableStructureController.php#1339
Illegal string offset ‘Data_length’

Backtrace

.librariesclassesControllersTableTableStructureController.php#1278: PhpMyAdminControllersTableTableStructureController->getTableStats()
.librariesclassesControllersTableTableStructureController.php#377: PhpMyAdminControllersTableTableStructureController->displayStructure(
array,
array,
array,
,
array,
array,
)
. bl_structure.php#57: PhpMyAdminControllersTableTableStructureController->indexAction()
Warning in .librariesclassesControllersTableTableStructureController.php#1342
Illegal string offset ‘Index_length’
Backtrace

.librariesclassesControllersTableTableStructureController.php#1278: PhpMyAdminControllersTableTableStructureController->getTableStats()
.librariesclassesControllersTableTableStructureController.php#377: PhpMyAdminControllersTableTableStructureController->displayStructure(
array,
array,
array,
,
array,
array,
)
. bl_structure.php#57: PhpMyAdminControllersTableTableStructureController->indexAction()

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

enter image description here

Solution #1:

Do these steps:

  1. Open your MySQL configuration file: [drive]xamppmysqlinmy.ini

    OR

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

  2. Look up for: # The MySQL server [mysqld]

  3. Add this right below it: lower_case_table_names = 2
  4. Save the file and restart MySQL service
Respondent: Atul Jain

The answers/resolutions are collected from stackoverflow, are licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0 .

Leave a Reply

Your email address will not be published.