Web Threads

Or as I like to call it, “Query to assign guest posts to user who threw a tantrum and deleted their account and then wanted it back again.” We get these at least twice a year, usually around the holidays.

Have them create a new account and then run this query:

UPDATE smf_messages SET ID_MEMBER = {newaccountnumber} WHERE posterName = '{username}';

Always always back up before running queries or making changes.

Be sure to change {newaccountnumber} to the id of the new account, {username} to name of the old account (remove curly braces) and smf_messages to the correct table name/prefix.

1 person likes this post.

Unlike

Written by Web Threads

Follow Web Threads on Twitter