Notice (8): Trying to get property 'id' of non-object [APP/Plugin/Order/Controller/OrderProcessController.php, line 641]
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 |
SELECT `VoiceCloud`.*, `VoiceCloudType`.*, `Product`.`id`, `Product`.`name`, `Product`.`product_key`, `Product`.`preorder`, `Product`.`product_type`, `Product`.`location_id`, format_money(`Product`.setup_charge, "EUR") as setup_charge, `Location`.`id`, `Location`.`city`, `Location`.`country_code`, `Location`.`country`, `Location`.`location_key`, `CloudUnitType`.`name`, `CloudUnitType`.`multiplier`, `CloudUnitType`.`loco_key`, format_money(`ProductPrice`.final_price / `ProductPrice`.units / `CloudUnitType`.multiplier, `ProductPrice`.currency) as minimum_price, `ProductPrice`.`duration_days` FROM `webinterface_gp_2`.`voice_clouds` AS `VoiceCloud` LEFT JOIN `webinterface_gp_2`.`voice_cloud_types` AS `VoiceCloudType` ON (`VoiceCloudType`.`voiceCloudId` = `VoiceCloud`.`id`) LEFT JOIN `webinterface_gp_2`.`product_datas` AS `Product` ON (`Product`.`active` = 1 AND `Product`.`product_type_id` = `VoiceCloud`.`id` AND `Product`.`product_type` = 'VoiceClouds') JOIN `webinterface_gp_2`.`infrastructure_locations` AS `Location` ON (`Location`.`id` = `Product`.`location_id`) INNER JOIN `webinterface_gp_2`.`cloud_unit_types` AS `CloudUnitType` ON (`CloudUnitType`.`id` = `VoiceCloud`.`unit_type_id`) INNER JOIN `webinterface_gp_2`.`product_price_caches` AS `ProductPrice` ON (`ProductPrice`.`product_id` = `Product`.`id` AND `ProductPrice`.`duration_days` = 30 AND `ProductPrice`.`units` = `VoiceCloudType`.`minUnits`) WHERE `VoiceCloud`.`cloudKey` = 'VOICECLOUD' GROUP BY `Location`.`id` ORDER BY `Location`.`frontend_order` ASC, `Location`.`id` ASC
Plugin/VoiceServer/Model/VoiceCloud.php:96- VoiceCloud->getProductLocationRows() src/GPortal/Lib/Order/OrderProduct.php:134- VoiceCloud->getProductInfo() src/GPortal/Lib/Order/OrderProduct.php:84- GPortal\Lib\Order\OrderProduct->getOrderProductFromThisRegion() src/GPortal/Lib/Order/OrderProduct.php:63- GPortal\Lib\Order\OrderProduct->getOrderProductByType() Plugin/Order/Controller/OrderProcessController.php:558- GPortal\Lib\Order\OrderProduct->getOrderProduct() Plugin/Order/Controller/OrderProcessController.php:487- OrderProcessController->createBasket() Plugin/Order/Controller/OrderProcessController.php:247- OrderProcessController->createBasketFromQuery() ?:?- OrderProcessController->stepOne() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:193- WebinterfaceControllerAbstract->invokeAction() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:167- AppDispatcher->_invoke() webroot/index.php:33- AppDispatcher->dispatch() |
1 | 1 | 3 | |
| 2 |
SELECT `ProductDetail`.`id`, `ProductDetail`.`min`, `ProductDetail`.`max`, `ProductDetail`.`step`, `ProductDetail`.`default` FROM `webinterface_gp_2`.`product_details` AS `ProductDetail` WHERE `ProductDetail`.`product_id` = 21 ORDER BY `ProductDetail`.`min` ASC
Plugin/VoiceServer/Model/VoiceCloud.php:150- Product->getProductDetailRows() src/GPortal/Lib/Order/OrderProduct.php:134- VoiceCloud->getProductInfo() src/GPortal/Lib/Order/OrderProduct.php:84- GPortal\Lib\Order\OrderProduct->getOrderProductFromThisRegion() src/GPortal/Lib/Order/OrderProduct.php:63- GPortal\Lib\Order\OrderProduct->getOrderProductByType() Plugin/Order/Controller/OrderProcessController.php:558- GPortal\Lib\Order\OrderProduct->getOrderProduct() Plugin/Order/Controller/OrderProcessController.php:487- OrderProcessController->createBasket() Plugin/Order/Controller/OrderProcessController.php:247- OrderProcessController->createBasketFromQuery() ?:?- OrderProcessController->stepOne() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:193- WebinterfaceControllerAbstract->invokeAction() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:167- AppDispatcher->_invoke() webroot/index.php:33- AppDispatcher->dispatch() |
5 | 5 | 1 | |
| 3 |
SELECT `ContractDuration`.`id`, `ContractDuration`.`duration`, `ContractDuration`.`duration_type`, `ContractDuration`.`discount` FROM `webinterface_gp_2`.`product_contract_durations` AS `ContractDuration` WHERE `ContractDuration`.`product_id` = 21 ORDER BY `ContractDuration`.`duration` ASC
Plugin/VoiceServer/Model/VoiceCloud.php:160- Product->getProductDurationRows() src/GPortal/Lib/Order/OrderProduct.php:134- VoiceCloud->getProductInfo() src/GPortal/Lib/Order/OrderProduct.php:84- GPortal\Lib\Order\OrderProduct->getOrderProductFromThisRegion() src/GPortal/Lib/Order/OrderProduct.php:63- GPortal\Lib\Order\OrderProduct->getOrderProductByType() Plugin/Order/Controller/OrderProcessController.php:558- GPortal\Lib\Order\OrderProduct->getOrderProduct() Plugin/Order/Controller/OrderProcessController.php:487- OrderProcessController->createBasket() Plugin/Order/Controller/OrderProcessController.php:247- OrderProcessController->createBasketFromQuery() ?:?- OrderProcessController->stepOne() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:193- WebinterfaceControllerAbstract->invokeAction() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:167- AppDispatcher->_invoke() webroot/index.php:33- AppDispatcher->dispatch() |
4 | 4 | 1 | |
| 4 |
SELECT `Product`.`id`, `Product`.`name`, `Product`.`product_key`, `Product`.`product_type`, `Product`.`show_at_order`, `Product`.`optional`, `ProductDetail`.`id`, `ProductDetail`.`price`, `ProductDetail`.`min`, `ProductDetail`.`max`, `ProductDetail`.`step`, `ProductDetail`.`default`, `Addon`.`loco_key`, `CloudUnitType`.`name`, `CloudUnitType`.`multiplier`, `CloudUnitType`.`loco_key` FROM `webinterface_gp_2`.`product_datas` AS `Product` LEFT JOIN `webinterface_gp_2`.`product_details` AS `ProductDetail` ON (`ProductDetail`.`product_id` = `Product`.`id`) LEFT JOIN `webinterface_gp_2`.`games_addons` AS `Addon` ON (`Addon`.`id` = `Product`.`product_type_id`) LEFT JOIN `webinterface_gp_2`.`cloud_unit_types` AS `CloudUnitType` ON (`CloudUnitType`.`id` = `Addon`.`cloud_unit_type_id`) WHERE `Product`.`parent_id` = 21 AND `Product`.`active` = '1' ORDER BY `Product`.`id` ASC, `ProductDetail`.`min` ASC
Plugin/GameMgmt/Model/GameGroup.php:167- Product->getProductExtensionRows() src/GPortal/Lib/Order/Struct/ProductStruct.php:317- GameGroup->getProductExtensionsByProductId() src/GPortal/Lib/Order/Struct/ProductStruct.php:334- GPortal\Lib\Order\Struct\ProductStruct->getExtensions() Plugin/Order/Controller/OrderProcessController.php:595- GPortal\Lib\Order\Struct\ProductStruct->getMandatoryExtensions() Plugin/Order/Controller/OrderProcessController.php:487- OrderProcessController->createBasket() Plugin/Order/Controller/OrderProcessController.php:247- OrderProcessController->createBasketFromQuery() ?:?- OrderProcessController->stepOne() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:193- WebinterfaceControllerAbstract->invokeAction() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:167- AppDispatcher->_invoke() webroot/index.php:33- AppDispatcher->dispatch() |
0 | 0 | 1 | |
| 5 |
SELECT format_money(`ProductPriceCache`.final_price, `ProductPriceCache`.currency) as formatted_amount FROM `webinterface_gp_2`.`product_price_caches` AS `ProductPriceCache` WHERE `ProductPriceCache`.`product_id` = 21 AND `ProductPriceCache`.`duration_days` = 30 AND `ProductPriceCache`.`units` = 4 LIMIT 1
src/GPortal/Lib/Order/Struct/ProductStruct.php:272- ProductPriceCache->getPrice() src/GPortal/Lib/Order/OrderPrice.php:90- GPortal\Lib\Order\Struct\ProductStruct->getPrice() src/GPortal/Lib/Order/OrderPrice.php:44- GPortal\Lib\Order\OrderPrice->getOrderPriceFromThisRegion() src/GPortal/Lib/Order/Struct/LocationStruct.php:147- GPortal\Lib\Order\OrderPrice->getOrderPriceResponse() Plugin/Order/Controller/OrderProcessController.php:614- GPortal\Lib\Order\Struct\LocationStruct->getLocalizedDiscountedOrderPrice() Plugin/Order/Controller/OrderProcessController.php:487- OrderProcessController->createBasket() Plugin/Order/Controller/OrderProcessController.php:247- OrderProcessController->createBasketFromQuery() ?:?- OrderProcessController->stepOne() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:193- WebinterfaceControllerAbstract->invokeAction() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:167- AppDispatcher->_invoke() webroot/index.php:33- AppDispatcher->dispatch() |
1 | 1 | 1 | |
| 6 |
SELECT `Product`.`id`, `Product`.`name`, `Product`.`product_key`, `Product`.`product_type`, `Product`.`show_at_order`, `Product`.`optional`, `ProductDetail`.`id`, `ProductDetail`.`price`, `ProductDetail`.`min`, `ProductDetail`.`max`, `ProductDetail`.`step`, `ProductDetail`.`default`, `Addon`.`loco_key`, `CloudUnitType`.`name`, `CloudUnitType`.`multiplier`, `CloudUnitType`.`loco_key` FROM `webinterface_gp_2`.`product_datas` AS `Product` LEFT JOIN `webinterface_gp_2`.`product_details` AS `ProductDetail` ON (`ProductDetail`.`product_id` = `Product`.`id`) LEFT JOIN `webinterface_gp_2`.`games_addons` AS `Addon` ON (`Addon`.`id` = `Product`.`product_type_id`) LEFT JOIN `webinterface_gp_2`.`cloud_unit_types` AS `CloudUnitType` ON (`CloudUnitType`.`id` = `Addon`.`cloud_unit_type_id`) WHERE `Product`.`parent_id` = 21 AND `Product`.`active` = '1' ORDER BY `Product`.`id` ASC, `ProductDetail`.`min` ASC
Plugin/GameMgmt/Model/GameGroup.php:167- Product->getProductExtensionRows() src/GPortal/Lib/Order/Struct/ProductStruct.php:317- GameGroup->getProductExtensionsByProductId() src/GPortal/Lib/Order/Struct/ProductStruct.php:382- GPortal\Lib\Order\Struct\ProductStruct->getExtensions() src/GPortal/Lib/Order/Struct/PriceResponseResponseStruct.php:61- GPortal\Lib\Order\Struct\ProductStruct->getExtensionsWithPrices() src/GPortal/Lib/Order/OrderPrice.php:52- GPortal\Lib\Order\Struct\PriceResponseResponseStruct::createFromGPMoney() src/GPortal/Lib/Order/Struct/LocationStruct.php:147- GPortal\Lib\Order\OrderPrice->getOrderPriceResponse() Plugin/Order/Controller/OrderProcessController.php:614- GPortal\Lib\Order\Struct\LocationStruct->getLocalizedDiscountedOrderPrice() Plugin/Order/Controller/OrderProcessController.php:487- OrderProcessController->createBasket() Plugin/Order/Controller/OrderProcessController.php:247- OrderProcessController->createBasketFromQuery() ?:?- OrderProcessController->stepOne() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:193- WebinterfaceControllerAbstract->invokeAction() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:167- AppDispatcher->_invoke() webroot/index.php:33- AppDispatcher->dispatch() |
0 | 0 | 0 | |
| 7 |
SELECT `ProductDetail`.`id`, `ProductDetail`.`product_id`, `ProductDetail`.`default`, `ProductDetail`.`price`, `ProductDetail`.`min`, `ProductDetail`.`max`, `ProductDetail`.`step`, `ProductDetail`.`created`, `ProductDetail`.`modified`, `Product`.`id`, `Product`.`parent_id`, `Product`.`group_id`, `Product`.`location_id`, `Product`.`is_official`, `Product`.`show_at_order`, `Product`.`name`, `Product`.`active`, `Product`.`optional`, `Product`.`setup_charge`, `Product`.`unit_price`, `Product`.`image_mime_type`, `Product`.`product_key`, `Product`.`product_type`, `Product`.`product_type_id`, `Product`.`product_unit_id`, `Product`.`minimum_term`, `Product`.`cancellation_period_id`, `Product`.`hardware_category_id`, `Product`.`hardware_operating_system_id`, `Product`.`preorder`, `Product`.`created`, `Product`.`modified` FROM `webinterface_gp_2`.`product_details` AS `ProductDetail` LEFT JOIN `webinterface_gp_2`.`product_datas` AS `Product` ON (`ProductDetail`.`product_id` = `Product`.`id`) WHERE `ProductDetail`.`product_id` = 21 ORDER BY `ProductDetail`.`product_id` ASC, `ProductDetail`.`min` ASC
Plugin/ProductManagement/Model/ProductDetail.php:79- ProductDetail->getAllByProductId() Plugin/ProductManagement/Model/Product.php:359- ProductDetail->getProductUnit() src/GPortal/Lib/Order/Struct/ProductStruct.php:236- Product->getUnitPrice() Plugin/Order/Controller/OrderProcessController.php:620- GPortal\Lib\Order\Struct\ProductStruct->getUnitPrice() Plugin/Order/Controller/OrderProcessController.php:487- OrderProcessController->createBasket() Plugin/Order/Controller/OrderProcessController.php:247- OrderProcessController->createBasketFromQuery() ?:?- OrderProcessController->stepOne() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:193- WebinterfaceControllerAbstract->invokeAction() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:167- AppDispatcher->_invoke() webroot/index.php:33- AppDispatcher->dispatch() |
5 | 5 | 1 | |
| 8 |
SELECT `Product`.`id`, `Product`.`name`, `Product`.`product_key`, `Product`.`product_type`, `Product`.`show_at_order`, `Product`.`optional`, `ProductDetail`.`id`, `ProductDetail`.`price`, `ProductDetail`.`min`, `ProductDetail`.`max`, `ProductDetail`.`step`, `ProductDetail`.`default`, `Addon`.`loco_key`, `CloudUnitType`.`name`, `CloudUnitType`.`multiplier`, `CloudUnitType`.`loco_key` FROM `webinterface_gp_2`.`product_datas` AS `Product` LEFT JOIN `webinterface_gp_2`.`product_details` AS `ProductDetail` ON (`ProductDetail`.`product_id` = `Product`.`id`) LEFT JOIN `webinterface_gp_2`.`games_addons` AS `Addon` ON (`Addon`.`id` = `Product`.`product_type_id`) LEFT JOIN `webinterface_gp_2`.`cloud_unit_types` AS `CloudUnitType` ON (`CloudUnitType`.`id` = `Addon`.`cloud_unit_type_id`) WHERE `Product`.`parent_id` = 21 AND `Product`.`active` = '1' ORDER BY `Product`.`id` ASC, `ProductDetail`.`min` ASC
Plugin/GameMgmt/Model/GameGroup.php:167- Product->getProductExtensionRows() src/GPortal/Lib/Order/Struct/ProductStruct.php:317- GameGroup->getProductExtensionsByProductId() src/GPortal/Lib/Order/Struct/ProductResponseStruct.php:91- GPortal\Lib\Order\Struct\ProductStruct->getExtensions() src/GPortal/Lib/Order/OrderProduct.php:43- GPortal\Lib\Order\Struct\ProductResponseStruct::createFromProduct() Plugin/Order/Controller/OrderProcessController.php:260- GPortal\Lib\Order\OrderProduct->getOrderProductResponse() ?:?- OrderProcessController->stepOne() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:193- WebinterfaceControllerAbstract->invokeAction() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:167- AppDispatcher->_invoke() webroot/index.php:33- AppDispatcher->dispatch() |
0 | 0 | 1 | |
| 9 |
SELECT `LandingPage`.*, JSON_EXTRACT(Page.content, "$.title") AS title, JSON_EXTRACT(Page.content, "$.name") AS name FROM `webinterface_gp_2`.`content_landing_pages` AS `LandingPage` INNER JOIN `webinterface_gp_2`.`content_pages` AS `Page` ON (`LandingPage`.`locale` = `Page`.`locale` AND `LandingPage`.`page_key` = `Page`.`key`) WHERE `LandingPage`.`locale` = 'fr' AND FIND_IN_SET(3, `LandingPage`.`groups`) > 0 ORDER BY `name` ASC
src/GPortal/Lib/HeadlessCMS/LandingPages.php:248- LandingPage->search() Vendor/cakephp/cakephp/lib/Cake/Cache/Cache.php:576- GPortal\Lib\HeadlessCMS\LandingPages->GPortal\Lib\HeadlessCMS\{closure}() src/GPortal/Lib/HeadlessCMS/LandingPages.php:250- Cache::remember() View/Helper/VueHelper.php:94- GPortal\Lib\HeadlessCMS\LandingPages->search() View/Helper/VueHelper.php:71- VueHelper->footer() Vendor/twig/twig/src/Template.php:700- VueHelper->configPluginData() tmp/cache/templates/85/85580d12aa68fc33df8aa08d6fb3db28654f69c96f9e4d88c1a60c35f1e3f90d.php:219- Twig\Template->getAttribute() Vendor/twig/twig/src/Template.php:453- __TwigTemplate_c5ce0c44cc77f8d3ce90d6468dc5e1bfb121aa53e43f0b1c7cdfcb80dc89a608->doDisplay() Vendor/twig/twig/src/Template.php:420- Twig\Template->displayWithErrorHandling() tmp/cache/templates/20/20dcbb7f8de428446d349f7511c4fb6676d13862275db7e61fc767ae2c5d9fb4.php:36- Twig\Template->display() Vendor/twig/twig/src/Template.php:453- __TwigTemplate_3f0614e9e0938ce25ded18dc6ef3325484252b6100571ba697fdd3f07be26453->doDisplay() Vendor/twig/twig/src/Template.php:420- Twig\Template->displayWithErrorHandling() Vendor/twig/twig/src/Template.php:432- Twig\Template->display() Plugin/TwigView/View/TwigView.php:228- Twig\Template->render() Vendor/cakephp/cakephp/lib/Cake/View/View.php:546- TwigView->_render() Vendor/cakephp/cakephp/lib/Cake/View/View.php:481- View->renderLayout() Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php:968- View->render() Controller/Abstracts/VueControllerAbstract.php:22- Controller->render() Plugin/Order/Controller/OrderProcessController.php:290- VueControllerAbstract->render() ?:?- OrderProcessController->stepOne() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:193- WebinterfaceControllerAbstract->invokeAction() Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:167- AppDispatcher->_invoke() webroot/index.php:33- AppDispatcher->dispatch() |
6 | 6 | 1 |