Dateiverwaltung - Knoten lassen sich nicht öffnen

Druckbare Version

30.10.2023, 17:03
MarkIII

Dateiverwaltung - Knoten lassen sich nicht öffnen

Seit der Installation und anschließender De-Installation der "ivoschimani/loadscripts"-Erweiterung ließ sich die Dateiverwaltung nicht mehr öffnen, Internal Server Error 500.

Nach Löschen der Sessiondaten und des Bildercaches im Benutzerprofil kann ich die Dateiverwaltung zwar wieder aufrufen, jedoch lassen sich die Knoten nur noch auf Ordnerebene öffnen. Sobald es an die Dateien geht läuft sich die Seite tot. Es hilft nur ein Neuladen.
Auch aus der Artikelverwaltung und aus dem Frontendhelper heraus funktioniert es nicht mehr.

Mittlerweile ist der prod-xxxx-xx-xx.log auf die Größe von über 160 MB angewachsen.

Beispieleinträge:

Code:

[2023-10-30T12:30:45.454586+01:00] php.INFO: User Deprecated: Since contao/core-bundle 4.13: Using "Contao\Controller::replaceInsertTags()" has been deprecated and will no longer work in Contao 5.0. Use the InsertTagParser service instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since contao/core-bundle 4.13: Using "Contao\\Controller::replaceInsertTags()" has been deprecated and will no longer work in Contao 5.0. Use the InsertTagParser service instead. at /homepages/35/d36705907/htdocs/contao-test/vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:843)"} [] [2023-10-30T12:30:45.454621+01:00] php.INFO: User Deprecated: Since contao/core-bundle 4.13: Using "Contao\Controller::replaceInsertTags()" has been deprecated and will no longer work in Contao 5.0. Use the InsertTagParser service instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since contao/core-bundle 4.13: Using "Contao\\Controller::replaceInsertTags()" has been deprecated and will no longer work in Contao 5.0. Use the InsertTagParser service instead. at /homepages/35/d36705907/htdocs/contao-test/vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:843)"} [] [2023-10-30T12:30:45.454657+01:00] php.INFO: User Deprecated: Since contao/core-bundle 4.13: Using "Contao\Controller::replaceInsertTags()" has been deprecated and will no longer work in Contao 5.0. Use the InsertTagParser service instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since contao/core-bundle 4.13: Using "Contao\\Controller::replaceInsertTags()" has been deprecated and will no longer work in Contao 5.0. Use the InsertTagParser service instead. at /homepages/35/d36705907/htdocs/contao-test/vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:843)"} [] [2023-10-30T12:30:45.455983+01:00] php.INFO: User Deprecated: Since contao/core-bundle 4.13: Using "Contao\Controller::replaceInsertTags()" has been deprecated and will no longer work in Contao 5.0. Use the InsertTagParser service instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since contao/core-bundle 4.13: Using "Contao\\Controller::replaceInsertTags()" has been deprecated and will no longer work in Contao 5.0. Use the InsertTagParser service instead. at /homepages/35/d36705907/htdocs/contao-test/vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:843)"} [] ..... [2023-10-30T16:52:10.588733+01:00] php.INFO: User Deprecated: Since symfony/http-foundation 5.1: Retrieving a non-scalar value from "Symfony\Component\HttpFoundation\InputBag::get()" is deprecated, and will throw a "Symfony\Component\HttpFoundation\Exception\BadRequestException" exception in Symfony 6.0, use "Symfony\Component\HttpFoundation\InputBag::all($key)" instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since symfony/http-foundation 5.1: Retrieving a non-scalar value from \"Symfony\\Component\\HttpFoundation\\InputBag::get()\" is deprecated, and will throw a \"Symfony\\Component\\HttpFoundation\\Exception\\BadRequestException\" exception in Symfony 6.0, use \"Symfony\\Component\\HttpFoundation\\InputBag::all($key)\" instead. at /homepages/35/d36705907/htdocs/contao-test/vendor/symfony/http-foundation/InputBag.php:39)"} [] [2023-10-30T16:52:10.624630+01:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'cssID' at row 442" at /homepages/35/d36705907/htdocs/contao-test/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 117 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1265): An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'cssID' at row 442 at /homepages/35/d36705907/htdocs/contao-test/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1265): SQLSTATE[01000]: Warning: 1265 Data truncated for column 'cssID' at row 442 at /homepages/35/d36705907/htdocs/contao-test/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 01000): SQLSTATE[01000]: Warning: 1265 Data truncated for column 'cssID' at row 442 at /homepages/35/d36705907/htdocs/contao-test/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:33)"} [] [2023-10-30T16:52:10.631079+01:00] php.INFO: User Deprecated: Class "Nyholm\Psr7\Factory\HttplugFactory" is deprecated since version 1.8, use "Nyholm\Psr7\Factory\Psr17Factory" instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Class \"Nyholm\\Psr7\\Factory\\HttplugFactory\" is deprecated since version 1.8, use \"Nyholm\\Psr7\\Factory\\Psr17Factory\" instead. at /homepages/35/d36705907/htdocs/contao-test/vendor/nyholm/psr7/src/Factory/HttplugFactory.php:18)"} [] [2023-10-30T16:52:10.631997+01:00] php.INFO: User Deprecated: Since symfony/security-core 5.4: Passing the access decision strategy as a string is deprecated, pass an instance of "Symfony\Component\Security\Core\Authorization\Strategy\AccessDecisionStrategyInterface" instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since symfony/security-core 5.4: Passing the access decision strategy as a string is deprecated, pass an instance of \"Symfony\\Component\\Security\\Core\\Authorization\\Strategy\\AccessDecisionStrategyInterface\" instead. at /homepages/35/d36705907/htdocs/contao-test/vendor/symfony/security-core/Authorization/AccessDecisionManager.php:75)"} []

Auch das Einspielen eines Datenbankbackups hat nichts gebracht.
31.10.2023, 07:16
MarkIII

Könnte es mit dem gleichzeitig erfolgten Symfony Update zusammenhängen?

Code:

$ /usr/bin/php8.1-cli -q -dmax_execution_time=0 -dmemory_limit=-1 -ddisplay_errors=0 -ddisplay_startup_errors=0 -derror_reporting=0 -dallow_url_fopen=1 -ddisable_functions= -ddate.timezone=Europe/Berlin /homepages/35/d36705907/htdocs/contao-test/public/contao-manager.phar.php composer require ivoschimani/loadscripts --no-update --no-scripts --prefer-stable --sort-packages --no-ansi --no-interaction # Process terminated with exit code 0 # Result: OK > Resolving dependencies using Composer Cloud v3.6.0-1-g9d9036c [7.6MiB/0.20s] Loading composer repositories with package information [68.7MiB/8.55s] Updating dependencies [29.3MiB/8.82s] Lock file operations: 1 install, 13 updates, 0 removals [29.3MiB/8.82s] - Locking ivoschimani/loadscripts (v0.1.9) [29.3MiB/8.83s] - Upgrading nette/utils (v4.0.2 => v4.0.3) [29.3MiB/8.83s] - Upgrading symfony/cache (v5.4.29 => v5.4.30) [29.3MiB/8.83s] - Upgrading symfony/doctrine-bridge (v5.4.28 => v5.4.30) [29.3MiB/8.83s] - Upgrading symfony/framework-bundle (v5.4.29 => v5.4.30) [29.3MiB/8.83s] - Upgrading symfony/http-foundation (v5.4.28 => v5.4.30) [29.3MiB/8.83s] - Upgrading symfony/http-kernel (v5.4.29 => v5.4.30) [29.3MiB/8.83s] - Upgrading symfony/intl (v5.4.26 => v5.4.30) [29.3MiB/8.83s] - Upgrading symfony/lock (v5.4.25 => v5.4.30) [29.3MiB/8.84s] - Upgrading symfony/security-bundle (v5.4.29 => v5.4.30) [29.3MiB/8.84s] - Upgrading symfony/security-core (v5.4.29 => v5.4.30) [29.3MiB/8.84s] - Upgrading symfony/security-http (v5.4.28 => v5.4.30) [29.3MiB/8.84s] - Upgrading symfony/translation (v5.4.24 => v5.4.30) [29.3MiB/8.84s] - Upgrading symfony/yaml (v5.4.23 => v5.4.30) [28.5MiB/8.85s] Writing lock file [14.3MiB/8.88s] <warning>Package php-http/message-factory is abandoned, you should avoid using it. Use psr/http-factory instead.</warning> [14.6MiB/9.29s] No security vulnerability advisories found [15.2MiB/9.31s] Memory usage: 15.2MB (peak: 195.86MB), time: 9.33s. [15.2MiB/9.32s] Finished Composer Cloud resolving. # Job ID J0WLDSTFRmb5N1rpNc3puInEPoQu0iJH5iVjOv2t9gGmAk8wm34dJr87yDC6fH3jIEHG3mSydfrx8BCSl6bySCV completed in 14 seconds # Memory usage: 15.2MB (peak: 195.86MB), time: 9.33s. $ /usr/bin/php8.1-cli -q -dmax_execution_time=0 -dmemory_limit=-1 -ddisplay_errors=0 -ddisplay_startup_errors=0 -derror_reporting=0 -dallow_url_fopen=1 -ddisable_functions= -ddate.timezone=Europe/Berlin /homepages/35/d36705907/htdocs/contao-test/public/contao-manager.phar.php composer install --no-dev --no-progress --no-ansi --no-interaction --optimize-autoloader # Process terminated with exit code 0 # Result: OK

