You are currently reviewing an older revision of this page.
Symptoms
When there are two tables with the same name, but different casing (e.g. lowercase vs UPPERCASE vs camelCase), the following can occur:
phpMyAdmin throws a 502 error whenever there is a UI that displays both tables
phpMyAdmin throws a 502 error when trying to drop either table
Cause
Action
To fix the issue, run the following commands in phpMyAdmin:
RENAME TABLE `MY_TABLE` TO `MY_TABLE_KEEP_ME`;RENAME TABLE `my_table` TO `my_table_drop_me`;RENAME TABLE `MY_TABLE_KEEP_ME` TO `MY_TABLE`;DROP TABLE `my_table_drop_me`