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`.`content`, `I18n__description`.`content`, `I18n__author`.`content`, `I18n__publisher`.`content`, `I18n__series_title`.`content`, `I18n__authors`.`content`, `I18n__artist`.`content`, `I18n__group`.`content`, `Product`.`id` FROM `products` AS `Product` LEFT JOIN `i18n` AS `I18n__name` ON (`Product`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Product' AND `I18n__name`.`field` = 'name') LEFT JOIN `i18n` AS `I18n__description` ON (`Product`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Product' AND `I18n__description`.`field` = 'description') LEFT JOIN `i18n` AS `I18n__author` ON (`Product`.`id` = `I18n__author`.`foreign_key` AND `I18n__author`.`model` = 'Product' AND `I18n__author`.`field` = 'author') LEFT JOIN `i18n` AS `I18n__publisher` ON (`Product`.`id` = `I18n__publisher`.`foreign_key` AND `I18n__publisher`.`model` = 'Product' AND `I18n__publisher`.`field` = 'publisher') LEFT JOIN `i18n` AS `I18n__series_title` ON (`Product`.`id` = `I18n__series_title`.`foreign_key` AND `I18n__series_title`.`model` = 'Product' AND `I18n__series_title`.`field` = 'series_title') LEFT JOIN `i18n` AS `I18n__authors` ON (`Product`.`id` = `I18n__authors`.`foreign_key` AND `I18n__authors`.`model` = 'Product' AND `I18n__authors`.`field` = 'authors') LEFT JOIN `i18n` AS `I18n__artist` ON (`Product`.`id` = `I18n__artist`.`foreign_key` AND `I18n__artist`.`model` = 'Product' AND `I18n__artist`.`field` = 'artist') LEFT JOIN `i18n` AS `I18n__group` ON (`Product`.`id` = `I18n__group`.`foreign_key` AND `I18n__group`.`model` = 'Product' AND `I18n__group`.`field` = 'group') 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` = 41 AND `I18n__name`.`locale` = 'eng' AND `I18n__description`.`locale` = 'eng' AND `I18n__author`.`locale` = 'eng' AND `I18n__publisher`.`locale` = 'eng' AND `I18n__series_title`.`locale` = 'eng' AND `I18n__authors`.`locale` = 'eng' AND `I18n__artist`.`locale` = 'eng' AND `I18n__group`.`locale` = 'eng' "
$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`.`content`, `I18n__description`.`content`, `I18n__author`.`content`, `I18n__publisher`.`content`, `I18n__series_title`.`content`, `I18n__authors`.`content`, `I18n__artist`.`content`, `I18n__group`.`content`, `Product`.`id` FROM `products` AS `Product` LEFT JOIN `i18n` AS `I18n__name` ON (`Product`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Product' AND `I18n__name`.`field` = 'name') LEFT JOIN `i18n` AS `I18n__description` ON (`Product`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Product' AND `I18n__description`.`field` = 'description') LEFT JOIN `i18n` AS `I18n__author` ON (`Product`.`id` = `I18n__author`.`foreign_key` AND `I18n__author`.`model` = 'Product' AND `I18n__author`.`field` = 'author') LEFT JOIN `i18n` AS `I18n__publisher` ON (`Product`.`id` = `I18n__publisher`.`foreign_key` AND `I18n__publisher`.`model` = 'Product' AND `I18n__publisher`.`field` = 'publisher') LEFT JOIN `i18n` AS `I18n__series_title` ON (`Product`.`id` = `I18n__series_title`.`foreign_key` AND `I18n__series_title`.`model` = 'Product' AND `I18n__series_title`.`field` = 'series_title') LEFT JOIN `i18n` AS `I18n__authors` ON (`Product`.`id` = `I18n__authors`.`foreign_key` AND `I18n__authors`.`model` = 'Product' AND `I18n__authors`.`field` = 'authors') LEFT JOIN `i18n` AS `I18n__artist` ON (`Product`.`id` = `I18n__artist`.`foreign_key` AND `I18n__artist`.`model` = 'Product' AND `I18n__artist`.`field` = 'artist') LEFT JOIN `i18n` AS `I18n__group` ON (`Product`.`id` = `I18n__group`.`foreign_key` AND `I18n__group`.`model` = 'Product' AND `I18n__group`.`field` = 'group') 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` = 41 AND `I18n__name`.`locale` = 'eng' AND `I18n__description`.`locale` = 'eng' AND `I18n__author`.`locale` = 'eng' AND `I18n__publisher`.`locale` = 'eng' AND `I18n__series_title`.`locale` = 'eng' AND `I18n__authors`.`locale` = 'eng' AND `I18n__artist`.`locale` = 'eng' AND `I18n__group`.`locale` = 'eng'
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