EasyMedia update von 5.3.5 pl2 auf 5.5 SQL Fehler

Ein Fehler ist aufgetreten

Interner Fehlercode: 19aa63d0624f7ff01e1e3070b1efe26699e02a2e

Was ist passiert?

Leider ist es bei der Verarbeitung zu einem Fehler gekommen und die Ausführung wurde abgebrochen. Falls möglich, leiten Sie bitte den oben stehenden Fehlercode an den Administrator weiter.

 

Administratoren können die vollständige Fehlermeldung mit Hilfe dieses Codes in der Administrationsoberfläche unter „Protokoll » Fehler“ einsehen. Zusätzlich wurden die Informationen in die Protokolldatei */log/2023-10-22.txt geschrieben und können beispielsweise mit Hilfe eines FTP-Programms abgerufen werden.

 

Hinweis: Der Fehlercode wird zufällig generiert, erlaubt keinen Rückschluss auf die Ursache und ist daher für Dritte nutzlos.

System Information

    PHP Version:

    8.1.22

    WoltLab Suite Core:

    5.5.18

    Peak Memory Usage:

    6.69/256 MiB

    Request URI:

    POST /acp/index.php?install-package/&t=2dacc728722f30f6347e65a13045c163bb4b2f6e38c17eb8e52dda07d405db19-f2MVOm1B3zp8YJPwd6mlUA==

    Referrer:

    https://www.actias.de/acp/index.php?package-update/

    User Agent:

    Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/118.0

Original Error

    Error Type:

    PDOException

    Error Message:

    SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'latitude' at row 2442

    Error Code:

    22003

    File:

    */lib/system/database/statement/PreparedStatement.class.php (126)

    Stack Trace:
        #0 */lib/system/database/statement/PreparedStatement.class.php (126):
        PDOStatement->execute([ ])
        #1 */lib/system/database/editor/MySQLDatabaseEditor.class.php (319):
        wcf\system\database\statement\PreparedStatement->execute()
        #2 */lib/system/database/table/DatabaseTableChangeProcessor.class.php (388):
        wcf\system\database\editor\MySQLDatabaseEditor->alterColumns('easymedia1_image', [ 20 items ])
        #3 */lib/system/database/table/DatabaseTableChangeProcessor.class.php (279):
        wcf\system\database\table\DatabaseTableChangeProcessor->applyColumnChanges('easymedia1_image', [ 15 items ], [ 0 => , 1 => , 2 => , 3 => , 4 => ], [ ])
        #4 */lib/system/database/table/DatabaseTableChangeProcessor.class.php (1164):
        wcf\system\database\table\DatabaseTableChangeProcessor->applyChanges()
        #5 */lib/system/package/plugin/DatabasePackageInstallationPlugin.class.php (78):
        wcf\system\database\table\DatabaseTableChangeProcessor->process()
        #6 */lib/system/package/plugin/DatabasePackageInstallationPlugin.class.php (48):
        wcf\system\package\plugin\DatabasePackageInstallationPlugin->updateDatabase('*/easymedia/acp/database/install_com.cls.easymedia.image.php')
        #7 */lib/system/package/plugin/AbstractPackageInstallationPlugin.class.php (76):
        wcf\system\package\plugin\DatabasePackageInstallationPlugin->install()
        #8 */lib/system/package/PackageInstallationDispatcher.class.php (807):
        wcf\system\package\plugin\AbstractPackageInstallationPlugin->update()
        #9 */lib/system/package/PackageInstallationDispatcher.class.php (155):
        wcf\system\package\PackageInstallationDispatcher->executePIP([ attributes => , pip => , value => ])
        #10 */lib/acp/action/InstallPackageAction.class.php (82):
        wcf\system\package\PackageInstallationDispatcher->install('78ad1d46')
        #11 */lib/action/AbstractDialogAction.class.php (73):
        wcf\acp\action\InstallPackageAction->stepInstall()
        #12 */lib/action/AbstractAction.class.php (57):
        wcf\action\AbstractDialogAction->execute()
        #13 */lib/system/request/Request.class.php (90):
        wcf\action\AbstractAction->__run()
        #14 */lib/system/request/RequestHandler.class.php (107):
        wcf\system\request\Request->execute()
        #15 */acp/index.php (11):
        wcf\system\request\RequestHandler->handle('wcf', true)

