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' ORDER BY f.views_count DESC LIMIT 0,")
/home/iar24/domains/giercowisko.pl/public_html/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/iar24/domains/giercowisko.pl/public_html/libs/adodb/adodb.inc.php(886): adodb_throw('mysql', 'EXECUTE', 1064, 'You have an err...', 'SELECT ????c.id...', false, Object(ADODB_mysql))
#1 /home/iar24/domains/giercowisko.pl/public_html/libs/adodb/adodb.inc.php(861): ADOConnection->_Execute('SELECT ????c.id...', false)
#2 /home/iar24/domains/giercowisko.pl/public_html/protected/modules/dataModule.php(82): ADOConnection->Execute('SELECT ????c.id...')
#3 /home/iar24/domains/giercowisko.pl/public_html/protected/modules/dataModule.php(1340): dataModule->__call(Array, Array)
#4 /home/iar24/domains/giercowisko.pl/public_html/protected/modules/dataModule.php(1340): dataModule->Execute('Execute', Array)
#5 /home/iar24/domains/giercowisko.pl/public_html/protected/pages/files/viewsFiles.php(12): dataModule->getFiles('SELECT ????c.id...')
#6 /home/iar24/domains/giercowisko.pl/public_html/libs/prado/Web/UI/TControl.php(1197): viewsFiles->onLoad('f.status='1'', 'ORDER BY f.view...', 'LIMIT 0,')
#7 /home/iar24/domains/giercowisko.pl/public_html/libs/prado/Web/UI/TPage.php(190): TControl->loadRecursive(NULL)
#8 /home/iar24/domains/giercowisko.pl/public_html/libs/prado/Web/UI/TPage.php(173): TPage->processNormalRequest()
#9 /home/iar24/domains/giercowisko.pl/public_html/libs/prado/Web/Services/TPageService.php(458): TPage->run(Object(THtmlWriter))
#10 /home/iar24/domains/giercowisko.pl/public_html/libs/prado/TApplication.php(988): TPageService->run(Object(THtmlWriter))
#11 /home/iar24/domains/giercowisko.pl/public_html/libs/prado/TApplication.php(346): TApplication->runService()
#12 /home/iar24/domains/giercowisko.pl/public_html/index.php(36): TApplication->run()
#13 {main}