[Bug]: ErrorException: Undefined array key "Create_time"

Describe the bug

I have this table used for testing. Don't know how I created it (probably some SQL import, it has a few years) that shows those errors when I try to acces it. I really don't know why or what I'm missing. I only get the errors when DisableIS is set to false.

When I click on table name:

Internal error in .\src\Table\Table.php#291
ErrorException: Undefined array key "Create_time"

When I click on Structure:

Internal error in .\resources\templates\table\structure\display_table_stats.twig#4
Twig\Error\RuntimeError: Key "TABLE_COMMENT" for sequence/mapping with keys "Data_length, Index_length" does not exist in "table/structure/display_table_stats.twig" at line 4.

Tried to patch the code here and there, but then also:

Internal error in .\resources\templates\table\structure\display_table_stats.twig#92
Twig\Error\RuntimeError: Key "Create_options" for sequence/mapping with keys "Data_length, Index_length" does not exist in "table/structure/display_table_stats.twig" at line 92.

If I patch this too, I can access the table but table information like rows, size, is missing.

getStatusInfo returns null for everything for this specific table and this is causing the errors.

The thing is Create_time date is present, TABLE_COMMENT and Create_options are empty strings:

SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAME`         AS `Name`, `TABLE_TYPE`         AS `TABLE_TYPE`, `ENGINE`             AS `Engine`, `ENGINE`             AS `Type`, `VERSION`            AS `Version`, `ROW_FORMAT`         AS `Row_format`, `TABLE_ROWS`         AS `Rows`, `AVG_ROW_LENGTH`     AS `Avg_row_length`, `DATA_LENGTH`        AS `Data_length`, `MAX_DATA_LENGTH`    AS `Max_data_length`, `INDEX_LENGTH`       AS `Index_length`, `DATA_FREE`          AS `Data_free`, `AUTO_INCREMENT`     AS `Auto_increment`, `CREATE_TIME`        AS `Create_time`, `UPDATE_TIME`        AS `Update_time`, `CHECK_TIME`         AS `Check_time`, `TABLE_COLLATION`    AS `Collation`, `CHECKSUM`           AS `Checksum`, `CREATE_OPTIONS`     AS `Create_options`, `TABLE_COMMENT`      AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA`  IN ('test22') AND t.`TABLE_NAME`  IN ('Country');

Shows:

TABLE_CATALOG,Db,Name,TABLE_TYPE,Type,Version,Row_format,Rows,Avg_row_length,Data_length,Max_data_length,Index_length,Data_free,Auto_increment,Create_time,Update_time,Check_time,Collation,Checksum,Create_options,Comment,MAX_INDEX_LENGTH,TEMPORARY,Db,Name,TABLE_TYPE,Engine,Type,Version,Row_format,Rows,Avg_row_length,Data_length,Max_data_length,Index_length,Data_free,Auto_increment,Create_time,Update_time,Check_time,Collation,Checksum,Create_options,Comment
def,test22,country,BASE TABLE,MyISAM,10,Fixed,239,261,62379,73464968921481215,5120,0,NULL,2024-06-06 19:43:51,2024-12-02 00:55:55,2024-06-06 19:43:51,latin1_swedish_ci,NULL,,,1125899906841600,N,test22,country,BASE TABLE,MyISAM,MyISAM,10,Fixed,239,261,62379,73464968921481215,5120,0,NULL,2024-06-06 19:43:51,2024-12-02 00:55:55,2024-06-06 19:43:51,latin1_swedish_ci,NULL,,

SHOW TABLE STATUS FROM `test22` WHERE Name = 'Country';

Shows:

Name 	Engine 	Version 	Row_format 	Rows 	Avg_row_length 	Data_length 	Max_data_length 	Index_length 	Data_free 	Auto_increment 	Create_time 	Update_time 	Check_time 	Collation 	Checksum 	Create_options 	Comment 	Max_index_length 	Temporary 	
Country 	MyISAM 	10 	Fixed 	239 	261 	62379 	73464968921481215 	5120 	0 	NULL 	2024-06-06 19:43:51 	2024-12-02 00:55:55 	2024-06-06 19:43:51 	latin1_swedish_ci 	NULL 			1125899906841600 	N

How to Reproduce

$cfg['Servers'][$i]['DisableIS'] = false;

1. Stop MariaDB server
2. Copy the MyISAM table to a folder in data folder

Country.zip

3. Start MariaDB server
4. Try to access the table or structure

Expected behavior

Table should be readable.

Screenshots

No response

Operating System

No response

Web Server

nginx/1.29.4

Database Server

No response

Database version

MariaDB/12.2.1

PHP version

8.5.2

phpMyAdmin version

5.2.4-dev, 6.0.0-dev

browser

No response

Additional context

No response