There was an issue with the database. Technical advisors have been notified and this issue will be repaired shortly.
DB_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -1 [message] => DB Error: unknown error [userinfo] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol [nativecode=1242 ** Subquery returns more than 1 row] [backtrace] => Array ( [0] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/DB.php [line] => 741 [function] => PEAR_Error [class] => PEAR_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => DB Error: unknown error [1] => -1 [2] => 1 [3] => 1024 [4] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol [nativecode=1242 ** Subquery returns more than 1 row] ) ) [1] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/PEAR.php [line] => 536 [function] => DB_Error [class] => DB_Error [object] => DB_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => -1 [1] => 1 [2] => 1024 [3] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol [nativecode=1242 ** Subquery returns more than 1 row] ) ) [2] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/DB/common.php [line] => 500 [function] => raiseError [class] => PEAR [object] => DB_mysql Object ( [connection] => Resource id #9 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 3 [_db] => fccacom [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => fccacom [password] => ComFcc_76 [protocol] => tcp [hostspec] => p3plcpnl0940.prod.phx3.secureserver.net [port] => [socket] => [database] => fccacom ) ) [type] => -> [args] => Array ( [0] => [1] => -1 [2] => [3] => [4] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol [nativecode=1242 ** Subquery returns more than 1 row] [5] => DB_Error [6] => 1 ) ) [3] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/DB/mysql.php [line] => 776 [function] => raiseError [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #9 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 3 [_db] => fccacom [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => fccacom [password] => ComFcc_76 [protocol] => tcp [hostspec] => p3plcpnl0940.prod.phx3.secureserver.net [port] => [socket] => [database] => fccacom ) ) [type] => -> [args] => Array ( [0] => -1 [1] => [2] => [3] => [4] => 1242 ** Subquery returns more than 1 row ) ) [4] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/DB/mysql.php [line] => 228 [function] => mysqlRaiseError [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #9 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 3 [_db] => fccacom [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => fccacom [password] => ComFcc_76 [protocol] => tcp [hostspec] => p3plcpnl0940.prod.phx3.secureserver.net [port] => [socket] => [database] => fccacom ) ) [type] => -> [args] => Array ( ) ) [5] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/DB/common.php [line] => 1144 [function] => simpleQuery [class] => DB_mysql [object] => DB_mysql Object ( [connection] => Resource id #9 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 3 [_db] => fccacom [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => fccacom [password] => ComFcc_76 [protocol] => tcp [hostspec] => p3plcpnl0940.prod.phx3.secureserver.net [port] => [socket] => [database] => fccacom ) ) [type] => -> [args] => Array ( [0] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol ) ) [6] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/lib/DB/common.php [line] => 1595 [function] => query [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #9 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 3 [_db] => fccacom [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => fccacom [password] => ComFcc_76 [protocol] => tcp [hostspec] => p3plcpnl0940.prod.phx3.secureserver.net [port] => [socket] => [database] => fccacom ) ) [type] => -> [args] => Array ( [0] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol ) ) [7] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/code/display.offers.function.php [line] => 229 [function] => getAll [class] => DB_common [object] => DB_mysql Object ( [connection] => Resource id #9 [phptype] => mysql [dbsyntax] => mysql [prepare_tokens] => Array ( ) [prepare_types] => Array ( ) [num_rows] => Array ( ) [transaction_opcount] => 0 [autocommit] => 1 [fetchmode] => 3 [_db] => fccacom [features] => Array ( [prepare] => [pconnect] => 1 [transactions] => 1 [limit] => alter ) [errorcode_map] => Array ( [1004] => -15 [1005] => -15 [1006] => -15 [1007] => -5 [1008] => -17 [1022] => -5 [1046] => -14 [1048] => -3 [1050] => -5 [1051] => -18 [1054] => -19 [1062] => -5 [1064] => -2 [1100] => -21 [1136] => -22 [1146] => -18 [1216] => -3 [1217] => -3 ) [prepared_queries] => [prepare_maxstmt] => 0 [last_query] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol [fetchmode_object_class] => stdClass [options] => Array ( [persistent] => [ssl] => [debug] => 0 [seqname_format] => %s_seq [autofree] => [portability] => 0 [optimize] => performance ) [dbh] => [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => DB_Error [_expected_errors] => Array ( ) [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => fccacom [password] => ComFcc_76 [protocol] => tcp [hostspec] => p3plcpnl0940.prod.phx3.secureserver.net [port] => [socket] => [database] => fccacom ) ) [type] => -> [args] => Array ( [0] => SELECT oo.offerId AS OfferId, oo.tcshow AS tcshow, oo.tclink as tclink, oo.tctext as tctext, oo.SmallCreative AS SmallCreative, oo.ShowDefaultImage AS ShowDefaultImage, oo.SelectedImg AS SelectedImg, oo.PurchasesIntroRate AS PurchasesIntroRate, oo.AnnualFee AS AnnualFee, oo.PurchasesGoToRate AS PurchasesGoToRate, oo.BalanceTransferIntroPeriod AS BalanceTransferIntroPeriod, oo.BalanceTransferIntroRate AS BalanceTransferIntroRate, oo.CreditType AS CreditType, oo.PurchasesIntroPeriod AS PurchasesIntroPeriod, oo.RedirectLink AS RedirectLink, r.OfferSelection AS OfferSelection, r.CategoryName AS CategoryName, oo.offername AS OfferName, oo.AltText AS AltText, oo.offerhead AS offerhead,oo.offerfooter AS offerfooter, r.RankId, (select (r1.RankId + rand() ) AS v FROM (SELECT distinct o.*,(SELECT distinct c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId FROM offerorder o WHERE o.CategoryName='Visa') as r1 WHERE r1.OfferId=r.OfferId and r1.CategoryName=r.CategoryName ) as randcol FROM (SELECT distinct o.*,(SELECT DISTINCT c.RankId FROM category c WHERE c.CategoryName='Visa' and o.OfferId=c.OfferId order by o.OfferId) as RankId from offerorder o where o.CategoryName='Visa') as r inner join offerdetails oo on oo.OfferId=r.OfferId WHERE r.CategoryName='Visa' and r.old_offer=0 and OfferStatus=1 ORDER BY RAND(7972) #order by r.RankId,randcol ) ) [8] => Array ( [file] => /home/k5xnaih3yd0s/public_html/offerdisplay/code/display.offers.function.php [line] => 34 [function] => FetchOffers [args] => Array ( [0] => Visa [1] => 0 [2] => 1 [3] => 0 ) ) [9] => Array ( [file] => /home/k5xnaih3yd0s/public_html/visa-credit-cards.php [line] => 63 [function] => DisplayOffers [args] => Array ( [0] => Visa [1] => 20 [2] => 1 [3] => 1 [4] => 1 [5] => visa-credit-cards ) ) ) [callback] => )