Code:
Database error in vBulletin 3.8.3:
Invalid SQL:
SELECT
link.linkid AS linkid, link.linkname AS linkname, link.linkdoi AS linkdoi,
link.linkuserid AS linkuserid, link.linkusername AS linkusername,
link.linkurl AS linkurl, link.linkimg AS linkimg,
link.linkimgthumb AS linkimgthumb, link.linkimgthumbsize AS linkimgthumbsize,
link.linkforum AS linkforum,
link.linkdesc AS linkdesc, link.numrate AS numrate, link.totrate AS totrate,
link.numcomment AS numcomment,
link.linkhits AS linkhits, link.linksize AS linksize, link.linkstatus AS linkstatus,
link.linkdate AS linkdate, link.linkmoderate AS linkmoderate, link.linkmoddate AS
linkmoddate,
link.linkreviewfreq AS linkreviewfreq,
ltoc.catid AS linkcatid, ltoc.displayorder AS linkdorder
, user.userid AS userid, user.avatarid AS avatarid, user.avatarrevision AS
avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid)
AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS
avwidth,customavatar.height AS avheight
, ltoc2.catid AS linkcatid2
, lkeys.keyid AS linkkeyid, lkeys.keyword AS linkkey
FROM vb6_linkslink AS link
LEFT JOIN vb6_linksltoc AS ltoc ON link.linkid = ltoc.linkid
LEFT JOIN vb6_user AS user ON (user.userid = link.linkuserid)
LEFT JOIN vb6_avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vb6_customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN vb6_linksltoc AS ltoc2
ON link.linkid = ltoc2.linkid
LEFT JOIN vb6_linksltok AS ltok
ON link.linkid = ltok.linkid
LEFT JOIN vb6_linkskeys AS lkeys
ON ltok.keyid = lkeys.keyid
WHERE link.linkforum NOT IN
(0,69,191,127,209,68,57,129,152,368,153,130,164,369,167,154,165,370,168,155,166,371,169,128,156,372,163,171,170,274,180,146,341,54,55,143,304,305,302,83,122)
AND (link.linkid IN (-1) OR link.linkid IN
(-1,2267,355,417,928,1326,1332,1701,1752,1867,2105,2185,2186,3114,3798,3904,4105,4122,4303,4362,4482,5068,5362,5905,6030,6197,7050,7057,7561)
OR link.linkid IN (-1)) AND link.linkstatus != -3 AND (link.linkmoderate = 0 OR
(link.linkmoderate = -2 AND link.linkuserid = 57101))
AND ltoc.catid IN
(158%2C58%2C84%2C132%2C55%2C64%2C135%2C26%2C7%2C76%2C80%2C71%2C47%2C53%2C129%2C102%2C93%2C120%2C140%2C114%2C52%2C51%2C23%2C116%2C77%2C5%2C75%2C6%2C96%2C74%2C104%2C25%2C131%2C110%2C240%2C90%2C59%2C94%2C241%2C37%2C73%2C41%2C159%2C27%2C66%2C178%2C117%2C105%2C145%2C113%2C115%2C137%2C50%2C36%2C87%2C99%2C91%2C81%2C119%2C97%2C78%2C54%2C28%2C118%2C20%2C68%2C128%2C139%2C107%2C153%2C82%2C179%2C101%2C29%2C154%2C9%2C32%2C49%2C89%2C155%2C147%2C57%2C108%2C12%2C242%2C95%2C134%2C56%2C31%2C103%2C133%2C4%2C243%2C72%2C79%2C85%2C86%2C60%2C138%2C30%2C11%2C69%2C2%2C35%2C83%2C33%2C92%2C88%2C65%2C18%2C10%2C112%2C109%2C70%2C151%2C177%2C98%2C106%2C3%2C34%2C148%2C130%2C21%2C239%2C8%2C16%2C17%2C22%2C19%2C40%2C15%2C24%2C152%2C38%2C46%2C67%2C1)
ORDER BY linkdate DESC, linkname ASC, linkcatid ASC;
MySQL Error : Unknown column '2C58' in 'where clause'
Error Number : 1054
Request Date : Wednesday, December 2nd 2009 @ 10:27:35 PM
Error Date : Wednesday, December 2nd 2009 @ 10:27:36 PM
Script :
http://www.mysite.com/forum/local_links_search.php?s=&action=show&page=1&pp=40&search=academic%2Bscience%2Binternational&literal=2&desc=1&ents=1&keys=1&catlist=158%252C58%252C84%252C132%252C55%252C64%252C135%252C26%252C7%252C76%252C80%252C71%252C47%252C53%252C129%252C102%252C93%252C120%252C140%252C114%252C52%252C51%252C23%252C116%252C77%252C5%252C75%252C6%252C96%252C74%252C104%252C25%252C131%252C110%252C240%252C90%252C59%252C94%252C241%252C37%252C73%252C41%252C159%252C27%252C66%252C178%252C117%252C105%252C145%252C113%252C115%252C137%252C50%252C36%252C87%252C99%252C91%252C81%252C119%252C97%252C78%252C54%252C28%252C118%252C20%252C68%252C128%252C139%252C107%252C153%252C82%252C179%252C101%252C29%252C154%252C9%252C32%252C49%252C89%252C155%252C147%252C57%252C108%252C12%252C242%252C95%252C134%252C56%252C31%252C103%252C133%252C4%252C243%252C72%252C79%252C85%252C86%252C60%252C138%252C30%252C11%252C69%252C2%252C35%252C83%252C33%252C92%252C88%252C65%252C18%252C10%252C112%252C109%252C70%252C151%252C177%252C98%252C106%252C3%252C34%252C148%252C130%252C21%252C239%252C8%252C16%252C17%252C22%252C19%252C40%252C15%252C24%252C152%252C38%252C46%252C67%252C1&childcats=1&beforeafter=1&sort=d
Referrer : http://www.mysite.com/forum/local_links_search.php
IP Address : xx.xx.xx.xx
Username :
Classname : vB_Database
MySQL Version :