Our team intervenes within 48 hours, we recommend you submit a public ticket so that other developers can help to fix the issue as soon as possible.

If you purchased the item 6 months ago, please read the Item Support Policy carefully before submitting a ticket.

Note: don’t share item or server credentials on public, use the private option.

Okay
  Public Ticket #1892676
Database error
Closed

Comments

  • mitchell9292 started the conversation

    I added a store inside the admin panel but there is a database error after creating it. When I check the database, the store is inside it.


    A Database Error Occurred

    Error Number: 1055

    Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'stadapp_db.category.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

    SELECT category.name as category_name, store.* FROM `store` JOIN `category` ON `category`.`id_category`=`store`.`category_id` WHERE `store`.`id_store` = 3 GROUP BY `store`.`id_store` ORDER BY `store`.`id_store` DESC LIMIT 20

    Filename: modules/store/models/Store_model.php

    Line Number: 601


  •  142
    Elyas replied

    This error is related to the php version compatibility , please go to your cpanel and downgrade your php version to 5.6 or 7.0 to run the app correctly .


    Thank you 

    Best Regards DT team.

    NearbyStores iOS => Buy now from envato

    NearbyStores Android => Buy now from envato

    Follow us on Facebook Page => Here

  • mitchell9292 replied

    Solved, was mysql problem.

  •  142
    Elyas replied

    Perfect , thanks for the update .


    Best Regards DT team.

    NearbyStores iOS => Buy now from envato

    NearbyStores Android => Buy now from envato

    Follow us on Facebook Page => Here