Change a Guest post to a User

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vskylabv
    Senior Member
    • Feb 2009
    • 210
    • 3.8.x

    Change a Guest post to a User

    Is there a way I can change a post made by a Guest and move it to a user?
    Art of Travel Blogging : The Travel Blogging Community for Beginners and Professionals
  • Lats
    Senior Member
    • Mar 2002
    • 3671

    #2
    Try this query...
    Code:
    UPDATE 
       post 
    SET 
       userid=xx 
    WHERE 
       username='Guest'
    AND
       postid = yy
    Change xx to the userid you want to take ownership and change yy to the postid of the guest post.
    Lats...

    Comment

    • vskylabv
      Senior Member
      • Feb 2009
      • 210
      • 3.8.x

      #3
      The user has the super script character of (TM) in his user name. Does this make a difference?

      #1054 - Unknown column 'Cochiseâ„¢' in 'field list'
      Art of Travel Blogging : The Travel Blogging Community for Beginners and Professionals

      Comment

      • Lats
        Senior Member
        • Mar 2002
        • 3671

        #4
        You can drop the username part...
        Code:
        UPDATE 
           post 
        SET 
           userid=xx 
        WHERE 
           postid = yy
        Lats...

        Comment

        • vskylabv
          Senior Member
          • Feb 2009
          • 210
          • 3.8.x

          #5
          Thank you!
          Art of Travel Blogging : The Travel Blogging Community for Beginners and Professionals

          Comment

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