Help I was running "Rebuild Forum Information", site crashed/main forum page error

[kellyandmike]

Help,
Last night, I was in admin, pruned posts, rebuilt thread information 100 at a time, and then chose "Rebuild Forum Information". That shut the site down.

What I have since found is that I can get to the site, just not from the main index page. I can read Private Messages, get to my vbulletin admin, email users, post, reply and all, just not get to the main page.

I am running 3.5.4

Here is the error I get:
Warning: mysql_query(): Unable to save result set in /includes/class_core.php on line 405

The main page is at www.couponchix.com/feedback

Here is the link that works to one of the forums: http://couponchix.com/feedback/forumdisplay.php?s=&daysprune=&f=4

Please help.
And thanks in advance,

Kelly

[Ted S]

Your actual error is something much more tangible (you can find it by viewing the page source):

Invalid SQL:

SELECT title, data
FROM datastore
WHERE title IN ('','options','bitfields','forumcache','usergroupc ache','stylecache','languagecache','products','plu ginlist','cron','userstats','birthdaycache','maxlo ggedin','iconcache','eventcache','mailqueue');

MySQL Error : Got error 127 from table handler
Error Number : 1030
Date : Saturday, April 14th 2007 @ 07:17:07 PM
Script : http://couponchix.com/feedback/
Referrer : https://vborg.vbsupport.ru/showthread.php?t=144898
IP Address : 207.167.100.99
Username :
Classname : vb_database

Error 127s are no fun but generally they can be fixed. Run Repair/Optimize in the Admin CP, repeat a few times if necessary.

If things remain broken, ssh into your server and run the CHECK and REPAIR commands in mysql.

If you're still stuck let me know and I can explain about dealing with serious corruption.

[kellyandmike]

Thank you for replying. I will try it this afternoon,

Your actual error is something much more tangible (you can find it by viewing the page source):

Invalid SQL:

SELECT title, data
FROM datastore
WHERE title IN ('','options','bitfields','forumcache','usergroupc ache','stylecache','languagecache','products','plu ginlist','cron','userstats','birthdaycache','maxlo ggedin','iconcache','eventcache','mailqueue');

MySQL Error : Got error 127 from table handler
Error Number : 1030
Date : Saturday, April 14th 2007 @ 07:17:07 PM
Script : http://couponchix.com/feedback/
Referrer : https://vborg.vbsupport.ru/showthread.php?t=144898
IP Address : 207.167.100.99
Username :
Classname : vb_database

Error 127s are no fun but generally they can be fixed. Run Repair/Optimize in the Admin CP, repeat a few times if necessary.

If things remain broken, ssh into your server and run the CHECK and REPAIR commands in mysql.

If you're still stuck let me know and I can explain about dealing with serious corruption.

I am still stuck. Went to repair the tables through my vb admin and now the page to get into my admin is giving me an error. I can still get into certain pages, but just not the admin. I do have myPhPAdmin, but don't know anything about it. If you can help me, I can give you access. I am working today, from 3PM-9PM EST so if I don't respond until after then, you will know why. ;)

Thanks so much offering to help.
Kelly

Here is the view source on this error:
<!--
Database error in vBulletin :

Invalid SQL:

SELECT title, data
FROM datastore
WHERE title IN ('','options','bitfields','forumcache','usergroupc ache','stylecache','languagecache','products','plu ginlist','cron','maxloggedin','mailqueue','pluginl istadmin');

MySQL Error : Can't open file: 'datastore.MYI'. (errno: 145)
Error Number : 1016
Date : Sunday, April 15th 2007 @ 11:13:43 AM
Script : http://couponchix.com/feedback/admincp/index.php
Referrer : http://couponchix.com/feedback/showthread.php?t=5
IP Address : 208.104.25.214
Username :
Classname : vb_database
-->

FIXED.

Ran REPAIR TABLE datastore; query in myPhp admin.

Thank you so much.

[ThorstenA]

I solved problems with this type by just turning off datastore file cache.

[kellyandmike]

How do you turn off the database cache?

My board is still slow and here is the error message now sometimes...

Database error in vBulletin :

mysql_connect(): Too many connections
/home/couponch/public_html/feedback/includes/class_core.php on line 280

MySQL Error :
Error Number :

Date : Tuesday, April 17th 2007 @ 02:16:08 PM
Script : http://couponchix.com/feedback/search.php?searchid=111430&pp=25&page=2
Referrer : http://couponchix.com/feedback/search.php?searchid=111430
IP Address : 67.83.36.228
Username :
Classname : vb_database

[ThorstenA]

How do you turn off the database cache?


1. open
includes/config.php

2. replace
??line with "using datastore file cache
with
// ??line with "using datastore file cache.

[kellyandmike]

What program do I open it with? I had been opening them with Macromedia Dreamweaver, but ipower told me that one of my files was corrupt and I was thinking it was one that I opened with that program. ipower said it was opened with Word, but was not.

Thanks again for your reply. :up:

[dj_melayu]

Use Notepad :)

[kellyandmike]

HELP with these errors!!!

Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
/home/couponch/public_html/feedback/includes/class_core.php on line 279

MySQL Error :
Error Number :

Date : Thursday, April 19th 2007 @ 07:13:09 AM
Script : http://couponchix.com/feedback/private.php?do=newpm&pmid=87264
Referrer : http://couponchix.com/feedback/private.php?do=showpm&pmid=87264
IP Address : 24.119.192.18
Username :
Classname : vb_database



Database error in vBulletin :

mysql_connect(): Too many connections
/home/couponch/public_html/feedback/includes/class_core.php on line 279

MySQL Error :
Error Number :
Date : Thursday, April 19th 2007 @ 09:42:12 AM
Script : http://couponchix.com/feedback/forumdisplay.php?f=5&daysprune=-1&order=desc&sort=replycount
Referrer :
IP Address : 128.241.20.202
Username :
Classname : vb_database

Running 3.5.4
couponchix.com/feedback

Please help.

[Marco van Herwaarden]

mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

This error means either:
1. The info in your config.php file is wrong (in which case your forums wouldn't work at all), or
2. MySQL crashed, it's not running or it can't find the socket. You need to contact your host about this. Here is more info on this error:
http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html

mysql_connect(): Too many connections

Your host is limiting the maximum number of connections, please contact your host and request this to be raised.