FlyerTalk Forums

FlyerTalk Forums (
-   Technical Support and Feedback (
-   -   Database Errors Accessing Long Threads (

Canarsie Sep 9, 09 11:05 am

Database Errors Accessing Long Threads
Along with other FlyerTalk members, I have noticed sporadically in the past couple of months that I get a database error when attempting to access long threads such as the and threads. There seems to be no rhyme or reason as to why this happens, as it appears to occur on a completely random basis and is not repeatable from my end. Usually, after one or more attempts, I eventually gain access to those threads.

In fact, I just encountered this problem again. This is the message that I get:

Database error
The FlyerTalk Forums database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the home page, then try to open another page.
* Click the Back button to try another link.

The forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.7.3:

Invalid SQL:

                SELECT post.*, IF(post.userid = 0, post.username, user.username) AS username
                FROM post AS post
                LEFT JOIN user AS user ON (user.userid = post.userid)
                WHERE post.visible = 1
                        AND post.userid NOT IN (deleted)
                        AND post.threadid = 309875
                ORDER BY dateline DESC, postid DESC
                LIMIT 41;

MySQL Error  : MySQL server has gone away
Error Number  : 2006
Request Date  : Wednesday, September 9th 2009 @ 09:06:00 AM
Error Date    : Wednesday, September 9th 2009 @ 09:08:01 AM
Script        :
Referrer      :
IP Address    : (withheld by me — will provide it upon request if necessary, although the technical staff which maintains FlyerTalk should be able to access it)
Username      : Canarsie
Classname    : vB_Database_MySQLi
MySQL Version :

Please click here to view the brief discussion in the thread.

Could you please look into what could be the cause of this problem?

Thank you in advance.

Mikel at Webflyer Sep 9, 09 11:25 am

Thanks for reporting this Canarsie.

As I understand it, this is a known, and as yet, unresolved issue. Luckily, as you noted, it only occurs intermittently, and the issue is relegated to exceptionally long threads. vBulletin handles these long threads better than our previous bb software (with UBB we had to manually segment long threads into multiple threads), but it obviously doesn't handle them well in every case.

I've passed your report along to the IB tech team as another data point.

All times are GMT -6. The time now is 8:39 pm.

This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.