Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2007-05-09 05:05:59
- scdoody
- Member
- Registered: 2006-10-18
- Posts: 129
Help - crazy sql errors - site worked yesterday and is broken today
Help!!
When I go to my blog homepage, the page displays – but some of the CSS fonts are mixed up and I get these errors at the top:
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/7871/domains/mydomain.com/html/_0507test/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-us’ limit 1 in /home/7871/domains/mydomain.com/html/_0507test/textpattern/lib/txplib_db.php on line 84
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/7871/domains/mydomain.com/html/_0507test/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’ AND ( event=‘public’ OR event=‘common’) in /home/7871/domains/mydomain.com/html/_0507test/textpattern/lib/txplib_db.php on line 84
Offline
#2 2007-05-09 05:22:52
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Offline
#3 2007-05-09 05:35:47
- scdoody
- Member
- Registered: 2006-10-18
- Posts: 129
Re: Help - crazy sql errors - site worked yesterday and is broken today
My preflight check says:
mysql_table_errors: txp_lang: error: Size of indexfile is: 98304 Should be: 101376,
txp_lang: error: Corrupt
From this article http://textpattern.com/faq/240/diagnostics-mysql-table-errors it leads me to believe that somehow my database got corrupted.
So having no database experience – what can I do to troubleshoot this – I don’t understand how to use this plugin http://www.wilshireone.com/textpattern-plugins/rss_admin_db_manager to help solve the problem
Cheers
Offline
#4 2007-05-09 05:43:28
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: Help - crazy sql errors - site worked yesterday and is broken today
That FAQ has pointers to some information. The process for repairing a table depends on your server and host, so we can’t help with the specifics.
Alex
Offline
Re: Help - crazy sql errors - site worked yesterday and is broken today
scdoody wrote:
So having no database experience – what can I do to troubleshoot this – I don’t understand how to use this plugin http://www.wilshireone.com/textpattern-plugins/rss_admin_db_manager to help solve the problem
Install it, enable it. Then go to Extenstions>db manager and click on the repair links which show as red. Do not click on the DROP links as these delete the tables.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#6 2007-05-09 05:55:02
- scdoody
- Member
- Registered: 2006-10-18
- Posts: 129
Re: Help - crazy sql errors - site worked yesterday and is broken today
thank you so much colak!!!!! have a great night.
Offline