[5.2 RC1] Upgrade - Medien/Imageviewer Fehler

Dukemaster · December 16, 2019 at 11:45 PM

Bei mir geht es immernoch um die von 3.1.11 auf 5.2.0 RC 1 upgedatete Seite (nur Core+CMS, keine Apps, aber 5-sprachig).

Beim Klick auf die Bilder der Startseite dreht sich ein regenbogenfarbiger Spinner ewig. Bild wird keines geladen. Dafür gibt es eine Fehlermeldung(en).

Requested URL: /media/5-santa-maria-de-columbus-jpg/

Referrer: https://www.bilder-designs.de/

Error Message: Could not prepare statement 'UPDATE wcf1_media SET downloads = ?, lastDownloadTime = ? WHERE mediaID = ?'

Type: wcf\system\database\exception\DatabaseQueryException

File (Line): /var/www/vhosts/bilder-designs.de/httpdocs/lib/system/database/Database.class.php (276)

Stacktrace

/var/www/vhosts/bilder-designs.de/httpdocs/lib/data/DatabaseObjectEditor.class.php (67): wcf\system\database\Database->prepareStatement(…)
/var/www/vhosts/bilder-designs.de/httpdocs/lib/page/MediaPage.class.php (150): wcf\data\DatabaseObjectEditor->update(…)
/var/www/vhosts/bilder-designs.de/httpdocs/lib/page/AbstractPage.class.php (114): wcf\page\MediaPage->show(…)
/var/www/vhosts/bilder-designs.de/httpdocs/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/var/www/vhosts/bilder-designs.de/httpdocs/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/vhosts/bilder-designs.de/httpdocs/index.php (9): wcf\system\request\RequestHandler->handle(…)

Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lastDownloadTime' in 'field list'

Type: PDOException

File (Line): /var/www/vhosts/bilder-designs.de/httpdocs/lib/system/database/Database.class.php (271)

Stacktrace

/var/www/vhosts/bilder-designs.de/httpdocs/lib/system/database/Database.class.php (271): PDO->prepare(…)
/var/www/vhosts/bilder-designs.de/httpdocs/lib/data/DatabaseObjectEditor.class.php (67): wcf\system\database\Database->prepareStatement(…)
/var/www/vhosts/bilder-designs.de/httpdocs/lib/page/MediaPage.class.php (150): wcf\data\DatabaseObjectEditor->update(…)
/var/www/vhosts/bilder-designs.de/httpdocs/lib/page/AbstractPage.class.php (114): wcf\page\MediaPage->show(…)
/var/www/vhosts/bilder-designs.de/httpdocs/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
/var/www/vhosts/bilder-designs.de/httpdocs/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
/var/www/vhosts/bilder-designs.de/httpdocs/index.php (9): wcf\system\request\RequestHandler->handle(…)

Mon, 16 Dec 2019 22:38:41 +0000
Message: Could not prepare statement 'UPDATE    wcf1_media
             SET    downloads = ?, lastDownloadTime = ?
             WHERE    mediaID = ?'
PHP version: 7.3.12
WoltLab Suite version: 5.2.0 RC 1
Request URI: /media/5-santa-maria-de-columbus-jpg/
Referrer: https://www.bilder-designs.de/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:71.0) Gecko/20100101 Firefox/71.0
Peak Memory Usage: 1739568/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'UPDATE    wcf1_media
             SET    downloads = ?, lastDownloadTime = ?
             WHERE    mediaID = ?'
Error Code: 42
File: /var/www/vhosts/bilder-designs.de/httpdocs/lib/system/database/Database.class.php (276)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/lib\/data\/DatabaseObjectEditor.class.php","line":67,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["UPDATE\twcf1_media\r\n\t\t\tSET\tdownloads = ?, lastDownloadTime = ?\r\n\t\t\tWHERE\tmediaID = ?"]},{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/lib\/page\/MediaPage.class.php","line":150,"function":"update","class":"wcf\\data\\DatabaseObjectEditor","type":"->","args":[{"downloads":"[redacted]","lastDownloadTime":"[redacted]"}]},{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\MediaPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lastDownloadTime' in 'field list'
Error Code: 42
File: /var/www/vhosts/bilder-designs.de/httpdocs/lib/system/database/Database.class.php (271)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/lib\/system\/database\/Database.class.php","line":271,"function":"prepare","class":"PDO","type":"->","args":["UPDATE\twcf1_media\r\n\t\t\tSET\tdownloads = ?, lastDownloadTime = ?\r\n\t\t\tWHERE\tmediaID = ? -- '\/media\/5-santa-maria-de-columbus-jpg\/'"]},{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/lib\/data\/DatabaseObjectEditor.class.php","line":67,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["UPDATE\twcf1_media\r\n\t\t\tSET\tdownloads = ?, lastDownloadTime = ?\r\n\t\t\tWHERE\tmediaID = ?"]},{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/lib\/page\/MediaPage.class.php","line":150,"function":"update","class":"wcf\\data\\DatabaseObjectEditor","type":"->","args":[{"downloads":"[redacted]","lastDownloadTime":"[redacted]"}]},{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\MediaPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/bilder-designs.de\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf"]}]

