Search
Notices
Forum Suggestions & User Assistance Have a suggestion for the forums? Need help with the Forums? Post here.

Database errors

Thread Tools
 
Search this Thread
 
Old 11-23-09, 10:36 PM
  #1  
StupidlyBrave 
Chepooka
Thread Starter
 
StupidlyBrave's Avatar
 
Join Date: Sep 2006
Location: South Central PA
Posts: 1,179

Bikes: 1990 Trek 1400 7spd; 2001 Litespeed Arenberg 10 speed

Mentioned: 5 Post(s)
Tagged: 0 Thread(s)
Quoted: 1110 Post(s)
Liked 1,085 Times in 669 Posts
Database errors

I didn't see a thread related to the increased frequency of seeing the dreaded "Database Error" page. So I thought that I might start one.

I saw some earlier today that suggested that the forum software had some difficulty connecting to the MySql server. I see that as largely a transient issue, so I hesitate to bring that up.

However, there is a larger problem where occasionally large threads will display that page if you click on the "Last post" icon OR the "last post date" link. It acts very much like an "off-by-one" error. However, this error is embedded:
Code:
Database error in vBulletin 4.0.0 Beta 4:

Invalid SQL:

ORDER BY a.contentid, a.attachmentid;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY a.contentid, a.attachmentid' at line 1
Possibly the select and where clause were separated by some inadvertent punctuation.
StupidlyBrave is offline  
Old 11-23-09, 10:56 PM
  #2  
Tom Stormcrowe
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
 
Tom Stormcrowe's Avatar
 
Join Date: Mar 2006
Location: South Florida
Posts: 16,056

Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 22 Times in 17 Posts
Thank you, added to the tech list.
__________________
. “He who fights with monsters might take care lest he thereby become a monster. And if you gaze for long into an abyss, the abyss gazes also into you.”- Fredrick Nietzsche

"We can judge the heart of a man by his treatment of animals." - Immanuel Kant
Tom Stormcrowe is offline  
Old 11-25-09, 03:46 PM
  #3  
StupidlyBrave 
Chepooka
Thread Starter
 
StupidlyBrave's Avatar
 
Join Date: Sep 2006
Location: South Central PA
Posts: 1,179

Bikes: 1990 Trek 1400 7spd; 2001 Litespeed Arenberg 10 speed

Mentioned: 5 Post(s)
Tagged: 0 Thread(s)
Quoted: 1110 Post(s)
Liked 1,085 Times in 669 Posts
A new one:

Code:
Database error in vBulletin :

mysqli_real_connect() [<a href='function.mysqli-real-connect'>function.mysqli-real-connect<

/a>]: (08004/1040): Too many connections

/var/www/public_html/includes/class_core.php on line 1180

MySQL Error   : 

Error Number  : 

Request Date  : Wednesday, November 25th 2009 @ 01:30:01 PM

Error Date    : Wednesday, November 25th 2009 @ 01:30:01 PM

Possibly a misconfiguration, possibly a connection leak. Connection leaks are no fun to diagnose.
StupidlyBrave is offline  
Old 11-28-09, 08:00 PM
  #4  
bigbenaugust 
always rides with luggage
 
bigbenaugust's Avatar
 
Join Date: Feb 2005
Location: KIGX
Posts: 2,109

Bikes: 2007 Trek SU100, 2009 Fantom CX, 2012 Fantom Cross Uno, Bakfiets

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 273 Post(s)
Liked 20 Times in 17 Posts
Originally Posted by StupidlyBrave
However, there is a larger problem where occasionally large threads will display that page if you click on the "Last post" icon OR the "last post date" link.
I get this all the time. I'd love to catch up on the Commuter Bicycle Pics thread, but alas, database errors are all I get. There's a long thread or two in Foo that give me database errors, too.
__________________
--Ben
2006 Trek SU100, 2009 Motobecane Fantom CX, 2011 Motobecane Fantom Cross Uno, and a Bakfiets
Previously: 2000 Trek 4500 (2000-2003), 2003 Novara Randonee (2003-2006), 2003 Giant Rainier (2003-2008), 2005 Xootr Swift (2005-2007), 2007 Nashbar 1x9 (2007-2011), 2011 Windsor Shetland (2011-2014), 2008 Citizen Folder (2015)
Non-Bike hardware: MX Linux / BunsenLabs Linux / Raspbian / Mac OS 10.6 / Android 7
bigbenaugust is offline  
Old 11-28-09, 08:21 PM
  #5  
wolfpack 
Rawwrrrrrrrrr!
 
wolfpack's Avatar
 
Join Date: Jan 2006
Location: Clayton, NC
Posts: 2,730

