Hi, im relativeliy new with Spryker, but working in a Team on an actual Dev-System. At the Moment we

UP957L8F3

Hi, im relativeliy new with Spryker, but working in a Team on an actual Dev-System. At the Moment we have problems with the backend to show the category groups. https://testshop.com/category-gui/list throws an Ajax Error. which results from calling following request:
https://testshop.com/category-gui/list/table?draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=4&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=5&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=6&columns%5B6%5D%5Bname%5D=&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=true&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B7%5D%5Bdata%5D=7&columns%5B7%5D%5Bname%5D=&columns%5B7%5D%5Bsearchable%5D=true&columns%5B7%5D%5Borderable%5D=false&columns%5B7%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B7%5D%5Bsearch%5D%5Bregex%5D=false&order%5B0%5D%5Bcolumn%5D=0&order%5B0%5D%5Bdir%5D=asc&start=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1571302428907

which throws following SQL Exception:
https://pastebin.com/jheWizTx

ULL0N440J

Hey Ulrich,
could you have a look into the project/data/DE/logs/ZED/exception.log? I've had some similar issues before. By my experience it's mainly some basic mistakes (for example "Couldn't find template with id 'page-static'" (wrong spelling or something)).

Valerii Trots

Exception is here - https://pastebin.com/jheWizTx.

Valerii Trots

Seems like data\access to data problems

UP957L8F3

hmmm but where. Most things are working

UP957L8F3

I have to mention that we use MySQL

Valerii Trots

Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'helukabel.spy_category.id_category' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /var/www/html/public/spryker/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:194)

UP957L8F3

Ah and I'm no SQL God 🙂

Valerii Trots

https://ourcodeworld.com/articles/read/732/how-to-solve-mysql-syntax-error-or-access-violation-1055-expression-of-select-list-is-not-in-group-by-clause-and-contains-nonaggregated-column-which-is-not-functionally-dependent-on-columns-in-group-by-clause ?

UP957L8F3

Oh cool, I'll try this. Many thanks 😄

Valerii Trots

I will just copy-paste links that can be useful here:

https://stackoverflow.com/questions/34115174/error-related-to-only-full-group-by-when-executing-a-query-in-mysql

https://stackoverflow.com/questions/36950857/sqlstate42000-syntax-error-or-access-violation-1055-expression-3-of-select

https://stackoverflow.com/questions/41887460/select-list-is-not-in-group-by-clause-and-contains-nonaggregated-column-inc

https://stackoverflow.com/questions/36228836/syntax-error-or-access-violation-1055-expression-8-of-select-list-is-not-in-gr

https://stackoverflow.com/questions/37951742/1055-expression-of-select-list-is-not-in-group-by-clause-and-contains-nonaggr

UP957L8F3

so, at the moment following option is set for MySQL:
sql-mode = STRICT_ALL_TABLES

UP957L8F3

This is recommended in the Spryker Howto ;/

UP957L8F3

Oooohk, was a fault on my side. my MySQL did'nt read my config with this parameter

UP957L8F3

after setting this the Problem went away.

UP957L8F3

Many thanks 😄

Valerii Trots

👍