Forum rules
RUNALYZE started as one-man-project with only one user and has grown to an app with around 15.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/
chpusch
Neuling
Posts: 15
Joined: Sun 28. Feb 2016, 18:28
Contact: Website Twitter

ANOVA, Poster Tool mit ERROR 500

Sat 20. May 2017, 19:38

Hallo,

ich bekomme aktuell einen ERROR 500 beim Poster Tool und ANOVA mit der Version 4.1.
Bei beidem sind die Fehlermeldungen in den Log-Files 1zu1 identisch.

Habe ich irgendetwas übersehen?

Code: Select all

===== 3 ERROR MESSAGES: ===== === Unknown error type: Not quoting the scalar "%kernel.root_dir%/" starting with the "%" indicator character is deprecated since Symfony 3.1 and will throw a ParseException in 4.0. (in /var/www/runalyze/vendor/symfony/symfony/src/Symfony/Component/Yaml/Inline.php::325) === Unknown error type: Not quoting the scalar "%kernel.root_dir%/../src" starting with the "%" indicator character is deprecated since Symfony 3.1 and will throw a ParseException in 4.0. (in /var/www/runalyze/vendor/symfony/symfony/src/Symfony/Component/Yaml/Inline.php::325) === Unknown error type: Not quoting the scalar "%kernel.root_dir%/Resources/translations" starting with the "%" indicator character is deprecated since Symfony 3.1 and will throw a ParseException in 4.0. (in /var/www/runalyze/vendor/symfony/symfony/src/Symfony/Component/Yaml/Inline.php::325)

Viele Grüße,
Christian
0 x

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

Re: ANOVA, Poster Tool mit ERROR 500

Sat 20. May 2017, 19:57

Nutzt du PHP 7.1? Das wäre nicht unterstützt
0 x

chpusch
Neuling
Posts: 15
Joined: Sun 28. Feb 2016, 18:28
Contact: Website Twitter

Re: ANOVA, Poster Tool mit ERROR 500

Sat 20. May 2017, 20:09

Ich habe die Version 7.0

Code: Select all

php -v
PHP 7.0.15-0ubuntu0.16.04.4 (cli) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies
    with Zend OPcache v7.0.15-0ubuntu0.16.04.4, Copyright (c) 1999-2017, by Zend Technologies
0 x

User avatar
laufhannes
Core developer
Posts: 737
Joined: Mon 29. Jul 2013, 20:59

Re: ANOVA, Poster Tool mit ERROR 500

Sat 20. May 2017, 23:07

Sind das die Logs aus var/logs/...? Das schaut mir eher nach data/log/... aus.
0 x
User help -- short questions via Twitter, Facebook

chpusch
Neuling
Posts: 15
Joined: Sun 28. Feb 2016, 18:28
Contact: Website Twitter

Re: ANOVA, Poster Tool mit ERROR 500

Sun 21. May 2017, 14:09

stimmt.

Aus symfony.log kommt folgende Meldung:

Code: Select all

[2017-05-21 12:05:22] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.short AS short_4, t0.kcal AS kcal_5, t0.HFavg AS HFavg_6, t0.distances AS distances_7, t0.speed AS speed_8, t0.power AS power_9, t0.outside AS outside_10, t0.is_main AS is_main_11, t0.internal_sport_id AS internal_sport_id_12, t0.main_equipmenttypeid AS main_equipmenttypeid_13, t0.default_typeid AS default_typeid_14, t0.accountid AS accountid_15 FROM runalyze1_sport t0 WHERE t0.accountid = ? AND t0.distances = ?' with params [1, 1]:  SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.is_main' in 'field list'" at /var/www/christianpusch.de/runalyze/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.short AS short_4, t0.kcal AS kcal_5, t0.HFavg AS HFavg_6, t0.distances AS distances_7, t0.speed AS speed_8, t0.power AS power_9, t0.outside AS outside_10, t0.is_main AS is_main_11, t0.internal_sport_id AS internal_sport_id_12, t0.main_equipmenttypeid AS main_equipmenttypeid_13, t0.default_typeid AS default_typeid_14, t0.accountid AS accountid_15 FROM runalyze1_sport t0 WHERE t0.accountid = ? AND t0.distances = ?' with params [1, 1]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.is_main' in 'field list' at /var/www/christianpusch.de/runalyze/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.is_main' in 'field list' at /var/www/christianpusch.de/runalyze/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.is_main' in 'field list' at /var/www/christianpusch.de/runalyze/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []

Hilft das etwas? Ich wer nicht schlau daraus. Leider.
0 x

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

Re: ANOVA, Poster Tool mit ERROR 500

Sun 21. May 2017, 16:51

Es fehlen Felder wie "is_main" die in der Version 4.1 hinzugekommen sind. Update durchgeführt?
0 x

chpusch
Neuling
Posts: 15
Joined: Sun 28. Feb 2016, 18:28
Contact: Website Twitter

Re: ANOVA, Poster Tool mit ERROR 500

Sun 21. May 2017, 18:07

Vielen Dank. Das Update lief nicht komplett durch.

Ich habe herausgefunden, dass es ein Problem bei der Migration mit der Zuordnung der Tables gab.

Meine mysql Tables haben alle runalyze1_ und dies hat bei einem Schritt der Migration zu einem Fehler geführt. Nach Umbenennung aller Tables zu runalyze_ hat das Update geklappt.

Vielen Dank und viele Grüße,
Christian
0 x

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

Re: ANOVA, Poster Tool mit ERROR 500

Sun 21. May 2017, 18:28

Stimmt, der Fix ist zwar schon drin, aber ich schaffe es zeitlich nicht da ein passendes Paket zur Verfügung zu stellen.
0 x

chpusch
Neuling
Posts: 15
Joined: Sun 28. Feb 2016, 18:28
Contact: Website Twitter

Re: ANOVA, Poster Tool mit ERROR 500

Sun 21. May 2017, 22:16

Ich finde es sowieso beeindruckend, was ihr hier für eine super Software kostenfrei zur Verfügung stellt und dann auch noch versucht zu helfen. Vielen Dank!

Ich werde mal schauen, ob ich noch bei einem weiteren Thema helfen kann.

Viele Grüße, Christian
0 x

Return to “Runalyze v4.1.x”

Who is online

Users browsing this forum: No registered users and 1 guest