Admin account became guest during database error

[khininger]

Hello,

Our forum was experiencing some database errors and during this time period an Admin logged out.
That Admin account is now listed as "guest" on all posts and is not listed elsewhere on forums.
It is as if the account was deleted but there is nothing in the logs showing this account was deleted.
A database repair was ran.
I have no idea what to do now.

The glitches we were experiencing when this occured were error messages claiming this Admin was an invalid user when another member tried to p.m., many threads temporarily dissapeared and users were being logged out.

Really appreciate any help offered!

[Marco van Herwaarden]

Without the full error message we can only guess.

[khininger]

Astericks added /editted by me.

Database error in vBulletin 3.8.0:

Invalid SQL:

REPLACE INTO threadread
(threadid, userid, readtime)
VALUES
(5633, 668, 1252354877);

MySQL Error : Duplicate entry '1252354877' for key 2
Error Number : 1062
Request Date : Thursday, September 17th 2009 @ 03:00:37 AM
Error Date : Thursday, September 17th 2009 @ 03:00:37 AM
Script : http://www.fortrefuge.com/forum/showthread.php?t=5633
Referrer : http://www.fortrefuge.com/forum/online.php
IP Address : **.175.77.47
Username : Jenny
Classname : vb_database
MySQL Version :

This is Admin deleted:

Database error in vBulletin 3.8.0:

Invalid SQL:
INSERT INTO pmtext
(fromuserid, fromusername, title, message, iconid, dateline, showsignature, allowsmilie, touserarray)
VALUES
(2, 'Lala', 'Re: Need password to chat', 'You dont need a password to chat except the password that parachat emails you.\r\nYou register with parachat at the top of the \"support page\". In main website. YOu can get there by clicking Chatrooms at top of forums.\r\n\r\nLala\r\n\r\n\r\n\r\nLala,\r\nI need a password to chat. Can you help? The message said one would be sent to me, but I haven\'t received one yet.', 0, 1253156981, 0, 1, 'a:1:{s:2:\"cc\";a:1:{i:847;s:11:\"S*ftsecrets\";}}');

MySQL Error : Duplicate entry '5052' for key 1
Error Number : 1062
Request Date : Thursday, September 17th 2009 @ 03:09:41 AM
Error Date : Thursday, September 17th 2009 @ 03:09:42 AM
Script : http://www.fortrefuge.com/forum/private.php?do=insertpm&pmid=9504
Referrer : http://www.fortrefuge.com/forum/private.php?do=showpm&pmid=9504
IP Address : ***.39.228.68
Username : Lala
Classname : vb_database
MySQL Version : 4.1.14

--------------- Added 1253193864 at 1253193864 ---------------

This came up on database repair:

user Check Warning: Size of datafile is: 112336 Should be: 108868 user Check Error: Wrong bytesec: 0-0-0 at linkstart: 108868 user Check Error: Corrupt

[snakes1100]

Do you have a prior backup of the DB before this issue?

If not, you can try a repair via the cmd line.
change to directory of your db and run the following below.
myisamchk -o -f *

If this is a winblows server, you will need to install the sql command line client and do the above via it.

[Marco van Herwaarden]

If there is too much corruption, then restoring a backup would be a good solution.

If it is only the original error message then please see Duplicate entry 'XXX' (http://www.vbulletin.com/docs/html/mysql_duplicatekey)