diff options
author | William Desportes <williamdes@wdes.fr> | 2019-05-28 00:29:19 +0300 |
---|---|---|
committer | William Desportes <williamdes@wdes.fr> | 2019-05-28 00:29:19 +0300 |
commit | fd7f2397d36fdcbae7123ef078c536e8e197ffc4 (patch) | |
tree | d4f3356b0e50c3df588277e7145e9e18909a2ec8 | |
parent | 9d586fc539aacd19399df867e9136e7cce250157 (diff) |
Fix #15283 - phpMyAdmin tries to change collation on Views when changing collation on all tables/fields
Fixes: #15283
# 1347 [Name of View] is not BASE TABLE
Signed-off-by: William Desportes <williamdes@wdes.fr>
-rw-r--r-- | libraries/db_common.inc.php | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/libraries/db_common.inc.php b/libraries/db_common.inc.php index bca8f2d07d..c008e80213 100644 --- a/libraries/db_common.inc.php +++ b/libraries/db_common.inc.php @@ -101,6 +101,11 @@ if (isset($_REQUEST['submitcollation']) ) { list($tables, , , , , , , ,) = PhpMyAdmin\Util::getDbInfo($db, null); foreach($tables as $tableName => $data) { + if ($GLOBALS['dbi']->getTable($db, $tableName)->isView()) { + // Skip views, we can not change the collation of a view. + // issue #15283 + continue; + } $sql_query = 'ALTER TABLE ' . PhpMyAdmin\Util::backquote($db) . '.' |