Is there a way to find email address of a deleted user?

[Pathum]

OK, I have run them one at a time.. sory about the above, I did did not read well...
anyway it returns the error

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

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

[Matthew Gordon]

You must be using a table prefix. Find the following part of your config.php file:

    //    ****** TABLE PREFIX ******
    //    Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = ''; 

You'll need to insert the table prefix in front of post and thread in the queries. For example, if your config.php looks like this:

    //    ****** TABLE PREFIX ******
    //    Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'vb_'; 

you'd need to change the queries to this:

UPDATE vb_post SET userid = Y WHERE userid = X;
UPDATE vb_thread SET postuserid = Y WHERE postuserid = X;

[Pathum]

Wow,,,
true


Returned this

Affected Rows: 0 (0.0001s)

and nothing happend

[Matthew Gordon]

Try these instead. Change X to their username and Y to their userid. You don't need their old userid for these. Make sure that you add the table prefixes.

UPDATE post SET userid = [color=green]Y[/color] WHERE username = '[color=blue]X[/color]';
UPDATE thread SET postuserid = [color=green]Y[/color] WHERE postusername = '[color=blue]X[/color]';

[Pathum]

Cool, thank you Matthew.
One more thing ....
Now I have their post count set to zero and can not visualize started threads posts blogs etc...

- - - Updated - - -

and gives me "invalid user specified ...." when viewing their profile in older posts....

- - - Updated - - -

Practically I have got the old user account cancelled...

[John Lester]

Next time a situation like this arises you are better off "merging" the accounts via the admin control panel. I did as you, deleted the old user and then ran around in circles for a week tying the old posts to the new userid. Someone from here told me to merge them next time, and it was sooooo easy

[Pathum]

thanks, now it is too late for that either......