User disappeared
 

I have problem with vbulletin 4.2.2. One of the oldest user disappeared. I checked in logs no one delete them or modify... User cant log in, there is message like there is no such user. Posts of this user are visible like Guest, and you cant search him in admin panel.
User record is visible in database in tables user,userfield,usertextfield. His post are visible in table post and there is correct userid and username.
I have tried to repair tables, and repair profile users, but without any result..
Please help what should I check more?
What select query vbulletin is using to check if username exist?

You checked the control panel logs? How about looking at the access_logs around the time he disappeared? Or how about the server access logs (you may need to ask your host how to access those)?

Almost afraid to ask - do you have a recent backup?

There may also be some help for you here:

https://vborg.vbsupport.ru/showthread.php?t=199120

I have access_logs only for last day, so its to late..
I have recent backup, but user disappered 4 days ago, its meaningless to now restore database and lost 4 days of data..
I will write one more time, user is visible in PHP MyAdmin, so it wasnt deleted..

I remember seeing a mod which would restore a deleted member, but can't find it.
I found this one but it's in the graveyard:
https://vborg.vbsupport.ru/showthrea...=236861&page=7

The only other thing is this:
http://www.vbulletin.com/forum/forum...deleted-member

You mean he shows up in the user table? How about the userfield and the usertextfield tables?

Yes.. but..
I found something..
select query from vbulletin admin panel shows something different than query form phpMyAadmin..
What the hell...? I`am connected to unknown server..

Your message is really to vague for us to help. Can you be more specific about the *exact* query you ran in phpMyAdmin and the *exact* query you ran in the Admincp? And what is this about an unknown server?