Bikes: 2009 Specialized Ruby Sworks SL w/SRAM Red; 2006 Fuji Team RC; 2008 Felt F1x; 1980's Lotus Excelle; Mangusta FG/SS; Rossin (yet to be built up)

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 2 Times in 1 Post
maybe this stuff should've been beta tested prior to rolling out.....
__________________
wolfpackcycles
skiffrun: Enjoy the ride. Ride for the enjoyment.
wolfpack is offline  
Old 11-29-09, 01:18 PM
  #6  
DMF 
Elitist Troglodyte
 
DMF's Avatar
 
Join Date: Jun 2006
Location: Dallas
Posts: 6,925

Bikes: 03 Raleigh Professional (steel)

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 2 Post(s)
Likes: 0
Liked 1 Time in 1 Post
No way to beta test with the size database and number of users on BF.

May be for vB should have had its flying ad say "vB 4.0 beta"...

__________________
Stupidity got us into this mess - why can't it get us out?

- Will Rogers
DMF is offline  
Old 11-29-09, 05:12 PM
  #7  
luketg08
woopwoop
 
Join Date: Apr 2009
Location: Minneapolis
Posts: 114
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times in 0 Posts
I'd like to see the visits for an average day before and after the new forum was installed. My guess is it has gone down. I haven't even been checking these forums because of all the database errors. Revert?
luketg08 is offline  
Old 11-30-09, 04:25 AM
  #8  
Machka 
In Real Life
 
Machka's Avatar
 
Join Date: Jan 2003
Location: Down under down under
Posts: 52,152

Bikes: Lots

Mentioned: 141 Post(s)
Tagged: 0 Thread(s)
Quoted: 3203 Post(s)
Liked 596 Times in 329 Posts
Originally Posted by luketg08
I'd like to see the visits for an average day before and after the new forum was installed. My guess is it has gone down. I haven't even been checking these forums because of all the database errors. Revert?
If you go to the main forum page and scroll down, you'll find this ...

Bike Forums Statistics
Threads 556,142 Posts 9,520,022 Members 170,558 Active Members 15,301 (this was a few days ago, I see they are even lower than that now)

----------------------------------------
We're down to 8.9% active users.

Rowan has been commenting to me, and posting somewhere on BF, about the steady decline of active users on this forum. During the Northern Hemisphere "season" it was up around 13% (the lowest "seasonal" percent it has been in a few years). Pre-forum-change he made some comment about it being down to 11% ... and now it's down below 9%. I don't think it's been that low since the very early days of the forum.

2% might not seem very much but 2% of 170,558 is 3411 people. A 4% drop from the "season" is 6822 people. So during the "season" the Active Membership was up around 22123 people (which as I mentioned before was lower than most previous "seasons") ... we've dropped approx. 1/3 of those in the last couple months, half of that because of the end of the "season" and half of that because of the forum change.


As for the subject of this thread ... I haven't been getting that many Database Errors, but I get a ton of Internet Explorer Cannot Find Webpage type errors in this site.

Last edited by Machka; 11-30-09 at 04:30 AM.
Machka is offline  
Old 11-30-09, 06:40 PM
  #9  
StupidlyBrave 
Chepooka
Thread Starter
 
StupidlyBrave's Avatar
 
Join Date: Sep 2006
Location: South Central PA
Posts: 1,179

Bikes: 1990 Trek 1400 7spd; 2001 Litespeed Arenberg 10 speed

Mentioned: 5 Post(s)
Tagged: 0 Thread(s)
Quoted: 1110 Post(s)
Liked 1,085 Times in 669 Posts
Originally Posted by Machka
<snip> I haven't been getting that many Database Errors, but I get a ton of Internet Explorer Cannot Find Webpage type errors in this site.
They may be the same thing. The server returns a 500 series error code (503) to the browser. Your IE is probably set to display "friendly error messages". This is to prevent you from seeing an occasional stack trace or other techno-complaints, but it will also prevent you from seeing the page when the web server (correctly) sends a custom error page with the correct HTTP status code.

Last edited by StupidlyBrave; 12-01-09 at 07:56 AM. Reason: Verified my recollection and updated statement accordingly
StupidlyBrave is offline  
Old 12-01-09, 05:56 PM
  #10  
bigbenaugust 
always rides with luggage
 
bigbenaugust's Avatar
 
Join Date: Feb 2005
Location: KIGX
Posts: 2,109

Bikes: 2007 Trek SU100, 2009 Fantom CX, 2012 Fantom Cross Uno, Bakfiets

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 273 Post(s)
Liked 20 Times in 17 Posts
So I noticed the other day (I occasionally do software QA) that if you set your thread viewing mode to Newest First, the longer threads come out fine and the database errors go away. But viewing Newest First is so non-intuitive and painful (the Last button takes you to the first post, if it works at all and you end up reading threads all out of order) that it's a tough trade-off.

