AA
Asked
Hello
The page does not open when any product's Product Details is clicked on the products page. how can i solve this error.
The page does not open when any product's Product Details is clicked on the products page. how can i solve this error.
- MSAnsweredHello,
Please check the server requirements in the documentation.pdf that is included in your download. Please pay special attention on `MySQL` mode `only_full_group_by`
Lastly check your server error logs and let me know the error details so that I can suggest.
Thank you - AAAnsweredHello, everything is ok when I do the checks.
https://prnt.sc/rqwxco
but it still gets stuck like this
https://prnt.sc/rqwxrs - MSAnsweredYou didn't post the error details from server error logs :(
You can enable app log by editing the `app/config/config.php` and changing the `log_threshold` to 1. After visit the page again to reproduce error. Lastly check the latest log in `app/logs/` folder.
Thank you - AAAnsweredHello,
App/logs
<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "shop"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "list_returns"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "add_return"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "promos"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "list_printers"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "add_printer"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "tax_report"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "front_end"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "shop_settings"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "slider_settings"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "list_pages"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "add_page"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "sms_settings"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "send_sms"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "sms_log"
ERROR - 2020-04-01 18:58:15 --> Could not find the language line "required_invalid"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "shop"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "list_returns"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "add_return"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "promos"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "list_printers"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "add_printer"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "tax_report"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "front_end"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "shop_settings"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "slider_settings"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "list_pages"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "add_page"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "sms_settings"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "send_sms"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "sms_log"
ERROR - 2020-04-01 18:58:17 --> Could not find the language line "required_invalid"
ERROR - 2020-04-01 18:58:27 --> Query error: Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tumbakid_panel.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_warehouses`.*, `sma_warehouses_products`.`quantity`, `sma_warehouses_products`.`rack`
FROM `sma_warehouses`
LEFT JOIN `sma_warehouses_products` ON `sma_warehouses_products`.`warehouse_id`=`sma_warehouses`.`id`
WHERE `sma_warehouses_products`.`product_id` = '3'
GROUP BY `sma_warehouses`.`id`
ERROR - 2020-04-01 18:58:27 --> Severity: error --> Exception: Call to a member function num_rows() on boolean /home/tumbakide/public_html/panel/app/models/admin/Products_model.php 367 - AAAnsweredhello app logs.
att https://prnt.sc/rqyi1w - MSAnsweredAs you can see from error the `only_full_group_by` is not disabled and SMA is compatible with this mode. Please disabled it. Thank you
- AAAnsweredthank you the problem is solved good day.
- Login to Reply