Merging threads

[PhilipAlv]

Hi,an old admin in my forum got into my database and deleted my username.i got everything restored through vB.com

now,here is the problem.All the old threads i posted are now showing up as posted by 'Guest'

is there any way i can get the threads back ?

i have come back in the same old username....

thanks

[Marco van Herwaarden]

Make a note of your new userid and use that in the following 2 queries (replace NEW_USERID and USERNAME with the correct values):

[sql]update post set userid = NEW_USERID where username = 'USERNAME';[/sql]
[sql]update thread set postuserid = NEW_USERID where postusername = 'USERNAME';[/sql]
You might need to run update counters and maybe clear your post cache before the change will show.

[PhilipAlv]

thanks for the reply....

a small doubt...USERNAME is the old id that got deleted...right..?

[Marco van Herwaarden]

USERNAME = the old username (and you stated that you created a new account with the same name, so same as new name also)

PS Create a backup before running manual queries.

[PhilipAlv]

Hi,i tried running the query..but i m getting this error...

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'mydatabase_me.post' doesn't exist

I havent changed or removed any tables from my database...

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

i do have a table which says vb_post in my vB database...this table is around 48 MB in size...

I used the "manual query" option in the admincp....

[calorie]

Try adding vb_ to the table names in the post two queries.

[PhilipAlv]

Hi, so instead of "update post set userid ",i got to type in "update vb_post set userid"...right...?

my config.php file says
Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'vb_';

i guess this is the reason why all my tables start with vb_

is there any particular advantage in setting it like this ?

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

Hi,i changed 'post with "vb_post" and i m now getting this error


error number: 1146
error desc: Table 'mydatabase_me.vb_' doesn't exist