vb.org Archive - Deleted wrong user

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

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

- - Deleted wrong user (https://vborg.vbsupport.ru/showthread.php?t=74093)

lasto

01-09-2005 08:35 PM

Deleted wrong user

ok by mistake i have deleted a user when it should of been another member.Tiredness makes people do bad things :(

anyway on the board all his posts are now set to guest - is there anyway at all by way of a query or soemthing i can restore his account or is it gone for good.

Also relised its in wrong section as well sorry

Jolten

01-09-2005 09:45 PM

A backup of the db user table and restore his account.

Then you can run an update query to alter the post users to his name, assuming that's the only "Guest" posting.

lasto

01-09-2005 10:00 PM

dont want to restore to a backup m8 as that defeats the problem.If i go to a backup (his account will be fine)but i lose 2 days posts.Guests are not allowed to post on the board and no one is posting as guest as well.
I see his posts and threads still on the board but under his name he is now set to guests.So was hoping was someway of getting his posts threads back under a new ID.
Edit

Misread your post soz

so what tables do i need to backup m8 as i have backups - is it just the usertable i need to restore and if so i can do that but what do i do from there ?

Jolten

01-10-2005 03:27 AM

Restore just his account. Restoring from a backup doesn't mean you have to restore everything. Open the .sql file in a text editor, find the user table and his account and run a query to insert the values. All the code you need will be right there with the user table all you need is the following and run it in the sql query window.

Code:

INSERT INTO user VALUES('X', 'X', '', 'X', 'XXXX', 'XXXX', 'XX', ... etc....);

organik81

05-23-2005 08:14 PM

this is my deleted account's information in backup.sql :

Code:

INSERT INTO user VALUES('4', '9', '', '0', 'organik81', '11282228e7345f3b2987cdf888ff605a', '2005-01-24', 'organik81@cennetforum.com', '1', '', 'http://www.cennetforum.com/', '', '', '', '1', '<span style=\"color: brown;\">Development</span>', '1', '1106301600', '0', '1110928451', '1110929509', '1110406320', '278', '30', '6', '1', '0', '0', '0', '3543', '07-24-1981', '1981-07-24', '30', '2', '81.213.99.81', '0', '2', 'xorganik81x@hotmail.com', '0', '0', '-1', '26', '0', 'oh8');

I run it in phpMyAdmin ; and this is the result : #1136 - Column count doesn't match value count at row 1 ?????

All times are GMT. The time now is 09:05 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02962 seconds Memory Usage 1,722KB 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 (2)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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: