Scheint soweit gelöst worden zu sein. Vielen Dank für die Hilfe und die investierte Zeit.
Beiträge von Voehnics im Thema „Fehlerseite nach Update“
-
-
Probiere jatzt nach dem zurücksetzen der Datenbank das Update neu.
-
Habe die korrekten Daten hinterlegt. Ja ein Backup wurde probiert, konnte aber nicht durchgeführt werden.
-
-
Seit heute kann ich die Seite nicht mehr öffnen. DIe Seite ist nur noch für Mitglieder erreichbar die keinen Zugriff auf EasyMedia habe. Gestern hatte ich das Update EasyMedia 3.5.x zur aktuellen Version gemacht.
PHP
Alles anzeigenPDOException Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'video.isPublished' in 'where clause' Error Code: 42S22 File: */lib/system/database/Database.class.php (328) Template Context: ?> <li class="<?php if ($this->v['menuItemNode']->isActiveNode()) { ?>active<?php } ?><?php if ($this->v['menuItemNode']->hasChildren()) { ?> boxMenuHasChildren<?php } ?>" data-identifier="<?=$this->v['menuItemNode']->identifier;?>"> <a <?=$this->pluginObjects['wcf\system\template\plugin\AnchorAttributesFunctionTemplatePlugin']->execute(['url' => $this->v['menuItemNode']->getURL(), 'appendClassname' => false], $this);?> class="boxMenuLink"<?php if ($this->v['menuItemNode']->isActiveNode()) { ?> aria-current="page"<?php } ?>> <span class="boxMenuLinkTitle"><?=wcf\util\StringUtil::encodeHTML($this->v['menuItemNode']->getTitle());?></span> ====> <?php if ($this->v['menuItemNode']->getOutstandingItems() > 0) { ?> <span class="boxMenuLinkOutstandingItems badge badgeUpdate" aria-label="(<?=wcf\util\StringUtil::formatNumeric($this->v['menuItemNode']->getOutstandingItems());?> <?php if ($this->v['menuItemNode']->getOutstandingItems() == 1) { ?>neuer Eintrag<?php } else { ?>neue Einträge<?php } ?>)"><?=wcf\util\StringUtil::formatNumeric($this->v['menuItemNode']->getOutstandingItems());?></span> <?php } ?> </a> <?php if ($this->v['menuItemNode']->hasChildren()) { ?><ol class="boxMenuDepth<?=$this->v['menuItemNode']->getDepth();?>"><?php } else { ?></li><?php } ?> Stack Trace: #0 */lib/system/database/Database.class.php (328): PDO->prepare() #1 */easymedia/lib/data/video/ViewableVideo.class.php (266): wcf\system\database\Database->prepareStatement() #2 */easymedia/lib/system/page/handler/OverviewPageHandler.class.php (24): easymedia\data\video\ViewableVideo::getUnreadLivestreams() #3 */lib/data/menu/item/MenuItem.class.php (157): easymedia\system\page\handler\OverviewPageHandler->getOutstandingItemCount() #4 */lib/data/DatabaseObjectDecorator.class.php (96): wcf\data\menu\item\MenuItem->getOutstandingItems() #5 */templates/compiled/123_wcf_1___menu.php (29): wcf\data\DatabaseObjectDecorator->__call() #6 */lib/system/template/TemplateEngine.class.php (350): include('*/templates/compiled/123_wcf_1___menu.php') #7 */lib/system/template/TemplateEngine.class.php (594): wcf\system\template\TemplateEngine->display() #8 */lib/data/menu/Menu.class.php (95): wcf\system\template\TemplateEngine->fetch() #9 */lib/data/box/Box.class.php (281): wcf\data\menu\Menu->getContent() #10 */templates/compiled/123_wcf_1___box.php (43): wcf\data\box\Box->getContent() #11 */lib/system/template/TemplateEngine.class.php (350): include('*/templates/compiled/123_wcf_1___box.php') #12 */lib/system/template/TemplateEngine.class.php (594): wcf\system\template\TemplateEngine->display() #13 */lib/data/box/Box.class.php (324): wcf\system\template\TemplateEngine->fetch() #14 */templates/compiled/123_wcf_1_cms.php (867): wcf\data\box\Box->render() #15 */lib/system/template/TemplateEngine.class.php (350): include('*/templates/compiled/123_wcf_1_cms.php') #16 */lib/page/AbstractPage.class.php (390): wcf\system\template\TemplateEngine->display() #17 */lib/page/AbstractPage.class.php (135): wcf\page\AbstractPage->show() #18 */lib/system/request/Request.class.php (90): wcf\page\AbstractPage->__run() #19 */lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute() #20 */index.php (11): wcf\system\request\RequestHandler->handle() Final Error Error Type: wcf\system\database\exception\DatabaseQueryException Error Message: Could not prepare statement 'SELECT COUNT(*) FROM easymedia1_video video LEFT JOIN wcf1_tracked_visit tracked_visit ON (tracked_visit.objectTypeID = 249 AND tracked_visit.objectID = video.videoID AND tracked_visit.userID = 1) WHERE video.videoID IN (SELECT videoID FROM easymedia1_video_to_category WHERE categoryID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND video.time > ? AND video.isPublished = ? AND video.isDisabled = ? AND video.isDeleted = ? AND video.isLivestream = ? AND tracked_visit.visitTime IS NULL AND (video.access IN (?, ?) OR (video.access IN (?, ?, ?, ?) AND video.userID = ?) OR video.access = ? AND IF(FIND_IN_SET(?, video.accessGroups)>0,1,0) OR video.access = ? AND IF(LOCATE(?,video.accessUsers)>0,1,0) OR video.access = ? AND IF(FIND_IN_SET(?, video.accessGroups)>0,1,0) OR video.access = ? AND IF(LOCATE(?,video.accessUsers)>0,1,0) OR video.access = ? AND IF(FIND_IN_SET(?, video.accessGroups)>0,1,0) OR video.access = ? AND IF(LOCATE(?,video.accessUsers)>0,1,0) OR video.access = ? AND IF(FIND_IN_SET(?, video.accessGroups)>0,1,0) OR video.access = ? AND IF(LOCATE(?,video.accessUsers)>0,1,0) OR video.access = ?)' Error Code: 42S22 File: */lib/system/database/Database.class.php (333) Template Context: ?> <li class="<?php if ($this->v['menuItemNode']->isActiveNode()) { ?>active<?php } ?><?php if ($this->v['menuItemNode']->hasChildren()) { ?> boxMenuHasChildren<?php } ?>" data-identifier="<?=$this->v['menuItemNode']->identifier;?>"> <a <?=$this->pluginObjects['wcf\system\template\plugin\AnchorAttributesFunctionTemplatePlugin']->execute(['url' => $this->v['menuItemNode']->getURL(), 'appendClassname' => false], $this);?> class="boxMenuLink"<?php if ($this->v['menuItemNode']->isActiveNode()) { ?> aria-current="page"<?php } ?>> <span class="boxMenuLinkTitle"><?=wcf\util\StringUtil::encodeHTML($this->v['menuItemNode']->getTitle());?></span> ====> <?php if ($this->v['menuItemNode']->getOutstandingItems() > 0) { ?> <span class="boxMenuLinkOutstandingItems badge badgeUpdate" aria-label="(<?=wcf\util\StringUtil::formatNumeric($this->v['menuItemNode']->getOutstandingItems());?> <?php if ($this->v['menuItemNode']->getOutstandingItems() == 1) { ?>neuer Eintrag<?php } else { ?>neue Einträge<?php } ?>)"><?=wcf\util\StringUtil::formatNumeric($this->v['menuItemNode']->getOutstandingItems());?></span> <?php } ?> </a> <?php if ($this->v['menuItemNode']->hasChildren()) { ?><ol class="boxMenuDepth<?=$this->v['menuItemNode']->getDepth();?>"><?php } else { ?></li><?php } ?> Stack Trace: #0 */easymedia/lib/data/video/ViewableVideo.class.php (266): wcf\system\database\Database->prepareStatement() #1 */easymedia/lib/system/page/handler/OverviewPageHandler.class.php (24): easymedia\data\video\ViewableVideo::getUnreadLivestreams() #2 */lib/data/menu/item/MenuItem.class.php (157): easymedia\system\page\handler\OverviewPageHandler->getOutstandingItemCount() #3 */lib/data/DatabaseObjectDecorator.class.php (96): wcf\data\menu\item\MenuItem->getOutstandingItems() #4 */templates/compiled/123_wcf_1___menu.php (29): wcf\data\DatabaseObjectDecorator->__call() #5 */lib/system/template/TemplateEngine.class.php (350): include('*/templates/compiled/123_wcf_1___menu.php') #6 */lib/system/template/TemplateEngine.class.php (594): wcf\system\template\TemplateEngine->display() #7 */lib/data/menu/Menu.class.php (95): wcf\system\template\TemplateEngine->fetch() #8 */lib/data/box/Box.class.php (281): wcf\data\menu\Menu->getContent() #9 */templates/compiled/123_wcf_1___box.php (43): wcf\data\box\Box->getContent() #10 */lib/system/template/TemplateEngine.class.php (350): include('*/templates/compiled/123_wcf_1___box.php') #11 */lib/system/template/TemplateEngine.class.php (594): wcf\system\template\TemplateEngine->display() #12 */lib/data/box/Box.class.php (324): wcf\system\template\TemplateEngine->fetch() #13 */templates/compiled/123_wcf_1_cms.php (867): wcf\data\box\Box->render() #14 */lib/system/template/TemplateEngine.class.php (350): include('*/templates/compiled/123_wcf_1_cms.php') #15 */lib/page/AbstractPage.class.php (390): wcf\system\template\TemplateEngine->display() #16 */lib/page/AbstractPage.class.php (135): wcf\page\AbstractPage->show() #17 */lib/system/request/Request.class.php (90): wcf\page\AbstractPage->__run() #18 */lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute() #19 */index.php (11): wcf\system\request\RequestHandler->handle()