Results 1 to 4 of 4
-
21st Dec 2011, 05:18 PM #1OPMemberWebsite's:
ExpresShare.comGuest made posts into specific users posts?
Few days ago a forum crashed and "user" table was lost and I had to import an old backup of it, 3 months old. After successfully doing that, i've lost no post & topic count, but lost around 7K or registered users. Now, that wouldn't be a problem if users could register again with same usernames as they had before the crash, but they can't. Don't know why.
Now to my question. Now, all those posts that have been posted in these last 3 months, but users that posted them registered on later date, show as guest made. Is there any way to merge those posts to newly created accounts?
I know there are these tho options for mysql
UPDATE post SET userid=X WHERE username LIKE 'DesiredUsername'
UPDATE thread SET postusername='X', postuserid='Y' WHERE postuserid=0
but that is for one user only. I need to do it for many and possible to automatize it somehow.grand.error Reviewed by grand.error on . Guest made posts into specific users posts? Few days ago a forum crashed and "user" table was lost and I had to import an old backup of it, 3 months old. After successfully doing that, i've lost no post & topic count, but lost around 7K or registered users. Now, that wouldn't be a problem if users could register again with same usernames as they had before the crash, but they can't. Don't know why. Now to my question. Now, all those posts that have been posted in these last 3 months, but users that posted them registered on later Rating: 5
-
25th Dec 2011, 11:38 PM #2Member
Just try repairing your tables via adminCp.
vBulletin-Mods.co.uk - vBulletin-Mods.co.uk is a global community dedicated to extending vBulletin and educating vBulletin users everywhere.
-
31st Dec 2011, 12:36 AM #3OPMemberWebsite's:
ExpresShare.comSorry for late replay..
Tried that and all the usual stuff that goes with it, didn't help one bit.
-
3rd Jan 2012, 04:10 PM #4MemberWebsite's:
UmNotaBlogger.com
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
The right price for guest posts?
By mwdar in forum Webmaster DiscussionReplies: 2Last Post: 24th Jul 2011, 07:36 PM -
Limit number of posts by users
By WaReZ in forum WordpressReplies: 4Last Post: 20th Jun 2011, 11:40 AM -
Users not able to edit there own posts
By Lordiez in forum vBulletinReplies: 5Last Post: 27th Mar 2011, 06:42 PM -
How do users can edit Posts icon?
By duonglg in forum vBulletinReplies: 3Last Post: 23rd Feb 2011, 10:45 PM -
users colors on posts
By x0r in forum IP.BoardReplies: 1Last Post: 4th Nov 2008, 11:38 PM
themaLeecher - leech and manage...
Version 4.94 released. Open older version (or...