vb.org Archive - Locked Myself Out

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Locked Myself Out (https://vborg.vbsupport.ru/showthread.php?t=220835)

HayleyP

08-13-2009 11:35 PM

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.

Jinovich

08-14-2009 12:56 AM

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 ;

HayleyP

08-14-2009 01:18 AM

I did that and image verification is still there..

Winterworks

08-14-2009 01:24 AM

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.

Lynne

08-14-2009 01:31 AM

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.

HayleyP

08-14-2009 01:37 AM

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.

Lynne

08-14-2009 01:41 AM

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.

HayleyP

08-14-2009 01:41 AM

No, I didn't get an error.

Lynne

08-14-2009 02:02 AM

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?

HayleyP

08-14-2009 02:48 AM

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

Lynne

08-14-2009 02:58 AM

Post 2 has that info.

table - setting
varname = hv_type
value = 0

HayleyP

08-14-2009 03:08 AM

Yeah I checked and it's set to 0. Sigh.. haha

Lynne

08-14-2009 03:11 AM

And you still see the images when you try to register? Do you have any modifications? Perhaps we should turn those off. Disable them from your config.php file:
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:


		
			
define('DISABLE_HOOKS', true);

Senti.Jatt

08-14-2009 03:23 AM

why don't you try to manually add a user in phpmyadmin and then run tools.php to get back administrator access??

HayleyP

08-14-2009 03:41 AM

Done that. Still not working.

Dismounted

08-14-2009 06:04 AM

Find an MD5 hashing utility (there are probably ones that work online).
Hash a temporary password.
Look in the user table. Note down the "salt" field next to your name.
Take the output of step 2 and add the "salt" onto the end of it.
Put this assortment of characters into the MD5 utility again, and hash it.
Place the output of this into the "password" field.
Login to your forum and change your password.

HayleyP

08-15-2009 12:33 AM

THANK YOU. That worked perfectly.

All times are GMT. The time now is 01:41 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01096 seconds Memory Usage 1,741KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (17)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: