mysql error when click [Top Statistics]

[onel0ve]

Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 413
Database Error Database error
The Fileserve Hotfile Filesonic Duckload Mediafire oron Free Premium Download database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the forum.smiling-dream.info home page, then try to open another page.
* Click the Back button to try another link.

The forum.smiling-dream.info forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.
Database error in vBulletin 4.0.8: Invalid SQL: SELECT * FROM thread ORDER BY replycount DESC; MySQL Error : Lost connection to MySQL server during query Error Number : 2013 Request Date : Thursday, February 3rd 2011 @ 08:08:48 AM Error Date : Thursday, February 3rd 2011 @ 08:08:49 AM Script : http://******/admincp/stats.php?do=top Referrer : http://*********/admincp/stats.php?do=index IP Address : ******.187 Username : warez Classname : vB_Database MySQL Version :

onel0ve Reviewed by onel0ve on 3rd Feb 2011. mysql error when click [Top Statistics] Warning: mysql_query() : Unable to save result set in /includes/class_core.php on line 413 Database Error Database error The Fileserve Hotfile Filesonic Duckload Mediafire oron Free Premium Download database has encountered a problem. Please try the following: * Load the page again by clicking the Refresh button in your web browser. * Open the forum.smiling-dream.info home page, then try to open another page. * Click the Back button to try another link. The Rating: 5

[Lock Down]

Lost connection to MySQL server during query Error Number : 2013

Your mysql is timing out. Could be too many connections or one of those wonderful mods that has a malformed sql statement. If this is your vps/dedi you can optimize mysql by changing timeouts and connections.

to start try:

mysql> show variables like "%timeout%";
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| connect_timeout | 5 |
| delayed_insert_timeout | 300 |
| innodb_lock_wait_timeout | 50 |
| interactive_timeout | 28800 |
| net_read_timeout | 100 |
| net_write_timeout | 60 |
| slave_net_timeout | 3600 |
| wait_timeout | 28800 |
+--------------------------+-------+

mysql> SET @@NET_READ_TIMEOUT=200;

mysql> SET @@connect_timeout=30;

mysql> show variables like "%timeout%";

Expand

[onel0ve]

ok thanks

[Lock Down]

You are welcome.