Announcement

Collapse
No announcement yet.

Database error in vBulletin 4.2.2 after upgrade

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

  • #16
    Originally posted by Zambfd View Post
    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
    Please start your own thread, and provide the information requested here:
    http://www.vbulletin.com/forum/node/4005557
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.5.6 Demo
    AdminAmmo - My Cloud Demo

    Comment


    • #17
      Originally posted by Mark.B View Post

      Please start your own thread, and provide the information requested here:
      http://www.vbulletin.com/forum/node/4005557
      Why? It is the exact same problem the thread owner has.
      The problem is the following code snippet in external.php:
      Code:
      if ($foundcache = $db->query_first("
          SELECT text, headers, dateline
          FROM " . TABLE_PREFIX . "externalcache
          WHERE cachehash = '" . $db->escape_string($cachehash). "' AND
               dateline >= " . (TIMENOW - $cachetime) . "
      "))
      {
          $db->close();
      
          if (!empty($foundcache['headers']))
          {
              $headers = unserialize($foundcache['headers']);
      
              if (sizeof($headers))
              {
                  foreach($headers AS $header)
                  {
                          header($header);
                  }
              }
          }
              echo $foundcache['text'];
              exit;
      }

      $cachehash is a md5 hash but $db->escape_string($cachehash) returns and empty string and when you remove the escape_string function it is getting worse.

      Comment


      • #18
        Originally posted by Zambfd View Post

        Why? It is the exact same problem the thread owner has.
        Well first off, you did not provide the info requested. Secondly, this thread is a year old, so anything to do with it might be outdated. Third, because it is the rules, and a staff member asked you to do so.

        My Mods also available at OzzModz.com

        New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders!
        Stop Spam Now The era of Big Spam is over.

        Vote to bring back hooks in vB5, http://tracker.vbulletin.com/browse/VBV-10333

        Comment


        • #19
          Originally posted by Zambfd View Post

          Why? It is the exact same problem the thread owner has.
          The problem is the following code snippet in external.php:
          Firstly, it becomes very confusing trying to provide support to multiple people in the same thread.
          Secondly, what looks like the same issue often isn't.
          Thirdly, this is a very old thread and what caused an issue back then, may not be the cause now, as new versions have and patches have been out since.
          Finally, and probably most importantly - it's a forum rule, and it's the only way to get support.

          If you really think a previous issue does have relevance, you can link to it in your new thread.
          MARK.B | vBULLETIN SUPPORT

          TalkNewsUK - My vBulletin 5.5.6 Demo
          AdminAmmo - My Cloud Demo

          Comment


          • #20
            Just to chime in real quick. I solved this problem last year - I think it was an issue with Vbseo, which I've since removed. Sorry not to update this earlier, (I usually do), but it totally slipped my mind. I must have been pretty busy.
            ~ Master of my own Domain ~

            Comment

            Related Topics

            Collapse

            Working...
            X