Moving posts from deleted users?

[fwfp]

Is there a smart way of moving posts from deleted users to another exsiting user? I think I've seen someone writing about this in this forum, but unfortunately I'm not able to find this post again

[Steve Machol]

Run this query:

UPDATE post SET userid='xxx' WHERE username='Old Name';

...with 'xxx' being the userid number of his new account and 'Old Name' being the username on the old account.

Then rebuild the thread and forum counters in that order:

Admin CP -> Maintenance -> Update Counters

[fwfp]

I get this error when executing this query:

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

[Steve Machol]

You need to add what table prefix you are using in front of 'post'.

[fwfp]

Would it be:

UPDATE "mydbprefix"_vbpost SET userid='xxx' WHERE username='Old Name';

then?

Sorry for asking such a stupid question, but I'm not skilled in making DB-queries!

[Steve Machol]

What is your prefix exactly?

[fwfp]

hw6005_vb

[Steve Machol]

If that is the exact table prefix then this will work:

UPDATE hw6005_vbpost SET userid='xxx' WHERE username='Old Name';

[fwfp]

Tried with:

UPDATE vbpost SET userid='xxx' WHERE username='Old Name';

Which worked perfectly!

Thanks for fast - as always - help on this one