Textpattern CMS

#1 2008-02-20 11:04:33

castanet

Member

From: Oxford

Registered: 2005-03-19

Posts: 97

How do I repair a table

Hi
Just noticed this in my diagnostics:
textpattern: error: Table upgrade required. Please do “REPAIR TABLE `textpattern`” to fix it!,
txp_category: error: Table upgrade required. Please do “REPAIR TABLE `txp_category`” to fix it!,
txp_css: error: Table upgrade required. Please do “REPAIR TABLE `txp_css`” to fix it!,
txp_discuss: error: Table upgrade required. Please do “REPAIR TABLE `txp_discuss`” to fix it!,
txp_discuss_ipban: error: Table upgrade required. Please do “REPAIR TABLE `txp_discuss_ipban`” to fix it!,
txp_discuss_nonce: error: Table upgrade required. Please do “REPAIR TABLE `txp_discuss_nonce`” to fix it!,
txp_file: error: Table upgrade required. Please do “REPAIR TABLE `txp_file`” to fix it!,
txp_form: error: Table upgrade required. Please do “REPAIR TABLE `txp_form`” to fix it!,
txp_image: error: Table upgrade required. Please do “REPAIR TABLE `txp_image`” to fix it!,
txp_lang: error: Table upgrade required. Please do “REPAIR TABLE `txp_lang`” to fix it!,
txp_link: error: Table upgrade required. Please do “REPAIR TABLE `txp_link`” to fix it!,
txp_log: error: Table upgrade required. Please do “REPAIR TABLE `txp_log`” to fix it!,
txp_log_mention: error: Table upgrade required. Please do “REPAIR TABLE `txp_log_mention`” to fix it!,
txp_page: error: Table upgrade required. Please do “REPAIR TABLE `txp_page`” to fix it!,
txp_plugin: error: Table upgrade required. Please do “REPAIR TABLE `txp_plugin`” to fix it!,
txp_prefs: error: Table upgrade required. Please do “REPAIR TABLE `txp_prefs`” to fix it!,
txp_priv: error: Table upgrade required. Please do “REPAIR TABLE `txp_priv`” to fix it!,
txp_section: error: Table upgrade required. Please do “REPAIR TABLE `txp_section`” to fix it!,
txp_users: error: Table upgrade required. Please do “REPAIR TABLE `txp_users`” to fix it!

Can someone please tell a MySQL dummy how to do REPAIR TABLE.
Thanks

#2 2008-02-20 14:11:06

colak

Admin

From: Cyprus

Registered: 2004-11-20

Posts: 9,200

Website GitHub Mastodon Twitter

Re: How do I repair a table

Can someone please tell a MySQL dummy how to do REPAIR TABLE.

From one dummy to another. You can either login to your db via phpMyAdmin where you will select all tables and in the pull down menu, you select repair. or you can install rss_admin_db_manager which offers a that capability. If you are using TXP 4.0.6 download the plugin from here

---

Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

#3 2008-02-20 14:33:27

castanet

Member

From: Oxford

Registered: 2005-03-19

Posts: 97

Re: How do I repair a table

Thanks, Colak. The plugin did the job. All checks passed!