JS
Asked
this error I get does not open because I vote this error in li localhost normal works someone can help
http://dicova.pe/shop/search?page=1
This page does not work The dicova.pe page cannot process this request now.
http://dicova.pe/shop/search?page=1
This page does not work The dicova.pe page cannot process this request now.
- MSAnsweredHello,
Please check your server error logs and let us know the error details so that we can suggest.
If you need to enable app logs, you can change the `log_threshold` to 1 in the `app/config/config.php` file and then visit the page again to reproduce the errors. Lastly check the latest log file in the `app/logs/` folder.
Thank you - JSAnsweredERROR - 2020-08-11 09:57:18 --> Severity: error --> Exception: Call to a member function result_array() on bool /home/dicovaperu/public_html/app/models/shop/Shop_model.php 475
ERROR - 2020-08-11 09:58:26 --> Query error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dicovape_dicova.sma_warehouses_products.quantity' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT `sma_products`.`id` as `id`, `sma_products`.`name` as `name`, `sma_products`.`code` as `code`, `sma_products`.`image` as `image`, `sma_products`.`slug` as `slug`, `sma_products`.`price` as `price`, `sma_warehouses_products`.`quantity` as `quantity`, `type`, `promotion`, `promo_price`, `start_date`, `end_date`, `product_details` as `details`, `b`.`name` as `brand_name`, `b`.`slug` as `brand_slug`
FROM `sma_products`
LEFT JOIN `sma_brands` `b` ON `sma_products`.`brand`=`b`.`id`
LEFT JOIN `sma_warehouses_products` ON `sma_products`.`id`=`sma_warehouses_products`.`product_id`
WHERE `sma_warehouses_products`.`warehouse_id` = '1'
AND `hide` != 1
GROUP BY `sma_products`.`id`
ORDER BY `name` asc
LIMIT 12
ERROR - 2020-08-11 09:58:26 --> Severity: error --> Exception: Call to a member function result_array() on bool /home/dicovaperu/public_html/app/models/shop/Shop_model.php 475
ERROR - 2020-08-11 09:58:26 --> Query error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dicovape_dicova.sma_warehouses_products.quantity' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT `sma_products`.`id` as `id`, `sma_products`.`name` as `name`, `sma_products`.`code` as `code`, `sma_products`.`image` as `image`, `sma_products`.`slug` as `slug`, `sma_products`.`price` as `price`, `sma_warehouses_products`.`quantity` as `quantity`, `type`, `promotion`, `promo_price`, `start_date`, `end_date`, `product_details` as `details`, `b`.`name` as `brand_name`, `b`.`slug` as `brand_slug`
FROM `sma_products`
LEFT JOIN `sma_brands` `b` ON `sma_products`.`brand`=`b`.`id`
LEFT JOIN `sma_warehouses_products` ON `sma_products`.`id`=`sma_warehouses_products`.`product_id`
WHERE `sma_warehouses_products`.`warehouse_id` = '1'
AND `hide` != 1
GROUP BY `sma_products`.`id`
ORDER BY `name` asc
LIMIT 12
ERROR - 2020-08-11 09:58:26 --> Severity: error --> Exception: Call to a member function result_array() on bool /home/dicovaperu/public_html/app/models/shop/Shop_model.php 475
ERROR - 2020-08-11 09:58:26 --> Query error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dicovape_dicova.sma_warehouses_products.quantity' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT `sma_products`.`id` as `id`, `sma_products`.`name` as `name`, `sma_products`.`code` as `code`, `sma_products`.`image` as `image`, `sma_products`.`slug` as `slug`, `sma_products`.`price` as `price`, `sma_warehouses_products`.`quantity` as `quantity`, `type`, `promotion`, `promo_price`, `start_date`, `end_date`, `product_details` as `details`, `b`.`name` as `brand_name`, `b`.`slug` as `brand_slug`
FROM `sma_products`
LEFT JOIN `sma_brands` `b` ON `sma_products`.`brand`=`b`.`id`
LEFT JOIN `sma_warehouses_products` ON `sma_products`.`id`=`sma_warehouses_products`.`product_id`
WHERE `sma_warehouses_products`.`warehouse_id` = '1'
AND `hide` != 1
GROUP BY `sma_products`.`id`
ORDER BY `name` asc
LIMIT 12
ERROR - 2020-08-11 09:58:26 --> Severity: error --> Exception: Call to a member function result_array() on bool /home/dicovaperu/public_html/app/models/shop/Shop_model.php 475
ERROR - 2020-08-11 09:58:26 --> Query error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dicovape_dicova.sma_warehouses_products.quantity' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT `sma_products`.`id` as `id`, `sma_products`.`name` as `name`, `sma_products`.`code` as `code`, `sma_products`.`image` as `image`, `sma_products`.`slug` as `slug`, `sma_products`.`price` as `price`, `sma_warehouses_products`.`quantity` as `quantity`, `type`, `promotion`, `promo_price`, `start_date`, `end_date`, `product_details` as `details`, `b`.`name` as `brand_name`, `b`.`slug` as `brand_slug`
FROM `sma_products`
LEFT JOIN `sma_brands` `b` ON `sma_products`.`brand`=`b`.`id` - MSAnsweredHello,
Please disabled the MySQL `only_full_group_by` mode. It's mentioned on the item page that this item is no compatible with the mode.
If you are not using the latest version, then you can perform update by downloading the latest file and following the update instructions from documentation.pdf
Thank you - Login to Reply