newsletter_recipients nicht erreichbar nach update auf 4.9

Hallo,

nach einem update von 4.4 auf 4.9 kann ich die Newsletter Emfänger nicht mehr aufrufen.
Im Debugmodus ist diese Fehlermeldung zu finden.

Code:

---

An exception occurred while executing 'SELECT * FROM tl_newsletter_recipients WHERE pid='1' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER('kuec') ORDER BY confirmed DESC, email LIMIT 0,30':
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause'

---

Das ist das Log:

Code:

---

Kernel->handle(object(Request))
in web/index.php (line 31)
$loader = require __DIR__.'/../vendor/autoload.php';$request = Request::createFromGlobals();$kernel = ContaoKernel::fromRequest(\dirname(__DIR__), $request);$response = $kernel->handle($request);$response->send();if ($kernel instanceof TerminableInterface) {    $kernel->terminate($request, $response);}

---

Ich komme da nicht weiter, was könnte das sein?

Eine Extension die mit Contao 4.4 funktionierte, aber mit 4.9 nicht mehr?
Eine zerschossenen Tabele? Das update der Datenfelder hat mehrfach beim Server eine timeout erzeugt.

Fragt dtptiger, und bleibt Gesund!

Benutze den Debug-Modus und poste den Stack Trace.

Danke!

Stack Traces: 3

Code:

---

[3/3] InvalidFieldNameException
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing 'SELECT * FROM tl_newsletter_recipients WHERE pid='1' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER('kuec') ORDER BY confirmed DESC, email LIMIT 0,30':

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60
  at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30\':SQLSTATE[42S22]: Column not found: 1054 Unknown column \'confirmed\' in \'order clause\'', object(PDOException))
    (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:169)
  at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred while executing \'SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30\':SQLSTATE[42S22]: Column not found: 1054 Unknown column \'confirmed\' in \'order clause\'')
    (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:149)
  at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30', array())
    (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:914)
  at Doctrine\DBAL\Connection->executeQuery('SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30')
    (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274)
  at Contao\Database\Statement->query()
    (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248)
  at Contao\Database\Statement->execute(array('1', 'kuec'))
    (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:4424)
  at Contao\DC_Table->parentView()
    (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:364)
  at Contao\DC_Table->showAll()
    (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644)
  at Contao\Backend->getBackendModule('newsletter', null)
    (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167)
  at Contao\BackendMain->run()
    (vendor/contao/core-bundle/src/Controller/BackendController.php:48)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
    (vendor/symfony/http-kernel/HttpKernel.php:158)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
    (vendor/symfony/http-kernel/HttpKernel.php:80)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
    (vendor/symfony/http-kernel/Kernel.php:201)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
    (web/index.php:31)
  at require('/var/customers/webs/weller/brauerei-weller.de/web/index.php')
    (web/app.php:4)
[2/3] PDOException
Doctrine\DBAL\Driver\PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83
  at Doctrine\DBAL\Driver\PDOConnection->query('SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30')
    (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:911)
  at Doctrine\DBAL\Connection->executeQuery('SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30')
    (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274)
  at Contao\Database\Statement->query()
    (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248)
  at Contao\Database\Statement->execute(array('1', 'kuec'))
    (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:4424)
  at Contao\DC_Table->parentView()
    (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:364)
  at Contao\DC_Table->showAll()
    (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644)
  at Contao\Backend->getBackendModule('newsletter', null)
    (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167)
  at Contao\BackendMain->run()
    (vendor/contao/core-bundle/src/Controller/BackendController.php:48)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
    (vendor/symfony/http-kernel/HttpKernel.php:158)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
    (vendor/symfony/http-kernel/HttpKernel.php:80)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
    (vendor/symfony/http-kernel/Kernel.php:201)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
    (web/index.php:31)
  at require('/var/customers/webs/weller/brauerei-weller.de/web/index.php')
    (web/app.php:4)
[1/3] PDOException
PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
  at PDO->query('SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30')
    (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)
  at Doctrine\DBAL\Driver\PDOConnection->query('SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30')
    (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:911)
  at Doctrine\DBAL\Connection->executeQuery('SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30')
    (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274)
  at Contao\Database\Statement->query()
    (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248)
  at Contao\Database\Statement->execute(array('1', 'kuec'))
    (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:4424)
  at Contao\DC_Table->parentView()
    (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:364)
  at Contao\DC_Table->showAll()
    (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644)
  at Contao\Backend->getBackendModule('newsletter', null)
    (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167)
  at Contao\BackendMain->run()
    (vendor/contao/core-bundle/src/Controller/BackendController.php:48)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
    (vendor/symfony/http-kernel/HttpKernel.php:158)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
    (vendor/symfony/http-kernel/HttpKernel.php:80)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
    (vendor/symfony/http-kernel/Kernel.php:201)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
    (web/index.php:31)
  at require('/var/customers/webs/weller/brauerei-weller.de/web/index.php')
    (web/app.php:4)

---

Klicke rechts oben mal auf deinen Benutzer » Profil » Cache leeren » Session-Daten aktivieren » Speichern & schließen.

Wow!
Danke für den schnellen Support ! ! !
Das hat geholfen!
Im Manager hatte ich alles an Cache gelöscht was es gibt, ebenso in den Systemeinstellungen des Backends.
Das der User da noch vorrangig läuft hätte ich niemals erwartet.
Ist das so gewollt?
So muss jeder User das individuell machen, das wird lustig :D

Gruß
dtptiger

Führe folgenden query aus:

Code:

---

UPDATE `tl_user` SET `session` = NULL;

---

Dann ist das für alle behoben ;)

Ok, SQL in der db.
Sofort eben laufen gelassen.

Könnte das in den Manager, oder Ist dieses Cacheproblem mit Hintergrundrauschen nach deinem Support so selten?

Mit einem Cache hat das nichts zu tun. Der Fehler tritt auf, wenn der jeweilige Benutzer vor dem Update einen Filter irgendwo im Backend aktiv hatte, mit einem Attribut, das es nach dem Update nicht mehr gibt.

Ok!
Das kann ich nachvollziehen, der Filter "kuec" in newsletter reciepts war in 4.1 gesetzt gewesen.