Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 514]
$sql = "SELECT `ProductRelated`.`id`, `ProductRelated`.`related_id`, `ProductRelated`.`parent_id`, `ProductRelated`.`published`, `ProductRelated`.`created`, `ProductRelated`.`modified`, `ProductRelated`.`lft`, `ProductRelated`.`rght`, `ProductRelated`.`products_id`, `Product`.`slug`, `Product`.`name`, `Product`.`image`, `Product`.`retail` FROM `product_related` AS `ProductRelated` LEFT JOIN `products` AS `Product` ON (`ProductRelated`.`related_id` = `Product`.`id`) WHERE `ProductRelated`.`published` = 1 AND `ProductRelated`.`products_id` = "
$error = "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 514
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 337
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 636
Model::find() - CORE/cake/libs/model/model.php, line 1956
Model::findAll() - CORE/cake/libs/model/model.php, line 2821
PagesController::products() - APP/controllers/pages_controller.php, line 218
Object::dispatchMethod() - CORE/cake/libs/object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 245
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 211
[main] - APP/webroot/index.php, line 84
Query: SELECT `ProductRelated`.`id`, `ProductRelated`.`related_id`, `ProductRelated`.`parent_id`, `ProductRelated`.`published`, `ProductRelated`.`created`, `ProductRelated`.`modified`, `ProductRelated`.`lft`, `ProductRelated`.`rght`, `ProductRelated`.`products_id`, `Product`.`slug`, `Product`.`name`, `Product`.`image`, `Product`.`retail` FROM `product_related` AS `ProductRelated` LEFT JOIN `products` AS `Product` ON (`ProductRelated`.`related_id` = `Product`.`id`) WHERE `ProductRelated`.`published` = 1 AND `ProductRelated`.`products_id` =
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY `ProductOption`.`options_id` ORDER BY `ProductOption`.`lft` ASC' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 514]
$sql = "SELECT `ProductOption`.`id`, `ProductOption`.`products_id`, `ProductOption`.`variants_id`, `ProductOption`.`price`, `ProductOption`.`weight`, `ProductOption`.`published`, `ProductOption`.`options_id`, `ProductOption`.`bulk`, `ProductOption`.`retail`, `ProductOption`.`code`, `ProductOption`.`lft`, `ProductOption`.`rght`, `ProductOption`.`parent_id`, `ProductOption`.`relative`, `OptionVariant`.`id`, `OptionVariant`.`options_id`, `OptionVariant`.`published`, `Option`.`id`, `Option`.`published`, `Option`.`type`, `Option`.`inventory` FROM `product_options` AS `ProductOption` LEFT JOIN `option_variants` AS `OptionVariant` ON (`ProductOption`.`variants_id` = `OptionVariant`.`id`) LEFT JOIN `options` AS `Option` ON (`ProductOption`.`options_id` = `Option`.`id`) WHERE `ProductOption`.`published`=1 AND `Option`.`type`="selectbox" AND `ProductOption`.`products_id`= GROUP BY `ProductOption`.`options_id` ORDER BY `ProductOption`.`lft` ASC "
$error = "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY `ProductOption`.`options_id` ORDER BY `ProductOption`.`lft` ASC' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 514
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 337
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 636
Model::find() - CORE/cake/libs/model/model.php, line 1956
Model::findAll() - CORE/cake/libs/model/model.php, line 2821
PagesController::products() - APP/controllers/pages_controller.php, line 227
Object::dispatchMethod() - CORE/cake/libs/object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 245
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 211
[main] - APP/webroot/index.php, line 84
Query: SELECT `ProductOption`.`id`, `ProductOption`.`products_id`, `ProductOption`.`variants_id`, `ProductOption`.`price`, `ProductOption`.`weight`, `ProductOption`.`published`, `ProductOption`.`options_id`, `ProductOption`.`bulk`, `ProductOption`.`retail`, `ProductOption`.`code`, `ProductOption`.`lft`, `ProductOption`.`rght`, `ProductOption`.`parent_id`, `ProductOption`.`relative`, `OptionVariant`.`id`, `OptionVariant`.`options_id`, `OptionVariant`.`published`, `Option`.`id`, `Option`.`published`, `Option`.`type`, `Option`.`inventory` FROM `product_options` AS `ProductOption` LEFT JOIN `option_variants` AS `OptionVariant` ON (`ProductOption`.`variants_id` = `OptionVariant`.`id`) LEFT JOIN `options` AS `Option` ON (`ProductOption`.`options_id` = `Option`.`id`) WHERE `ProductOption`.`published`=1 AND `Option`.`type`="selectbox" AND `ProductOption`.`products_id`= GROUP BY `ProductOption`.`options_id` ORDER BY `ProductOption`.`lft` ASC
Warning (2): Invalid argument supplied for foreach() [APP/controllers/pages_controller.php, line 232]
$counter = 0; foreach($product_options as $option):
PagesController::products() - APP/controllers/pages_controller.php, line 232
Object::dispatchMethod() - CORE/cake/libs/object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 245
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 211
[main] - APP/webroot/index.php, line 84
::[ Αρχική | Ανθοπωλεία στα Ιωάννινα Ανθοσύνθεση, Ανθοπωλείο στα Γιάννενα ]::