Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
Reload this Page User disappeared
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 12-13-2013, 09:50 PM
CivicKlub CivicKlub is offline
 
Join Date: Jun 2008
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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?
Reply With Quote
  #2  
Old 12-14-2013, 12:14 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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)?
Reply With Quote
  #3  
Old 12-14-2013, 12:35 AM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
Reply With Quote
Благодарность от:
tbworld
  #4  
Old 12-14-2013, 07:37 AM
CivicKlub CivicKlub is offline
 
Join Date: Jun 2008
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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..
Reply With Quote
  #5  
Old 12-14-2013, 10:41 AM
New Joe's Avatar
New Joe New Joe is offline
 
Join Date: May 2009
Posts: 1,128
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
Reply With Quote
  #6  
Old 12-14-2013, 05:06 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by CivicKlub View Post
I will write one more time, user is visible in PHP MyAdmin, so it wasnt deleted..
You mean he shows up in the user table? How about the userfield and the usertextfield tables?
Reply With Quote
  #7  
Old 12-14-2013, 08:53 PM
CivicKlub CivicKlub is offline
 
Join Date: Jun 2008
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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..
Reply With Quote
  #8  
Old 12-14-2013, 10:50 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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?
Reply With Quote
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 02:21 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04110 seconds
  • Memory Usage 2,225KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (1)post_thanks_box_bit
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete