You are currently reviewing an older revision of this page.

Error on phpMyAdmin after creating two tables with the same name, different case

Symptoms

phpMyAdmin throws a 502 error.

Cause

This will 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`

This applies to all versions of Appian.

Last Reviewed: May 2017