Fehler (500) beim News anlegen

**tblumrich** · 07.11.2022, 16:44

Hallo,

ich bekomme bei einer Installation einen 500er Fehler, wenn ich einen Newsbeitrag neu anlegen möchte.
Passender Eintrag in var/logs dazu:

Code:

[2022-11-07T17:36:12.503211+01:00] request.INFO: Matched route "contao_backend". {"route":"contao_backend","route_parameters":{"_route":"contao_backend","_scope":"backend","_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\BackendController::mainAction"},"request_uri":"https://www.goethegymnasium-demmin.de/contao?act=create&do=news&id=2&mode=2&pid=2&ref=EnUYJTJg&rt=dd2b3c5506.iYeXPEDWOx87w0Y8B5OMheG2ZzPC2S4tiryLH0_p7KE.5t7aCjqyVWdc8wBpUOq84pPaUEeSvmds_crDVn6GtM28_eYPFLBcVAKHLQ&table=tl_news","method":"GET"} []
[2022-11-07T17:36:12.529694+01:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'floating' at row 1" at /var/www/virtual/ggd/c413/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 117 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1406): An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'floating' at row 1 at /var/www/virtual/ggd/c413/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1406): SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'floating' at row 1 at /var/www/virtual/ggd/c413/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 22001): SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'floating' at row 1 at /var/www/virtual/ggd/c413/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134)"} []

Die Installation wurde gerade auf 4.13. (PHP 8) geupdatet und vorher ging das problemlos. Was auch geht, einen alten Beitrag duplizieren, bearbeiten, änderrn und speichern...

Wenen ichs richtig sehe, ist in irgendeiner DB-Spalte was zu lang... aber warum und wie kann ich das beheben?

**Spooky** · 07.11.2022, 16:48

Nutze den Debug-Modus und poste den Stack Trace.

**tblumrich** · 07.11.2022, 16:59

Wenn ich den Debug-Modus starte und dann nur auf Inhalte - Nachrichten klicke, lande auf der Server 500er Seite (passiert auch bei Inhalte - Events). Hoster ist Uberspace.

**tblumrich** · 09.11.2022, 09:29

Ich hab jetzt mal die Server Error Page deaktiviert.

StackTrace beim Aufruf des Menüpunktes Nachrichten:

Code:

ErrorException:
Warning: Undefined array key "TL_DCA"

  at vendor/fritzmg/contao-sharebuttons/system/modules/sharebuttons/dca/tl_news_archive.php:19
  at include('/var/www/virtual/ggd/c413/vendor/fritzmg/contao-sharebuttons/system/modules/sharebuttons/dca/tl_news_archive.php')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/DcaLoader.php:120)
  at Contao\DcaLoader->loadDcaFiles(false)
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/DcaLoader.php:75)
  at Contao\DcaLoader->load()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:1442)
  at Contao\Controller::loadDataContainer('tl_news_archive')
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:387)
  at Contao\Backend->getBackendModule('news', null)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

Stacktrace bei Events:

Code:

ErrorException:
Warning: Undefined array key "TL_DCA"

  at vendor/fritzmg/contao-sharebuttons/system/modules/sharebuttons/dca/tl_calendar.php:19
  at include('/var/www/virtual/ggd/c413/vendor/fritzmg/contao-sharebuttons/system/modules/sharebuttons/dca/tl_calendar.php')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/DcaLoader.php:120)
  at Contao\DcaLoader->loadDcaFiles(false)
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/DcaLoader.php:75)
  at Contao\DcaLoader->load()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:1442)
  at Contao\Controller::loadDataContainer('tl_calendar')
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:387)
  at Contao\Backend->getBackendModule('calendar', null)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

**Spooky** · 09.11.2022, 09:32

Welche Version von fritzmg/contao-sharebuttons hast du im Einsatz?

**tblumrich** · 09.11.2022, 10:09

Der Manager sagt 1.3.9

...die ist uralt, oder?

Meine composer.json:

Code:

