Tonight I was attempting to help one of my forum members log in. At first he was unable to log in at all. Reset his password and could log in, but the forum would kick him out after attempting to navigate. He was working on a new laptop with IE. Had him add my URL to the Trusted Sites to make sure the cookies weren't being blocked. And, he was then able to post a thread before being kicked out again.
When I checked my email for error reports I found several from this same user. Every report, while referencing a different URL, always reported the same SQL error. There appears to be something missing between the parenthesis.
I upgraded my forum from vB4.2.2 to vB5.1.0 and many members run into this error. In fact in 9 days, with a slow forum, I have close to 400 of these reports. Every one because of this SQL error. No only did these errors occur when attempting to view/use the PM system, but when attempting to respond to or to create a thread as well.
Forum Version: 5.1.0
Upgraded from 4.2.2
MySQL: 5.5.29
PHP: 5.3.28
When I checked my email for error reports I found several from this same user. Every report, while referencing a different URL, always reported the same SQL error. There appears to be something missing between the parenthesis.
Database error in vBulletin 5.1.0: Invalid SQL: SELECT DISTINCT node.nodeid, node.contenttypeid FROM node AS starter INNER JOIN node AS node ON (node.starter = starter.nodeid) WHERE ( )AND node.contenttypeid NOT IN (15,29) ORDER BY node.publishdate DESC LIMIT 20; 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 ')AND node.contenttypeid NOT IN (15,29) ORDER BY node.publishdate DESC LIMIT 20' at line 4 Error Number : 1064 Request Date : Tuesday, April 8th 2014 @ 02:51:00 AM Error Date : Tuesday, April 8th 2014 @ 02:51:01 AM Script : http:///forum/privatemessage/index Referrer : http://www.everythingaquatic.net/for...emessage/index IP Address : xxx Username : xxx Classname : vB_Database_MySQLi MySQL Version :
Forum Version: 5.1.0
Upgraded from 4.2.2
MySQL: 5.5.29
PHP: 5.3.28
Comment