HELP!!!!!! DB Error? Bad SQL Query?

logos · 08-25-2004, 12:09 PM

I just went to visit my gaming site www.gloads.com to upload some games and it says this in the header of the home page:

DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars WHERE session_id NOT IN ('1706172cb6515c2decc054ff49417126', '3869c525a42066252da398948a7a6096', '7d8cd5b37adde2e9bf8ac969de6897da', ETC!!!! Visit www.gloads.com to see for yourself!

What does this mean??? Also how do I fix this error?
Unfortunatly it has not stopped the site from running normally?
If anyone of you guys can fix it I'll give you advertisement free for 2 months as well as 100np$!
????: NamePros.com http://www.namepros.com/the-break-room/44901-help-db-error-bad-sql-query.html

Thanks comments are extremly appreciated!!!

Scott · 08-25-2004, 12:11 PM

Login to PHPMyAdmin and run:

Code:

REPAIR TABLE 4images_sessionvars

LeeRyder · 08-25-2004, 12:11 PM

seems to me like the database is just a little busy right now. Let your host work it out by giving it a couple of hours. that should be enough time to clear it up.

I've seen it take up to 24 hours for something like this to be resolved, so submit a ticket and be patient. it is vary vary rare for a MySQL DB to spontaniously self destruct without outside help.

logos · 08-25-2004, 12:12 PM

Now this is what it's telling me?

Incorrect key file for table: '4images_sessionvars'. Try to repair it!

Scott · 08-25-2004, 12:18 PM

Have you tried REPAIR TABLE 4images_sessionvars ?

Scott · 08-25-2004, 07:48 PM

All fixed for logos!

PM me if you need anything else.

08-25-2004, 12:09 PM	THREAD STARTER #1 (permalink)
logos Account Closed Join Date: May 2004 Location: USA Posts: 373	HELP!!!!!! DB Error? Bad SQL Query? I just went to visit my gaming site www.gloads.com to upload some games and it says this in the header of the home page: DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars WHERE session_id NOT IN ('1706172cb6515c2decc054ff49417126', '3869c525a42066252da398948a7a6096', '7d8cd5b37adde2e9bf8ac969de6897da', ETC!!!! Visit www.gloads.com to see for yourself! What does this mean??? Also how do I fix this error? Unfortunatly it has not stopped the site from running normally? If anyone of you guys can fix it I'll give you advertisement free for 2 months as well as 100np$! ????: NamePros.com http://www.namepros.com/the-break-room/44901-help-db-error-bad-sql-query.html Thanks comments are extremly appreciated!!!

08-25-2004, 12:11 PM	#2 (permalink)
Scott Senior Member Join Date: Jun 2003 Location: UK Posts: 3,541	Login to PHPMyAdmin and run: Code: REPAIR TABLE 4images_sessionvars

	NamePros Account Upgrade	Forum Sponsorship
	Take advantage of our upgraded membership levels (2 levels to choose from) so you can have MORE active sales threads, Custom Titles, A Directory Listing, Invisible Mode, Message Tracking, And MORE!

08-25-2004, 12:11 PM	#3 (permalink)
LeeRyder Account Suspended Join Date: Jan 2004 Location: Left Coast Posts: 3,503	seems to me like the database is just a little busy right now. Let your host work it out by giving it a couple of hours. that should be enough time to clear it up. I've seen it take up to 24 hours for something like this to be resolved, so submit a ticket and be patient. it is vary vary rare for a MySQL DB to spontaniously self destruct without outside help.

08-25-2004, 12:12 PM	THREAD STARTER #4 (permalink)
logos Account Closed Join Date: May 2004 Location: USA Posts: 373	Now this is what it's telling me? Incorrect key file for table: '4images_sessionvars'. Try to repair it!

08-25-2004, 12:18 PM	#5 (permalink)
Scott Senior Member Join Date: Jun 2003 Location: UK Posts: 3,541	Have you tried REPAIR TABLE 4images_sessionvars ?

08-25-2004, 07:48 PM	#6 (permalink)
Scott Senior Member Join Date: Jun 2003 Location: UK Posts: 3,541	All fixed for logos! PM me if you need anything else.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)