Notification Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kushina
    New Member
    • Jul 2008
    • 6
    • 3.8.x

    Notification Error

    Currently Running: Version 3.8.7

    Ran into an issue with the notification system. We had an annoying bot the other day that went profile posting. I banned it, deleted all of it's posts, but for some reason, the system still shows:
    Your Notifications: 4,294,967,295
    And when you click the drop down it shows this:
    Unread Visitor Messages 4,294,967,294
    It's forcing all new profile messages into the unapproved area and I have no idea how to fix this issue. Any help please?
  • BirdOPrey5
    Senior Member
    • Jul 2008
    • 9613
    • 5.6.3

    #2
    Probably going to have to manually update the user table...

    ALWAYS BACKUP THE DATABASE BEFORE EDITING.

    Run the query:

    Code:
    UPDATE user SET vmunreadcount = 0 WHERE userid = x;
    Where X is the userid of the user with the problem.

    If you want to set EVERYONE's VB notifications to 0, then just run:

    Code:
    UPDATE user SET vmunreadcount = 0;
    If you use a table prefix, you will need to prefix "user" in the above queries- such as: UPDATE vb_user....

    Comment

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