ADODB_Exception

Description

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 '' at line 11] in EXECUTE("SELECT c.id AS categoryID, c.name AS categoryName, c.child, f.*, IFNULL(ROUND((f.votes_sum/f.votes_count),2),0) AS avg, u.id AS userID, u.username AS userName FROM files f, users u, categories c WHERE f.user_id=u.id AND c.id=f.category_id AND f.status='1' AND c.adult=0 AND c.protected=0 ORDER BY f.send_time DESC LIMIT 0,")

Source File

/home2/wkreapl1/public_html/plejor.com/libs/adodb/adodb-exceptions.inc.php (78)

0067: * @param $p1        $fn specific parameter - see below
0068: * @param $P2        $fn specific parameter - see below
0069: */
0070: 
0071: function adodb_throw($dbms, $fn, $errno, $errmsg, $p1, $p2, $thisConnection)
0072: {
0073: global $ADODB_EXCEPTION;
0074:     
0075:     if (error_reporting() == 0) return; // obey @ protocol
0076:     if (is_string($ADODB_EXCEPTION)) $errfn = $ADODB_EXCEPTION;
0077:     else $errfn = 'ADODB_EXCEPTION';
0078: throw new $errfn($dbms, $fn, $errno, $errmsg, $p1, $p2, $thisConnection);
0079: } 0080: 0081: 0082: ?>

Stack Trace

#0 /home2/wkreapl1/public_html/plejor.com/libs/adodb/adodb.inc.php(886): adodb_throw('mysql', 'EXECUTE', 1064, 'You have an err...', 'SELECT ????c.id...', false, Object(ADODB_mysql))
#1 /home2/wkreapl1/public_html/plejor.com/libs/adodb/adodb.inc.php(861): ADOConnection->_Execute('SELECT ????c.id...', false)
#2 [internal function]: ADOConnection->Execute('SELECT ????c.id...')
#3 /home2/wkreapl1/public_html/plejor.com/protected/modules/dataModule.php(82): call_user_func_array(Array, Array)
#4 [internal function]: dataModule->__call('Execute', Array)
#5 /home2/wkreapl1/public_html/plejor.com/protected/modules/dataModule.php(1340): dataModule->Execute('SELECT ????c.id...')
#6 /home2/wkreapl1/public_html/plejor.com/protected/pages/files/lastFiles.php(16): dataModule->getFiles('f.status='1' AN...', 'ORDER BY f.send...', 'LIMIT 0,')
#7 /home2/wkreapl1/public_html/plejor.com/libs/prado/Web/UI/TControl.php(1197): lastFiles->onLoad(NULL)
#8 /home2/wkreapl1/public_html/plejor.com/libs/prado/Web/UI/TPage.php(190): TControl->loadRecursive()
#9 /home2/wkreapl1/public_html/plejor.com/libs/prado/Web/UI/TPage.php(173): TPage->processNormalRequest(Object(THtmlWriter))
#10 /home2/wkreapl1/public_html/plejor.com/libs/prado/Web/Services/TPageService.php(458): TPage->run(Object(THtmlWriter))
#11 /home2/wkreapl1/public_html/plejor.com/libs/prado/TApplication.php(988): TPageService->run()
#12 /home2/wkreapl1/public_html/plejor.com/libs/prado/TApplication.php(346): TApplication->runService()
#13 /home2/wkreapl1/public_html/plejor.com/index.php(36): TApplication->run()
#14 {main}
2009-01-07 00:58 Apache/2.2.9 (Unix) mod_ssl/2.2.9 OpenSSL/0.9.8g mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PRADO/3.0.2