Database error in vBulletin 4.2.2 after upgrade

[Mark.B]

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

[Zambfd]

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:

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.

[ozzy47]

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.

[Mark.B]

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.

[Bryanb]

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.