Go Back  FlyerTalk Forums > Support&Services > Technical Support and Feedback
Reload this Page >

Database Errors Accessing Long Threads

Database Errors Accessing Long Threads

Old Sep 9, 09, 11:05 am
  #1  
Moderator: Hilton Honors forums
Original Poster
 
Join Date: Dec 2002
Location: Marietta, Georgia, United States
Posts: 24,554
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:
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.
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 :
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.

Last edited by Canarsie; Sep 11, 09 at 2:29 pm
Canarsie is offline  
Old Sep 9, 09, 11:25 am
  #2  
 
Join Date: Apr 2005
Posts: 1,390
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.
Mikel at Webflyer is offline  

Thread Tools
Search this Thread
Search Engine: