Warning (512): SQL Error: 1104: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
Code |
Context
$sql = "SELECT `Product`.*, `Category`.*, `ProductType`.*, `I18n__name__acf`.`content`, `I18n__name__eng`.`content`, `I18n__description__acf`.`content`, `I18n__description__eng`.`content`, `I18n__author__acf`.`content`, `I18n__author__eng`.`content`, `I18n__publisher__acf`.`content`, `I18n__publisher__eng`.`content`, `I18n__series_title__acf`.`content`, `I18n__series_title__eng`.`content`, `I18n__authors__acf`.`content`, `I18n__authors__eng`.`content`, `I18n__artist__acf`.`content`, `I18n__artist__eng`.`content`, `I18n__group__acf`.`content`, `I18n__group__eng`.`content`, `Product`.`id` FROM `products` AS `Product` LEFT JOIN `i18n` AS `I18n__name__acf` ON (`Product`.`id` = `I18n__name__acf`.`foreign_key` AND `I18n__name__acf`.`model` = 'Product' AND `I18n__name__acf`.`field` = 'name' AND `I18n__name__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__name__eng` ON (`Product`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Product' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__description__acf` ON (`Product`.`id` = `I18n__description__acf`.`foreign_key` AND `I18n__description__acf`.`model` = 'Product' AND `I18n__description__acf`.`field` = 'description' AND `I18n__description__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__description__eng` ON (`Product`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Product' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__author__acf` ON (`Product`.`id` = `I18n__author__acf`.`foreign_key` AND `I18n__author__acf`.`model` = 'Product' AND `I18n__author__acf`.`field` = 'author' AND `I18n__author__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__author__eng` ON (`Product`.`id` = `I18n__author__eng`.`foreign_key` AND `I18n__author__eng`.`model` = 'Product' AND `I18n__author__eng`.`field` = 'author' AND `I18n__author__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__publisher__acf` ON (`Product`.`id` = `I18n__publisher__acf`.`foreign_key` AND `I18n__publisher__acf`.`model` = 'Product' AND `I18n__publisher__acf`.`field` = 'publisher' AND `I18n__publisher__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__publisher__eng` ON (`Product`.`id` = `I18n__publisher__eng`.`foreign_key` AND `I18n__publisher__eng`.`model` = 'Product' AND `I18n__publisher__eng`.`field` = 'publisher' AND `I18n__publisher__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__series_title__acf` ON (`Product`.`id` = `I18n__series_title__acf`.`foreign_key` AND `I18n__series_title__acf`.`model` = 'Product' AND `I18n__series_title__acf`.`field` = 'series_title' AND `I18n__series_title__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__series_title__eng` ON (`Product`.`id` = `I18n__series_title__eng`.`foreign_key` AND `I18n__series_title__eng`.`model` = 'Product' AND `I18n__series_title__eng`.`field` = 'series_title' AND `I18n__series_title__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__authors__acf` ON (`Product`.`id` = `I18n__authors__acf`.`foreign_key` AND `I18n__authors__acf`.`model` = 'Product' AND `I18n__authors__acf`.`field` = 'authors' AND `I18n__authors__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__authors__eng` ON (`Product`.`id` = `I18n__authors__eng`.`foreign_key` AND `I18n__authors__eng`.`model` = 'Product' AND `I18n__authors__eng`.`field` = 'authors' AND `I18n__authors__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__artist__acf` ON (`Product`.`id` = `I18n__artist__acf`.`foreign_key` AND `I18n__artist__acf`.`model` = 'Product' AND `I18n__artist__acf`.`field` = 'artist' AND `I18n__artist__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__artist__eng` ON (`Product`.`id` = `I18n__artist__eng`.`foreign_key` AND `I18n__artist__eng`.`model` = 'Product' AND `I18n__artist__eng`.`field` = 'artist' AND `I18n__artist__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__group__acf` ON (`Product`.`id` = `I18n__group__acf`.`foreign_key` AND `I18n__group__acf`.`model` = 'Product' AND `I18n__group__acf`.`field` = 'group' AND `I18n__group__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__group__eng` ON (`Product`.`id` = `I18n__group__eng`.`foreign_key` AND `I18n__group__eng`.`model` = 'Product' AND `I18n__group__eng`.`field` = 'group' AND `I18n__group__eng`.`locale` = 'eng') LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `product_types` AS `ProductType` ON (`Product`.`product_type_id` = `ProductType`.`id`) WHERE `Product`.`id` = 49 "
$error = "1104: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay"
$out = null
$out = null;
if ($error) {
trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 525
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 336
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 653
Model::find() - CORE/cake/libs/model/model.php, line 1988
ProductsController::view() - APP/controllers/products_controller.php, line 34
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - ROOT/index.php, line 175
Query: SELECT `Product`.*, `Category`.*, `ProductType`.*, `I18n__name__acf`.`content`, `I18n__name__eng`.`content`, `I18n__description__acf`.`content`, `I18n__description__eng`.`content`, `I18n__author__acf`.`content`, `I18n__author__eng`.`content`, `I18n__publisher__acf`.`content`, `I18n__publisher__eng`.`content`, `I18n__series_title__acf`.`content`, `I18n__series_title__eng`.`content`, `I18n__authors__acf`.`content`, `I18n__authors__eng`.`content`, `I18n__artist__acf`.`content`, `I18n__artist__eng`.`content`, `I18n__group__acf`.`content`, `I18n__group__eng`.`content`, `Product`.`id` FROM `products` AS `Product` LEFT JOIN `i18n` AS `I18n__name__acf` ON (`Product`.`id` = `I18n__name__acf`.`foreign_key` AND `I18n__name__acf`.`model` = 'Product' AND `I18n__name__acf`.`field` = 'name' AND `I18n__name__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__name__eng` ON (`Product`.`id` = `I18n__name__eng`.`foreign_key` AND `I18n__name__eng`.`model` = 'Product' AND `I18n__name__eng`.`field` = 'name' AND `I18n__name__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__description__acf` ON (`Product`.`id` = `I18n__description__acf`.`foreign_key` AND `I18n__description__acf`.`model` = 'Product' AND `I18n__description__acf`.`field` = 'description' AND `I18n__description__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__description__eng` ON (`Product`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'Product' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__author__acf` ON (`Product`.`id` = `I18n__author__acf`.`foreign_key` AND `I18n__author__acf`.`model` = 'Product' AND `I18n__author__acf`.`field` = 'author' AND `I18n__author__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__author__eng` ON (`Product`.`id` = `I18n__author__eng`.`foreign_key` AND `I18n__author__eng`.`model` = 'Product' AND `I18n__author__eng`.`field` = 'author' AND `I18n__author__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__publisher__acf` ON (`Product`.`id` = `I18n__publisher__acf`.`foreign_key` AND `I18n__publisher__acf`.`model` = 'Product' AND `I18n__publisher__acf`.`field` = 'publisher' AND `I18n__publisher__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__publisher__eng` ON (`Product`.`id` = `I18n__publisher__eng`.`foreign_key` AND `I18n__publisher__eng`.`model` = 'Product' AND `I18n__publisher__eng`.`field` = 'publisher' AND `I18n__publisher__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__series_title__acf` ON (`Product`.`id` = `I18n__series_title__acf`.`foreign_key` AND `I18n__series_title__acf`.`model` = 'Product' AND `I18n__series_title__acf`.`field` = 'series_title' AND `I18n__series_title__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__series_title__eng` ON (`Product`.`id` = `I18n__series_title__eng`.`foreign_key` AND `I18n__series_title__eng`.`model` = 'Product' AND `I18n__series_title__eng`.`field` = 'series_title' AND `I18n__series_title__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__authors__acf` ON (`Product`.`id` = `I18n__authors__acf`.`foreign_key` AND `I18n__authors__acf`.`model` = 'Product' AND `I18n__authors__acf`.`field` = 'authors' AND `I18n__authors__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__authors__eng` ON (`Product`.`id` = `I18n__authors__eng`.`foreign_key` AND `I18n__authors__eng`.`model` = 'Product' AND `I18n__authors__eng`.`field` = 'authors' AND `I18n__authors__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__artist__acf` ON (`Product`.`id` = `I18n__artist__acf`.`foreign_key` AND `I18n__artist__acf`.`model` = 'Product' AND `I18n__artist__acf`.`field` = 'artist' AND `I18n__artist__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__artist__eng` ON (`Product`.`id` = `I18n__artist__eng`.`foreign_key` AND `I18n__artist__eng`.`model` = 'Product' AND `I18n__artist__eng`.`field` = 'artist' AND `I18n__artist__eng`.`locale` = 'eng') LEFT JOIN `i18n` AS `I18n__group__acf` ON (`Product`.`id` = `I18n__group__acf`.`foreign_key` AND `I18n__group__acf`.`model` = 'Product' AND `I18n__group__acf`.`field` = 'group' AND `I18n__group__acf`.`locale` = 'acf') LEFT JOIN `i18n` AS `I18n__group__eng` ON (`Product`.`id` = `I18n__group__eng`.`foreign_key` AND `I18n__group__eng`.`model` = 'Product' AND `I18n__group__eng`.`field` = 'group' AND `I18n__group__eng`.`locale` = 'eng') LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `product_types` AS `ProductType` ON (`Product`.`product_type_id` = `ProductType`.`id`) WHERE `Product`.`id` = 49
Warning (2): Cannot modify header information - headers already sent by (output started at /home3/stlucia1/public_html/cake_125/cake/basics.php:109) [CORE/cake/libs/controller/controller.php, line 644]
Code |
Context
$status = "Location: https://stluciafolk.org/carts"
header - [internal], line ??
Controller::header() - CORE/cake/libs/controller/controller.php, line 644
Controller::redirect() - CORE/cake/libs/controller/controller.php, line 625
ProductsController::view() - APP/controllers/products_controller.php, line 36
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - ROOT/index.php, line 175