Announcement

Collapse
No announcement yet.

Database error in vBulletin 4.2.2 after upgrade

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

  • Bryanb
    replied
    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.

    Leave a comment:


  • Mark.B
    replied
    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.

    Leave a comment:


  • ozzy47
    replied
    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.

    Leave a comment:


  • Zambfd
    replied
    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.

    Leave a comment:


  • Mark.B
    replied
    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

    Leave a comment:


  • Zambfd
    replied
    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.

    Leave a comment:


  • Bryanb
    replied
    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!

    Leave a comment:


  • Bryanb
    replied
    Originally posted by Zachery View Post
    Still need you to make those adjustments
    What adjustments?

    Leave a comment:


  • Zachery
    replied
    Still need you to make those adjustments

    Leave a comment:


  • Bryanb
    replied
    Any ideas?

    Leave a comment:


  • Bryanb
    replied
    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.

    Leave a comment:


  • Bryanb
    replied
    Ok - will do.

    Leave a comment:


  • Zachery
    replied
    Ask your webhost what their MySQL max_packet_size and wait_timeout are.

    Leave a comment:


  • Bryanb
    replied
    Did that about an hour ago. I'm still getting these notofications.

    Leave a comment:


  • Zachery
    replied
    Go into the AdminCP > Maintenance > Clear System cache

    See if that improves anything.

    Leave a comment:

Related Topics

Collapse

Working...
X