KB-1348 502 error on phpMyAdmin after creating two tables with the same name but different case

Symptoms

phpMyAdmin throws a 502 error.

Cause

This can happen if there are two tables with the same name but different casing (e.g. lowercase vs UPPERCASE vs camelCase).

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`

If unable to do so, contact Appian Technical Support who can restart MySQL to remove any locks and can execute these statements.

Affected Versions

This applies to all versions of Appian Cloud.

Last Reviewed: May 2017

Related
Recommended