Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2007-05-14 08:34:04

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 700
Website Mastodon

my sql errors in 4.0.4 / "Unable to save result ..."

Hello

i’m using txp 4.0.4 just for comments on a friend’s site.
Unfortunately i am getting SQL errors, when trying to
update user passwords.

looking like this:

“ Warning: mysql_query(): Unable to save result set in /home/annalivia/public_html/comments/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/annalivia/public_html/comments/textpattern/lib/txplib_db.php on line 84 Warning: mysql_query(): Unable to save result set in /home/annalivia/public_html/comments/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/annalivia/public_html/comments/textpattern/lib/txplib_db.php on line 84 Warning: Cannot modify header information – headers already sent by (output started at /home/annalivia/public_html/comments/textpattern/lib/txplib_db.php:78) in /home/annalivia/public_html/comments/textpattern/include/txp_auth.php on line 163”

Does anyone have a clue what this means? i can;t see thru it.

Thanx a zillion, really, and in advance.


A hole turned upside down is a dome, when there’s also gravity.

Offline

#2 2007-05-14 09:54:20

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: my sql errors in 4.0.4 / "Unable to save result ..."

Have you tried repairing the txp_lang table?

Offline

#3 2007-05-14 12:06:01

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 700
Website Mastodon

Re: my sql errors in 4.0.4 / "Unable to save result ..."

thanx ruud, that fixed it, was happy to find a repair option in phpmyadmin on that server, otehrwise the control panel on myserverworld.com does not have any option like this.

question remains: why did it get corrupted at all?
just curious.
and MANY thanx, ruud, again.


A hole turned upside down is a dome, when there’s also gravity.

Offline

#4 2007-05-14 16:16:51

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: my sql errors in 4.0.4 / "Unable to save result ..."

Why? -> FAQ :)

Offline

Board footer

Powered by FluxBB