Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2005-08-25 10:32:12
- skinnylatte
- Member
- Registered: 2004-10-04
- Posts: 13
Unable to save result set in ..
getting this message on the header of my public site and admin site, though i haven’t modified any information.
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/…/public/textpattern/lib/txplib_db.php on line 53
and on my admin site,
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/…/public/textpattern/lib/txplib_db.php on line 53
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/…/public/textpattern/lib/txplib_db.php on line 53
Warning: Cannot modify header information – headers already sent by (output started at /home/…/public/textpattern/lib/txplib_db.php:53) in /home/…/public/textpattern/include/txp_auth.php on line 143
Warning: Cannot modify header information – headers already sent by (output started at /home/…/public/textpattern/lib/txplib_db.php:53) in /home/…/public/textpattern/include/txp_auth.php on line 145
Any ideas on what I can do?
Last edited by skinnylatte (2005-08-25 10:35:24)
Offline
#2 2005-08-25 10:44:11
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: Unable to save result set in ..
Run a table repair via phpmyadmin or the mysql command line. Even if ‘check table’ says it’s fine.
If that doesn’t help, talk to your web host; they might’ve upgraded PHP or MySQL incorrectly.
Alex
Offline
Re: Unable to save result set in ..
I think this is just a textdrive thing. It’s happened to me twice now out of the blue and a couple other people as well.
So I started a thread at Textdrive
…but no one has helped as of yet.
Offline
#4 2005-08-25 13:48:34
- skinnylatte
- Member
- Registered: 2004-10-04
- Posts: 13
Re: Unable to save result set in ..
> andreaparrish wrote:
> I think this is just a textdrive thing. It’s happened to me twice now out of the blue and a couple other people as well.
Yeah, I’m on textdrive too and I found it very puzzling (I’m on gilford). I’m wondering if it has somethign to do with the server migration?
Anyway I did what zem said, repairing tables in phpmyadmin solved it.
Last edited by skinnylatte (2005-08-25 13:53:28)
Offline
#5 2005-08-25 23:29:16
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: Unable to save result set in ..
I’m wondering if it has somethign to do with the server migration?
Nobody knows what causes it yet. There are any number of possible causes, from installation errors to hardware problems.
The error message is a meaningless fallback; basically PHP is saying “something went wrong with MySQL and I don’t know what”.
Alex
Offline
#6 2005-08-28 23:11:20
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: Unable to save result set in ..
is this going to be a frequent problem?
We don’t know. It’s not caused by Textpattern, it’s a MySQL or server issue.
Alex
Offline
#7 2005-08-29 03:47:35
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Unable to save result set in ..
i.e: Go ask Textdrive tech support. :)
Offline
Re: Unable to save result set in ..
out of the 18 tables are are we to know which one is causing the problem?? is there a clue that i should be looking for in the eror message? thx….
…. texted postive
Offline
#9 2005-10-27 22:19:36
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: Unable to save result set in ..
is there a clue that i should be looking for in the eror message? thx….
I’d try the ‘textpattern’ table first, but it could be any of them.
Alex
Offline
Re: Unable to save result set in ..
don’t know which table the problem was in, as i repaired each one and then checked the site .. and voila it was fixed!
BUT i noticed the following warnings (which still exist after doing table repairs)..
txptxp_form:
PRIMARY and INDEX keys should not both be set for column `name`
txptxp_lang
UNIQUE and INDEX keys should not both be set for column `lang`
txptxp_page
PRIMARY and INDEX keys should not both be set for column `name`
txptxp_plugin
UNIQUE and INDEX keys should not both be set for column `name`
txptxp_section
PRIMARY and INDEX keys should not both be set for column `name`
Is this something that textpattern needs to be mindful of? or is it a mySQL problem? just curious.
…. texted postive
Offline
#11 2005-11-01 17:58:30
- ktinkel
- Member
- Registered: 2004-06-04
- Posts: 16
Re: Unable to save result set in ..
Well, I sure am glad I found this thread. Day 2 with TextPattern, Day 3 on TextDrive, and wam!
Anyway, repairing all tables fixed it right up. Thanks.
Offline
Pages: 1