- Betroffene App
- WoltLab Suite Core
- Forum frisch installiert
- Blog installiert über Paketserver
- Galerie versucht zu installieren führt zu folgendem Fehler:
WoltLab Marcel Werk könnt ihr die Zeichenlänge von 10,000 erhöhen? Die komplette Fehlermeldung kann ich nicht posten, hab den stackrace raus genommen weil es über 10,000 zeichen war
Code
<<<<<<<<9b97b7838e2e70822bcf2e3bc38d55850882d997<<<<
Fri, 21 Oct 2016 19:03:49 +0000
Message: Could not execute statement 'CREATE TABLE `gallery1_image` (
`imageID` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,`tmpHash` varchar(40) NOT NULL DEFAULT '',`userID` int(10),`username` varchar(255) NOT NULL DEFAULT '',`albumID` int(10),`title` varchar(255) NOT NULL DEFAULT '',`description` text,`filename` varchar(255) NOT NULL DEFAULT '',`fileExtension` varchar(7) NOT NULL DEFAULT '',`fileHash` varchar(8) NOT NULL DEFAULT '',`filesize` int(10) NOT NULL DEFAULT 0,`comments` smallint(5) NOT NULL DEFAULT 0,`views` mediumint(8) NOT NULL DEFAULT 0,`cumulativeLikes` mediumint(7) NOT NULL DEFAULT 0,`uploadTime` int(10) NOT NULL DEFAULT 0,`creationTime` int(10) NOT NULL DEFAULT 0,`width` smallint(5) NOT NULL DEFAULT 0,`height` smallint(5) NOT NULL DEFAULT 0,`orientation` tinyint(1) NOT NULL DEFAULT 1,`camera` varchar(255) NOT NULL DEFAULT '',`location` varchar(255) NOT NULL DEFAULT '',`latitude` float(10,7) NOT NULL DEFAULT 0.0,`longitude` float(10,7) NOT NULL DEFAULT 0.0,`thumbnailX` smallint(5) NOT NULL DEFAULT 0,`thumbnailY` smallint(5) NOT NULL DEFAULT 0,`thumbnailHeight` smallint(5) NOT NULL DEFAULT 0,`thumbnailWidth` smallint(5) NOT NULL DEFAULT 0,`tinyThumbnailSize` int(10) NOT NULL DEFAULT 0,`smallThumbnailSize` int(10) NOT NULL DEFAULT 0,`mediumThumbnailSize` int(10) NOT NULL DEFAULT 0,`largeThumbnailSize` int(10) NOT NULL DEFAULT 0,`enableHtml` tinyint(1) NOT NULL DEFAULT 0,`ipAddress` varchar(39) NOT NULL DEFAULT '',`enableComments` tinyint(1) NOT NULL DEFAULT 1,`isDisabled` tinyint(1) NOT NULL DEFAULT 0,`isDeleted` tinyint(1) NOT NULL DEFAULT 0,`deleteTime` int(10) NOT NULL DEFAULT 0,`rawExifData` mediumtext,`exifData` mediumtext,`accessLevel` tinyint(1) NOT NULL DEFAULT 0,`hasEmbeddedObjects` tinyint(1) NOT NULL DEFAULT 0,`hasMarkers` tinyint(1) NOT NULL DEFAULT 0,`showOrder` int(10) NOT NULL DEFAULT 0,`hasOriginalWatermark` tinyint(1) NOT NULL DEFAULT 0
,
KEY `hasLargeThumbnail` (`largeThumbnailSize`),KEY (`tmpHash`),KEY `access` (`accessLevel`,`userID`),KEY (`camera`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci'
PHP version: 7.0.10-nmm1
WCF version: 3.0.0 Beta 3
Request URI: /acp/index.php?install-package/&t=ca0efc66b96a563ca969a8cb1dbf2a6f4e6c1336
Referrer: http://neu.woltlab.com/acp/index.php?package-start-install/&action=install
User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.143 Safari/537.36
Peak Memory Usage: 37798360/2146435072
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'CREATE TABLE `gallery1_image` (
`imageID` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,`tmpHash` varchar(40) NOT NULL DEFAULT '',`userID` int(10),`username` varchar(255) NOT NULL DEFAULT '',`albumID` int(10),`title` varchar(255) NOT NULL DEFAULT '',`description` text,`filename` varchar(255) NOT NULL DEFAULT '',`fileExtension` varchar(7) NOT NULL DEFAULT '',`fileHash` varchar(8) NOT NULL DEFAULT '',`filesize` int(10) NOT NULL DEFAULT 0,`comments` smallint(5) NOT NULL DEFAULT 0,`views` mediumint(8) NOT NULL DEFAULT 0,`cumulativeLikes` mediumint(7) NOT NULL DEFAULT 0,`uploadTime` int(10) NOT NULL DEFAULT 0,`creationTime` int(10) NOT NULL DEFAULT 0,`width` smallint(5) NOT NULL DEFAULT 0,`height` smallint(5) NOT NULL DEFAULT 0,`orientation` tinyint(1) NOT NULL DEFAULT 1,`camera` varchar(255) NOT NULL DEFAULT '',`location` varchar(255) NOT NULL DEFAULT '',`latitude` float(10,7) NOT NULL DEFAULT 0.0,`longitude` float(10,7) NOT NULL DEFAULT 0.0,`thumbnailX` smallint(5) NOT NULL DEFAULT 0,`thumbnailY` smallint(5) NOT NULL DEFAULT 0,`thumbnailHeight` smallint(5) NOT NULL DEFAULT 0,`thumbnailWidth` smallint(5) NOT NULL DEFAULT 0,`tinyThumbnailSize` int(10) NOT NULL DEFAULT 0,`smallThumbnailSize` int(10) NOT NULL DEFAULT 0,`mediumThumbnailSize` int(10) NOT NULL DEFAULT 0,`largeThumbnailSize` int(10) NOT NULL DEFAULT 0,`enableHtml` tinyint(1) NOT NULL DEFAULT 0,`ipAddress` varchar(39) NOT NULL DEFAULT '',`enableComments` tinyint(1) NOT NULL DEFAULT 1,`isDisabled` tinyint(1) NOT NULL DEFAULT 0,`isDeleted` tinyint(1) NOT NULL DEFAULT 0,`deleteTime` int(10) NOT NULL DEFAULT 0,`rawExifData` mediumtext,`exifData` mediumtext,`accessLevel` tinyint(1) NOT NULL DEFAULT 0,`hasEmbeddedObjects` tinyint(1) NOT NULL DEFAULT 0,`hasMarkers` tinyint(1) NOT NULL DEFAULT 0,`showOrder` int(10) NOT NULL DEFAULT 0,`hasOriginalWatermark` tinyint(1) NOT NULL DEFAULT 0
,
KEY `hasLargeThumbnail` (`largeThumbnailSize`),KEY (`tmpHash`),KEY `access` (`accessLevel`,`userID`),KEY (`camera`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci'
Error Code: 42000
File: /www/htdocs/woltlab/websites/woltlab/WCF22/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTowOnt9
======
Error Class: PDOException
Error Message: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
Error Code: 42000
File: /www/htdocs/woltlab/websites/woltlab/WCF22/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
<<<<
Alles anzeigen