You are currently reviewing an older revision of this page.
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
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`
© 2020 Appian. All rights reserved.