| ( ! ) ADODB_Exception: 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 'india%' or video_caption like '%d'india%'' at line 1] in EXECUTE("select * from v_video_annunci where video_title like '%d'india%' or video_caption like '%d'india%'")
in /opt/vhosts/beta.petpassion.tv/includes/adodb/adodb-exceptions.inc.php on line 78 |
|---|
| Call Stack |
|---|
| # | Time | Memory | Function | Location |
|---|
| 1 | 0.0003 | 106024 | {main}( ) | ../index.php:0 |
| 2 | 0.0254 | 4743424 | include( '/opt/vhosts/beta.petpassion.tv/searchresult/model.php' ) | ../index.php:20 |
| 3 | 0.3491 | 4813832 | ADOConnection->Execute( 'select * from v_video_annunci where video_title like \'%d\'india%\' or video_caption like \'%d\'india%\'', ??? ) | ../model.php:47 |
| 4 | 0.3492 | 4813832 | ADOConnection->_Execute( 'select * from v_video_annunci where video_title like \'%d\'india%\' or video_caption like \'%d\'india%\'', FALSE ) | ../adodb.inc.php:1018 |
| 5 | 0.3494 | 4813832 | adodb_throw( 'mysql', 'EXECUTE', 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 \'india%\' or video_caption like \'%d\'india%\'\' at line 1', 'select * from v_video_annunci where video_title like \'%d\'india%\' or video_caption like \'%d\'india%\'', FALSE, class ADODB_mysql { public $databaseType = 'mysql'; public $dataProvider = 'mysql'; public $hasInsertID = TRUE; public $hasAffectedRows = TRUE; public $metaTablesSQL = 'SHOW TABLES'; public $metaColumnsSQL = 'SHOW COLUMNS FROM `%s`'; public $fmtTimeStamp = '\'Y-m-d H:i:s\''; public $hasLimit = TRUE; public $hasMoveFirst = TRUE; public $hasGenID = TRUE; public $isoDates = TRUE; public $sysDate = 'CURDATE()'; public $sysTimeStamp = 'NOW()'; public $hasTransactions = FALSE; public $forceNewConnect = FALSE; public $poorAffectedRows = TRUE; public $clientFlags = 0; public $substr = 'substring'; public $nameQuote = '`'; public $compat323 = FALSE; public $_genIDSQL = 'update %s set id=LAST_INSERT_ID(id+1);'; public $_genSeqSQL = 'create table %s (id int not null)'; public $_genSeqCountSQL = 'select count(*) from %s'; public $_genSeq2SQL = 'insert into %s values (%s)'; public $_dropSeqSQL = 'drop table %s'; public $database = 'petpassion'; public $host = '10.10.10.2'; public $user = 'petadmin'; public $password = 'p3p1ss10n'; public $debug = FALSE; public $maxblobsize = 262144; public $concat_operator = '+'; public $length = 'length'; public $random = 'rand()'; public $upperCase = 'upper'; public $fmtDate = '\'Y-m-d\''; public $true = '1'; public $false = '0'; public $replaceQuote = '\\\''; public $charSet = FALSE; public $metaDatabasesSQL = ''; public $uniqueOrderBy = FALSE; public $emptyDate = ' '; public $emptyTimeStamp = ' '; public $lastInsID = FALSE; public $hasTop = FALSE; public $readOnly = FALSE; public $genID = 0; public $raiseErrorFn = 'adodb_throw'; public $cacheSecs = 3600; public $memCache = FALSE; public $memCacheHost = NULL; public $memCachePort = 11211; public $memCacheCompress = FALSE; public $sysUTimeStamp = FALSE; public $arrayClass = 'ADORecordSet_array'; public $noNullStrings = FALSE; public $numCacheHits = 0; public $numCacheMisses = 0; public $pageExecuteCountRows = TRUE; public $uniqueSort = FALSE; public $leftOuter = FALSE; public $rightOuter = FALSE; public $ansiOuter = FALSE; public $autoRollback = FALSE; public $fnExecute = FALSE; public $fnCacheExecute = FALSE; public $blobEncodeType = FALSE; public $rsPrefix = 'ADORecordSet_'; public $autoCommit = TRUE; public $transOff = 0; public $transCnt = 0; public $fetchMode = FALSE; public $null2null = 'null'; public $_oldRaiseFn = FALSE; public $_transOK = NULL; public $_connectionID = resource(10) of type (mysql link); public $_errorMsg = '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 \'india%\' or video_caption like \'%d\'india%\'\' at line 1'; public $_errorCode = FALSE; public $_queryID = FALSE; public $_isPersistentConnection = FALSE; public $_bindInputArray = FALSE; public $_evalAll = FALSE; public $_affected = FALSE; public $_logsql = FALSE; public $_transmode = ''; public $databaseName = 'petpassion' } ) | ../adodb.inc.php:1043 |