The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 7 posts ] 
Author Message
PostPosted: Tue Feb 02, 2010 4:31 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Feb 02, 2010 4:26 am
Posts: 1
Hi all,

In the admin panel, when I go to module manager I get the following error:

Code:
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /libraries/joomla/database/database/mysql.php on line 223


Also, pagination does not work in the module manager page.

On the front end, the site looks wrong too.

I was moving around a module to different positions when it happened.

I've tried repairing all the tables in the database thru phpmyadmin.

Any help is greatly appreciated! Thanks in advance!!


Top
 Profile  
 
PostPosted: Fri Mar 19, 2010 5:22 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Apr 02, 2008 6:59 am
Posts: 5
Please repair your jos_session table


Top
 Profile  
 
PostPosted: Mon Dec 20, 2010 11:07 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Aug 13, 2010 8:24 am
Posts: 14
Repair All your Tables from PhpMyAdmin


Top
 Profile  
 
PostPosted: Sat Jan 01, 2011 7:14 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Fri Aug 13, 2010 9:44 am
Posts: 3
Happy new year for all!


I've got the same problem and see this error on the Module-view:

Code:
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/domains/pd2rld.nl/public_html/libraries/joomla/database/database/mysql.php on line 223


I repaired the whole database in PhpMyAdmin and try also to repair the session-table, but nothing works. I made a backup of the database, delete the original and put the backup back again, still the same error.

Hopefully can anybody tell me how I fix this error.

Roland.


Top
 Profile  
 
PostPosted: Fri May 13, 2011 4:54 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Tue May 04, 2010 8:36 pm
Posts: 128
You fixed this error yet ? How big is your site and are you trying to list a section with a whole load of articles ?

_________________
Retete culinare, mancaruri => http://reteteaz.net
Legislatie actualizata gratis la zi => http://legeaz.net


Top
 Profile  
 
PostPosted: Thu Feb 23, 2012 10:48 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Feb 22, 2012 9:55 pm
Posts: 2
Hello,

Has anyone come to a solution for this issue?

We are receiving the following errors when loading a category in category blog view. This seems to be a related issue to what you mention above.

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /htdocs/libraries/joomla/database/database/mysql.php on line 223

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /htdocs/libraries/joomla/database/database/mysql.php on line 344

Thank You!


Top
 Profile  
 
PostPosted: Thu Jul 26, 2012 3:51 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Mar 12, 2007 7:04 pm
Posts: 19
Does anyone have a solution to this problem? Our site have been going down for the past few weeks with this error and I have reviewed the code in mysql.php but cannot find a solution. I have seen post indicating this is a traffic issue however our server was offline for a while and still over loaded the cpu.

I am on J1.5 attempting to move for a while . Our site has over 100,000 articles with 3,000 menu items on K2, for me a big mistake since K2 does not give me the flexibility of moving back to Joomla.

We are on a could server server. Any ideas on how we could solve this problem would be appreciated.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 



Who is online

Users browsing this forum: No registered users and 47 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group