MySQL error on Crashed Site

[Cygnus]

http://boards.survivoraddicts.com/index.php

PHP version: 4.3.1
MySQL version: 4.0.11-gamma
Apache version: 1.3.27

Warning

: 1 is not a valid MySQL-Link resource in /hsphere/local/home/survivor/boards.survivoraddicts.com/admin/db_mysql.php on line 93


There seems to have been a slight problem with the SurvivorAddicts.com database.

Please try again by pressing the refresh button in your browser.


An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.


We apologise for any inconvenience.

Database error in vBulletin 2.2.8:
Invalid SQL: SELECT * FROM usergroup WHERE usergroupid=6
mysql error:
mysql error number:
Date: Saturday 29th of March 2003 12:17:48 PM
Script: http://boards.survivoraddicts.com/
Referer:

Warning: 1 is not a valid MySQL-Link resource in /hsphere/local/home/survivor/boards.survivoraddicts.com/admin/db_mysql.php on line 93

There seems to have been a slight problem with the SurvivorAddicts.com database.
Please try again by pressing the refresh button in your browser.


An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.


We apologise for any inconvenience.

Database error in vBulletin 2.2.8:
Invalid SQL: UPDATE session SET lastactivity=1048969066,location='/' WHERE sessionhash='059eb97a5185325b83551dddcb2f82c7'
mysql error:
mysql error number:
Date: Saturday 29th of March 2003 12:17:49 PM
Script: http://boards.survivoraddicts.com/
Referer:

We have run repair.php
I have tried to repair the usergroup table through phpMyAdmin
We restored files from yesterday in case there was script corruption
I have emptied the session table and then run repair.php
I have emptied the session table and then tried to repair usergroup through phpMyAdmin

Nothing is working.

I have looked at these tables using phpMyAdmin and everything LOOKS normal to my untrained eye.

Help?

[Cygnus]

Oh... and for what it is worth, I can log in to the control panel and have no problems navigating around there.

[Cygnus]

From our sysadmin:

I used mysql tools to fix this DB. no errors, no problems but forum doesn't work... old DB and old content..

[TripleH]

Have you added any hacks recently ??

[Cygnus]

Have you added any hacks recently ??

Nope. The last hack I added was about a month ago (vbArcadepro, I think) and the boards have been working flawlessly since then.

[ManagerJosh]

I'm thinking it is an issue with PHP 4.3.1
Lemme check something....

Could you post a copy of your db_mysql.php (upload one that is) to these forums?

[Cygnus]

Sure

Here is db_mysql.php:

vB file code removed. Please do not post vB files.

[ManagerJosh]

OKay...I recommend this and give it a shot..

Reupload the ORIGINAL db_mysql.php from the vBulletin229.zip from the members area (or one stored locally)

It must be the original one, unaltered and with nocodehacks.

See if that solves anything.

[Cygnus]

Same error.

I don't think that I have any hacks that altered db_mysql.php.

[ManagerJosh]

Did your host upgrade PHP/MySQL/Apache within the last 48hrs?

[Cygnus]

I think so. He rolled it back, though, and we were still having the same error.

Why? What's on your mind?

[Scott MacVicar]

sounds like the database connection is being lost after it connects.

Do you have any mysql_close() or $DB_site->close(); in the code anywhere?

[Cygnus]

I don't think we have anything in the code that looks like that.

The odd thing is that I have another site with the same host which has vBulletin boards and they have been working fine all along except for when the host has taken down the server for a reboot or what have you. We're moving MySQL and will retry in about an hour. Hoping that will do it...

[Scott MacVicar]

If you want to pm me your forum details (ftp and admin password) I'll check all the code for it. It is not a database corruption there is a problem with the code which has caused it to close the connection at some point.

[Cygnus]

Appreciate it greatly, Scott. If I am still having issues when we are done moving, I'll PM you all of the necessary info.