Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MariaDB: Unknown system variable 'disabled_storage_engines' #17331

Closed
gs71 opened this issue Feb 2, 2022 · 1 comment
Closed

MariaDB: Unknown system variable 'disabled_storage_engines' #17331

gs71 opened this issue Feb 2, 2022 · 1 comment
Assignees
Labels
Bug A problem or regression with an existing feature has-pr An issue that has a pull request pending that may fix this issue. The pull request may be incomplete
Milestone

Comments

@gs71
Copy link

gs71 commented Feb 2, 2022

Describe the bug

MariaDB does not support system variable 'disabled_storage_engines', so clicking on the 'Engines' link produces an error in the SQL errors log (if enabled):

2022-02-02 9:00:52 root[root] @ localhost [] ERROR 1193: Unknown system variable 'disabled_storage_engines' : SELECT @@disabled_storage_engines

To Reproduce

Steps to reproduce the behavior:

  1. Enable the SQL errors log in MariaDB ("sql_error_log_filename" variable)
  2. Click on 'Engines'
  3. See error in log file

Expected behavior

No error

Server configuration

  • Operating system: Linux
  • Web server: Apache
  • Database version: MariaDB 10.6.5
  • PHP version: 8.1.2
  • phpMyAdmin version: 5.2

Client configuration

  • Browser: any
  • Operating system: any

Additional context

Bug can be fixed by modifying line 122 in file libraries/classes/StorageEngine.php:

from:
if ($dbi->getVersion() >= 50708) {

to:
if (!$dbi->isMariaDB() && $dbi->getVersion() >= 50708) {

@williamdes williamdes added the Bug A problem or regression with an existing feature label Feb 3, 2022
@williamdes williamdes added this to the 5.1.3 milestone Feb 3, 2022
@williamdes williamdes self-assigned this Feb 3, 2022
@williamdes
Copy link
Member

Thank you for the report @guidoselva !

@williamdes williamdes added the has-pr An issue that has a pull request pending that may fix this issue. The pull request may be incomplete label Feb 3, 2022
williamdes added a commit that referenced this issue Feb 3, 2022
Signed-off-by: William Desportes <williamdes@wdes.fr>
@github-actions github-actions bot locked as resolved and limited conversation to collaborators Feb 4, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Bug A problem or regression with an existing feature has-pr An issue that has a pull request pending that may fix this issue. The pull request may be incomplete
Projects
None yet
Development

No branches or pull requests

2 participants