Error Message
ADODB_Exception
ADODB_Exception [1064] was raised (native)
mysql error: [1064: 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 xar_categories.xar_left <= WHERE xar_articles.xar_status IN (3, 2) AND xar_' at line 1] in EXECUTE("SELECT DISTINCT xar_articles.xar_aid, xar_articles.xar_title, xar_articles.xar_summary, xar_articles.xar_authorid, xar_articles.xar_pubdate, xar_articles.xar_pubtypeid, xar_articles.xar_notes, xar_articles.xar_status, xar_articles.xar_body, xar_articles.xar_checkout, xar_articles.xar_checkouttime, xar_articles.xar_editor, xar_roles.xar_name FROM ((xar_articles LEFT JOIN xar_roles ON xar_roles.xar_uid = xar_articles.xar_authorid) LEFT JOIN xar_categories_linkage ON xar_categories_linkage.xar_iid = xar_articles.xar_aid) INNER JOIN xar_categories ON xar_categories.xar_cid = xar_categories_linkage.xar_cid AND xar_categories.xar_left >= AND xar_categories.xar_left <= WHERE xar_articles.xar_status IN (3, 2) AND xar_articles.xar_pubdate < 1328629106 AND xar_categories_linkage.xar_modid = 151 ORDER BY xar_articles.xar_pubdate DESC, xar_articles.xar_aid DESC LIMIT 0,20")
Raised in: /home/sabbishou/www/www.springiette.net/html/lib/adodb/adodb-exceptions.inc.php, line 78
Further Information:
#0 /home/sabbishou/www/www.springiette.net/html/lib/adodb/adodb.inc.php(1040): adodb_throw('mysql', 'EXECUTE', 1064, 'You have an err...', 'SELECT DISTINCT...', false, Object(ADODB_xarmysql))
#1 /home/sabbishou/www/www.springiette.net/html/lib/adodb/drivers/adodb-xarmysql.inc.php(35): ADOConnection->_Execute('SELECT DISTINCT...', false)
#2 /home/sabbishou/www/www.springiette.net/html/lib/adodb/adodb.inc.php(1015): ADODB_xarmysql->_Execute('SELECT DISTINCT...', false)
#3 /home/sabbishou/www/www.springiette.net/html/lib/adodb/drivers/adodb-mysql.inc.php(498): ADOConnection->Execute('SELECT DISTINCT...', false)
#4 /home/sabbishou/www/www.springiette.net/html/modules/articles/xaruserapi/getall.php(401): ADODB_mysql->SelectLimit('SELECT DISTINCT...', 20, 0)
#5 /home/sabbishou/www/www.springiette.net/html/lib/xarigami/xarMod.php(714): articles_userapi_getall(Array)
#6 /home/sabbishou/www/www.springiette.net/html/lib/xarigami/xarMod.php(776): xarMod::callFunc('articles', 'user', 'getall', Array, 'api', 1)
#7 /home/sabbishou/www/www.springiette.net/html/lib/xarigami/xarMod.php(175): xarMod::apiFunc('articles', 'user', 'getall', Array, 1)
#8 /home/sabbishou/www/www.springiette.net/html/modules/articles/xaruser/view.php(350): xarModAPIFunc('articles', 'user', 'getall', Array)
#9 /home/sabbishou/www/www.springiette.net/html/lib/xarigami/xarMod.php(714): articles_user_view(Array)
#10 /home/sabbishou/www/www.springiette.net/html/lib/xarigami/xarMod.php(731): xarMod::callFunc('articles', 'user', 'view', Array)
#11 /home/sabbishou/www/www.springiette.net/html/index.php(90): xarMod::guiFunc('articles', 'user', 'view')
#12 /home/sabbishou/www/www.springiette.net/html/index.php(159): xarMain()
#13 {main}