Das Update erfolgte um 11:31 Uhr, die Fehler im prod-log gehen um 11:35 Uhr los
31.10.2023, 07:32
MarkIII

Hat das was mit dem php Memory Limit zu tun oder ist das auch ein Fehler von Symfony?

Code:

[2023-10-30T11:54:32.924626+01:00] php.CRITICAL: Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) {"exception":"[object] (Symfony\\Component\\ErrorHandler\\Error\\OutOfMemoryError(code: 0): Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) at /homepages/35/d36705907/htdocs/contao-test/vendor/symfony/error-handler/ErrorHandler.php:781)"} [] [2023-10-30T11:54:33.061937+01:00] request.CRITICAL: Uncaught PHP Exception Symfony\Component\ErrorHandler\Error\OutOfMemoryError: "Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes)" at /homepages/35/d36705907/htdocs/contao-test/vendor/symfony/error-handler/ErrorHandler.php line 781 {"exception":"[object] (Symfony\\Component\\ErrorHandler\\Error\\OutOfMemoryError(code: 0): Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) at /homepages/35/d36705907/htdocs/contao-test/vendor/symfony/error-handler/ErrorHandler.php:781)"} []
31.10.2023, 07:47
Spooky

Befinden sich sehr viele Dateien in den Ordnern, die du öffnen willst?
31.10.2023, 07:54
MarkIII

Nachdem Heraufsetzen des PHP-Memory-Limits auf 512MB kann ich den Prozess der Dateiverwaltung noch nicht einmal mit einem Neuladen des Browserfensters unterbrechen.

Der aktuelle prod-log hat eine Größe von über 220 MB.

Code:

