Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
corrupt language table
hello
I had posted a problem with a corrupt language table a few weeks back. That was my first textpattern install. Now im on my second install and the same thing has happened again.
I was able to fix the problem by emptying the txp_lang table. Will that screw anything else up?
Obviously this is not a coincidence, what could i be doing that corrupts this table?
Heres the post from the first incident.
http://forum.textpattern.com/viewtopic.php?id=21304
heres the errors.
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/nwtc/www/textpattern/lib/txplib_db.php on line 78
Warning: Incorrect key file for table: ‘txp_lang’. Try to repair it select name from txp_lang where lang=‘en-gb’ limit 1 in /home/nwtc/www/textpattern/lib/txplib_db.php on line 84
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/nwtc/www/textpattern/lib/txplib_db.php on line 78
Warning: Incorrect key file for table: ‘txp_lang’. Try to repair it select name, data from txp_lang where lang=‘en-gb’ in /home/nwtc/www/textpattern/lib/txplib_db.php on line 84
its a bad hen that wont scratch itself.
photogallery
Offline
Re: corrupt language table
Oh one more bit of information that may be useful here.
In php my admin i get this warning:
UNIQUE and INDEX keys should not both be set for column `lang`
its a bad hen that wont scratch itself.
photogallery
Offline
#3 2007-04-10 18:03:37
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: corrupt language table
The phpMyAdmin warning is not related.
It won’t screw anything up. Remember to re-install the language(s) you need. You should always try and repair the lang table first, and empty it only if that fails.
(And of course, you can’t do that – empty the table & start over – with any of the other tables. In that situation you would have to restore from a backup when repair fails.)
Offline
Offline
#5 2007-04-11 23:57:28
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: corrupt language table
I added a new FAQ for the phpMyAdmin error message.
Regarding the table corruption: did you try repairing the table?
Last edited by zem (2007-04-11 23:57:51)
Alex
Offline
Pages: 1