Final Error

    Error Type:

    wcf\system\database\exception\DatabaseQueryExecutionException

    Error Message:

    Could not execute statement 'ALTER TABLE `easymedia1_image` ADD COLUMN `tinyThumbnailWidth` smallint(5) NOT NULL DEFAULT '0',ADD COLUMN `tinyThumbnailHeight` smallint(5) NOT NULL DEFAULT '0',ADD COLUMN `smallThumbnailWidth` smallint(5) NOT NULL DEFAULT '0',ADD COLUMN `smallThumbnailHeight` smallint(5) NOT NULL DEFAULT '0',ADD COLUMN `mediumThumbnailWidth` smallint(5) NOT NULL DEFAULT '0',ADD COLUMN `mediumThumbnailHeight` smallint(5) NOT NULL DEFAULT '0',ADD COLUMN `largeThumbnailWidth` smallint(5) NOT NULL DEFAULT '0',ADD COLUMN `largeThumbnailHeight` smallint(5) NOT NULL DEFAULT '0',ADD COLUMN `hasMarkers` tinyint(1) NOT NULL DEFAULT '0',ADD COLUMN `readExif` tinyint(1) NOT NULL DEFAULT '1',ADD COLUMN `disableReadExifCamera` tinyint(1) NOT NULL DEFAULT '0',ADD COLUMN `disableReadExifTime` tinyint(1) NOT NULL DEFAULT '0',ADD COLUMN `disableReadExifOrientation` tinyint(1) NOT NULL DEFAULT '0',ADD COLUMN `disableReadExifLocation` tinyint(1) NOT NULL DEFAULT '0',ADD COLUMN `fileType` varchar(255) NULL DEFAULT '',CHANGE COLUMN `description` `description` mediumtext NULL,CHANGE COLUMN `rating` `rating` float(3,2) NOT NULL DEFAULT '0.00',CHANGE COLUMN `orientation` `orientation` tinyint(1) NOT NULL DEFAULT '0',CHANGE COLUMN `enableHtml` `enableHtml` tinyint(1) NOT NULL DEFAULT '1',CHANGE COLUMN `pendingThumbnail` `pendingThumbnail` tinyint(1) NOT NULL DEFAULT '1''

    Error Code:

    22003

    File:

    */lib/system/database/statement/PreparedStatement.class.php (144)

    Stack Trace:
        #0 */lib/system/database/editor/MySQLDatabaseEditor.class.php (319):
        wcf\system\database\statement\PreparedStatement->execute()
        #1 */lib/system/database/table/DatabaseTableChangeProcessor.class.php (388):
        wcf\system\database\editor\MySQLDatabaseEditor->alterColumns('easymedia1_image', [ 20 items ])
        #2 */lib/system/database/table/DatabaseTableChangeProcessor.class.php (279):
        wcf\system\database\table\DatabaseTableChangeProcessor->applyColumnChanges('easymedia1_image', [ 15 items ], [ 0 => , 1 => , 2 => , 3 => , 4 => ], [ ])
        #3 */lib/system/database/table/DatabaseTableChangeProcessor.class.php (1164):
        wcf\system\database\table\DatabaseTableChangeProcessor->applyChanges()
        #4 */lib/system/package/plugin/DatabasePackageInstallationPlugin.class.php (78):
        wcf\system\database\table\DatabaseTableChangeProcessor->process()
        #5 */lib/system/package/plugin/DatabasePackageInstallationPlugin.class.php (48):
        wcf\system\package\plugin\DatabasePackageInstallationPlugin->updateDatabase('*/easymedia/acp/database/install_com.cls.easymedia.image.php')
        #6 */lib/system/package/plugin/AbstractPackageInstallationPlugin.class.php (76):
        wcf\system\package\plugin\DatabasePackageInstallationPlugin->install()
        #7 */lib/system/package/PackageInstallationDispatcher.class.php (807):
        wcf\system\package\plugin\AbstractPackageInstallationPlugin->update()
        #8 */lib/system/package/PackageInstallationDispatcher.class.php (155):
        wcf\system\package\PackageInstallationDispatcher->executePIP([ attributes => , pip => , value => ])
        #9 */lib/acp/action/InstallPackageAction.class.php (82):
        wcf\system\package\PackageInstallationDispatcher->install('78ad1d46')
        #10 */lib/action/AbstractDialogAction.class.php (73):
        wcf\acp\action\InstallPackageAction->stepInstall()
        #11 */lib/action/AbstractAction.class.php (57):
        wcf\action\AbstractDialogAction->execute()
        #12 */lib/system/request/Request.class.php (90):
        wcf\action\AbstractAction->__run()
        #13 */lib/system/request/RequestHandler.class.php (107):
        wcf\system\request\Request->execute()
        #14 */acp/index.php (11):
        wcf\system\request\RequestHandler->handle('wcf', true)