Question: I can not edit product

I can not edit product

hello sir, after I install, I can't edit the product, please check it for me, thanks

P

panchuanhong

Asked
hello sir, after I install, I can't edit the product, please check it for me, thanks
  • MS

    Mian Saleem

    Answered
    Hello,

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

    panchuanhong

    Answered
    hello sir, please check screenshot at below
    after click here https://prnt.sc/qmkzf8
    then https://prnt.sc/qmkzps
  • MS

    Mian Saleem

    Answered
    Please check your server error logs for 500 error details and let me know so that I can suggest solution.
  • P

    panchuanhong

    Answered
    [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
  • MS

    Mian Saleem

    Answered
    The 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.
  • P

    panchuanhong

    Answered
    hello sir,
    I disabled it, but still same problem. other all are ok.
  • MS

    Mian Saleem

    Answered
    Please 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.
  • P

    panchuanhong

    Answered
    <?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
  • P

    panchuanhong

    Answered
    Hi , this is from the error log
  • MS

    Mian Saleem

    Answered
    As 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