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

[Pathum]

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

[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]

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...

[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]

Wow,,,
true


Returned this

Affected Rows: 0 (0.0001s)

and nothing happend

[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]

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]

By userid, I mean the number for the queries too. Find their old userid in your backup and their new userid in your current database.

[Pathum]

Here right ?

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = 'username';




**** One more thing, the old and the new usernames are the same

Thank you!

- - - Updated - - -

ah ok
user ID, the number

OK

- - - Updated - - -

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE thread SET postuserid = dunkan77 WHERE postuserid = dunkan77' at line 2

[Matthew Gordon]

If you don't have phpMyAdmin installed on your server (or don't know where it is), you can run queries in the Admin CP -> Maintenance -> Execute SQL Query. If you are given a message saying that you are not authorized to run MySQL queries, you need to give yourself this permission by editing your includes/config.php file:

    //    ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    //    The users specified here will be allowed to run queries from the control panel.
    //    See the above entries for more information on the format.
    //    Please note that the ability to run queries is quite powerful. You may wish
    //    to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = ''; 

Add your userid there. For example, if your userid is 1 (as it would be if you are using the user created during the initial installation of the software), change it to this:

    //    ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    //    The users specified here will be allowed to run queries from the control panel.
    //    See the above entries for more information on the format.
    //    Please note that the ability to run queries is quite powerful. You may wish
    //    to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '1'; 

Also, keep in mind that I posted two separate queries. You'll have to run them one at a time in the Admin CP.

[Amaury]

This is really funny,,,
I get "you are not authorized....."

You'll need to give yourself permission by adding your ID to your includes/config.php file.

[Pathum]

This is really funny,,,
I get "you are not authorized....."

[Matthew Gordon]

Run these MySQL queries. Change X to their old userid and Y to their new userid.

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

[Pathum]

exactly

[Matthew Gordon]

Can you explain exactly what you are trying to do? You have a deleted user, now there is a new user account and you want to move the posts from the old (deleted) account to the new one? Is that right?