No announcement yet.

Re-Associate Guest Posts???

  • Filter
  • Time
  • Show
Clear All
new posts

  • Re-Associate Guest Posts???

    Here's what happened:

    I accidently deleted my posting username with my admin account so I thought nothing of it and re-created the username only one problem now... All of my old posts now show guest... I know how to manually re-do all 500 posts I had but that would take a long time... Is there a query I could put in that'd do this for me?

  • #2
    update post set postuserid=NEWUSERID where postuserid=OLDUSERID.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API


    • #3
      Originally posted by wluke
      update post set postuserid=NEWUSERID where postuserid=OLDUSERID.
      That didn't quite work...
      SQL-query :
      update post set postuserid=16 where postuserid=1
      MySQL said:
      Unknown column 'postuserid' in 'where clause'
      Maybe I should make myself a little more clear... My old posts have all turned in guest posts... So in essence, I'd want to do a IF Username = Ian Than userid = 16... It'd be in a different syntax though...


      • #4
        Bump! We need an answer....
        Kakarot, (a.k.a. Nitro)
        ZFN Head Webmaster
        WebSite Forums:


        • #5
          Originally posted by Kakarot
          Bump! We need an answer....
          Ask at as there is no built in support for restoring guest posts.


          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.