Announcement

Collapse
No announcement yet.

User Notes

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • User Notes

    Since I did import my old Forum and convert it into vB, in each Profile i have that tab "USER NOTES" filled with:

    Imported User
    Now removing that in each userprofile, when you have hundreds of users, is kinda madness. Is there a other way to get that "Imported User" out of there

  • #2
    This SQL :

    Code:
    UPDATE usernote SET message='' where importusernoteid <> 0;
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      Thanks, I did that. And the query says it was done without errors. But it still shows all those User Notes at every imported user. I did already some of the items in "UPDATE COUNTERS" but still.

      What did i miss ?

      Comment


      • #4
        Sounds like you've removed the importids before running this ?

        Try this :

        Code:
        UPDATE usernote SET message='' WHERE message LIKE 'Imported User ';
        I wrote ImpEx.

        Blog | Me

        Comment


        • #5
          It says USER NOTES (1) still at all imported Accounts. When you click on that, you get the following (with one of the Usernames as example!)

          User Notes for Sailor 05-09-2009
          Guest

          Posts: n/a


          Imported Note
          What should I do now ? CanĀ“t i get rid of the complete Usernote message, no matter what it says ?
          Last edited by tlwwolfseye; Tue 23 Jun '09, 1:03am.

          Comment


          • #6
            I run this and it was the solution:
            PHP Code:
            DELETE FROM forofc_usernote 
            Regards, Gorgias.
            Pallida Mors aequo pulsat pede pauperum tabernas regumque turres. Vitae summa brevis spem nos vetat inchoare longam. ForoCompeticion.com: creado por y para aficionados.

            Comment

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