FORUM COMPLETELY CRAPPED OUT

[Mortin]

Ok

last night my mysql database went down

and today it's back up

now I get this message when trying to access my forum:
http://www.apushardware.com/vb/index.php

There seems to have been a slight problem with the 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.


now im getting SPAMMED with email

(around 300 emails every 30 minutes)
from this god damn forum

and its not even up

I HAVE TRIED EVERYTHING TO GET IT TO GO BACK UP

in the email it says this:
Database error in vBulletin: Invalid SQL: INSERT INTO session (sessionid,userid,ipaddress,lastactivity,location) VALUES (NULL,0,'195.153.219.170',973513033,'/vb/index.php')
mysql error: Duplicate entry '11442' for key 1
mysql error number: 1062
Date: Monday 06th of November 2000 06:17:13 AM
Script: /vb/index.php
Referer:


what can I DO?!?!?!?!?!?

[chrispadfield]

sounds like table corruption to me. You are getting the emails because when the forum fails it sends you one, each email is one hit to the forum:

Solution: find a post by EVA2000 on the forum, look in his siguature for a thread on database repair and follow it through, it should sort the problem out. It sounds as if you have two rows with the same id, 11442. A simple fix may be just to delete one of the rows using phpMyadmin .

[eva2000]

here's a post by me :)

check this thread - http://vbulletin.com/forum/showthread.php?threadid=3944

note the steps outlined in their are for MySQL version 3.22 and below, if you have MySQL 3.23 you use myisamchk instead of isamchk

[Freddie Bingham]

Go into phpMyAdmin and "Empty" the session table. If that doesn't work then do a search on "INSERT into session" on this forum and you will find a script by me that will drop your session table and re-create. You lose no data from this as this is a table that holds temp data.