Can't export to .xml on latest 5.0.2 - Error: htmlspecialchars() expects parameter 1 to be string, null given

[pamamolf]

Describe the bug

Export to .xml doesn't work and got an error message ERR_INVALID_RESPONSE on Chrome...

To Reproduce

Steps to reproduce the behavior:
Just try to export anything to .xml

Expected behavior

Export to .xml file.

Screenshots

https://i.postimg.cc/W1yTrPPr/image.png

Server configuration

• Operating system: Centos 7 64bit
• Web server:Nginx 1.17.9
• Database version:MariaDB 10.3.22
• PHP version: 7.4.4
• phpMyAdmin version: 5.0.2

Client configuration

• Browser: Chrome latest
• Operating system: Windows 10

###Additional info:
[02-Apr-2020 20:51:25 UTC] PHP Fatal error: Uncaught TypeError: htmlspecialchars() expects parameter 1 to be string, null given in /usr/local/nginx/html/mysqladmin/libraries/classes/Plugins/Export/ExportXml.php:315
Stack trace:
#0 /usr/local/nginx/html/mysqladmin/libraries/classes/Plugins/Export/ExportXml.php(315): htmlspecialchars()
#1 /usr/local/nginx/html/mysqladmin/export.php(448): PhpMyAdmin\Plugins\Export\ExportXml->exportHeader()
#2 {main}
thrown in /usr/local/nginx/html/mysqladmin/libraries/classes/Plugins/Export/ExportXml.php on line 315

Thank you

[ibennetch]

Thanks for the report! We will look in to it.

[ibennetch]

The error message you've helpfully provided should be enough for us to fix this, however I can't reproduce it.

The value of $tbl here should be the CREATE statement that gets placed in the <pma:table name... tag, and it's not immediately clear to me why this could be null.

Would you mind exporting an SQL file of the database structure (obscuring any sensitive information) and posting it here so I can check against your specific table structure? Could you also confirm if you're trying to export the complete database or just one table?

[williamdes]

Here is my proposal patch, could you test it @pamamolf ?

diff --git a/libraries/classes/Plugins/Export/ExportXml.php b/libraries/classes/Plugins/Export/ExportXml.php
index db85add4e2..7ef348cdc3 100644
--- a/libraries/classes/Plugins/Export/ExportXml.php
+++ b/libraries/classes/Plugins/Export/ExportXml.php
@@ -290,7 +290,7 @@ class ExportXml extends ExportPlugin
                     . Util::backquote($table),
                     0
                 );
-                $tbl = $result[$table][1];
+                $tbl = (string) $result[$table][1];
 
                 $is_view = $GLOBALS['dbi']->getTable($db, $table)
                     ->isView();

[pamamolf]

Yes it works !

Thank you

[williamdes]

Thank you, I will commit it to close this issue :)

[williamdes]

Done as 4f4b86d
Sorry for the delay