[2023-10-31T08:41:17.321466+01:00] php.INFO: User Deprecated: Since contao/core-bundle 4.13: Using "Contao\Controller::replaceInsertTags()" has been deprecated and will no longer work in Contao 5.0. Use the InsertTagParser service instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since contao/core-bundle 4.13: Using \"Contao\\Controller::replaceInsertTags()\" has been deprecated and will no longer work in Contao 5.0. Use the InsertTagParser service instead. at /homepages/35/d36705907/htdocs/contao-test/vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:843)"} [] [2023-10-31T08:41:17.321491+01:00] php.INFO: User Deprecated: Since contao/core-bundle 4.13: Using "Contao\Controller::replaceInsertTags()" has been deprecated and will no longer work in Contao 5.0. Use the InsertTagParser service instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since contao/core-bundle 4.13: Using \"Contao\\Controller::replaceInsertTags()\" has been deprecated and will no longer work in Contao 5.0. Use the InsertTagParser service instead. at /homepages/35/d36705907/htdocs/contao-test/vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:843)"} [] [2023-10-31T08:41:17.359387+01:00] php.CRITICAL: Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) {"exception":"[object] (Symfony\\Component\\ErrorHandler\\Error\\OutOfMemoryError(code: 0): Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /homepages/35/d36705907/htdocs/contao-test/vendor/symfony/error-handler/ErrorHandler.php:767)"} [] [2023-10-31T08:41:18.417105+01:00] request.CRITICAL: Uncaught PHP Exception Symfony\Component\ErrorHandler\Error\OutOfMemoryError: "Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes)" at /homepages/35/d36705907/htdocs/contao-test/vendor/symfony/error-handler/ErrorHandler.php line 767 {"exception":"[object] (Symfony\\Component\\ErrorHandler\\Error\\OutOfMemoryError(code: 0): Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) at /homepages/35/d36705907/htdocs/contao-test/vendor/symfony/error-handler/ErrorHandler.php:767)"} [] [2023-10-31T08:41:26.301554+01:00] php.INFO: User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.native" service is deprecated, use "session.storage.factory.native" instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since symfony/framework-bundle 5.3: The \"session.storage.native\" service is deprecated, use \"session.storage.factory.native\" instead. at /homepages/35/d36705907/htdocs/contao-test/var/cache/prod/ContainerJy507Ly/getSession_Storage_NativeService.php:22)"} [] [2023-10-31T08:41:26.303236+01:00] php.INFO: User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.metadata_bag" service is deprecated, create your own "session.storage.factory" instead. {"exception":"[object] (ErrorException(code: 0): User Deprecated: Since symfony/framework-bundle 5.3: The \"session.storage.metadata_bag\" service is deprecated, create your own \"session.storage.factory\" instead. at /homepages/35/d36705907/htdocs/contao-test/var/cache/prod/ContainerJy507Ly/getSession_Storage_MetadataBagService.php:22)"} [] [2023-10-31T08:41:26.303368+01:00] php.WARNING: Runtime Notice: date_default_timezone_get(): We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead {"exception":"[object] (ErrorException(code: 0): Runtime Notice: date_default_timezone_get(): We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead at /homepages/35/d36705907/htdocs/contao-test/vendor/monolog/monolog/src/Monolog/Logger.php:196)"} []

Hilfe mittlerweile verzweifelt gesucht

- - - Aktualisiert - - -

Zitat:

Zitat von Spooky

Befinden sich sehr viele Dateien in den Ordnern, die du öffnen willst?

Nein, zwischen 1 und 6 .jpg
31.10.2023, 07:58
Spooky

Poste die genaue Contao Version und deine composer.json
31.10.2023, 08:19
MarkIII

Version 4.13.32

composer.json

Code:

{ "name": "symfony/config", "type": "library", "description": "Helps you find, load, combine, autofill and validate configuration values of any kind", "keywords": [], "homepage": "https://symfony.com", "license": "MIT", "authors": [ { "name": "Fabien Potencier", "email": "fabien@symfony.com" }, { "name": "Symfony Community", "homepage": "https://symfony.com/contributors" } ], "require": { "php": ">=7.2.5", "symfony/deprecation-contracts": "^2.1|^3", "symfony/filesystem": "^4.4|^5.0|^6.0", "symfony/polyfill-ctype": "~1.8", "symfony/polyfill-php80": "^1.16", "symfony/polyfill-php81": "^1.22" }, "require-dev": { "symfony/event-dispatcher": "^4.4|^5.0|^6.0", "symfony/finder": "^4.4|^5.0|^6.0", "symfony/messenger": "^4.4|^5.0|^6.0", "symfony/service-contracts": "^1.1|^2|^3", "symfony/yaml": "^4.4|^5.0|^6.0" }, "conflict": { "symfony/finder": "<4.4" }, "suggest": { "symfony/yaml": "To use the yaml reference dumper" }, "autoload": { "psr-4": { "Symfony\\Component\\Config\\": "" }, "exclude-from-classmap": [ "/Tests/" ] }, "minimum-stability": "dev" }
31.10.2023, 08:20
Spooky

