Notice (8) : Undefined offset: 0 [APP/Controller/CategoriesController.php , line 295 ]Code Context //pour le changement de langue
if( $this -> language == 'Fr' ){
$this -> Session -> write ( 'PassEn' , $selected_category [ 0 ][ 0 ][ 'SlugEn' ]);
$category_slug = 'honey'
$title = 'honey'
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 4
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 3
[protected] _queriesTime => (float) 7
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 295
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Trying to access array offset on value of type null [APP/Controller/CategoriesController.php , line 295 ]Code Context //pour le changement de langue
if( $this -> language == 'Fr' ){
$this -> Session -> write ( 'PassEn' , $selected_category [ 0 ][ 0 ][ 'SlugEn' ]);
$category_slug = 'honey'
$title = 'honey'
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 4
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 3
[protected] _queriesTime => (float) 7
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 295
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Trying to access array offset on value of type null [APP/Controller/CategoriesController.php , line 295 ]Code Context //pour le changement de langue
if( $this -> language == 'Fr' ){
$this -> Session -> write ( 'PassEn' , $selected_category [ 0 ][ 0 ][ 'SlugEn' ]);
$category_slug = 'honey'
$title = 'honey'
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 4
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 3
[protected] _queriesTime => (float) 7
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 295
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Undefined offset: 0 [APP/Controller/CategoriesController.php , line 300 ]Code Context }
$this -> set ( 'selected_category' , $selected_category [ 0 ][ 0 ]);
$category_slug = 'honey'
$title = 'honey'
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 4
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 3
[protected] _queriesTime => (float) 7
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 300
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Trying to access array offset on value of type null [APP/Controller/CategoriesController.php , line 300 ]Code Context }
$this -> set ( 'selected_category' , $selected_category [ 0 ][ 0 ]);
$category_slug = 'honey'
$title = 'honey'
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 4
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 3
[protected] _queriesTime => (float) 7
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 300
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Undefined offset: 0 [APP/Controller/CategoriesController.php , line 333 ]Code Context 'StoreCode' => $this -> store_code ,
'BannerCode' => $this -> banner_code ,
'DivisionProductId' => $selected_category [ 0 ][ 0 ][ 'DivisionProductId' ]));
$category_slug = 'honey'
$title = 'honey'
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 4
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 3
[protected] _queriesTime => (float) 7
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 333
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Trying to access array offset on value of type null [APP/Controller/CategoriesController.php , line 333 ]Code Context 'StoreCode' => $this -> store_code ,
'BannerCode' => $this -> banner_code ,
'DivisionProductId' => $selected_category [ 0 ][ 0 ][ 'DivisionProductId' ]));
$category_slug = 'honey'
$title = 'honey'
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 4
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 3
[protected] _queriesTime => (float) 7
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 333
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Trying to access array offset on value of type null [APP/Controller/CategoriesController.php , line 333 ]Code Context 'StoreCode' => $this -> store_code ,
'BannerCode' => $this -> banner_code ,
'DivisionProductId' => $selected_category [ 0 ][ 0 ][ 'DivisionProductId' ]));
$category_slug = 'honey'
$title = 'honey'
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 4
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 3
[protected] _queriesTime => (float) 7
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 333
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Undefined offset: 0 [APP/Controller/CategoriesController.php , line 339 ]Code Context $this -> set ( 'sub_categories' , $sub_categories );
$title = $selected_category [ 0 ][ 0 ][ 'Name' . $this -> language ];
$category_slug = 'honey'
$title = 'honey'
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 3
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 4
[protected] _queriesTime => (float) 10
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
),
'
SELECT
SubDivisionProductInfoId As SubDivisionId,
DimSubDivisionProduct.SubDivisionProductId,
DimSubDivisionProduct.BannerCode,
DimSubDivisionProduct.StoreCode,
SubDivisionProductInfoNameFr As SubDivisionNameFr,
SubDivisionProductInfoNameEn As SubDivisionNameEn,
SubDivisionProductInfoDescriptionFr As SubDivisionDescriptionFr,
SubDivisionProductInfoDescriptionEn As SubDivisionDescriptionEn,
SubDivisionProductInfoVideoFr As SubDivisionVideoFr,
SubDivisionProductInfoVideoEn As SubDivisionVideoEn,
SubDivisionProductInfoImagePathFr As SubDivisionImagePathFr,
SubDivisionProductInfoImagePathEn As SubDivisionImagePathEn,
SubDivisionProductInfoSlugFr As SubDivisionSlugFr,
SubDivisionProductInfoSlugEn As SubDivisionSlugEn
FROM DimSubDivisionProductInfo
INNER JOIN DimSubDivisionProduct ON DimSubDivisionProduct.SubDivisionProductId = DimSubDivisionProductInfo.SubDivisionProductId
WHERE
DimSubDivisionProductInfo.StoreCode = :StoreCode
AND DimSubDivisionProductInfo.BannerCode = :BannerCode
AND DimSubDivisionProduct.DivisionProductId = :DivisionProductId
AND DimSubDivisionProduct.SubDivisionProductIsActive = 1
AND DimSubDivisionProduct.SubDivisionParentId IS NULL
ORDER BY DimSubDivisionProductInfo.SubDivisionProductInfoNameFr
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array()
$sub_categories = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 339
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Trying to access array offset on value of type null [APP/Controller/CategoriesController.php , line 339 ]Code Context $this -> set ( 'sub_categories' , $sub_categories );
$title = $selected_category [ 0 ][ 0 ][ 'Name' . $this -> language ];
$category_slug = 'honey'
$title = 'honey'
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 3
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 4
[protected] _queriesTime => (float) 10
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
),
'
SELECT
SubDivisionProductInfoId As SubDivisionId,
DimSubDivisionProduct.SubDivisionProductId,
DimSubDivisionProduct.BannerCode,
DimSubDivisionProduct.StoreCode,
SubDivisionProductInfoNameFr As SubDivisionNameFr,
SubDivisionProductInfoNameEn As SubDivisionNameEn,
SubDivisionProductInfoDescriptionFr As SubDivisionDescriptionFr,
SubDivisionProductInfoDescriptionEn As SubDivisionDescriptionEn,
SubDivisionProductInfoVideoFr As SubDivisionVideoFr,
SubDivisionProductInfoVideoEn As SubDivisionVideoEn,
SubDivisionProductInfoImagePathFr As SubDivisionImagePathFr,
SubDivisionProductInfoImagePathEn As SubDivisionImagePathEn,
SubDivisionProductInfoSlugFr As SubDivisionSlugFr,
SubDivisionProductInfoSlugEn As SubDivisionSlugEn
FROM DimSubDivisionProductInfo
INNER JOIN DimSubDivisionProduct ON DimSubDivisionProduct.SubDivisionProductId = DimSubDivisionProductInfo.SubDivisionProductId
WHERE
DimSubDivisionProductInfo.StoreCode = :StoreCode
AND DimSubDivisionProductInfo.BannerCode = :BannerCode
AND DimSubDivisionProduct.DivisionProductId = :DivisionProductId
AND DimSubDivisionProduct.SubDivisionProductIsActive = 1
AND DimSubDivisionProduct.SubDivisionParentId IS NULL
ORDER BY DimSubDivisionProductInfo.SubDivisionProductInfoNameFr
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array()
$sub_categories = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 339
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Trying to access array offset on value of type null [APP/Controller/CategoriesController.php , line 339 ]Code Context $this -> set ( 'sub_categories' , $sub_categories );
$title = $selected_category [ 0 ][ 0 ][ 'Name' . $this -> language ];
$category_slug = 'honey'
$title = 'honey'
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 3
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 4
[protected] _queriesTime => (float) 10
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
),
'
SELECT
SubDivisionProductInfoId As SubDivisionId,
DimSubDivisionProduct.SubDivisionProductId,
DimSubDivisionProduct.BannerCode,
DimSubDivisionProduct.StoreCode,
SubDivisionProductInfoNameFr As SubDivisionNameFr,
SubDivisionProductInfoNameEn As SubDivisionNameEn,
SubDivisionProductInfoDescriptionFr As SubDivisionDescriptionFr,
SubDivisionProductInfoDescriptionEn As SubDivisionDescriptionEn,
SubDivisionProductInfoVideoFr As SubDivisionVideoFr,
SubDivisionProductInfoVideoEn As SubDivisionVideoEn,
SubDivisionProductInfoImagePathFr As SubDivisionImagePathFr,
SubDivisionProductInfoImagePathEn As SubDivisionImagePathEn,
SubDivisionProductInfoSlugFr As SubDivisionSlugFr,
SubDivisionProductInfoSlugEn As SubDivisionSlugEn
FROM DimSubDivisionProductInfo
INNER JOIN DimSubDivisionProduct ON DimSubDivisionProduct.SubDivisionProductId = DimSubDivisionProductInfo.SubDivisionProductId
WHERE
DimSubDivisionProductInfo.StoreCode = :StoreCode
AND DimSubDivisionProductInfo.BannerCode = :BannerCode
AND DimSubDivisionProduct.DivisionProductId = :DivisionProductId
AND DimSubDivisionProduct.SubDivisionProductIsActive = 1
AND DimSubDivisionProduct.SubDivisionParentId IS NULL
ORDER BY DimSubDivisionProductInfo.SubDivisionProductInfoNameFr
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array()
$sub_categories = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 339
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Undefined offset: 0 [APP/Controller/CategoriesController.php , line 340 ]Code Context
$title = $selected_category [ 0 ][ 0 ][ 'Name' . $this -> language ];
$path = $selected_category [ 0 ][ 0 ][ 'ImagePath' . $this -> language ];
$category_slug = 'honey'
$title = null
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 3
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 4
[protected] _queriesTime => (float) 10
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
),
'
SELECT
SubDivisionProductInfoId As SubDivisionId,
DimSubDivisionProduct.SubDivisionProductId,
DimSubDivisionProduct.BannerCode,
DimSubDivisionProduct.StoreCode,
SubDivisionProductInfoNameFr As SubDivisionNameFr,
SubDivisionProductInfoNameEn As SubDivisionNameEn,
SubDivisionProductInfoDescriptionFr As SubDivisionDescriptionFr,
SubDivisionProductInfoDescriptionEn As SubDivisionDescriptionEn,
SubDivisionProductInfoVideoFr As SubDivisionVideoFr,
SubDivisionProductInfoVideoEn As SubDivisionVideoEn,
SubDivisionProductInfoImagePathFr As SubDivisionImagePathFr,
SubDivisionProductInfoImagePathEn As SubDivisionImagePathEn,
SubDivisionProductInfoSlugFr As SubDivisionSlugFr,
SubDivisionProductInfoSlugEn As SubDivisionSlugEn
FROM DimSubDivisionProductInfo
INNER JOIN DimSubDivisionProduct ON DimSubDivisionProduct.SubDivisionProductId = DimSubDivisionProductInfo.SubDivisionProductId
WHERE
DimSubDivisionProductInfo.StoreCode = :StoreCode
AND DimSubDivisionProductInfo.BannerCode = :BannerCode
AND DimSubDivisionProduct.DivisionProductId = :DivisionProductId
AND DimSubDivisionProduct.SubDivisionProductIsActive = 1
AND DimSubDivisionProduct.SubDivisionParentId IS NULL
ORDER BY DimSubDivisionProductInfo.SubDivisionProductInfoNameFr
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array()
$sub_categories = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 340
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Trying to access array offset on value of type null [APP/Controller/CategoriesController.php , line 340 ]Code Context
$title = $selected_category [ 0 ][ 0 ][ 'Name' . $this -> language ];
$path = $selected_category [ 0 ][ 0 ][ 'ImagePath' . $this -> language ];
$category_slug = 'honey'
$title = null
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 3
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 4
[protected] _queriesTime => (float) 10
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
),
'
SELECT
SubDivisionProductInfoId As SubDivisionId,
DimSubDivisionProduct.SubDivisionProductId,
DimSubDivisionProduct.BannerCode,
DimSubDivisionProduct.StoreCode,
SubDivisionProductInfoNameFr As SubDivisionNameFr,
SubDivisionProductInfoNameEn As SubDivisionNameEn,
SubDivisionProductInfoDescriptionFr As SubDivisionDescriptionFr,
SubDivisionProductInfoDescriptionEn As SubDivisionDescriptionEn,
SubDivisionProductInfoVideoFr As SubDivisionVideoFr,
SubDivisionProductInfoVideoEn As SubDivisionVideoEn,
SubDivisionProductInfoImagePathFr As SubDivisionImagePathFr,
SubDivisionProductInfoImagePathEn As SubDivisionImagePathEn,
SubDivisionProductInfoSlugFr As SubDivisionSlugFr,
SubDivisionProductInfoSlugEn As SubDivisionSlugEn
FROM DimSubDivisionProductInfo
INNER JOIN DimSubDivisionProduct ON DimSubDivisionProduct.SubDivisionProductId = DimSubDivisionProductInfo.SubDivisionProductId
WHERE
DimSubDivisionProductInfo.StoreCode = :StoreCode
AND DimSubDivisionProductInfo.BannerCode = :BannerCode
AND DimSubDivisionProduct.DivisionProductId = :DivisionProductId
AND DimSubDivisionProduct.SubDivisionProductIsActive = 1
AND DimSubDivisionProduct.SubDivisionParentId IS NULL
ORDER BY DimSubDivisionProductInfo.SubDivisionProductInfoNameFr
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array()
$sub_categories = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 340
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Trying to access array offset on value of type null [APP/Controller/CategoriesController.php , line 340 ]Code Context
$title = $selected_category [ 0 ][ 0 ][ 'Name' . $this -> language ];
$path = $selected_category [ 0 ][ 0 ][ 'ImagePath' . $this -> language ];
$category_slug = 'honey'
$title = null
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 3
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 4
[protected] _queriesTime => (float) 10
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
),
'
SELECT
SubDivisionProductInfoId As SubDivisionId,
DimSubDivisionProduct.SubDivisionProductId,
DimSubDivisionProduct.BannerCode,
DimSubDivisionProduct.StoreCode,
SubDivisionProductInfoNameFr As SubDivisionNameFr,
SubDivisionProductInfoNameEn As SubDivisionNameEn,
SubDivisionProductInfoDescriptionFr As SubDivisionDescriptionFr,
SubDivisionProductInfoDescriptionEn As SubDivisionDescriptionEn,
SubDivisionProductInfoVideoFr As SubDivisionVideoFr,
SubDivisionProductInfoVideoEn As SubDivisionVideoEn,
SubDivisionProductInfoImagePathFr As SubDivisionImagePathFr,
SubDivisionProductInfoImagePathEn As SubDivisionImagePathEn,
SubDivisionProductInfoSlugFr As SubDivisionSlugFr,
SubDivisionProductInfoSlugEn As SubDivisionSlugEn
FROM DimSubDivisionProductInfo
INNER JOIN DimSubDivisionProduct ON DimSubDivisionProduct.SubDivisionProductId = DimSubDivisionProductInfo.SubDivisionProductId
WHERE
DimSubDivisionProductInfo.StoreCode = :StoreCode
AND DimSubDivisionProductInfo.BannerCode = :BannerCode
AND DimSubDivisionProduct.DivisionProductId = :DivisionProductId
AND DimSubDivisionProduct.SubDivisionProductIsActive = 1
AND DimSubDivisionProduct.SubDivisionParentId IS NULL
ORDER BY DimSubDivisionProductInfo.SubDivisionProductInfoNameFr
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array()
$sub_categories = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 340
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Undefined offset: 0 [APP/Controller/CategoriesController.php , line 341 ]Code Context $title = $selected_category [ 0 ][ 0 ][ 'Name' . $this -> language ];
$path = $selected_category [ 0 ][ 0 ][ 'ImagePath' . $this -> language ];
$description = $selected_category [ 0 ][ 0 ][ 'Description' . $this -> language ];
$category_slug = 'honey'
$title = null
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 3
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 4
[protected] _queriesTime => (float) 10
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
),
'
SELECT
SubDivisionProductInfoId As SubDivisionId,
DimSubDivisionProduct.SubDivisionProductId,
DimSubDivisionProduct.BannerCode,
DimSubDivisionProduct.StoreCode,
SubDivisionProductInfoNameFr As SubDivisionNameFr,
SubDivisionProductInfoNameEn As SubDivisionNameEn,
SubDivisionProductInfoDescriptionFr As SubDivisionDescriptionFr,
SubDivisionProductInfoDescriptionEn As SubDivisionDescriptionEn,
SubDivisionProductInfoVideoFr As SubDivisionVideoFr,
SubDivisionProductInfoVideoEn As SubDivisionVideoEn,
SubDivisionProductInfoImagePathFr As SubDivisionImagePathFr,
SubDivisionProductInfoImagePathEn As SubDivisionImagePathEn,
SubDivisionProductInfoSlugFr As SubDivisionSlugFr,
SubDivisionProductInfoSlugEn As SubDivisionSlugEn
FROM DimSubDivisionProductInfo
INNER JOIN DimSubDivisionProduct ON DimSubDivisionProduct.SubDivisionProductId = DimSubDivisionProductInfo.SubDivisionProductId
WHERE
DimSubDivisionProductInfo.StoreCode = :StoreCode
AND DimSubDivisionProductInfo.BannerCode = :BannerCode
AND DimSubDivisionProduct.DivisionProductId = :DivisionProductId
AND DimSubDivisionProduct.SubDivisionProductIsActive = 1
AND DimSubDivisionProduct.SubDivisionParentId IS NULL
ORDER BY DimSubDivisionProductInfo.SubDivisionProductInfoNameFr
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array()
$path = null
$sub_categories = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 341
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Trying to access array offset on value of type null [APP/Controller/CategoriesController.php , line 341 ]Code Context $title = $selected_category [ 0 ][ 0 ][ 'Name' . $this -> language ];
$path = $selected_category [ 0 ][ 0 ][ 'ImagePath' . $this -> language ];
$description = $selected_category [ 0 ][ 0 ][ 'Description' . $this -> language ];
$category_slug = 'honey'
$title = null
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 3
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 4
[protected] _queriesTime => (float) 10
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
),
'
SELECT
SubDivisionProductInfoId As SubDivisionId,
DimSubDivisionProduct.SubDivisionProductId,
DimSubDivisionProduct.BannerCode,
DimSubDivisionProduct.StoreCode,
SubDivisionProductInfoNameFr As SubDivisionNameFr,
SubDivisionProductInfoNameEn As SubDivisionNameEn,
SubDivisionProductInfoDescriptionFr As SubDivisionDescriptionFr,
SubDivisionProductInfoDescriptionEn As SubDivisionDescriptionEn,
SubDivisionProductInfoVideoFr As SubDivisionVideoFr,
SubDivisionProductInfoVideoEn As SubDivisionVideoEn,
SubDivisionProductInfoImagePathFr As SubDivisionImagePathFr,
SubDivisionProductInfoImagePathEn As SubDivisionImagePathEn,
SubDivisionProductInfoSlugFr As SubDivisionSlugFr,
SubDivisionProductInfoSlugEn As SubDivisionSlugEn
FROM DimSubDivisionProductInfo
INNER JOIN DimSubDivisionProduct ON DimSubDivisionProduct.SubDivisionProductId = DimSubDivisionProductInfo.SubDivisionProductId
WHERE
DimSubDivisionProductInfo.StoreCode = :StoreCode
AND DimSubDivisionProductInfo.BannerCode = :BannerCode
AND DimSubDivisionProduct.DivisionProductId = :DivisionProductId
AND DimSubDivisionProduct.SubDivisionProductIsActive = 1
AND DimSubDivisionProduct.SubDivisionParentId IS NULL
ORDER BY DimSubDivisionProductInfo.SubDivisionProductInfoNameFr
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array()
$path = null
$sub_categories = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 341
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110 Notice (8) : Trying to access array offset on value of type null [APP/Controller/CategoriesController.php , line 341 ]Code Context $title = $selected_category [ 0 ][ 0 ][ 'Name' . $this -> language ];
$path = $selected_category [ 0 ][ 0 ][ 'ImagePath' . $this -> language ];
$description = $selected_category [ 0 ][ 0 ][ 'Description' . $this -> language ];
$category_slug = 'honey'
$title = null
$db = object(Sqlserver) {
description => 'SQL Server DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'smallinteger' => array(
[maximum depth reached]
),
'tinyinteger' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 3
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
)
)
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached]),
'datasource' => 'Database/Sqlserver',
'persistent' => false,
'prefix' => '',
'encoding' => (int) 65001
)
cacheSources => true
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'flags' => array([maximum depth reached])
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 4
[protected] _queriesTime => (float) 10
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimDivisionProduct.*, DimDivisionProductInfo.*
FROM DimDivisionProduct
INNER JOIN DimDivisionProductInfo ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE DimDivisionProductInfo.BannerCode = :BannerCode
AND DimDivisionProductInfo.StoreCode = :StoreCode
AND DivisionProductIsActive = 1
ORDER BY DimDivisionProduct.DivisionProductId
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugFr = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
),
'
SELECT
SubDivisionProductInfoId As SubDivisionId,
DimSubDivisionProduct.SubDivisionProductId,
DimSubDivisionProduct.BannerCode,
DimSubDivisionProduct.StoreCode,
SubDivisionProductInfoNameFr As SubDivisionNameFr,
SubDivisionProductInfoNameEn As SubDivisionNameEn,
SubDivisionProductInfoDescriptionFr As SubDivisionDescriptionFr,
SubDivisionProductInfoDescriptionEn As SubDivisionDescriptionEn,
SubDivisionProductInfoVideoFr As SubDivisionVideoFr,
SubDivisionProductInfoVideoEn As SubDivisionVideoEn,
SubDivisionProductInfoImagePathFr As SubDivisionImagePathFr,
SubDivisionProductInfoImagePathEn As SubDivisionImagePathEn,
SubDivisionProductInfoSlugFr As SubDivisionSlugFr,
SubDivisionProductInfoSlugEn As SubDivisionSlugEn
FROM DimSubDivisionProductInfo
INNER JOIN DimSubDivisionProduct ON DimSubDivisionProduct.SubDivisionProductId = DimSubDivisionProductInfo.SubDivisionProductId
WHERE
DimSubDivisionProductInfo.StoreCode = :StoreCode
AND DimSubDivisionProductInfo.BannerCode = :BannerCode
AND DimSubDivisionProduct.DivisionProductId = :DivisionProductId
AND DimSubDivisionProduct.SubDivisionProductIsActive = 1
AND DimSubDivisionProduct.SubDivisionParentId IS NULL
ORDER BY DimSubDivisionProductInfo.SubDivisionProductInfoNameFr
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null,
'having' => null,
'lock' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimActionResult',
(int) 2 => 'DimTime',
(int) 3 => 'DimActionNote',
(int) 4 => 'DimFeatureCategories',
(int) 5 => 'DimRealisationImages',
(int) 6 => 'DimTimeSlice',
(int) 7 => 'DimActionNamesActionResults',
(int) 8 => 'DimUsersFavorites',
(int) 9 => 'DimActionName',
(int) 10 => 'DimRealisationTypes',
(int) 11 => 'FactAchalandage',
(int) 12 => 'FactCancel',
(int) 13 => 'FactOrder',
(int) 14 => 'DimAction',
(int) 15 => 'FactOrderAddress',
(int) 16 => 'FactOrderDelivery',
(int) 17 => 'StoreInfo',
(int) 18 => 'FactOrderDetail',
(int) 19 => 'FactOrderPayment',
(int) 20 => 'ProvSaleHeader',
(int) 21 => 'FactSale',
(int) 22 => 'FactSaleHeader',
(int) 23 => 'ProvSale',
(int) 24 => 'DimFeature',
(int) 25 => 'FactSalePayment',
(int) 26 => 'FactSalePaymentNotice',
(int) 27 => 'FactSaleTaxes',
(int) 28 => 'DimPostFile',
(int) 29 => 'FactTimeSchedule',
(int) 30 => 'DimTaskTimeLog',
(int) 31 => 'License',
(int) 32 => 'DimTaskStatus',
(int) 33 => 'system_logging',
(int) 34 => 'DimScenario',
(int) 35 => 'FactInformationRequest',
(int) 36 => 'DimRecoveryUser',
(int) 37 => 'DimRecovery',
(int) 38 => 'DimProjectTask',
(int) 39 => 'DimProductFeatures',
(int) 40 => 'DimProjectStatus',
(int) 41 => 'DimProject',
(int) 42 => 'DimPost',
(int) 43 => 'DimMarket',
(int) 44 => 'DimPostType',
(int) 45 => 'DimGroup',
(int) 46 => 'DimProduct',
(int) 47 => 'DimContactType',
(int) 48 => 'DimContactRecovery',
(int) 49 => 'DimContact',
(int) 50 => 'DimCarrier',
(int) 51 => 'DimCity',
(int) 52 => 'DimCustomer',
(int) 53 => 'dimCustomerType',
(int) 54 => 'DimQuestions',
(int) 55 => 'DimOwners',
(int) 56 => 'DimProjectType',
(int) 57 => 'DimDate',
(int) 58 => 'FactOrderReservationPayment',
(int) 59 => 'DimProjectContractType',
(int) 60 => 'DimDepartment',
(int) 61 => 'DimTripType',
(int) 62 => 'DimDepartmentInfo',
(int) 63 => 'DimReservationQuestion',
(int) 64 => 'DimMealType',
(int) 65 => 'DimDiscount',
(int) 66 => 'DimDiscountInfo',
(int) 67 => 'DimDivisionProduct',
(int) 68 => 'DimPromoCode',
(int) 69 => 'DimDivisionProductInfo',
(int) 70 => 'DimEmployee',
(int) 71 => 'DimReservation',
(int) 72 => 'DimItemType',
(int) 73 => 'DimMode',
(int) 74 => 'DimModeInfo',
(int) 75 => 'DimOrderDetailNote',
(int) 76 => 'DimPayment',
(int) 77 => 'DimPaymentInfo',
(int) 78 => 'DimStoreInfo',
(int) 79 => 'DimPOS',
(int) 80 => 'FactInformationRequestNote',
(int) 81 => 'DimPriceLevel',
(int) 82 => 'DimProductUnavailabilities',
(int) 83 => 'DimProductBrand',
(int) 84 => 'DimProductInfo',
(int) 85 => 'DimProductFeature',
(int) 86 => 'DimInformedBy',
(int) 87 => 'DimProductFile',
(int) 88 => 'DimProvenance',
(int) 89 => 'DimProductImage',
(int) 90 => 'DimFeatureReservations',
(int) 91 => 'DimProductReservations',
(int) 92 => 'DimPromotion',
(int) 93 => 'DimPromotionType',
(int) 94 => 'DimProvider',
(int) 95 => 'DimProviderType',
(int) 96 => 'FactAchalandageAnalytic',
(int) 97 => 'DimPunchEmployee',
(int) 98 => 'DimPasswordReset',
(int) 99 => 'OauthAccounts',
(int) 100 => 'DimRelatedProduct',
(int) 101 => 'DimCaseStatus',
(int) 102 => 'FactProfiles',
(int) 103 => 'DimSource',
(int) 104 => 'DimCasesSales',
(int) 105 => 'DimStoreImage',
(int) 106 => 'DimCaseNote',
(int) 107 => 'DimCaseMessageFile',
(int) 108 => 'DimSubDivisionProduct',
(int) 109 => 'DimCaseMessage',
(int) 110 => 'DimSubDivisionProductInfo',
(int) 111 => 'DimCase',
(int) 112 => 'DimOrderReservation',
(int) 113 => 'DimTask',
(int) 114 => 'DimActionType',
(int) 115 => 'DimTaxe',
(int) 116 => 'DimActionStatus',
(int) 117 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array()
$path = null
$sub_categories = array() CategoriesController::index() - APP/Controller/CategoriesController.php, line 341
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110