P
Asked
hello sir, after I install, I can't edit the product, please check it for me, thanks
- MSAnsweredHello,
Please check the server requirements in the documentation.pdf that is included in your download.
If still same, please describe the issue in details with screenshot of the full page.
Thank you - PAnsweredhello sir, please check screenshot at below
after click here https://prnt.sc/qmkzf8
then https://prnt.sc/qmkzps - MSAnsweredPlease check your server error logs for 500 error details and let me know so that I can suggest solution.
- PAnswered[11-Jan-2020 00:20:15 Europe/London] PHP Fatal error: session_start(): Failed to initialize storage module: user (path: /tmp) in /home/skysongf/public_html/erp/system/libraries/Session/Session.php on line 143
- MSAnsweredThe session error might be logged before install and nothing to to do with your issue. Please check the server requirements in the documentation.pdf and make sure your server meet them, please pay special attention on mysql mode `only_full_group_by` It must be disabled.
- PAnsweredhello sir,
I disabled it, but still same problem. other all are ok. - MSAnsweredPlease check server error logs and let me know the error details. You can check with your host for logs path.
You can enabled app log by changing the log_threshold to 1 in app/config/config.php and then try to edit product again. The logs will in app/logs/ folder. - PAnswered<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "downloads"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "search"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "send_email_title"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "message_sent"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "out_of_stock"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "x_product"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "x_reverted_back"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "line1"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "line2"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "okay"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "cancel"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "email_is_invalid"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "full_name"
ERROR - 2020-01-16 19:59:49 --> Could not find the language line "required_invalid"
ERROR - 2020-01-16 20:00:12 --> Query error: Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'skysongf_erp.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` = '1'
GROUP BY `sma_warehouses`.`id`
ERROR - 2020-01-16 20:00:12 --> Severity: error --> Exception: Call to a member function num_rows() on boolean /home/skysongf/public_html/erp/app/models/admin/Products_model.php 367 - PAnsweredHi , this is from the error log
- MSAnsweredAs you can see the error, the issue is due to MySQL mode `only_full_group_by` Please disable it.
> It's already mentioned in the server requirements in documentation.pdf that is included in your download. - Login to Reply