#818 Type Table and Character Set is Missing in all Tables in MariaDB (MYSQL)

[DaRK AnGeL]

Type Table and Character Set is Missing in all Tables in MariaDB (MYSQL) in docker for Unraid (linux x64)
is only avalible in all row.
is it a bug ?
if not how it can be fixed ?

[Micheal Mand]

I also have this problem on a server as well as locally. Weirdly, one of my servers works just fine. I thought it might have been a MySQL information_schema issue, but I don't know enough about DBA to know how to fix it.

Here's my setups:

Broken server:

• Ubuntu 20.04.2 LTS
• Adminer 4.8.1
• MySQL version: 8.0.24 through PHP extension MySQLi
• PHP version: 8.0.5

---

Local:

• macOS 11.5.2
• Adminer 4.8.1
• MySQL version: 5.5.5-10.5.10-MariaDB-1:10.5.10+maria~focal through PHP extension MySQLi
• PHP version: 8.0.10

---

Working server:

• Ubuntu 18.04.5
• Adminer 4.8.1
• MySQL version: 8.0.24 through PHP extension MySQLi
• PHP version: 8.0.3

I'm going to update the servers later this week, so I'll write back if anything changes (unless this issue is solved earlier).

[Stephan]

This is probably a duplicate of Ticket #810

Deactivate error_reporting in php.ini, this will help you for now. That is probably the reason why one of your servers work and another doesn't. I bet that their error reporting config are different.

[Jigal van Hemert]

The actual issue is that in https://github.com/vrana/adminer/blob/f6880b59d6ab40444407616701c1376c90aba5a5/adminer/script.inc.php#L15 the variable $sql is not initialized. Turning error reporting off is not the right fix of course :-)