Hi
I logged into my forum earlier this morning to user's reporting database erros when trying to post. Having looked into the problem there seems to be at least 3 different database errors occuring.
The first occurs when a user clicks on the last post when in the main forum view. (the bit which shows the last post for every induvidual forum). I can view threads if i click into a forum and then onto the thread.
There error message is:
A second message appears when click on 'Post a Reply' when viewing a thread. However, no error occurs while using 'Quick Reply' to post a message.
The error message:
Error message when trying to delete a post:
There may be more errors that i havn't found yet.
All help is appreciated. Thanks
I logged into my forum earlier this morning to user's reporting database erros when trying to post. Having looked into the problem there seems to be at least 3 different database errors occuring.
The first occurs when a user clicks on the last post when in the main forum view. (the bit which shows the last post for every induvidual forum). I can view threads if i click into a forum and then onto the thread.
There error message is:
Code:
Database error in vBulletin 3.7.1: Invalid SQL: SELECT MIN(postid) AS postid FROM post WHERE threadid = 3824 AND visible = 1 AND dateline > 1262987214 AND userid NOT IN (212.235.107.70) LIMIT 1; 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 '.107.70) LIMIT 1' at line 6 Error Number : 1064 Request Date : Friday, January 8th 2010 @ 06:18:10 PM Error Date : Friday, January 8th 2010 @ 06:18:10 PM Script : [URL]http://www.wrestling-365.com/forum/showthread.php?goto=newpost&t=3824[/URL] Referrer : [URL]http://www.wrestling-365.com/forum/[/URL] IP Address : 88.105.36.213 Username : Muxx Classname : vB_Database MySQL Version : 5.0.67-community
The error message:
Code:
Database error in vBulletin 3.7.1: 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 (212.235.107.70) AND post.threadid = 3914 ORDER BY dateline DESC, postid DESC LIMIT 11; 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 '.107.70) AND post.threadid = 3914 ORDER BY dateline DESC, postid DESC LI' at line 5 Error Number : 1064 Request Date : Friday, January 8th 2010 @ 06:25:37 PM Error Date : Friday, January 8th 2010 @ 06:25:38 PM Script : [URL]http://www.wrestling-365.com/forum/newreply.php?do=newreply&noquote=1&p=43369[/URL] Referrer : [URL]http://www.wrestling-365.com/forum/showthread.php?t=3914[/URL] IP Address : 88.105.36.213 Username : Muxx Classname : vB_Database MySQL Version : 5.0.67-community
Code:
Database error in vBulletin 3.7.1: Invalid SQL: SELECT SUM(IF(visible = 1, attach, 0)) AS attachsum, SUM(IF(visible = 1, 1, 0)) AS visible, SUM(IF(visible = 0, 1, 0)) AS hidden, SUM(IF(visible = 2, 1, 0)) AS deleted FROM post AS post WHERE threadid = 3914 AND post.userid NOT IN (212.235.107.70); 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 '.107.70)' at line 8 Error Number : 1064 Request Date : Friday, January 8th 2010 @ 06:19:25 PM Error Date : Friday, January 8th 2010 @ 06:19:25 PM Script : [URL]http://www.wrestling-365.com/forum/editpost.php[/URL] Referrer : [URL]http://www.wrestling-365.com/forum/showthread.php?p=43372&posted=1#post43372[/URL] IP Address : 88.105.36.213 Username : Muxx Classname : vB_Database MySQL Version : 5.0.67-community
All help is appreciated. Thanks
Comment