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

[Pathum]

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

[beishe8]

You receive an email when somone registers on your forum.
That email contains the email address of the deleted user.

[Pathum]

Unfortunately no

[beishe8]

Have you got backups of your database?
With a little luck you might find it.
(user)

[Pathum]

Yes I have it

- - - Updated - - -

and thank you for following this post.....

- - - Updated - - -

Where to look for?

[Matthew Gordon]

You need to search the user table of your backup. Their email address is stored there if the user still exists.

[Pathum]

Thank you, Done!

What a relief

Matthew, Pls tell me how to link the profile to their older posts also

thanking you very much

Pathum

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

[Pathum]

exactly

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

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

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

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

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

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.