PDA

View Full Version : Help


badboyz
07-21-2006, 11:44 PM
Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1153527010 AND open <> 10, 1, 0)) AS newthread

FROM thread AS thread

WHERE forumid = 2
AND sticky = 0
AND visible = 1
AND postuserid NOT IN (77.71.1779.770);

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 '.179.120)' at line 9
Error Number : 1064


im getting this error help me to fix it

Invalid SQL:

SELECT postid AS itemid, post.visible AS post_visible, thread.visible AS thread_visible, thread.forumid, thread.threadid,
IF(postuserid = 1, 'self', 'other') AS starter
FROM post AS post
INNER JOIN thread AS thread ON(thread.threadid = post.threadid)
WHERE postid IN(15905)
AND thread.open <> 10
###AND thread.visible = 1###
###AND post.visible = 1###
AND post.userid NOT IN ()
AND thread.postuserid NOT IN ();

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 thread.postuserid NOT IN ()' at line 9



this error too

i duno wat to do please help me thankyou :(

leestrong7
07-23-2006, 12:01 PM
I have no idea, Try vBulletin support?

Kirk Y
07-23-2006, 10:10 PM
On a sidenote -- learn to make more descriptive titles. "Help" doesn't really describe your problem... at all.