Strict Standards: Only variables should be assigned by reference in /home/ystone/public_html/config.inc.php on line 25
ADODB_Exception Object ( [dbms] => mysql [fn] => EXECUTE [sql] => SELECT m.media_location AS gallery_image, m.media_label as label, gi.price FROM gallery g INNER JOIN gallery_images gi on gi.gallery_id = g.gallery_id INNER JOIN media m ON m.mediaid = gi.media_id WHERE g.gallery_id = 7 ORDER BY gi.sort_order ASC LIMIT -12, 12 [params] => [host] => localhost [database] => ystone_cms [message:protected] => 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 '-12, 12' at line 1] in EXECUTE("SELECT m.media_location AS gallery_image, m.media_label as label, gi.price FROM gallery g INNER JOIN gallery_images gi on gi.gallery_id = g.gallery_id INNER JOIN media m ON m.mediaid = gi.media_id WHERE g.gallery_id = 7 ORDER BY gi.sort_order ASC LIMIT -12, 12") [string:Exception:private] => [code:protected] => 1064 [file:protected] => /home/ystone/public_html/lib/adodb/adodb-exceptions.inc.php [line:protected] => 78 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/ystone/public_html/lib/adodb/adodb.inc.php [line] => 1042 [function] => adodb_throw [args] => Array ( [0] => mysql [1] => EXECUTE [2] => 1064 [3] => 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 '-12, 12' at line 1 [4] => SELECT m.media_location AS gallery_image, m.media_label as label, gi.price FROM gallery g INNER JOIN gallery_images gi on gi.gallery_id = g.gallery_id INNER JOIN media m ON m.mediaid = gi.media_id WHERE g.gallery_id = 7 ORDER BY gi.sort_order ASC LIMIT -12, 12 [5] => [6] => ADODB_mysql Object ( [databaseType] => mysql [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SHOW TABLES [metaColumnsSQL] => SHOW COLUMNS FROM `%s` [fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [nameQuote] => ` [compat323] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => ystone_cms [host] => localhost [user] => ystone_cms [password] => cms42u [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] =>   [emptyTimeStamp] =>   [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => adodb_throw [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [arrayClass] => ADORecordSet_array [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [_oldRaiseFn] => [_transOK] => [_connectionID] => Resource id #10 [_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 '-12, 12' at line 1 [_errorCode] => [_queryID] => [_isPersistentConnection] => [_bindInputArray] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => ystone_cms ) ) ) [1] => Array ( [file] => /home/ystone/public_html/modules/gallery.module.php [line] => 129 [function] => _Execute [class] => ADOConnection [type] => -> [args] => Array ( [0] => SELECT m.media_location AS gallery_image, m.media_label as label, gi.price FROM gallery g INNER JOIN gallery_images gi on gi.gallery_id = g.gallery_id INNER JOIN media m ON m.mediaid = gi.media_id WHERE g.gallery_id = 7 ORDER BY gi.sort_order ASC LIMIT -12, 12 ) ) [2] => Array ( [file] => /home/ystone/public_html/modules/gallery.module.php [line] => 15 [function] => show [class] => gallery [type] => -> [args] => Array ( ) ) [3] => Array ( [file] => /home/ystone/public_html/index.php [line] => 166 [function] => runModule [class] => gallery [type] => -> [args] => Array ( ) ) ) [previous:Exception:private] => [msg] => 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 '-12, 12' at line 1 ) Unable to load gallery information SELECT m.media_location AS gallery_image, m.media_label as label, gi.price FROM gallery g INNER JOIN gallery_images gi on gi.gallery_id = g.gallery_id INNER JOIN media m ON m.mediaid = gi.media_id WHERE g.gallery_id = 7 ORDER BY gi.sort_order ASC LIMIT -12, 12.1