Horrible database error

محروم.كوم · #1 01-09-2010, 03:40 AM

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:
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 : http://www.wrestling-365.com/forum/s...newpost&t=3824
Referrer : http://www.wrestling-365.com/forum/
IP Address : 88.105.36.213
Username : Muxx
Classname : vB_Database
MySQL Version : 5.0.67-community
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:
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 : http://www.wrestling-365.com/forum/n...uote=1&p=43369
Referrer : http://www.wrestling-365.com/forum/s...ead.php?t=3914
IP Address : 88.105.36.213
Username : Muxx
Classname : vB_Database
MySQL Version : 5.0.67-community
Error message when trying to delete a post:
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 : http://www.wrestling-365.com/forum/editpost.php
Referrer : http://www.wrestling-365.com/forum/s...ed=1#post43372
IP Address : 88.105.36.213
Username : Muxx
Classname : vB_Database
MySQL Version : 5.0.67-community
There may be more errors that i havn't found yet.

All help is appreciated. Thanks __DEFINE_LIKE_SHARE__