Dateiverwaltung - Knoten lassen sich nicht öffnen

**MarkIII** · 30.10.2023, 17:03

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.

**MarkIII** · 31.10.2023, 07:16

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

**MarkIII** · 31.10.2023, 07:32

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)"} []

**Spooky** · 31.10.2023, 07:47

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

**MarkIII** · 31.10.2023, 07:54

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 von Spooky

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

Nein, zwischen 1 und 6 .jpg

**Spooky** · 31.10.2023, 07:58

Poste die genaue Contao Version und deine composer.json

**MarkIII** · 31.10.2023, 08:19

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"
}

**Spooky** · 31.10.2023, 08:20

Das ist die composer.json von symfony/config, nicht die composer.json deiner Contao Installation

**MarkIII** · 31.10.2023, 08:28

OMG

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.

**Spooky** · 31.10.2023, 08:38

Deinstalliere marcel-mathias-nolte/contao-filesmanager-fileusage

**MarkIII** · 31.10.2023, 08:55

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

Jetzt funktioniert es wieder!

**MarkIII** · 31.10.2023, 09:00

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

**Spooky** · 31.10.2023, 09:05

Nein, die Erweiterung verursacht einfach diese hohe Last, völlig unabhängig vom Rest.

**MarkIII** · 31.10.2023, 09:17

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

**Spooky** · 31.10.2023, 09:37

Ich kenne die Erweiterung und weiß, dass dein Symptom höchstwahrscheinlich von dieser Erweiterung kommt, ja

**MarkIII** · 31.10.2023, 09:39

OK, alles klar! Vielen Dank nochmal!

**Spooky** · 31.10.2023, 09:43

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.