{
    "name": "contao/managed-edition",
    "type": "project",
    "description": "Contao Open Source CMS",
    "license": "LGPL-3.0+",
    "authors": [{
        "name": "Leo Feyer",
        "homepage": "https://github.com/leofeyer"
    }],
    "require": {
        "codefog/contao-mobile_menu": "^2.6",
        "codefog/contao-news_categories": "^3.0",
        "contao/calendar-bundle": "4.13.*",
        "contao/comments-bundle": "4.13.*",
        "contao/conflicts": "*@dev",
        "contao/faq-bundle": "4.13.*",
        "contao/listing-bundle": "4.13.*",
        "contao/manager-bundle": "4.13.*",
        "contao/news-bundle": "4.13.*",
        "contao/newsletter-bundle": "4.13.*",
        "delahaye/dlh_googlemaps": "^2.3",
        "erdmannfreunde/euf_overlay": "^1.3",
        "fritzmg/contao-sharebuttons": "^1.3",
        "fritzmg/contao-swiper": "^1.0",
        "hofff/contao-calendarfield": "^3.0",
        "hypergalaktisch/contao-parallax": "^2.0",
        "inspiredminds/contao-glightbox": "^1.0",
        "inspiredminds/contao-wowjs": "^1.1",
        "jrgregory/m17-sticky-backend-footer": "^2.0",
        "ma3xl3/contao-easy-favicon": "^2.0",
        "madeyourday/contao-rocksolid-columns": "^2.0",
        "madeyourday/contao-rocksolid-slider": "^2.0",
        "netzmacht/contao-font-awesome-inserttag": "^2.2",
        "netzmacht/contao-leaflet-maps": "^3.2",
        "richardhj/contao-ajax_reload_element": "^2.1",
        "sioweb/linkedelement": "^0.8.6",
        "terminal42/contao-ajaxform": "^1.0",
        "terminal42/notification_center": "^1.4"
    },
    "conflict": {
        "contao/core-bundle": "<4.4.8"
    },
    "config": {
        "component-dir": "assets"
    },
    "scripts": {
        "post-install-cmd": [
            "@php vendor/bin/contao-setup"
        ],
        "post-update-cmd": [
            "@php vendor/bin/contao-setup"
        ]
    },
    "extra": {
        "public-dir": "web"
    }
}

**Spooky** · 09.11.2022, 10:43

Die neueste Version ist 2.2.3.

**tblumrich** · 09.11.2022, 11:59

Ich hab jetzt die Version umgestellt und der Manager hat mir die 2.2.3 aktualisiert. Lieder bleibt ein Fehler... Stacktraces (3) beim Anlegen einer neuen Nachricht:

1

Code:

PDOException:
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'floating' at row 1

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134
  at PDOStatement->execute(null)
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134)
  at Doctrine\DBAL\Driver\PDO\Statement->execute(null)
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute(null)
     (vendor/doctrine/dbal/src/Logging/Statement.php:98)
  at Doctrine\DBAL\Logging\Statement->execute(null)
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute(null)
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:65)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:1063)
  at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_news (`author`, `date`, `time`, `alt`, `size`, `fullsize`, `floating`, `pid`, `tstamp`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('1', 1667995040, 1667995040, 'Foto', 'a:3:{i:0;s:3:"250";i:1;s:0:"";i:2;s:12:"proportional";}', true, 'a:1:{i:0;s:5:"right";}', '2', 0), array())
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:284)
  at Contao\Database\Statement->query('', array('1', 1667995040, 1667995040, 'Foto', 'a:3:{i:0;s:3:"250";i:1;s:0:"";i:2;s:12:"proportional";}', true, 'a:1:{i:0;s:5:"right";}', '2', 0))
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:240)
  at Contao\Database\Statement->execute()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:630)
  at Contao\DC_Table->create()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:667)
  at Contao\Backend->getBackendModule('news', null)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

2

Code:

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'floating' at row 1

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136)
  at Doctrine\DBAL\Driver\PDO\Statement->execute(null)
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute(null)
     (vendor/doctrine/dbal/src/Logging/Statement.php:98)
  at Doctrine\DBAL\Logging\Statement->execute(null)
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute(null)
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:65)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:1063)
  at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_news (`author`, `date`, `time`, `alt`, `size`, `fullsize`, `floating`, `pid`, `tstamp`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('1', 1667995040, 1667995040, 'Foto', 'a:3:{i:0;s:3:"250";i:1;s:0:"";i:2;s:12:"proportional";}', true, 'a:1:{i:0;s:5:"right";}', '2', 0), array())
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:284)
  at Contao\Database\Statement->query('', array('1', 1667995040, 1667995040, 'Foto', 'a:3:{i:0;s:3:"250";i:1;s:0:"";i:2;s:12:"proportional";}', true, 'a:1:{i:0;s:5:"right";}', '2', 0))
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:240)
  at Contao\Database\Statement->execute()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:630)
  at Contao\DC_Table->create()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:667)
  at Contao\Backend->getBackendModule('news', null)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

