You are currently reviewing an older revision of this page.
phpMyAdmin throws a 502 error.
This can happen if there are two tables with the same name, but different casing (e.g. lowercase vs UPPERCASE vs camelCase).
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`
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`
If unable to do so, contact Appian Technical Support who can restart MySQL to remove any locks and can execute these statements.
This applies to all versions of Appian.
Last Reviewed: May 2017