Problem on the Forum 11/16/2011

[mvlcek]

Just to note... some of our valuable plugin developers were also effected by this, and I know that some of you have posts that you go back and edit periodically. Now i am assuming that you can no longer do that to your old posts.

I should be able to re-associate any old post back to your username - but i will need some info in order to do that:

1. Your user ID number
2. The post ID (not topic ID) you want to get reassigned to you.

Just email that to admin@cagintranet.com and I will get that taken care of as fast as I can. Again.. sorry for all this...

See here for the database reference.
E.g. for user Oleg06 with id 795 the following SQL should do the job for all posts:

Code:

update posts set poster_id = 795 where poster_id = 1 and poster = 'Oleg06';

As there should be no guest posts, as posting requires registration, this should have no side effects.

For everybody try something like:

Code:

update posts p set poster_id =
(select u.id from users u where u.username = p.poster)
where p.poster_id = 1;

(this is Oracle SQL, don't know about MySQL)