Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
Unable to save result set in...
Hi
i am working on a site hosted in txd and I am getting this error <b>both in the front and the back end</b>:
<code>Warning: mysql_query() [function.mysql-query]: Unable to save result set in /users/home/mysite/web/public/central/textpattern/lib/txplib_db.php on line 57</code>
using 4.02/svn1091
the error occurs even with all plugins off and in testing, debugging and live mode.
Here are the diagnostics (the friend I am designing this for requested me to hide the address for now)
Textpattern version: 4.0.2 (r1076)
last_update: 2005-11-09 06:57:14/2005-11-01 15:01:29
Document root: /users/home/mysite/web/public
$path_to_site: /users/home/mysite/web/public/central
Textpattern path: /users/home/mysite/web/public/central/textpattern
Permanent link mode: section_id_title
upload_tmp_dir: /tmp
Temp folder: /users/home/mysite/web/public/central/textpattern/tmp
Site URL: mysite.com/central
PHP version: 5.0.4
server_time: 2005-11-09 10:41:26
MySQL: 4.1.14-log
Locale: en_GB.UTF-8
Server: Apache
.htaccess file contents:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#RewriteBase /relative/web/path/
<IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]
RewriteRule ^(.*) index.php </IfModule>#php_value register_globals 0
————————————
Does anybody have any ideas?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#2 2005-11-09 10:55:28
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Offline
Re: Unable to save result set in...
Thanks zem. used phpMyadmin which repaired and optimised my tables
>Edit: typos typos typos!
Last edited by colak (2005-11-10 07:13:10)
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#4 2005-11-09 20:29:49
- killnine
- Member
- Registered: 2005-11-06
- Posts: 16
Re: Unable to save result set in...
When do you get it, is it when you do something like post a comment? Or is it simply there when you load.?
Offline
Re: Unable to save result set in...
Hi killnine
It was there when I loaded both the front part of the site and in the admin.
It was a corrupted table which caused it.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Unable to save result set in...
ditto, had that problem when the servers crashed… repair table worked!
Offline
Pages: 1