Title: table name update failed
Last modified: November 3, 2024
---
# table name update failed
* Resolved [EMar](https://wordpress.org/support/users/sounds/)
* (@sounds)
* [1 year, 7 months ago](https://wordpress.org/support/topic/table-name-update-failed/)
* Hi,
* When I used the option to change table prefix, the home page had
a drop-down
to pick language for a fresh wordpress install.
* It changed the prefix in wp-config but it didn’t change any of the tables in
the database,
Also said it changed the records in usermeta, but I looked in
phpmyadmin, no tables changed.
* I just see this message for every table: table name update failed
* So I switched the table prefix back to wp_ in wp_config to fix the site.
* Any tips appreciated.
* Thanks
Viewing 5 replies - 1 through 5 (of 5 total)
* Plugin Support [hjogiupdraftplus](https://wordpress.org/support/users/hjogiupdraftplus/)
* (@hjogiupdraftplus)
* [1 year, 7 months ago](https://wordpress.org/support/topic/table-name-update-failed/#post-18117395)
* Hi [@sounds](https://wordpress.org/support/users/sounds/),
* It might be some other plugin installed with a drop-down to pick the language
for WordPress.
* Generally, fresh install does not have such an option to change language.
* DB prefix can be changed from the WordPress > Database security > Database prefix
* It might be the form to change prefix submitted but there might be DB operation
rights issue or any other issue the DB prefix is not updated using query and
only in wp-config.php DB prefix changed.
* Do you have WordPress debugging on and the errors are logged in the PHP error
log?
* WP security > Settings > General settings have the Debug log on feature for AIOS
security plugin.
* WP security > Dashboard > Debug log will have the logs but it will be the name
of the table with update failed etc.
* [https://developer.wordpress.org/advanced-administration/debug/debug-wordpress/](https://developer.wordpress.org/advanced-administration/debug/debug-wordpress/)
* Regards
* Thread Starter [EMar](https://wordpress.org/support/users/sounds/)
* (@sounds)
* [1 year, 7 months ago](https://wordpress.org/support/topic/table-name-update-failed/#post-18119112)
* Ok, I have debug turned on now,
Then I did a database backup to UpdraftPlus
and hit changed database prefix. There is nothing in the debug log when checking
afterwards. I only had to set the prefix back in wp-config.php to get the site
working again. Then I went into UpDraft and did database restore from saved file.
* ```
Starting DB prefix change operations.....
Your WordPress system has a total of 22 tables and your new DB prefix will be: br_
A backup copy of your wp-config.php file was created successfully!
wp_aiowps_audit_log table name update failed
wp_aiowps_debug_log table name update failed
wp_aiowps_events table name update failed
wp_aiowps_global_meta table name update failed
wp_aiowps_logged_in_users table name update failed
wp_aiowps_login_lockdown table name update failed
wp_aiowps_message_store table name update failed
wp_aiowps_permanent_block table name update failed
wp_commentmeta table name update failed
wp_comments table name update failed
wp_links table name update failed
wp_litespeed_url table name update failed
wp_litespeed_url_file table name update failed
wp_options table name update failed
wp_postmeta table name update failed
wp_posts table name update failed
wp_term_relationships table name update failed
wp_term_taxonomy table name update failed
wp_termmeta table name update failed
wp_terms table name update failed
wp_usermeta table name update failed
wp_users table name update failed
Please change the prefix manually for the above tables to: br_
Checking for MySQL tables of type "view".....
wp-config.php file was updated successfully!
Update of table br_options failed: unable to change wp_user_roles to br_user_roles
The usermeta table records which had references to the old DB prefix were updated successfully!
The database prefix change tasks have been completed.
```
* Plugin Support [hjogiupdraftplus](https://wordpress.org/support/users/hjogiupdraftplus/)
* (@hjogiupdraftplus)
* [1 year, 7 months ago](https://wordpress.org/support/topic/table-name-update-failed/#post-18119763)
* Hi [@sounds](https://wordpress.org/support/users/sounds/),
* It seems the sql query below fails for to rename the table and change table prefix.
* Which hosting have you used ?
* can you please contact hosting provider as this is not the general case. there
must be some rights issue.
* ```wp-block-code
RENAME TABLE wp_aiowps_audit_log TO br_aiowps_audit_log
```
* Thread Starter [EMar](https://wordpress.org/support/users/sounds/)
* (@sounds)
* [1 year, 7 months ago](https://wordpress.org/support/topic/table-name-update-failed/#post-18121454)
* Hi,
* I have it on my own server, Linux with Centos Web Panel,
Have other wp sites
on there, forget how I did the prefix on those. Think I did a fresh install for
other site.
* I’ll look into it further.
* Thanks
* Plugin Support [hjogiupdraftplus](https://wordpress.org/support/users/hjogiupdraftplus/)
* (@hjogiupdraftplus)
* [1 year, 7 months ago](https://wordpress.org/support/topic/table-name-update-failed/#post-18121825)
* Hi [@sounds](https://wordpress.org/support/users/sounds/),
* Ok, you should cross check the query RENAME do have any privilege issue?
* You may login to mysql server with the username, password and dbname mentioned
in wp-config.php
* Regards
Viewing 5 replies - 1 through 5 (of 5 total)
The topic ‘table name update failed’ is closed to new replies.
* 
* [All-In-One Security (AIOS) – Security and Firewall](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/)
* [Frequently Asked Questions](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/#faq)
* [Support Threads](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/)
* [Active Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/active/)
* [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/unresolved/)
* [Reviews](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/reviews/)
* 5 replies
* 2 participants
* Last reply from: [hjogiupdraftplus](https://wordpress.org/support/users/hjogiupdraftplus/)
* Last activity: [1 year, 7 months ago](https://wordpress.org/support/topic/table-name-update-failed/#post-18121825)
* Status: resolved