08:01:40
[256] postgres7 error: [-1: ERROR: Wrong key or corrupt data] in EXECUTE("SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC")
Fatal error on line 77 in file /usr/local/share/adodb/adodb-errorhandler.inc.php, PHP 5.2.17 (FreeBSD)
Backtrace:
#0 Logger->log([256] postgres7 error: [-1: ERROR: Wrong key or corrupt data] in EXECUTE("SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC")
Fatal error on line 77 in file /usr/local/share/adodb/adodb-errorhandler.inc.php, PHP 5.2.17 (FreeBSD)
, 1) called at [/var/www/sites/molo3.nfcloyalty.com/public_html/lib/logger.class.php:44]
#1 Logger->logError([256] postgres7 error: [-1: ERROR: Wrong key or corrupt data] in EXECUTE("SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC")
Fatal error on line 77 in file /usr/local/share/adodb/adodb-errorhandler.inc.php, PHP 5.2.17 (FreeBSD)
) called at [/var/www/sites/molo3.nfcloyalty.com/public_html/lib/logger.class.php:58]
#2 errorHandler(256, postgres7 error: [-1: ERROR: Wrong key or corrupt data] in EXECUTE("SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC")
, /usr/local/share/adodb/adodb-errorhandler.inc.php, 77, Array ([dbms] => postgres7,[fn] => EXECUTE,[errno] => -1,[errmsg] => ERROR: Wrong key or corrupt data,[p1] => SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC,[p2] => ,[thisConnection] => ADODB_postgres7 Object ([databaseType] => postgres7,[hasLimit] => 1,[ansiOuter] => 1,[charSet] => 1,[dataProvider] => postgres,[hasInsertID] => 1,[_resultid] => Resource id #39,[concat_operator] => ||,[metaDatabasesSQL] => select datname from pg_database where datname not in ('template0','template1') order by 1,[metaTablesSQL] => select tablename,'T' from pg_tables where tablename not like 'pg\_%'
and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages',
'sql_packages', 'sql_sizing', 'sql_sizing_profiles')
union
select viewname,'V' from pg_views where viewname not like 'pg\_%',[isoDates] => 1,[sysDate] => CURRENT_DATE,[sysTimeStamp] => CURRENT_TIMESTAMP,[blobEncodeType] => C,[metaColumnsSQL] => SELECT a.attname,t.typname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum
FROM pg_class c, pg_attribute a,pg_type t
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and a.attname not like '....%%'
AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum,[metaColumnsSQL1] => SELECT a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum
FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s'))
and c.relnamespace=n.oid and n.nspname='%s'
and a.attname not like '....%%' AND a.attnum > 0
AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum,[metaKeySQL] => SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key
FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid AND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum) AND a.attrelid = bc.oid AND bc.relname = '%s',[hasAffectedRows] => 1,[true] => TRUE,[false] => FALSE,[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasMoveFirst] => 1,[hasGenID] => 1,[_genIDSQL] => SELECT NEXTVAL('%s'),[_genSeqSQL] => CREATE SEQUENCE %s START %s,[_dropSeqSQL] => DROP SEQUENCE %s,[metaDefaultsSQL] => SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum,[random] => random(),[autoRollback] => 1,[_bindInputArray] => 1,[disableBlobs] => ,[database] => molotest,[host] => 192.168.173.81:5432,[user] => molotest,[password] => molotest,[debug] => ,[maxblobsize] => 262144,[substr] => substr,[length] => length,[upperCase] => upper,[replaceQuote] => \',[nameQuote] => ",[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ADODB_Error_Handler,[cacheSecs] => 5,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[poorAffectedRows] => ,[fnExecute] => ,[fnCacheExecute] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #36,[_errorMsg] => ERROR: Wrong key or corrupt data,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => 1,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[version] => Array ([description] => PostgreSQL 9.0.4 on amd64-portbld-freebsd8.1, compiled by GCC cc (GCC) 4.2.1 20070719 [FreeBSD], 64-bit,[version] => 9.0.4),[pgVersion] => 9,[_nestedSQL] => 1),[sql] => SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC,[inputparams] => ,[s] => postgres7 error: [-1: ERROR: Wrong key or corrupt data] in EXECUTE("SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC")
))
#3 trigger_error(postgres7 error: [-1: ERROR: Wrong key or corrupt data] in EXECUTE("SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC")
, 256) called at [/usr/local/share/adodb/adodb-errorhandler.inc.php:77]
#4 ADODB_Error_Handler(postgres7, EXECUTE, -1, ERROR: Wrong key or corrupt data, SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC, , ADODB_postgres7 Object ([databaseType] => postgres7,[hasLimit] => 1,[ansiOuter] => 1,[charSet] => 1,[dataProvider] => postgres,[hasInsertID] => 1,[_resultid] => Resource id #39,[concat_operator] => ||,[metaDatabasesSQL] => select datname from pg_database where datname not in ('template0','template1') order by 1,[metaTablesSQL] => select tablename,'T' from pg_tables where tablename not like 'pg\_%'
and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages',
'sql_packages', 'sql_sizing', 'sql_sizing_profiles')
union
select viewname,'V' from pg_views where viewname not like 'pg\_%',[isoDates] => 1,[sysDate] => CURRENT_DATE,[sysTimeStamp] => CURRENT_TIMESTAMP,[blobEncodeType] => C,[metaColumnsSQL] => SELECT a.attname,t.typname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum
FROM pg_class c, pg_attribute a,pg_type t
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and a.attname not like '....%%'
AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum,[metaColumnsSQL1] => SELECT a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum
FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n
WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s'))
and c.relnamespace=n.oid and n.nspname='%s'
and a.attname not like '....%%' AND a.attnum > 0
AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum,[metaKeySQL] => SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key
FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid AND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum) AND a.attrelid = bc.oid AND bc.relname = '%s',[hasAffectedRows] => 1,[true] => TRUE,[false] => FALSE,[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasMoveFirst] => 1,[hasGenID] => 1,[_genIDSQL] => SELECT NEXTVAL('%s'),[_genSeqSQL] => CREATE SEQUENCE %s START %s,[_dropSeqSQL] => DROP SEQUENCE %s,[metaDefaultsSQL] => SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum,[random] => random(),[autoRollback] => 1,[_bindInputArray] => 1,[disableBlobs] => ,[database] => molotest,[host] => 192.168.173.81:5432,[user] => molotest,[password] => molotest,[debug] => ,[maxblobsize] => 262144,[substr] => substr,[length] => length,[upperCase] => upper,[replaceQuote] => \',[nameQuote] => ",[uniqueOrderBy] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ADODB_Error_Handler,[cacheSecs] => 5,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[poorAffectedRows] => ,[fnExecute] => ,[fnCacheExecute] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #36,[_errorMsg] => ERROR: Wrong key or corrupt data,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => 1,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[version] => Array ([description] => PostgreSQL 9.0.4 on amd64-portbld-freebsd8.1, compiled by GCC cc (GCC) 4.2.1 20070719 [FreeBSD], 64-bit,[version] => 9.0.4),[pgVersion] => 9,[_nestedSQL] => 1)) called at [/usr/local/share/adodb/adodb.inc.php:1035]
#5 ADOConnection->_Execute(SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC, ) called at [/usr/local/share/adodb/adodb.inc.php:1010]
#6 ADOConnection->Execute(SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC, ) called at [/usr/local/share/adodb/adodb.inc.php:1540]
#7 ADOConnection->GetArray(SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC, ) called at [/usr/local/share/adodb/adodb.inc.php:1377]
#8 ADOConnection->GetAll(SELECT
LOGO.alternative_text, LOGO.image, LOGO.logo_id
FROM (SELECT coupon_id FROM coupon WHERE coupon_id = hex_to_int(pgp_sym_decrypt(decode('', 'hex'), 'k39u56Od'))) AS COUP
LEFT JOIN coupon_logo COLO ON COLO.coupon_id = COUP.coupon_id
LEFT JOIN logo LOGO ON LOGO.logo_id = COLO.logo_id
ORDER BY LOGO.logo_id DESC) called at [/var/www/sites/molo3.nfcloyalty.com/public_html/modules/Coupon/lib/LibCoupon.php:460]
#9 LibCoupon->fetchCouponsLogos() called at [/var/www/sites/molo3.nfcloyalty.com/public_html/modules/Coupon/lib/LibCoupon.php:301]
#10 LibCoupon->fetchCoupon(1, 558) called at [/var/www/sites/molo3.nfcloyalty.com/public_html/modules/Coupon/Coupon.php:90]
#11 Coupon->moreAboutCoupon(558) called at [/var/www/sites/molo3.nfcloyalty.com/public_html/modules/Coupon/Coupon.php:70]
#12 Coupon->render() called at [/var/www/sites/molo3.nfcloyalty.com/public_html/index.php:245]
REQUEST:
array (
'PHPSESSID' => 'qc7kph1n76bf332d4lksr8hb66',
)
---------------------------------------------------------------------------