Crash with MySQL and "on_connect_call: set_strict_mode"

[racke]

Error 500 - Internal Server Error

Runtime Error

Hook error: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: 'demoshop.product.canonical_sku' isn't in GROUP BY [for Statement "SELECT `product`.`sku`, `product`.`name`, `product`.`uri`, `product`.`price`, `product`.`short_description`, `product`.`highest_price`, (SELECT COUNT( * ) FROM `products` `variants_alias` WHERE ( `variants_alias`.`canonical_sku` = `product`.`sku` )), `product`.`average_rating`, `product`.`selling_price`, `product`.`quantity_in_stock`, `media_products`.`media_id`, `media_products`.`sku`, `media`.`media_id`, `media`.`file`, `media`.`uri`, `media`.`mime_type`, `media`.`label`, `media`.`author_users_id`, `media`.`created`, `media`.`last_modified`, `media`.`active`, `media`.`media_types_id`, `media`.`priority` FROM `navigation_products` `me`  JOIN (SELECT `product`.`sku`, `product`.`name`, `product`.`uri`, `product`.`price`, `product`.`short_description`, COALESCE( (SELECT MAX( `variants_alias`.`price` ) FROM `products` `variants_alias` WHERE ( `variants_alias`.`canonical_sku` = `product`.`sku` )), `product`.`price` ) AS `highest_price`, (SELECT COUNT( * ) FROM `products` `variants_alias` WHERE ( `variants_alias`.`canonical_sku` = `product`.`sku` )), COALESCE( (SELECT AVG( `message`.`rating` ) FROM `products` `canonical_alias`  JOIN `product_messages` `product_messages` ON `product_messages`.`sku` = `canonical_alias`.`sku`  JOIN `messages` `message` ON `message`.`messages_id` = `product_messages`.`messages_id`  JOIN `message_types` `message_type` ON `message_type`.`message_types_id` = `message`.`message_types_id` WHERE ( ( `canonical_alias`.`sku` = `product`.`canonical_sku` AND `message`.`approved` = ? AND `message`.`public` = ? AND `message_type`.`name` = ? ) )), (SELECT AVG( `message`.`rating` ) FROM `product_messages` `product_messages_alias`  JOIN `messages` `message` ON `message`.`messages_id` = `product_messages_alias`.`messages_id`  JOIN `message_types` `message_type` ON `message_type`.`message_types_id` = `message`.`message_types_id` WHERE ( ( `message`.`approved` = ? AND `message`.`public` = ? AND `message_type`.`name` = ? AND `product_messages_alias`.`sku` = `product`.`sku` ) )) ) AS `average_rating`, COALESCE( LEAST( COALESCE( (SELECT MIN( `price_modifiers`.`price` ) FROM `products` `variants_alias`  JOIN `price_modifiers` `price_modifiers` ON `price_modifiers`.`sku` = `variants_alias`.`sku` WHERE ( ( ( `end_date` IS NULL OR `end_date` >= ? ) AND `quantity` <= ? AND `roles_id` IS NULL AND ( `start_date` IS NULL OR `start_date` <= ? ) AND `variants_alias`.`canonical_sku` = `product`.`sku` ) )), (SELECT MIN( `variants_alias`.`price` ) FROM `products` `variants_alias` WHERE ( `variants_alias`.`canonical_sku` = `product`.`sku` )) ), (SELECT MIN( `variants_alias`.`price` ) FROM `products` `variants_alias` WHERE ( `variants_alias`.`canonical_sku` = `product`.`sku` )) ), COALESCE( (SELECT MIN( `price_modifiers_alias`.`price` ) FROM `price_modifiers` `price_modifiers_alias` WHERE ( ( ( `end_date` IS NULL OR `end_date` >= ? ) AND `price_modifiers_alias`.`sku` = `product`.`sku` AND `quantity` <= ? AND `roles_id` IS NULL AND ( `start_date` IS NULL OR `start_date` <= ? ) ) )), `product`.`price` ) ) AS `selling_price`, COALESCE( (SELECT SUM( `inventory`.`quantity` ) FROM `products` `variants_alias`  JOIN `inventories` `inventory` ON `inventory`.`sku` = `variants_alias`.`sku` WHERE ( `variants_alias`.`canonical_sku` = `product`.`sku` )), (SELECT `inventory_alias`.`quantity` FROM `inventories` `inventory_alias` WHERE ( `inventory_alias`.`sku` = `product`.`sku` )) ) AS `quantity_in_stock`, `product`.`active`, `product`.`priority` FROM `navigation_products` `me`  JOIN `products` `product` ON `product`.`sku` = `me`.`sku` LEFT JOIN `media_products` `media_products` ON `media_products`.`sku` = `product`.`sku` LEFT JOIN `medias` `media` ON `media`.`media_id` = `media_products`.`media_id` LEFT JOIN `media_types` `media_type` ON `media_type`.`media_types_id` = `media`.`media_types_id` WHERE ( ( `me`.`navigation_id` = ? AND `media`.`active` = ? AND `media_type`.`type` = ? AND `product`.`active` = ? ) ) GROUP BY `product`.`sku`, `product`.`name`, `product`.`uri`, `product`.`price`, `product`.`short_description`, (SELECT COUNT( * ) FROM `products` `variants_alias` WHERE ( `variants_alias`.`canonical_sku` = `product`.`sku` )), `product`.`active`, `product`.`priority` ORDER BY `product`.`priority` DESC LIMIT ?) `product` ON `product`.`sku` = `me`.`sku` LEFT JOIN `media_products` `media_products` ON `media_products`.`sku` = `product`.`sku` LEFT JOIN `medias` `media` ON `media`.`media_id` = `media_products`.`media_id` LEFT JOIN `media_types` `media_type` ON `media_type`.`media_types_id` = `media`.`media_types_id` WHERE ( ( `me`.`navigation_id` = ? AND `media`.`active` = ? AND `media_type`.`type` = ? AND `product`.`active` = ? ) ) ORDER BY `product`.`priority` DESC" with ParamValues: 0=1, 1=1, 2='product_review', 3=1, 4=1, 5='product_review', 6='2016-07-01 00:00:00', 7=1, 8='2016-07-01 00:00:00', 9='2016-07-01 00:00:00', 10=1, 11='2016-07-01 00:00:00', 12='12', 13=1, 14='image', 15=1, 16=10, 17='12', 18=1, 19='image', 20=1] at /home/racke/camp26/DanceShop/bin/../lib/DanceShop.pm line 456
 at /home/racke/camp26/local/lib/perl5/Dancer2/Plugin.pm line 531.
/home/racke/camp26/DanceShop/bin/../lib/DanceShop.pm around line 456
451             push @grid, +{ row => \@row };
452         }
453         $tokens->{products} = \@grid;
454     }
455     else {
456         $tokens->{products} = [ $products->all ];
457     }
458 
459     # pagination
460 
461     if ( $pager && $pager->last_page > 1 ) {