Database Errors

[SAVAGE]

Hi guys,

I was made aware of some database errors over the course of the last three days. Initially, it was isolated to one area of the site - and then today we experienced quite a few other errors and on different thread/forums. So here's what we found out... and what we did to fix the issues.

After completing a database repair, the readout showed that there were more then a few threads whose datafiles were corrupted. How they got that way or what exact threads were effected I do not know at this time (I did save a copy of the database so I can research this later)... but one thing was certain.... this should not be occurring.

The database repair fixed the problem - however preventing it from occurring again led me to upgrade the version of vBulletin to the final version of 3.7.x (we were on 3.7.2 - now on 3.7.5). With any luck - these issues will not crop up again.

Special thanks goes out to 93volpe (http://www.southeasternfoxbodies.com/forums/member.php?u=35) for his help in this matter. I didn't get home from work tonight untill about midnight, and really didn't have a lot of time to mess around (I need sleep too :lol1:) He notified me of the problem, what he was doing & the pages of the site that were giving him errors - and also copied down the error message itself and pasted it into the PM. This information allowed me to diagnose the problem in a very short time and complete the upgrade in less then 1 hour. Thanks again buddy - that stuff really saved our asses.:thumbsup2:

[Notch93]

Thanks for the work on the site Mark.:patriot: And Hanley for bringing it to Mark's attention.:yes1::thumbsup1:

[93volpe]

+1... Thanks Mark !! you do an awesome job:thumbsup1::thumbsup1: glad the input was helpful

[SVTSkip]

Thanks Yall !!! :thumbsup1:

[93fakesnake]

Good catch guys. Looks like we need to buy ya'll a steak dinner

[Wayne's 88 GT]

Thanks to Mark and Hanley!!!! :patriot:

[puttputt]

Thanks guys.:thumbsup1:

[bonesgt]

Thanks Mark, sorry to be a pian in yoru butt lately..LOL

[SAVAGE]

Thanks Mark, sorry to be a pian in yoru butt lately..LOL
Not a problem Scott - that's what I do. I am... the fixer :patriot:

And no... you have not been a pain in the butt. When things go poop, that's what I'm here for :yes1:

[Wayne's 88 GT]

Hey guys,
I was trying to send a private message and when I clicked the send button this is what appeared:

Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408
Database error
The SoutheasternFoxBodies.com Forums database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the southeasternfoxbodies.com home page, then try to open another page.
Click the Back button to try another link.
The southeasternfoxbodies.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Is anyone else getting this?

[bonesgt]

Yes Mark It seems the problems are back again, a few members have had problems sending PMs and even a few can not get on the site.

[Notch93]

Hey guys,
I was trying to send a private message and when I clicked the send button this is what appeared:

Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408
Database error
The SoutheasternFoxBodies.com Forums database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the southeasternfoxbodies.com home page, then try to open another page.
Click the Back button to try another link.
The southeasternfoxbodies.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Is anyone else getting this?


Yes SVTSkip is getting the same error.

http://southeasternfoxbodies.com/forums/showthread.php?t=3355

I sent Mark a PM, guess we will have to wait for Mark to fix the problem.

[SAVAGE]

Hey guys,
I was trying to send a private message and when I clicked the send button this is what appeared:

Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408
Database error
The SoutheasternFoxBodies.com Forums database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the southeasternfoxbodies.com home page, then try to open another page.
Click the Back button to try another link.
The southeasternfoxbodies.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Is anyone else getting this?

:hi: Fixed! :patriot:

[Wayne's 88 GT]

Thanks Mark!!

[SAVAGE]

Thanks Mark!!
You're most welcome :)

[speedys87gt]

Hey guys,
I was trying to send a private message and when I clicked the send button this is what appeared:

Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408
Database error
The SoutheasternFoxBodies.com Forums database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the southeasternfoxbodies.com home page, then try to open another page.
Click the Back button to try another link.
The southeasternfoxbodies.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Is anyone else getting this?

I am getting this message sometimes when I click on a thread. Just thought I would pass this along.

[93GTVert]

Thanks!!!! I'm glad it's fixed. :thumbsup1:

[speedys87gt]

I have been getting this error message over the last couple of days sometimes when I try to open a thread and when I try to reply. Not always, just a few times.

[SAVAGE]

I have been getting this error message over the last couple of days sometimes when I try to open a thread and when I try to reply. Not always, just a few times.
I now have the site setup to send me an email anytime here is a database error... so I get notified of the event and get a detailed error discription of what occured. Since I only set this up 2 days ago, I can only say that there has not been any errors over the last 48 hours. I just wanted to let you know that these error are now being monitored - so if one occurs I'll be on it as soon as I can - it's all good :yes1:

[cobra_4]

That is awesome!

[Notch93]

Thanks again Mark, for helping us keep SEFB online.:patriot:

[SAVAGE]

Thanks again Mark, for helping us keep SEFB online.:patriot:
Just doing my part sir :patriot:

Scott & Kelly are close friends... and helping friends is what life is about :thumbsup1:

[speedys87gt]

thanks for your help.:thumbsup1: