Textpattern CMS

#1 2009-09-21 10:21:05

Phil_

Member

Registered: 2009-09-21

Posts: 37

[Solved] 4.2.0 Upgrade issues "Table upgrade required"

Hi,

I just upgraded to 4.2.0 as instructed I checked my diagnostics tab and see that 11 of my database tables require repair.

This is a typical message:
txp_category: error: Table upgrade required. Please do “REPAIR TABLE `txp_category`” to fix it!,
Full list pasted below.

I have done REPAIR TABLE `txp_category` on this and REPAIR TABLE <<name>> on the other tables and as instructed have been to read tips on the MySQL web site. Even though I have repaired the tables and checked them I am still getting the same error message.

The version of MySQL installed on my server is 5.0.27

I can see no difference between the tables that Textpattern says require repair and the ones it does not flag up and wonder if there is an issue with the script that checks the database tables within Textpattern 4.2.0.

Apart from this my site is working fine.

Thanks in advance for any suggestions.

Phil

mysql_table_errors:
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_form: error: Table upgrade required. Please do “REPAIR TABLE `txp_form`” to fix it!,
txp_lang: error: Table upgrade required. Please do “REPAIR TABLE `txp_lang`” to fix it!,
txp_log: error: Table upgrade required. Please do “REPAIR TABLE `txp_log`” to fix it!,
txp_page: error: Table upgrade required. Please do “REPAIR TABLE `txp_page`” 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!

#2 2009-09-21 12:19:33

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: [Solved] 4.2.0 Upgrade issues "Table upgrade required"

Fire up PHPmyadmin and use that to check your tables. All that TXP does is use MySQL CHECK TABLE query to check the tables, so it’s not TXP itself that reports the error, but MySQL.

#3 2009-09-21 18:57:13

Phil_

Member

Registered: 2009-09-21

Posts: 37

Re: [Solved] 4.2.0 Upgrade issues "Table upgrade required"

Hi Ruud,

Many thanks for taking the trouble to reply.

I did all of what you suggested and was getting very confused as whatever I did had no apparent effect. Which is why I posted here. I eventually phoned my host company. Who told me I had moved away from their DNS server. I knew for sure that I had not done this so a bit of digging and it turned out that I’d been DNS hijacked though goodness knows why this particular little site would be targetted. Anyway I pointed back to the correct DNS and have spent the afternoon rebuilding the database. I didn’t have a full backup that I trusted and so had to input a lot of stuff by hand.

Thanks again

Phil