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 'AND books.isupcomming LIKE 'No' LIMIT 1' at line 1] in EXECUTE("SELECT count(*) FROM books INNER JOIN content ON (content.field_id = books.id AND content.language = 'bg' AND books.language = 'bg') WHERE content.table_name = 'books' AND AND books.isupcomming LIKE 'No' LIMIT 1")

Source File

/home/kolhida/modules/framework/3rdParty/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 /home/kolhida/modules/framework/3rdParty/adodb/adodb.inc.php(916): adodb_throw('mysql', 'EXECUTE', 1064, 'You have an err...', 'SELECT count(*)...', false, Object(ADODB_mysql))
#1 /home/kolhida/modules/framework/3rdParty/adodb/adodb.inc.php(891): ADOConnection->_Execute('SELECT count(*)...', false)
#2 /home/kolhida/modules/framework/3rdParty/adodb/drivers/adodb-mysql.inc.php(490): ADOConnection->Execute('SELECT count(*)...', false)
#3 /home/kolhida/modules/framework/3rdParty/adodb/drivers/adodb-mysql.inc.php(161): ADODB_mysql->SelectLimit('SELECT count(*)...', 1, -1, false)
#4 [internal function]: ADODB_mysql->GetOne('SELECT count(*)...')
#5 /home/kolhida/public_html/protected/Modules/adodb.php(76): call_user_func_array(Array, Array)
#6 /home/kolhida/public_html/protected/Common/DbHandler.php(55): adodb->__call('GetOne', Array)
#7 /home/kolhida/public_html/protected/Common/DbHandler.php(55): adodb->GetOne('SELECT count(*)...')
#8 /home/kolhida/public_html/protected/Common/MTPage.php(43): DbHandler->getResultsNum()
#9 /home/kolhida/public_html/protected/Pages/Catalog.php(47): MTPage->getRepeaterData(Object(TDataList))
#10 /home/kolhida/modules/framework/Web/UI/TControl.php(1240): Catalog->onLoad(NULL)
#11 /home/kolhida/modules/framework/Web/UI/TPage.php(206): TControl->loadRecursive()
#12 /home/kolhida/modules/framework/Web/UI/TPage.php(189): TPage->processNormalRequest(Object(THtmlWriter))
#13 /home/kolhida/modules/framework/Web/Services/TPageService.php(458): TPage->run(Object(THtmlWriter))
#14 /home/kolhida/modules/framework/TApplication.php(999): TPageService->run()
#15 /home/kolhida/modules/framework/TApplication.php(351): TApplication->runService()
#16 /home/kolhida/public_html/index.php(33): TApplication->run()
#17 {main}
2017-11-24 22:18 Apache/2.2.15 PRADO/3.1.0a