Das ist die composer.json von symfony/config, nicht die composer.json deiner Contao Installation ;)
31.10.2023, 08:28
MarkIII

OMG :o

Code:

{ "type": "project", "require": { "christianbarkowsky/contao-tiny-compress-images": "^2.2", "codefog/contao-social_images": "^4.1", "con4gis/maps": "^8.2", "contao-themes-net/mate-theme-bundle": "^2.20", "contao/conflicts": "*@dev", "contao/listing-bundle": "4.13.*", "contao/manager-bundle": "4.13.*", "dklemmt/contao_dk_masonry": "dev-master", "do-while/contao-backupdb-bundle": "^1.5", "fast-media/contao-redirection": "4.9.0", "fritzmg/contao-sharebuttons": "^2.2", "inspiredminds/contao-glightbox": "^1.0", "inspiredminds/contao-mailer-command": "^1.0", "jonnysp/pannorama": "^0.4.1", "madeyourday/contao-rocksolid-antispam": "^2.1", "madeyourday/contao-rocksolid-frontend-helper": "^2.2", "marcel-mathias-nolte/contao-filesmanager-fileusage": "^1.0", "mediamotionag/contao-backend-optim-bundle": "^2.0", "numero2/contao-marketing-suite": "^2.0", "numero2/contao-random-ce": "^2.0", "oveleon/contao-company-bundle": "^1.3", "oveleon/contao-cookiebar": "^1.13", "oveleon/contao-google-recommendation-bundle": "^1.2", "oveleon/contao-recommendation-bundle": "^1.2", "srhinow/tinymce-plugins": "^2.0", "terminal42/contao-ajaxform": "^1.3", "terminal42/contao-easy_themes": "^3.1", "terminal42/notification_center": "^1.7", "trilobit-gmbh/contao-tiles-bundle": "^2.0" }, "extra": { "public-dir": "public", "contao-component-dir": "assets" }, "scripts": { "post-install-cmd": [ "@php vendor/bin/contao-setup" ], "post-update-cmd": [ "@php vendor/bin/contao-setup" ] } }

Ich hoffe, das ist jetzt die richtige. Aus dem Wurzelverzeichnis.
31.10.2023, 08:38
Spooky

Deinstalliere marcel-mathias-nolte/contao-filesmanager-fileusage
31.10.2023, 08:55
MarkIII

Wow, Spooky! Vielen, vielen Dank!
Da wäre ich selbst ja niemals drauf gekommen.

Jetzt funktioniert es wieder!
31.10.2023, 09:00
MarkIII

Verstehe ich es richtig, dass das Update von Symfony mit der "Fileusage"-Erweiterung in Konflikt stand?
31.10.2023, 09:05
Spooky

Nein, die Erweiterung verursacht einfach diese hohe Last, völlig unabhängig vom Rest.
31.10.2023, 09:17
MarkIII

Aha, ok. Und das hast Du jetzt aus meinen Angaben heraus gelesen oder ist das ein bekanntes Problem der Erweiterung?
31.10.2023, 09:37
Spooky

Ich kenne die Erweiterung und weiß, dass dein Symptom höchstwahrscheinlich von dieser Erweiterung kommt, ja :)
31.10.2023, 09:39
MarkIII

OK, alles klar! Vielen Dank nochmal!
31.10.2023, 09:43
Spooky

Für die Zukunft: wenn du irgendwelche Probleme hast könntest du in Eigenregie auch versuchen die Extensions zu deinstallieren, die möglicherweise etwas damit zu tun haben. In deinem Fall hattest du Probleme mit der Dateiverwaltung, also könntest du nach der Reihe die Extensions installieren, die potentiell etwas mit der Dateiverwaltung zu tun haben.
31.10.2023, 10:37
MarkIII

OK, dann ohne die entsprechenden Tabellen zu löschen, für den Fall, dass die Erweiterung doch nicht die Ursache für das Problem war?
31.10.2023, 10:42
mlweb

ja