Just doing a little debugging for y'all.
__________________
--Ben
2006 Trek SU100, 2009 Motobecane Fantom CX, 2011 Motobecane Fantom Cross Uno, and a Bakfiets
Previously: 2000 Trek 4500 (2000-2003), 2003 Novara Randonee (2003-2006), 2003 Giant Rainier (2003-2008), 2005 Xootr Swift (2005-2007), 2007 Nashbar 1x9 (2007-2011), 2011 Windsor Shetland (2011-2014), 2008 Citizen Folder (2015)
Non-Bike hardware: MX Linux / BunsenLabs Linux / Raspbian / Mac OS 10.6 / Android 7
bigbenaugust is offline  
Old 12-01-09, 09:43 PM
  #11  
StupidlyBrave 
Chepooka
Thread Starter
 
StupidlyBrave's Avatar
 
Join Date: Sep 2006
Location: South Central PA
Posts: 1,179

Bikes: 1990 Trek 1400 7spd; 2001 Litespeed Arenberg 10 speed

Mentioned: 5 Post(s)
Tagged: 0 Thread(s)
Quoted: 1110 Post(s)
Liked 1,085 Times in 669 Posts
Here is a new one. I got this clicking on a new thread created after the upgrade with 0 replies.

Code:
Invalid SQL:

		SELECT
			post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
			user.*, userfield.*, usertextfield.*,
			
			avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
			
			
			editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
			editlog.reason AS edit_reason, editlog.hashistory,
			postparsed.pagetext_html, postparsed.hasimages,
			sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
			sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
			, '' AS field7
			
		FROM post AS post
		LEFT JOIN user AS user ON(user.userid = post.userid)
		LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		
			
		LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 7 AND postparsed.languageid = 1)
		LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 7 AND sigparsed.languageid = 1)
		LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
			
		WHERE post.postid IN ()
		ORDER BY post.dateline;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
		ORDER BY post.dateline' at line 29
StupidlyBrave is offline  
Old 12-01-09, 10:04 PM
  #12  
StupidlyBrave 
Chepooka
Thread Starter
 
StupidlyBrave's Avatar
 
Join Date: Sep 2006
Location: South Central PA
Posts: 1,179

Bikes: 1990 Trek 1400 7spd; 2001 Litespeed Arenberg 10 speed

Mentioned: 5 Post(s)
Tagged: 0 Thread(s)
Quoted: 1110 Post(s)
Liked 1,085 Times in 669 Posts
Originally Posted by StupidlyBrave
Code:
Database error in vBulletin 4.0.0 Beta 4:

Invalid SQL:

ORDER BY a.contentid, a.attachmentid;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY a.contentid, a.attachmentid' at line 1
The above error still occurs.
StupidlyBrave is offline  
Old 12-08-09, 08:54 PM
  #13  
StupidlyBrave 
Chepooka
Thread Starter
 
StupidlyBrave's Avatar
 
Join Date: Sep 2006
Location: South Central PA
Posts: 1,179

Bikes: 1990 Trek 1400 7spd; 2001 Litespeed Arenberg 10 speed

Mentioned: 5 Post(s)
Tagged: 0 Thread(s)
Quoted: 1110 Post(s)
Liked 1,085 Times in 669 Posts
Originally Posted by StupidlyBrave
The above error still occurs.
New version, same error.

Code:
Database error in vBulletin 4.0.0 Beta 5:

Invalid SQL:

ORDER BY a.contentid, a.attachmentid;
StupidlyBrave is offline  
Old 12-10-09, 03:57 PM
  #14  
StupidlyBrave 
Chepooka
Thread Starter
 
StupidlyBrave's Avatar
 
Join Date: Sep 2006
Location: South Central PA
Posts: 1,179

Bikes: 1990 Trek 1400 7spd; 2001 Litespeed Arenberg 10 speed

Mentioned: 5 Post(s)
Tagged: 0 Thread(s)
Quoted: 1110 Post(s)
Liked 1,085 Times in 669 Posts
Twice now, I noticed that when I clicked on the "last page" in a thread, I was taken to the top of the next-to-last page. Just like before the upgrade.

It is my belief that I would have seen a database error in this use case prior to yesterday (I haven't had time to pay close attention).

Progress?
StupidlyBrave is offline  
Old 12-10-09, 04:52 PM
  #15  
Tom Stormcrowe
Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
 
Tom Stormcrowe's Avatar
 
Join Date: Mar 2006
Location: South Florida
Posts: 16,056

Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike

Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Liked 22 Times in 17 Posts
We think we know what's causing this, and are trying to address it.
__________________
. “He who fights with monsters might take care lest he thereby become a monster. And if you gaze for long into an abyss, the abyss gazes also into you.”- Fredrick Nietzsche

"We can judge the heart of a man by his treatment of animals." - Immanuel Kant
Tom Stormcrowe is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.