Question: I CAN NOT ADD PRODUCT IN ADD SALES

I CAN NOT ADD PRODUCT IN ADD SALES

I CAN NOT ADD PRODUCTs INTO ADD SALES PAGE## The spinner will spin forever## I attached a screenshot of the problem ## DANIEL

D

DAN

Asked

I CAN NOT ADD PRODUCTs INTO ADD SALES PAGE## The spinner will spin forever##

I attached a screenshot of the problem

DANIEL

  • MS

    Mian Saleem

    Answered

    Hello,

    Please check the server requirements in the documentation.pdf specially MySQL only_full_group_by mode.

    Lastly check the server error logs and let me know the error details so that I can suggest solution.

    Thank you

  • D

    DAN

    Answered

    thanks for your reply .i do not think it is only_full_group_by mode because every other function works perfectly

    i looked into the request and response data i have a screen shot attached.

  • D

    DAN

    Answered

    as you can see from the attachment i think it is a code bug in the software

  • MS

    Mian Saleem

    Answered

    Hello,

    You need to check your server error logs to know the 500 error details. It might be cause to various reasons and without the error details I can’t suggest.

    You can enable app logs by changing the log_threshold to 1 in app/config/config.php and the perform the action again to produce errors. Lastly check the latest log in the app/logs/ folder.

    Thank you

  • D

    DAN

    Answered

    O Thank you for you quick reply i did as you suggested and this is the log it generated

    i attached it

    i can see this is incompatible with sql_mode=only_full_group_by and others

    i will love a step by step solution thank you!

  • D

    DAN

    Answered

    O Thank you for you quick reply i did as you suggested and this is the log it generated

    i attached it

    i can see this is incompatible with sql_mode=only_full_group_by and others

    i will love a step by step solution thank you!

  • MS

    Mian Saleem

    Answered

    You can check https://stackoverflow.com/questions/23921117/disable-only-full-group-by and with your server admin/host. Thank you

  • MD

    Martin Devlin

    Answered

    I have the same problem, and I have ONLY_FULL_GROUP_BY disabled. I don’t know what to do, I have no way to add the products

  • MS

    Mian Saleem

    Answered

    Martin Devlin Hello,

    Please ask new question with details and screenshot. SMA disables mode on session level. The might be due to some other reason. You can check your server php error logs and add the details to your question.

    Thank you

  • Login to Reply