[AndrewD]

Originally Posted by Alfa1

I'm getting a lot of these errors:

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 :

Do you have any idea what could cause this?

I can see that there's an obvious problem with the SQL - characters that should be commas are being transferred as %2C, which is the html escape sequence for commas. I've no idea why that should be. It looks like you are doing a search which is restricted to certain categories - I can't reproduce your problem.

Which version of LDM are you using and exactly what is the command which is triggering the error?