Announcement

Collapse
No announcement yet.

User Notes

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

  • Gorgias
    replied
    I run this and it was the solution:
    PHP Code:
    DELETE FROM forofc_usernote 
    Regards, Gorgias.

    Leave a comment:


  • tlwwolfseye
    replied
    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.

    Leave a comment:


  • Jerry
    replied
    Sounds like you've removed the importids before running this ?

    Try this :

    Code:
    UPDATE usernote SET message='' WHERE message LIKE 'Imported User ';

    Leave a comment:


  • tlwwolfseye
    replied
    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 ?

    Leave a comment:


  • Jerry
    replied
    This SQL :

    Code:
    UPDATE usernote SET message='' where importusernoteid <> 0;

    Leave a comment:


  • tlwwolfseye
    started a topic User Notes

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X