Skip to content

[Bug]: ErrorException: Error reading structure for table test.test: #1932 - Table "test.test" doesn't exist in engine #20160

New issue
New issue
Open
Open
[Bug]: ErrorException: Error reading structure for table test.test: #1932 - Table "test.test" doesn't exist in engine#20160
Labels
BugA problem or regression with an existing featureaffects/5.2This issue or pull-request affects 5.2.x releases (and maybe further versions)affects/6.0This issue or pull-request affects 6.0.x releases (and maybe further versions)confirmed/5.2This issue is confirmed to be reproduced on 5.2 at the time this label was setconfirmed/6.0This issue is confirmed to be reproduced on 6.0 at the time this label was set
@liviuconcioiu

Description

@liviuconcioiu
liviuconcioiu
opened on Feb 21, 2026

Describe the bug

ErrorException: Error reading structure for table test.test: #1932 - Table "test.test" doesn't exist in engine

https://reports.phpmyadmin.net/reports/view/87640

phpmyadmin/libraries/classes/Plugins/Export/ExportSql.php

Lines 1533 to 1547 in 3f658b8

$result = $dbi->tryQuery(
'SHOW CREATE TABLE ' . Util::backquote($db) . '.'
. Util::backquote($table)
);
// an error can happen, for example the table is crashed
$tmpError = $dbi->getError();
if ($tmpError) {
$message = sprintf(__('Error reading structure for table %s:'), $db . '.' . $table);
$message .= ' ' . $tmpError;
if (! defined('TESTSUITE')) {
trigger_error($message, PHP_VERSION_ID < 80400 ? E_USER_ERROR : E_USER_WARNING);
}
return $this->exportComment($message);
}

Also, this should be also fixed for all other export formats. Is not the same error, but it adds HTML code.

On 6.0.0-dev, there's no error for SQL, but for XML for example it outputs the entire HTML page, and the database tag is not closed. So, it should iterate all tables that can be read, and at the end add the closing tag.

How to Reproduce

  1. Start MySQL/MariaDB skip-innodb
  2. Try to export a database that uses InnoDB
  3. See error

phpMyAdmin version

5.2.4-dev, 6.0.0-dev

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugA problem or regression with an existing featureaffects/5.2This issue or pull-request affects 5.2.x releases (and maybe further versions)affects/6.0This issue or pull-request affects 6.0.x releases (and maybe further versions)confirmed/5.2This issue is confirmed to be reproduced on 5.2 at the time this label was setconfirmed/6.0This issue is confirmed to be reproduced on 6.0 at the time this label was set

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions