Activity Stream
48,167 MEMBERS
6927 ONLINE
besthostingforums On YouTube Subscribe to our Newsletter besthostingforums On Twitter besthostingforums On Facebook besthostingforums On facebook groups

Results 1 to 4 of 4
  1.     
    #1
    Member
    Website's:
    ExpresShare.com

    Default 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 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

  2.   Sponsored Links

  3.     
    #2
    Member
    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.

  4.     
    #3
    Member
    Website's:
    ExpresShare.com
    Sorry for late replay..

    Tried that and all the usual stuff that goes with it, didn't help one bit.

  5.     
    #4
    Member
    Website's:
    UmNotaBlogger.com

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. The right price for guest posts?
    By mwdar in forum Webmaster Discussion
    Replies: 2
    Last Post: 24th Jul 2011, 07:36 PM
  2. Limit number of posts by users
    By WaReZ in forum Wordpress
    Replies: 4
    Last Post: 20th Jun 2011, 11:40 AM
  3. Users not able to edit there own posts
    By Lordiez in forum vBulletin
    Replies: 5
    Last Post: 27th Mar 2011, 06:42 PM
  4. How do users can edit Posts icon?
    By duonglg in forum vBulletin
    Replies: 3
    Last Post: 23rd Feb 2011, 10:45 PM
  5. users colors on posts
    By x0r in forum IP.Board
    Replies: 1
    Last Post: 4th Nov 2008, 11:38 PM

Tags for this Thread

BE SOCIAL