Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2009, 11:35 PM
HayleyP HayleyP is offline
 
Join Date: Jun 2007
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Locked Myself Out

So, yeah. I did something really stupid. I was trying to change my password on my test forum and well, long story short I'm now locked out of my own forum :\ I can't register a new account and make them admin because my forums are turned off. When I try and get my password reset thing sent to me I can't see the CAPTCHA image (apparently because my forums are turned off). Is there any way I can reset my password via phpMyAdmin? Or at least a way to turn them back on? Thanks

--------------- Added [DATE]1250211502[/DATE] at [TIME]1250211502[/TIME] ---------------

Ok, so I got them turned back on but I can't register a new account or send myself a password reset email because captcha isn't working for some reason.. I also tried copying my password from my fully functional (not test) forum (from phpMyAdmin) and pasting it as this account's password but it still isn't working.
Reply With Quote
  #2  
Old 08-14-2009, 12:56 AM
Jinovich Jinovich is offline
 
Join Date: Mar 2005
Location: England
Posts: 51
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Run this query on your DB. It should disable the human verification.

Code:
UPDATE `setting` SET `value` = '0' WHERE `setting`.`varname` = 'hv_type' LIMIT 1 ;
Reply With Quote
  #3  
Old 08-14-2009, 01:18 AM
HayleyP HayleyP is offline
 
Join Date: Jun 2007
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I did that and image verification is still there..
Reply With Quote
  #4  
Old 08-14-2009, 01:24 AM
Winterworks Winterworks is offline
 
Join Date: Feb 2008
Location: Canada
Posts: 640
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Pretty sure there's an option in phpMyAdmin to enable registration again, or something. Take a quick peek for it. I'll try to look too.
Reply With Quote
  #5  
Old 08-14-2009, 01:31 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I replied to your thread over on vb.com about registering a new user and using tools.php to promote that user to an admin. Then reset your admin password.
Reply With Quote
  #6  
Old 08-14-2009, 01:37 AM
HayleyP HayleyP is offline
 
Join Date: Jun 2007
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Registration is enabled. I can't register, though because my image verification isn't working properly for some reason so it won't let me.
Reply With Quote
  #7  
Old 08-14-2009, 01:41 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

When you tried to disable image verification per post 2, did you get an error? If you use a prefix, then you need to add your prefix to the beginning of the table name.
Reply With Quote
  #8  
Old 08-14-2009, 01:41 AM
HayleyP HayleyP is offline
 
Join Date: Jun 2007
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No, I didn't get an error.
Reply With Quote
  #9  
Old 08-14-2009, 02:02 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do you have access to phpMyAdmin to check the setting manually? And did you do a Force Refresh on the registration page after you turned it off?
Reply With Quote
  #10  
Old 08-14-2009, 02:48 AM
HayleyP HayleyP is offline
 
Join Date: Jun 2007
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I do. Whereabouts is image verification in the db? And what should it be in order for it to be off?
Reply With Quote
Reply


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 07:09 AM.


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.05873 seconds
  • Memory Usage 2,244KB
  • Queries Executed 13 (?)
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_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete