Question: This page does not work HTTP ERROR 500

This page does not work HTTP ERROR 500

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 cann

JS

Jeysey Solon

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.
  • MS

    Mian Saleem

    Answered
    Hello,

    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
  • JS

    Jeysey Solon

    Answered
    ERROR - 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`
  • MS

    Mian Saleem

    Answered
    Hello,

    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