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.
PDOException
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()
Alles anzeigen