• Hello!

    Either you have not registered on this site yet, or you are registered but have not logged in. In either case, you will not be able to use the full functionality of this site until you have registered, and then logged in after your registration has been approved.

    Registration is FREE, so please register so you can participate instead of remaining a lurker....

    Please be certain that the location field is correctly filled out when you register. All registrations that appear to be bogus will be rejected. Which means that if your location field does NOT match the actual location of your registration IP address, then your registration will be rejected.

    Sorry about the strictness of this requirement, but it is necessary to block spammers and scammers at the door as much as possible.

Corrupted database

Rich Z

Rich Z

Administrator
Staff member
Administrator
Insiders Club
Sorry gang, but a table in the database got corrupted which left no choice but to roll back to the last good backup file. So it looks like everything was lost from the past day. There was no way around it, unfortunately.

Please keep you eyes open for database error messages from this site. If you see one, please cut and paste it into this thread so I can pass it onto my server guys. This may be caused by the server updates done about a week ago...
 
That sucks, but ya gotta do what ya gotta do.

Could have been worse, we could have lots the whole board!
 
I just want to say thanks for fixing the problem Rich.

We all need our ""fix"" ya know!! :dgrin:
 
No wonder my PMs were reset...lol. Not the end of the world.....good thing you had a very recent backup!
 
I was wondering where my thread disappeared to lol Thanks for fixing the problem, I'll have to ask my computer major boyfriend what a corrupted data base is about. And I'll repost the lost thread thanks again Rich.
 
OK Rich, when I tried to get into my PMs this morning, I received the following:

Database Error Database error
The CornSnakes.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 www.cornsnakes.com home page, then try to open another page.
* Click the Back button to try another link.

The www.cornsnakes.com 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 3.7.3: Invalid SQL: SELECT pm.*, pmtext.* , icon.title AS icontitle, icon.iconpath FROM pm AS pm LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid) LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid) WHERE pm.userid=59 AND pm.folderid=0 ORDER BY pmtext.dateline DESC LIMIT 0, 50; MySQL Error : Can't create/write to file '/tmp/#sql_fd5_0.MYI' (Errcode: 30) Error Number : 1 Request Date : Thursday, October 7th 2010 @ 06:44:40 AM Error Date : Thursday, October 7th 2010 @ 06:44:40 AM Script : http://www.cornsnakes.com/forums/private.php Referrer : http://www.cornsnakes.com/forums/ IP Address : 74.179.126.8 Username : Susan Classname : vB_Database MySQL Version : 5.0.91-community
Click to expand...

I even opened a new window, logged on and still got the same message.
 
I was in my PMs really early, like just after 0500, without a problem, but now I get the same message as Susan. 0648.
 
And this is what I get when I try to go into my User CP (minus the initial BS):

WHERE pm.userid = 59
AND pm.messageread = 0
ORDER BY pmtext.dateline DESC
LIMIT 5;

MySQL Error : Can't create/write to file '/tmp/#sql_fd5_0.MYI' (Errcode: 30)
Error Number : 1
Request Date : Thursday, October 7th 2010 @ 06:48:26 AM
Error Date : Thursday, October 7th 2010 @ 06:48:26 AM
Script : http://www.cornsnakes.com/forums/usercp.php
Referrer : http://www.cornsnakes.com/forums/showthread.php?p=1207007
IP Address : 74.179.126.8
Username : Susan
Classname : vB_Database
MySQL Version : 5.0.91-community
Click to expand...
 
Great! Me too! So glad I didn't do a huge photo shoot thread yesterday with the new babies!!
 
Fauna is out completely for me this morning.
I can get in by clicking links but pms and things are dead there too.
 
Last edited:
USERCP msg at 8:40 eastern


Database error The CornSnakes.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 www.cornsnakes.com home page, then try to open another page.
  • Click the Back button to try another link.
The www.cornsnakes.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
 
Just got the same error as everyone else 0859EST

"The CornSnakes.com Forums database has encountered a problem."
 
I just got the same page as tsst when I tried to send or read PMs. I was trying to PM Rich about the error when trying to read a PM, actually!
 
Yeah, me too - 0825 central time.

And I'm kinda relieved to know why my PMs disappeared. I wondered if I was losing my mind! :lol:
 
You must log in or register to reply here.
Back
Top