just notice this today and have no idea why any help please
Database error in vBulletin 4.2.3 Beta 3:
Invalid SQL:
SELECT
IF(a.votenum >= 1, a.votenum, 0) AS votenum,
IF(a.votenum >= 1 AND a.votenum > 0, a.votetotal / a.votenum, 0) AS voteavg,
a.*, fd.extension AS extension, IF(r.attachrateid >= 1, 1, 0) AS hasvoted,
p.title AS posttitle, p.postid AS postid, u.username
FROM attachment AS a
JOIN post AS p
ON (a.contentid = p.postid AND a.contenttypeid = 1)
LEFT JOIN user AS u
ON (a.userid = u.userid)
LEFT JOIN thread AS t
ON (p.threadid = t.threadid)
LEFT JOIN filedata AS fd
ON (fd.filedataid = a.filedataid)
LEFT JOIN attachrate AS r
ON (a.attachmentid = r.attachid AND r.userid = '1')
WHERE a.contenttypeid = 1
AND fd.extension IS NOT NULL
AND t.forumid IN (131,135,1,109,47,2,24,49,61,87,132,65,46,21,44,14,16,129,18,67,111,62,78,116,115,121,127, 130,134,125,110,122,119,133,28,126,29,45,60,120,77,37,88,39,43,113,92,96,93,102,94,91,95,1 14,98,107,99,97,117,89,100,104,106,101,48,66,15,59)
ORDER BY a.attachmentid DESC
LIMIT 0,;
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 '' at line 23
Error Number : 1064
Request Date : Sunday, February 1st 2015 @ 02:22:18 PM
Error Date : Sunday, February 1st 2015 @ 02:22:19 PM
Script : http://ucsclan.co.uk/attachmentgallery.php
Referrer :
MySQL Version : 5.5.40-cll
Database error in vBulletin 4.2.3 Beta 3:
Invalid SQL:
SELECT
IF(a.votenum >= 1, a.votenum, 0) AS votenum,
IF(a.votenum >= 1 AND a.votenum > 0, a.votetotal / a.votenum, 0) AS voteavg,
a.*, fd.extension AS extension, IF(r.attachrateid >= 1, 1, 0) AS hasvoted,
p.title AS posttitle, p.postid AS postid, u.username
FROM attachment AS a
JOIN post AS p
ON (a.contentid = p.postid AND a.contenttypeid = 1)
LEFT JOIN user AS u
ON (a.userid = u.userid)
LEFT JOIN thread AS t
ON (p.threadid = t.threadid)
LEFT JOIN filedata AS fd
ON (fd.filedataid = a.filedataid)
LEFT JOIN attachrate AS r
ON (a.attachmentid = r.attachid AND r.userid = '1')
WHERE a.contenttypeid = 1
AND fd.extension IS NOT NULL
AND t.forumid IN (131,135,1,109,47,2,24,49,61,87,132,65,46,21,44,14,16,129,18,67,111,62,78,116,115,121,127, 130,134,125,110,122,119,133,28,126,29,45,60,120,77,37,88,39,43,113,92,96,93,102,94,91,95,1 14,98,107,99,97,117,89,100,104,106,101,48,66,15,59)
ORDER BY a.attachmentid DESC
LIMIT 0,;
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 '' at line 23
Error Number : 1064
Request Date : Sunday, February 1st 2015 @ 02:22:18 PM
Error Date : Sunday, February 1st 2015 @ 02:22:19 PM
Script : http://ucsclan.co.uk/attachmentgallery.php
Referrer :
MySQL Version : 5.5.40-cll
Comment