CakePHP: the rapid development php framework: Errors

Notice (8): Undefined index: HTTP_ACCEPT_LANGUAGE [APP/Controller/AppController.php, line 121]

    if(!$this->Session->check('Config.language')){
      //checking the 1st favorite language of the user's browser
      $browserLanguage = substr($_SERVER['HTTP_ACCEPT_LANGUAGE'], 0, 2);

AppController::checkBrowserLanguage() - APP/Controller/AppController.php, line 121
AppController::beforeFilter() - APP/Controller/AppController.php, line 56
ProductsController::beforeFilter() - APP/Controller/ProductsController.php, line 38
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 243
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 677
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 189
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110

(dbphp) 2 queries took 2 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `Configuration`.`id`, `Configuration`.`tps_rate`, `Configuration`.`tvq_rate`, `Configuration`.`shipping_rate`, `Configuration`.`notification_active`, `Configuration`.`notification_message_fr`, `Configuration`.`notification_message_en` FROM `dcade`.`configurations` AS `Configuration` WHERE 1 = 1 LIMIT 1		1	1	1
2	SELECT `Configuration`.`id`, `Configuration`.`tps_rate`, `Configuration`.`tvq_rate`, `Configuration`.`shipping_rate`, `Configuration`.`notification_active`, `Configuration`.`notification_message_fr`, `Configuration`.`notification_message_en` FROM `dcade`.`configurations` AS `Configuration` WHERE 1 = 1 LIMIT 1		1	1	1

(dbphp) 2 queries took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Configuration`.`id`, `Configuration`.`tps_rate`, `Configuration`.`tvq_rate`, `Configuration`.`shipping_rate`, `Configuration`.`notification_active`, `Configuration`.`notification_message_fr`, `Configuration`.`notification_message_en` FROM `dcade`.`configurations` AS `Configuration` WHERE 1 = 1 LIMIT 1

(default) 4 queries took 4 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT DimSubDivisionProduct., DimSubDivisionProductInfo. FROM DimSubDivisionProduct INNER JOIN DimSubDivisionProductInfo ON DimSubDivisionProductInfo.SubDivisionProductId = DimSubDivisionProduct.SubDivisionProductId INNER JOIN DimDivisionProduct ON DimDivisionProduct.DivisionProductId = DimSubDivisionProduct.DivisionProductId WHERE DimSubDivisionProductInfo.BannerCode = :BannerCode AND DimSubDivisionProductInfo.StoreCode = :StoreCode AND SubDivisionProductIsActive = 1 AND DimSubDivisionProduct.DivisionProductId = 1078 AND DimSubDivisionProduct.SubDivisionParentId is null ORDER BY DimSubDivisionProductInfo.SubDivisionProductInfoNameFr , params[ StoreCode => 10012, BannerCode => 1006 ]	-1	-1	1
2	SELECT TOP 1 [Store].[StoreInfoId] AS [Store__StoreInfoId], [Store].[BannerCode] AS [Store__BannerCode], [Store].[StoreCode] AS [Store__StoreCode], [Store].[StoreInfoNameFr] AS [Store__StoreInfoNameFr], [Store].[StoreInfoNameEn] AS [Store__StoreInfoNameEn], [Store].[StoreInfoSloganFr] AS [Store__StoreInfoSloganFr], [Store].[StoreInfoSloganEn] AS [Store__StoreInfoSloganEn], [Store].[StoreInfoWebsite] AS [Store__StoreInfoWebsite], [Store].[StoreInfoLogoFr] AS [Store__StoreInfoLogoFr], [Store].[StoreInfoLogoEn] AS [Store__StoreInfoLogoEn], [Store].[StoreInfoTheme] AS [Store__StoreInfoTheme], [Store].[StoreInfoNoveltyDelay] AS [Store__StoreInfoNoveltyDelay], [Store].[StoreInfoInvoiceMessage] AS [Store__StoreInfoInvoiceMessage], [Store].[StoreInfoOwner] AS [Store__StoreInfoOwner], [Store].[StoreInfoTPS] AS [Store__StoreInfoTPS], [Store].[StoreInfoTVQ] AS [Store__StoreInfoTVQ], [Store].[StoreInfoPhoneNumber] AS [Store__StoreInfoPhoneNumber], [Store].[StoreInfoStripeSecretKey] AS [Store__StoreInfoStripeSecretKey], [Store].[StoreInfoStripePublicKey] AS [Store__StoreInfoStripePublicKey], [Store].[StoreInfoOrderMode] AS [Store__StoreInfoOrderMode], [Store].[StoreInfoEmployeeId] AS [Store__StoreInfoEmployeeId], [Store].[StoreInfoSliderFontPath] AS [Store__StoreInfoSliderFontPath], [Store].[StoreInfoSliderFontName] AS [Store__StoreInfoSliderFontName], [Store].[StoreInfoLanguage] AS [Store__StoreInfoLanguage], [Store].[StoreInfoFolderName] AS [Store__StoreInfoFolderName], [Store].[SliderHeight] AS [Store__SliderHeight], [Store].[StoreEmail] AS [Store__StoreEmail], [Store].[StoreInfoOrderNumber] AS [Store__StoreInfoOrderNumber], [Store].[StoreInfoThumbnailWidth] AS [Store__StoreInfoThumbnailWidth], [Store].[StoreInfoThumbnailHeight] AS [Store__StoreInfoThumbnailHeight], [Store].[StoreInfoOpeningMon] AS [Store__StoreInfoOpeningMon], [Store].[StoreInfoClosingMon] AS [Store__StoreInfoClosingMon], [Store].[StoreInfoOpeningTue] AS [Store__StoreInfoOpeningTue], [Store].[StoreInfoClosingTue] AS [Store__StoreInfoClosingTue], [Store].[StoreInfoOpeningWed] AS [Store__StoreInfoOpeningWed], [Store].[StoreInfoClosingWed] AS [Store__StoreInfoClosingWed], [Store].[StoreInfoOpeningThu] AS [Store__StoreInfoOpeningThu], [Store].[StoreInfoClosingThu] AS [Store__StoreInfoClosingThu], [Store].[StoreInfoOpeningFri] AS [Store__StoreInfoOpeningFri], [Store].[StoreInfoClosingFri] AS [Store__StoreInfoClosingFri], [Store].[StoreInfoOpeningSat] AS [Store__StoreInfoOpeningSat], [Store].[StoreInfoClosingSat] AS [Store__StoreInfoClosingSat], [Store].[StoreInfoOpeningSun] AS [Store__StoreInfoOpeningSun], [Store].[StoreInfoClosingSun] AS [Store__StoreInfoClosingSun], [Store].[StoreInfoShipping] AS [Store__StoreInfoShipping], [Store].[StoreInfoDeliveryCost] AS [Store__StoreInfoDeliveryCost] FROM [DimStoreInfo] AS [Store] WHERE [StoreCode] = 10012 AND [BannerCode] = 1006 ORDER BY (SELECT NULL)	-1	-1	1
3	SELECT TOP 1 [Store].[StoreInfoId] AS [Store__StoreInfoId], [Store].[BannerCode] AS [Store__BannerCode], [Store].[StoreCode] AS [Store__StoreCode], [Store].[StoreInfoNameFr] AS [Store__StoreInfoNameFr], [Store].[StoreInfoNameEn] AS [Store__StoreInfoNameEn], [Store].[StoreInfoSloganFr] AS [Store__StoreInfoSloganFr], [Store].[StoreInfoSloganEn] AS [Store__StoreInfoSloganEn], [Store].[StoreInfoWebsite] AS [Store__StoreInfoWebsite], [Store].[StoreInfoLogoFr] AS [Store__StoreInfoLogoFr], [Store].[StoreInfoLogoEn] AS [Store__StoreInfoLogoEn], [Store].[StoreInfoTheme] AS [Store__StoreInfoTheme], [Store].[StoreInfoNoveltyDelay] AS [Store__StoreInfoNoveltyDelay], [Store].[StoreInfoInvoiceMessage] AS [Store__StoreInfoInvoiceMessage], [Store].[StoreInfoOwner] AS [Store__StoreInfoOwner], [Store].[StoreInfoTPS] AS [Store__StoreInfoTPS], [Store].[StoreInfoTVQ] AS [Store__StoreInfoTVQ], [Store].[StoreInfoPhoneNumber] AS [Store__StoreInfoPhoneNumber], [Store].[StoreInfoStripeSecretKey] AS [Store__StoreInfoStripeSecretKey], [Store].[StoreInfoStripePublicKey] AS [Store__StoreInfoStripePublicKey], [Store].[StoreInfoOrderMode] AS [Store__StoreInfoOrderMode], [Store].[StoreInfoEmployeeId] AS [Store__StoreInfoEmployeeId], [Store].[StoreInfoSliderFontPath] AS [Store__StoreInfoSliderFontPath], [Store].[StoreInfoSliderFontName] AS [Store__StoreInfoSliderFontName], [Store].[StoreInfoLanguage] AS [Store__StoreInfoLanguage], [Store].[StoreInfoFolderName] AS [Store__StoreInfoFolderName], [Store].[SliderHeight] AS [Store__SliderHeight], [Store].[StoreEmail] AS [Store__StoreEmail], [Store].[StoreInfoOrderNumber] AS [Store__StoreInfoOrderNumber], [Store].[StoreInfoThumbnailWidth] AS [Store__StoreInfoThumbnailWidth], [Store].[StoreInfoThumbnailHeight] AS [Store__StoreInfoThumbnailHeight], [Store].[StoreInfoOpeningMon] AS [Store__StoreInfoOpeningMon], [Store].[StoreInfoClosingMon] AS [Store__StoreInfoClosingMon], [Store].[StoreInfoOpeningTue] AS [Store__StoreInfoOpeningTue], [Store].[StoreInfoClosingTue] AS [Store__StoreInfoClosingTue], [Store].[StoreInfoOpeningWed] AS [Store__StoreInfoOpeningWed], [Store].[StoreInfoClosingWed] AS [Store__StoreInfoClosingWed], [Store].[StoreInfoOpeningThu] AS [Store__StoreInfoOpeningThu], [Store].[StoreInfoClosingThu] AS [Store__StoreInfoClosingThu], [Store].[StoreInfoOpeningFri] AS [Store__StoreInfoOpeningFri], [Store].[StoreInfoClosingFri] AS [Store__StoreInfoClosingFri], [Store].[StoreInfoOpeningSat] AS [Store__StoreInfoOpeningSat], [Store].[StoreInfoClosingSat] AS [Store__StoreInfoClosingSat], [Store].[StoreInfoOpeningSun] AS [Store__StoreInfoOpeningSun], [Store].[StoreInfoClosingSun] AS [Store__StoreInfoClosingSun], [Store].[StoreInfoShipping] AS [Store__StoreInfoShipping], [Store].[StoreInfoDeliveryCost] AS [Store__StoreInfoDeliveryCost] FROM [DimStoreInfo] AS [Store] WHERE [StoreCode] = 10012 AND [BannerCode] = 1006 ORDER BY (SELECT NULL)	-1	-1	1
4	SELECT TOP 1 [Store].[StoreInfoId] AS [Store__StoreInfoId], [Store].[BannerCode] AS [Store__BannerCode], [Store].[StoreCode] AS [Store__StoreCode], [Store].[StoreInfoNameFr] AS [Store__StoreInfoNameFr], [Store].[StoreInfoNameEn] AS [Store__StoreInfoNameEn], [Store].[StoreInfoSloganFr] AS [Store__StoreInfoSloganFr], [Store].[StoreInfoSloganEn] AS [Store__StoreInfoSloganEn], [Store].[StoreInfoWebsite] AS [Store__StoreInfoWebsite], [Store].[StoreInfoLogoFr] AS [Store__StoreInfoLogoFr], [Store].[StoreInfoLogoEn] AS [Store__StoreInfoLogoEn], [Store].[StoreInfoTheme] AS [Store__StoreInfoTheme], [Store].[StoreInfoNoveltyDelay] AS [Store__StoreInfoNoveltyDelay], [Store].[StoreInfoInvoiceMessage] AS [Store__StoreInfoInvoiceMessage], [Store].[StoreInfoOwner] AS [Store__StoreInfoOwner], [Store].[StoreInfoTPS] AS [Store__StoreInfoTPS], [Store].[StoreInfoTVQ] AS [Store__StoreInfoTVQ], [Store].[StoreInfoPhoneNumber] AS [Store__StoreInfoPhoneNumber], [Store].[StoreInfoStripeSecretKey] AS [Store__StoreInfoStripeSecretKey], [Store].[StoreInfoStripePublicKey] AS [Store__StoreInfoStripePublicKey], [Store].[StoreInfoOrderMode] AS [Store__StoreInfoOrderMode], [Store].[StoreInfoEmployeeId] AS [Store__StoreInfoEmployeeId], [Store].[StoreInfoSliderFontPath] AS [Store__StoreInfoSliderFontPath], [Store].[StoreInfoSliderFontName] AS [Store__StoreInfoSliderFontName], [Store].[StoreInfoLanguage] AS [Store__StoreInfoLanguage], [Store].[StoreInfoFolderName] AS [Store__StoreInfoFolderName], [Store].[SliderHeight] AS [Store__SliderHeight], [Store].[StoreEmail] AS [Store__StoreEmail], [Store].[StoreInfoOrderNumber] AS [Store__StoreInfoOrderNumber], [Store].[StoreInfoThumbnailWidth] AS [Store__StoreInfoThumbnailWidth], [Store].[StoreInfoThumbnailHeight] AS [Store__StoreInfoThumbnailHeight], [Store].[StoreInfoOpeningMon] AS [Store__StoreInfoOpeningMon], [Store].[StoreInfoClosingMon] AS [Store__StoreInfoClosingMon], [Store].[StoreInfoOpeningTue] AS [Store__StoreInfoOpeningTue], [Store].[StoreInfoClosingTue] AS [Store__StoreInfoClosingTue], [Store].[StoreInfoOpeningWed] AS [Store__StoreInfoOpeningWed], [Store].[StoreInfoClosingWed] AS [Store__StoreInfoClosingWed], [Store].[StoreInfoOpeningThu] AS [Store__StoreInfoOpeningThu], [Store].[StoreInfoClosingThu] AS [Store__StoreInfoClosingThu], [Store].[StoreInfoOpeningFri] AS [Store__StoreInfoOpeningFri], [Store].[StoreInfoClosingFri] AS [Store__StoreInfoClosingFri], [Store].[StoreInfoOpeningSat] AS [Store__StoreInfoOpeningSat], [Store].[StoreInfoClosingSat] AS [Store__StoreInfoClosingSat], [Store].[StoreInfoOpeningSun] AS [Store__StoreInfoOpeningSun], [Store].[StoreInfoClosingSun] AS [Store__StoreInfoClosingSun], [Store].[StoreInfoShipping] AS [Store__StoreInfoShipping], [Store].[StoreInfoDeliveryCost] AS [Store__StoreInfoDeliveryCost] FROM [DimStoreInfo] AS [Store] WHERE [StoreCode] = 10012 AND [BannerCode] = 1006 ORDER BY (SELECT NULL)	-1	-1	1

(default) 4 queries took 4 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT DimSubDivisionProduct.*, DimSubDivisionProductInfo.* FROM DimSubDivisionProduct INNER JOIN DimSubDivisionProductInfo ON DimSubDivisionProductInfo.SubDivisionProductId = DimSubDivisionProduct.SubDivisionProductId INNER JOIN DimDivisionProduct ON DimDivisionProduct.DivisionProductId = DimSubDivisionProduct.DivisionProductId WHERE DimSubDivisionProductInfo.BannerCode = :BannerCode AND DimSubDivisionProductInfo.StoreCode = :StoreCode AND SubDivisionProductIsActive = 1 AND DimSubDivisionProduct.DivisionProductId = 1078 AND DimSubDivisionProduct.SubDivisionParentId is null ORDER BY DimSubDivisionProductInfo.SubDivisionProductInfoNameFr , params[ StoreCode => 10012, BannerCode => 1006 ]

-1

SELECT TOP 1 [Store].[StoreInfoId] AS [Store__StoreInfoId], [Store].[BannerCode] AS [Store__BannerCode], [Store].[StoreCode] AS [Store__StoreCode], [Store].[StoreInfoNameFr] AS [Store__StoreInfoNameFr], [Store].[StoreInfoNameEn] AS [Store__StoreInfoNameEn], [Store].[StoreInfoSloganFr] AS [Store__StoreInfoSloganFr], [Store].[StoreInfoSloganEn] AS [Store__StoreInfoSloganEn], [Store].[StoreInfoWebsite] AS [Store__StoreInfoWebsite], [Store].[StoreInfoLogoFr] AS [Store__StoreInfoLogoFr], [Store].[StoreInfoLogoEn] AS [Store__StoreInfoLogoEn], [Store].[StoreInfoTheme] AS [Store__StoreInfoTheme], [Store].[StoreInfoNoveltyDelay] AS [Store__StoreInfoNoveltyDelay], [Store].[StoreInfoInvoiceMessage] AS [Store__StoreInfoInvoiceMessage], [Store].[StoreInfoOwner] AS [Store__StoreInfoOwner], [Store].[StoreInfoTPS] AS [Store__StoreInfoTPS], [Store].[StoreInfoTVQ] AS [Store__StoreInfoTVQ], [Store].[StoreInfoPhoneNumber] AS [Store__StoreInfoPhoneNumber], [Store].[StoreInfoStripeSecretKey] AS [Store__StoreInfoStripeSecretKey], [Store].[StoreInfoStripePublicKey] AS [Store__StoreInfoStripePublicKey], [Store].[StoreInfoOrderMode] AS [Store__StoreInfoOrderMode], [Store].[StoreInfoEmployeeId] AS [Store__StoreInfoEmployeeId], [Store].[StoreInfoSliderFontPath] AS [Store__StoreInfoSliderFontPath], [Store].[StoreInfoSliderFontName] AS [Store__StoreInfoSliderFontName], [Store].[StoreInfoLanguage] AS [Store__StoreInfoLanguage], [Store].[StoreInfoFolderName] AS [Store__StoreInfoFolderName], [Store].[SliderHeight] AS [Store__SliderHeight], [Store].[StoreEmail] AS [Store__StoreEmail], [Store].[StoreInfoOrderNumber] AS [Store__StoreInfoOrderNumber], [Store].[StoreInfoThumbnailWidth] AS [Store__StoreInfoThumbnailWidth], [Store].[StoreInfoThumbnailHeight] AS [Store__StoreInfoThumbnailHeight], [Store].[StoreInfoOpeningMon] AS [Store__StoreInfoOpeningMon], [Store].[StoreInfoClosingMon] AS [Store__StoreInfoClosingMon], [Store].[StoreInfoOpeningTue] AS [Store__StoreInfoOpeningTue], [Store].[StoreInfoClosingTue] AS [Store__StoreInfoClosingTue], [Store].[StoreInfoOpeningWed] AS [Store__StoreInfoOpeningWed], [Store].[StoreInfoClosingWed] AS [Store__StoreInfoClosingWed], [Store].[StoreInfoOpeningThu] AS [Store__StoreInfoOpeningThu], [Store].[StoreInfoClosingThu] AS [Store__StoreInfoClosingThu], [Store].[StoreInfoOpeningFri] AS [Store__StoreInfoOpeningFri], [Store].[StoreInfoClosingFri] AS [Store__StoreInfoClosingFri], [Store].[StoreInfoOpeningSat] AS [Store__StoreInfoOpeningSat], [Store].[StoreInfoClosingSat] AS [Store__StoreInfoClosingSat], [Store].[StoreInfoOpeningSun] AS [Store__StoreInfoOpeningSun], [Store].[StoreInfoClosingSun] AS [Store__StoreInfoClosingSun], [Store].[StoreInfoShipping] AS [Store__StoreInfoShipping], [Store].[StoreInfoDeliveryCost] AS [Store__StoreInfoDeliveryCost] FROM [DimStoreInfo] AS [Store] WHERE [StoreCode] = 10012 AND [BannerCode] = 1006 ORDER BY (SELECT NULL)

-1

CakePHP: the rapid development php framework

404