Database Errors Accessing Long Threads
Sep 9, 2009 | 10:05 am
#1
Original Poster
Moderator: Hilton Honors forums
Join Date: Dec 2002
Location: Marietta, Georgia, United States
Posts: 25,422
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 http://www.flyertalk.com/forum/delta...y-welcome.html and http://www.flyertalk.com/forum/omni/...omni-game.html 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:
Please click here to view the brief discussion in the http://www.flyertalk.com/forum/omni/...omni-game.html thread.
Could you please look into what could be the cause of this problem?
Thank you in advance.
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 www.flyertalk.com home page, then try to open another page.
* Click the Back button to try another link.
The www.flyertalk.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
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 www.flyertalk.com home page, then try to open another page.
* Click the Back button to try another link.
The www.flyertalk.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
Code:
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 : http://www.flyertalk.com/forum/newreply.php?do=newreply&p=12344482 Referrer : http://www.flyertalk.com/forum/omni/309875-who-will-next-flyertalk-member-post-omni-game-3170.html 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 :
Could you please look into what could be the cause of this problem?
Thank you in advance.
Last edited by Canarsie; Sep 11, 2009 at 1:29 pm
Sep 9, 2009 | 10:25 am
#2
Join Date: Apr 2005
Posts: 2,312
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.
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.
