Announcement

Collapse
No announcement yet.

Database error in vBulletin 4.2.2 after upgrade

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

  • Database error in vBulletin 4.2.2 after upgrade

    Hi All,

    I just upgraded from 4.1.3 to 4.2.2 yesterday, and since then I've been getting a crapload of database errors like the following:


    Database error in vBulletin 4.2.2:
    Invalid SQL:
    SELECT data, expires, locktime, serialized
    FROM cache
    WHERE cacheid = '';
    MySQL Error :
    Error Number :
    Request Date : Friday, November 15th 2013 @ 12:33:04 PM
    Error Date : Friday, November 15th 2013 @ 12:33:04 PM
    Script : http://www.mywebsite.com/forums/external.php?type=RSS2
    Referrer :
    IP Address : 72.14.199.3
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
    ++++++++++++++++++++++

    Each one refers to an RSS URL and has a different IP (all are from Unregistered users). How do I trouble shoot this. I've never really messed with RSS feeds in vBulletin.

    I should add that I've turned off vBSEO since it is no longer supported and does not work with the current version of vB. I hope that is not the problem.
    ~ Master of my own Domain ~

  • #2
    That is the ENTIRE database error?

    Comment


    • #3
      Originally posted by Zachery View Post
      That is the ENTIRE database error?
      Yes, that's it (that's what I receive via email).
      ~ Master of my own Domain ~

      Comment


      • #4
        Was it just one email?

        Comment


        • #5
          Originally posted by Zachery View Post
          Was it just one email?
          Sorry, no. They are coming in about one every one to two minutes. here are the last three:

          Database error in vBulletin 4.2.2:
          Invalid SQL:
          SELECT data, expires, locktime, serialized
          FROM cache
          WHERE cacheid = '';
          MySQL Error :
          Error Number :
          Request Date : Friday, November 15th 2013 @ 08:40:43 PM
          Error Date : Friday, November 15th 2013 @ 08:40:43 PM
          Script : http://www.mywebsite.com//forums/external.php?type=RSS2
          Referrer :
          IP Address : 82.145.222.99
          Username : Unregistered
          Classname : vB_Database
          MySQL Version :
          Database error in vBulletin 4.2.2:
          Invalid SQL:
          SELECT data, expires, locktime, serialized
          FROM cache
          WHERE cacheid = '';
          MySQL Error :
          Error Number :
          Request Date : Friday, November 15th 2013 @ 08:34:44 PM
          Error Date : Friday, November 15th 2013 @ 08:34:44 PM
          Script : http://www.mywebsite.com/forums/external.php?type=RSS2&forumids=4
          Referrer :
          IP Address : 209.85.238.169
          Username : Unregistered
          Classname : vB_Database
          MySQL Version :
          Database error in vBulletin 4.2.2:
          Invalid SQL:
          SELECT data, expires, locktime, serialized
          FROM cache
          WHERE cacheid = '';
          MySQL Error :
          Error Number :
          Request Date : Friday, November 15th 2013 @ 08:33:43 PM
          Error Date : Friday, November 15th 2013 @ 08:33:43 PM
          Script : http://www.mywebsite.com/forums/external.php?type=RSS2&forumids=4
          Referrer :
          IP Address : 209.85.238.169
          Username : Unregistered
          Classname : vB_Database
          MySQL Version :
          I've gone through them and these are all being generated by unregistered users with differing IPs..

          When clicking the URL, it's a blank page with this message:

          XML Parsing Error: no element found
          Location: http://www.mywebsite.com/forums/external.php?type=RSS2
          Line Number 1, Column 1:
          ~ Master of my own Domain ~

          Comment


          • #6
            Go into the AdminCP > Maintenance > Clear System cache

            See if that improves anything.

            Comment


            • #7
              Did that about an hour ago. I'm still getting these notofications.
              ~ Master of my own Domain ~

              Comment


              • #8
                Ask your webhost what their MySQL max_packet_size and wait_timeout are.

                Comment


                • #9
                  Ok - will do.
                  ~ Master of my own Domain ~

                  Comment


                  • #10
                    My site admin guy is on leave at the moment, so I haven't been able to get the info on the server's max packet size data. One thing I have found out is that it only applies to some of the RSS feed links. On the main forum section, there is the little RSS feed image that you click to get the feed for each forum. Most of these work fine. But a handful when clicked open up to a page that states:

                    XML Parsing Error: no element found
                    Location: http://www.myforum.com/forums/extern...SS2&forumids=4
                    Line Number 1, Column 1:

                    I've tried to repair/optimize RSS feed tables in the admin control panel, but this had no effect. Is there something else that I can do? This only happened after the upgrade.
                    ~ Master of my own Domain ~

                    Comment


                    • #11
                      Any ideas?
                      ~ Master of my own Domain ~

                      Comment


                      • #12
                        Still need you to make those adjustments

                        Comment


                        • #13
                          Originally posted by Zachery View Post
                          Still need you to make those adjustments
                          What adjustments?
                          ~ Master of my own Domain ~

                          Comment


                          • #14
                            My max packet size is 16 MB and waitout time is 28.800. Any ideas on how to fix the broken RSS feeds? Please let me know. Thanks!
                            ~ Master of my own Domain ~

                            Comment


                            • #15
                              The same Problem here.

                              VB 4.1.3 & 4.2.2
                              Max Packet Size, wait timeout is more than adequate (commercial used boards with an expensive hardware setup behind it, no private hosting)
                              Cache clear and rebuilding the cache table is not working.


                              http://www.vbulletin.com/forum/forum...-after-upgrade
                              http://www.vbulletin.com/forum/forum...ase-error-help
                              Last edited by Zambfd; Wed 17th Sep '14, 2:43am.

                              Comment

                              Related Topics

                              Collapse

                              Working...
                              X