Announcement

Collapse
No announcement yet.

5.1.2 Post Upgrade Issues

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

  • 5.1.2 Post Upgrade Issues

    Hi,

    So we updated from 5.1.0 to 5.1.2 Patch Level 2 because of an issue where someone was trying to SQL Inject our forums.


    When we got done it seemed anyone in the supermod or administrators group would get spammed with new posts

    for example:

    From: Racing Rivals Forums [[email protected]]
    Sent: Wednesday, July 23, 2014 9:49 PM
    To: Todd Groten
    Subject: There is a new post in Forum Unsupported Player trades/sales

    SIMBASON has just posted in the Unsupported Player trades/sales forum of Racing Rivals Forums under the title B Class & Turbo 2-in-1 Turf Car!

    This thread is located at http://racingrivalsforum.ciegames.com/forum/the-neighborhood/unsupported-player-trades-sales/210114-b-class-turbo-2-in-1-turf-car?p=210276#post210276

    Here is the message that has just been posted:
    ***************
    Bring This Up!
    ***************

    As our forums gets busier in the day this can only get worse. The issue is I don't know where to turn it off. I don't know what changed. They have a default setting of subscribed with no notifications so I dont get why they are getting notifications. Todd one of our admins says he unsubscribed completely and turned everything off but hes still getting them he claims.





    The other bug is getting update node issues. There was always invalid sql with the forums it seemed when we updated to 5.1 but they were mostly cache issues. Now its this node issue.
    Database error in vBulletin 5.1.2:

    Invalid SQL:
    UPDATE node SET
    totalcount =
    CASE WHEN 1 > 0 OR totalcount > -1 * 1
    THEN totalcount + (1)
    ELSE 0 END,
    totalunpubcount =
    CASE WHEN 0 > 0 OR totalunpubcount > -1 * 0
    THEN totalunpubcount + (0)
    ELSE 0 END
    WHERE nodeid IN (216083,10,8,1)
    /**UpdateAncestorCount**/;

    MySQL Error : Deadlock found when trying to get lock; try restarting transaction
    Error Number : 1213
    Request Date : Thursday, July 24th 2014 @ 02:10:38 PM
    Error Date : Thursday, July 24th 2014 @ 02:10:38 PM
    Script : http:///create-content/private-message/
    Referrer : http://racingrivalsforum.ciegames.com/privatemessage/view/216083?folderid=155971
    IP Address : 24.47.99.151
    Username : 1Bullet1Deer
    Classname : vB_Database_MySQLi
    MySQL Version :




  • #2
    For the first issue, Admincp -> Channel Management -> Show All Moderators. Edit the individuals permission and remove the permission to receive emails on all new topics. Save the permissions. The second issue is being looked at.
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.5.6 Demo
    AdminAmmo - My Cloud Demo

    Comment


    • #3
      I tried it but I am getting an Invalid Page URL.

      Comment


      • #4
        So to UPDATE:

        The forums aren't including admincp for that page. so i had to change the Url from http://racingrivalsforum.ciegames.co...hp?do=showlist to http://racingrivalsforum.ciegames.co...hp?do=showlist to edit users.


        We are still getting excessive deadlocks though.

        Comment


        • #5
          There are some fixed for deadlocks in vBulletin 5.1.3.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API - Full / Mobile
          Vote for your favorite feature requests and the bugs you want to see fixed.

          Comment

          Related Topics

          Collapse

          Working...
          X