phpMyAdmin tries to change collation on Views when changing collation on all tables/fields

[hexydec]

Describe the bug

phpMyAdmin attempts to update the collation of views when you ask it to change the collation on all tables and fields. It returns an error with the statement that attempts to do this with the error:

#1347 [Name of View] is not BASE TABLE

To Reproduce

On a database that has a view:

1. Go to "Operations"
2. Scroll to "Collation"
3. Tick "Change all tables collations"
4. Tick "Change all tables columns collations" (Note the bug may appear without clicking this - not tested)
5. Click "Go"

Expected behavior

The collations of all tables and fields should be set to the selected collation.

Server configuration

• Operating system: Windows and Linux
• Web server: Apache and Nginx
• Database version: MySQL 5.7.17-log - MySQL Community Server (GPL) and MariaDB 10.2.24-MariaDB-log - MariaDB Server
• PHP version: 7.3
• phpMyAdmin version: 4.8.5

[williamdes]

Duplicate of #14575

[williamdes]

See: #14575 (comment)

[github-actions]

This issue has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.