phpmyadmin · gs71 · Mar 31, 2026 · Mar 31, 2026 · Mar 31, 2026 · Mar 31, 2026
diff --git a/libraries/classes/Engines/Innodb.php b/libraries/classes/Engines/Innodb.php
@@ -1,3 +1,3 @@
 <?php
 /**
 * The InnoDB storage engine
@@ -264,7 +264,7 @@
        global $dbi;

        return '<pre id="pre_innodb_status">' . "\n"
            . htmlspecialchars((string) $dbi->fetchValue(
                'SHOW ENGINE INNODB STATUS;',
                'Status'
            )) . "\n" . '</pre>' . "\n";
@@ -281,38 +281,22 @@
         return 'innodb-storage-engine';
     }
 
-    /**
-     * Gets the InnoDB plugin version number
-     *
-     * @return string the version number, or empty if not running as a plugin
-     */
-    public function getInnodbPluginVersion()
-    {
-        global $dbi;
-
-        return $dbi->fetchValue('SELECT @@innodb_version;') ?: '';
-    }
-
     /**
      * Gets the InnoDB file format
      *
      * (do not confuse this with phpMyAdmin's storage engine plugins!)
      *
      * @return string|null the InnoDB file format
      */
-    public function getInnodbFileFormat(): ?string
+    public function getInnodbFileFormat()
     {
         global $dbi;
 
-        $value = $dbi->fetchValue("SHOW GLOBAL VARIABLES LIKE 'innodb_file_format';", 1);
-
-        if ($value === false) {
-            // This variable does not exist anymore on MariaDB >= 10.6.0
-            // This variable does not exist anymore on MySQL >= 8.0.0
-            return null;
-        }
-
-        return (string) $value;
+        return
+          ($dbi->isMariaDB() && $dbi->getVersion() >= 100600)
+          || ($dbi->isMySql() && $dbi->getVersion() >= 80000)
+            ? ''
+            : $dbi->fetchValue("SHOW GLOBAL VARIABLES LIKE 'innodb_file_format';", 1);
     }
 
     /**

diff --git a/libraries/classes/Operations.php b/libraries/classes/Operations.php
@@ -232,7 +232,7 @@
            }

            // this does not apply to a rename operation
            if (! isset($_POST['add_constraints']) || empty($GLOBALS['sql_constraints_query'])) {
                continue;
            }

@@ -519,11 +519,7 @@
 
         /** @var Innodb $innodbEnginePlugin */
         $innodbEnginePlugin = StorageEngine::getEngine('Innodb');
-        $innodbPluginVersion = $innodbEnginePlugin->getInnodbPluginVersion();
-        $innodb_file_format = '';
-        if (! empty($innodbPluginVersion)) {
-            $innodb_file_format = $innodbEnginePlugin->getInnodbFileFormat() ?? '';
-        }
+        $innodb_file_format = $innodbEnginePlugin->getInnodbFileFormat();
 
         /**
          * Newer MySQL/MariaDB always return empty a.k.a '' on $innodb_file_format otherwise

diff --git a/test/classes/Engines/InnodbTest.php b/test/classes/Engines/InnodbTest.php
@@ -225,14 +225,6 @@ public function testGetMysqlHelpPage(): void
         self::assertSame('innodb-storage-engine', $this->object->getMysqlHelpPage());
     }
 
-    /**
-     * Test for getInnodbPluginVersion
-     */
-    public function testGetInnodbPluginVersion(): void
-    {
-        self::assertSame('1.1.8', $this->object->getInnodbPluginVersion());
-    }
-
     /**
      * Test for supportsFilePerTable
      */