Forum rules
RUNALYZE started as one-man-project with only one user and has grown to an app with around 13.000 users of our official online version. Server requirements and complexity of the app and its configuration grow with the feature list. Please understand that our main focus is on implementing new features and serving a performant online version. Therefore, support for local installations is limited and we cannot guarantee any support.

Please always provide log files (and screenshots, activity files if it makes sense) and all other needed information: https://docs.runalyze.com/en/latest/support.html

We spend our leisure time to make RUNALYZE as good as possible and we still have tons of great ideas, but time is scarce and after a hard training we first need some fruits or a smoothie. You can support the development of RUNALYZE with every financial contribution — We highly appreciate every grant.
https://blog.runalyze.com/donate/
ingmaroost
Neuling
Posts: 2
Joined: Sat 4. Mar 2017, 11:39

PDOException: "SQLSTATE[42000]: Syntax error

Sun 5. Mar 2017, 20:37

Hi guys,

I have been struggling to install version 3.2.0 on my ubuntu server. The installation has been successfully completed and a user is created. However; when I log in the dashboard screen is loaded but immediately greyed out and the setting buttons in the top bar are not available. If I press F5, I shortly see the icons for the settings, tools and help which can be clicked if I move quickly but after a second the complete dashboard is greyed out again.

Feel free to have a look for yourself at http://koningoost.nl:84
username: test
password: testtest

When I check the /var/log/syslog I see this error:

Mar 5 19:04:07 runalyze [9273]: request.CRITICAL: Uncaught PHP Exception PDOException: "SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'runalyze.t.time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by" at /var/www/runalyze-v3.2.0/inc/system/class.PDOforRunalyze.php line 271 {"exception":"[object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'runalyze.t.time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /var/www/runalyze-v3.2.0/inc/system/class.PDOforRunalyze.php:271)"} []

I have troubleshooted as far as I could but got stuck here. Can you please check it out and let me know what I have done wrong?

Much appreciated,
Ingmar Oost
0 x

User avatar
mipapo
Administrator
Posts: 1320
Joined: Mon 29. Jul 2013, 20:26
Location: Kiel
Contact: Website Facebook Twitter

Re: PDOException: "SQLSTATE[42000]: Syntax error

Sun 5. Mar 2017, 20:38

See https://docs.runalyze.com/en/latest/faq ... by-problem
So you would need to change your mysql configuration.
0 x
###Donate to RUNALYZE###
Höhenmeter (Korrektur & Berechnung) - Nutzerhilfe/User help -

Run Happy!,
Michael
P.S. Ich antworte gerne kurz und knackig ;)
Image

ingmaroost
Neuling
Posts: 2
Joined: Sat 4. Mar 2017, 11:39

Re: PDOException: "SQLSTATE[42000]: Syntax error

Tue 7. Mar 2017, 11:36

Ow wow, I cannot believe I missed that topic in the FAQ. Sorry for that.
I will have a go at it tonight and let you know the result.

Thanks for the quick, and helpful, reply.
0 x

Return to “Runalyze v3.2.x”

Who is online

Users browsing this forum: No registered users and 1 guest