Question: Product Details dont work

Product Details dont work

Hello The page does not open when any product's Product Details is clicked on the products page. how can i solve this error.

AA

Ali Veli Ahmet

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

    Mian Saleem

    Answered
    Hello,

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

    Ali Veli Ahmet

    Answered
    Hello, everything is ok when I do the checks.

    https://prnt.sc/rqwxco

    but it still gets stuck like this

    https://prnt.sc/rqwxrs
  • MS

    Mian Saleem

    Answered
    You 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
  • AA

    Ali Veli Ahmet

    Answered
    Hello,

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

    Ali Veli Ahmet

    Answered
    hello app logs.

    att https://prnt.sc/rqyi1w
  • MS

    Mian Saleem

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

    Ali Veli Ahmet

    Answered
    thank you the problem is solved good day.
  • Login to Reply