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 '-20,20' at line 10] in EXECUTE("SELECT c.id AS categoryID, c.name AS categoryName, 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 f.category_id=3 ORDER BY f.send_time DESC LIMIT -20,20")
/home/adamo/www/nazwaKapucyn/krystian/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: ?>
#0 /home/adamo/www/nazwaKapucyn/krystian/libs/adodb/adodb.inc.php(886): adodb_throw('mysql', 'EXECUTE', 1064, 'You have an err...', 'SELECT ????c.id...', false, Object(ADODB_mysql))
#1 /home/adamo/www/nazwaKapucyn/krystian/libs/adodb/adodb.inc.php(861): ADOConnection->_Execute('SELECT ????c.id...', false)
#2 [internal function]: ADOConnection->Execute('SELECT ????c.id...')
#3 /home/adamo/www/nazwaKapucyn/krystian/protected/modules/dataModule.php(80): call_user_func_array(Array, Array)
#4 [internal function]: dataModule->__call('Execute', Array)
#5 /home/adamo/www/nazwaKapucyn/krystian/protected/modules/dataModule.php(954): dataModule->Execute('SELECT ????c.id...')
#6 /home/adamo/www/nazwaKapucyn/krystian/protected/pages/files/viewFiles.php(28): dataModule->getFiles('f.status='1' AN...', 'ORDER BY f.send...', 'LIMIT -20,20')
#7 /home/adamo/www/nazwaKapucyn/krystian/libs/prado/Web/UI/TControl.php(1197): viewFiles->onLoad(NULL)
#8 /home/adamo/www/nazwaKapucyn/krystian/libs/prado/Web/UI/TPage.php(190): TControl->loadRecursive()
#9 /home/adamo/www/nazwaKapucyn/krystian/libs/prado/Web/UI/TPage.php(173): TPage->processNormalRequest(Object(THtmlWriter))
#10 /home/adamo/www/nazwaKapucyn/krystian/libs/prado/Web/Services/TPageService.php(458): TPage->run(Object(THtmlWriter))
#11 /home/adamo/www/nazwaKapucyn/krystian/libs/prado/TApplication.php(988): TPageService->run()
#12 /home/adamo/www/nazwaKapucyn/krystian/libs/prado/TApplication.php(346): TApplication->runService()
#13 /home/adamo/www/nazwaKapucyn/krystian/index.php(32): TApplication->run()
#14 {main}