3

Code:

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'floating' at row 1

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1908)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1851)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'INSERT INTO tl_news (`author`, `date`, `time`, `alt`, `size`, `fullsize`, `floating`, `pid`, `tstamp`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('1', 1667995040, 1667995040, 'Foto', 'a:3:{i:0;s:3:"250";i:1;s:0:"";i:2;s:12:"proportional";}', true, 'a:1:{i:0;s:5:"right";}', '2', 0), array())
     (vendor/doctrine/dbal/src/Connection.php:1070)
  at Doctrine\DBAL\Connection->executeQuery('INSERT INTO tl_news (`author`, `date`, `time`, `alt`, `size`, `fullsize`, `floating`, `pid`, `tstamp`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('1', 1667995040, 1667995040, 'Foto', 'a:3:{i:0;s:3:"250";i:1;s:0:"";i:2;s:12:"proportional";}', true, 'a:1:{i:0;s:5:"right";}', '2', 0), array())
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:284)
  at Contao\Database\Statement->query('', array('1', 1667995040, 1667995040, 'Foto', 'a:3:{i:0;s:3:"250";i:1;s:0:"";i:2;s:12:"proportional";}', true, 'a:1:{i:0;s:5:"right";}', '2', 0))
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:240)
  at Contao\Database\Statement->execute()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:630)
  at Contao\DC_Table->create()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:667)
  at Contao\Backend->getBackendModule('news', null)
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

**Spooky** · 09.11.2022, 12:01

Du scheinst eine DCA Anpassung oder Extension für tl_news zu haben, die das Feld "floating" ändert (in einer falschen Art und Weise).

**tblumrich** · 09.11.2022, 12:09

Ahhhh - Ja, ich hab beim Updaten eine dcaconfig.php mitgenommen:

Code:

<?php
// Put your custom configuration here

$GLOBALS['TL_DCA']['tl_news']['fields']['alt']['default'] = 'Foto'; # Alternativer Text bei Bildern
$GLOBALS['TL_DCA']['tl_news']['fields']['size']['default'] = array(0=>'250',1=>'',2=>'proportional'); # Bildbreite
$GLOBALS['TL_DCA']['tl_news']['fields']['fullsize']['default'] = true; # Großansicht/Neues Fenster
$GLOBALS['TL_DCA']['tl_news']['fields']['floating']['default'] = array('right'); # Bildausrichtung

$GLOBALS['TL_DCA']['tl_content']['fields']['size']['default'] = array(0=>'400',1=>'',2=>'proportional'); # Bildbreite
$GLOBALS['TL_DCA']['tl_content']['fields']['fullsize']['default'] = true; # Großansicht/Neues Fenster
$GLOBALS['TL_DCA']['tl_content']['fields']['perRow']['default'] = 12;

Ich versuche das mal zu reparieren

**Spooky** · 09.11.2022, 12:13

Du musst

PHP-Code:


$GLOBALS['TL_DCA']['tl_news']['fields']['floating']['default'] = array('right'); # Bildausrichtung

auf

PHP-Code:


$GLOBALS['TL_DCA']['tl_news']['fields']['floating']['default'] = 'right'; # Bildausrichtung

oder

PHP-Code:


$GLOBALS['TL_DCA']['tl_news']['fields']['floating']['sql'] = ['type' => 'string', 'length' => 12, 'default' => 'right']; # Bildausrichtung

ändern.

**tblumrich** · 09.11.2022, 13:10

Perfekt - Danke!

Thema: Fehler (500) beim News anlegen

Themen-Optionen

Thema durchsuchen

Fehler (500) beim News anlegen

Aktive Benutzer

Aktive Benutzer

Lesezeichen

Lesezeichen

Berechtigungen

Contao

Empfohlene Webdesign-Bücher