Thread: Database errors
View Single Post
Old 11-23-09 | 10:36 PM
  #1  
StupidlyBrave's Avatar
StupidlyBrave
Chepooka
Titanium Club Membership
15 Anniversary
 
Joined: Sep 2006
Posts: 1,180
Likes: 1,543
From: South Central PA

Bikes: 2001 Litespeed Arenberg 10 speed; 2015 Giant Escape 2; 2025 Aventon Ramblas

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  
Reply