Code

Could not prepare statement 'UPDATE wcf1_media SET downloads = ?, lastDownloadTime = ? WHERE mediaID = ?'

Fecha
    16 Diciembre 2019, 22:38

URL solicitado
    /media/5-santa-maria-de-columbus-jpg/

URL de referencia
    https://www.example.com/

Navegador
    Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:71.0) Gecko/20100101 Firefox/71.0

Memoria principal
    1,66 MiB / 256 MiB

Mensaje de error
    Could not prepare statement 'UPDATE wcf1_media SET downloads = ?, lastDownloadTime = ? WHERE mediaID = ?'

Tipo
    wcf\system\database\exception\DatabaseQueryException

Archivo (Línea)
    /var/www/vhosts/example.com/httpdocs/lib/system/database/Database.class.php (276)

Stacktrace

        /var/www/vhosts/example.com/httpdocs/lib/data/DatabaseObjectEditor.class.php (67): wcf\system\database\Database->prepareStatement(…)
        /var/www/vhosts/example.com/httpdocs/lib/page/MediaPage.class.php (150): wcf\data\DatabaseObjectEditor->update(…)
        /var/www/vhosts/example.com/httpdocs/lib/page/AbstractPage.class.php (114): wcf\page\MediaPage->show(…)
        /var/www/vhosts/example.com/httpdocs/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
        /var/www/vhosts/example.com/httpdocs/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
        /var/www/vhosts/example.com/httpdocs/index.php (9): wcf\system\request\RequestHandler->handle(…)

Mensaje de error
    SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lastDownloadTime' in 'field list'

Tipo
    PDOException

Archivo (Línea)
    /var/www/vhosts/example.com/httpdocs/lib/system/database/Database.class.php (271)

Stacktrace

        /var/www/vhosts/example.com/httpdocs/lib/system/database/Database.class.php (271): PDO->prepare(…)
        /var/www/vhosts/example.com/httpdocs/lib/data/DatabaseObjectEditor.class.php (67): wcf\system\database\Database->prepareStatement(…)
        /var/www/vhosts/example.com/httpdocs/lib/page/MediaPage.class.php (150): wcf\data\DatabaseObjectEditor->update(…)
        /var/www/vhosts/example.com/httpdocs/lib/page/AbstractPage.class.php (114): wcf\page\MediaPage->show(…)
        /var/www/vhosts/example.com/httpdocs/lib/system/request/Request.class.php (83): wcf\page\AbstractPage->__run(…)
        /var/www/vhosts/example.com/httpdocs/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
        /var/www/vhosts/example.com/httpdocs/index.php (9): wcf\system\request\RequestHandler->handle(…)

Display More

Scamander · December 17, 2019 at 5:29 AM

ist bekannt bzw. behoben, dort steht wie es bereits vorab behoben werden kann:

https://beta.woltlab.com/forum/thread/3…D=1584#post1584

[5.2 RC1] Upgrade - Medien/Imageviewer Fehler

Matthias Schmidt December 17, 2019 at 7:10 AM

Matthias Schmidt December 21, 2019 at 11:23 AM

Participate now!

Similar Threads

Ein Fehler ist aufgetreten (5.2 RC1 )

[5.2 RC1] Upgrade - Hauptmenü wurde hinzugefügt, obwohl schon da

[WSC 5.2.0 RC1] Fehler nach User / Foren löschen - anzeigen aktualisieren

[5.2 RC1] Upgrade-Fehler - LikeableArticleUserActivityEvent

[WSC 5.2 RC 1] Fehler bei Upgrade zu WSC 5.2

Users Viewing This Thread

Matthias Schmidt December 17, 2019 at 7:10 AM

Matthias Schmidt December 21, 2019 at 11:23 AM