Ok beim nächsten mal. Danke dir trotzdem.
Beiträge von Floka im Thema „Datenbank kaputt?“
-
-
Nein habe ein Back up eingespielt. nun klappte es auch in der live nicht mehr. auf dem Tester habe ich nun das Plug in deinstalliert und neu installiert das hat dort geholfen. wollte mir dort alle Dateien vom Newssystem raus holen und neu rüber ziehen aber das läuft auch nicht so wie gewollt. somit werde ich es wohl bei der live auch deinstallieren und neu installieren.
-
Ok komisch also wen ich die selben Dateien in die Haupt Installation rein übertrage via filezilla ist alles sauber. echt komisch.
-
Hallo ich habe meine live Umgebung als backup genommen und auf meine Testumgebung gepackt. alles funtzt nur die Newsseite wirft das hier aus.
Code* @package de.wbb-elite.news * @category News-System * * @method News current() * @method News[] getObjects() * @method News|null search($objectID) * @property News[] $objects */class NewsList extends DatabaseObjectList { /** * @inheritdoc */ public $className = News::class; /** * @inheritdoc */ public function countObjects() { $sql = "SELECT COUNT(DISTINCT(news.newsID)) AS count FROM " . $this->getDatabaseTableName() . " " . $this->getDatabaseTableAlias() . " " . $this->sqlConditionJoins . " " . $this->getConditionBuilder(); $statement = WCF::getDB()->prepareStatement($sql); $statement->execute($this->getConditionBuilder()->getParameters()); $row = $statement->fetchArray(); return $row['count']; } /** * @inheritdoc */ public function readObjectIDs() { $this->objectIDs = []; $sql = "SELECT DISTINCT " . $this->getDatabaseTableAlias() . "." . $this->getDatabaseTableIndexName() . " AS objectID, " . $this->getDatabaseTableAlias() . ".* FROM " . $this->getDatabaseTableName() . " " . $this->getDatabaseTableAlias() . " " . $this->sqlConditionJoins . " " . $this->getConditionBuilder() . " " . (!empty($this->sqlOrderBy) ? "ORDER BY " . $this->sqlOrderBy : ''); $statement = WCF::getDB()->prepareStatement($sql, $this->sqlLimit, $this->sqlOffset); $statement->execute($this->getConditionBuilder()->getParameters()); while ($row = $statement->fetchArray()) { $this->objectIDs[] = $row['objectID']; } } /** * @inheritdoc */ public function readObjects() { if (StringUtil::startsWith($this->sqlSelects, ",")) { $this->sqlSelects = mb_substr($this->sqlSelects, 1, strlen($this->sqlSelects) - 1); } else if (StringUtil::startsWith($this->sqlSelects, " ,")) { $this->sqlSelects = mb_substr($this->sqlSelects, 2, strlen($this->sqlSelects) - 2); } if ($this->objectIDs !== null) { if (empty($this->objectIDs)) { return; } $sql = "SELECT DISTINCT(news.newsID), " . (!empty($this->sqlSelects) ? $this->sqlSelects . ($this->useQualifiedShorthand ? ',' : '') : '') . " " . ($this->useQualifiedShorthand ? $this->getDatabaseTableAlias() . '.*' : '') . " FROM " . $this->getDatabaseTableName() . " " . $this->getDatabaseTableAlias() . " " . $this->sqlJoins . " WHERE " . $this->getDatabaseTableAlias() . "." . $this->getDatabaseTableIndexName() . " IN (?" . str_repeat(',?', count($this->objectIDs) - 1) . ") " . (!empty($this->sqlOrderBy) ? "ORDER BY " . $this->sqlOrderBy : ''); $statement = WCF::getDB()->prepareStatement($sql); $statement->execute($this->objectIDs); $this->objects = $statement->fetchObjects(($this->objectClassName ?: $this->className)); } else { $sql = "SELECT DISTINCT(news.newsID), " . (!empty($this->sqlSelects) ? $this->sqlSelects . ($this->useQualifiedShorthand ? ',' : '') : '') . " " . ($this->useQualifiedShorthand ? $this->getDatabaseTableAlias() . '.*' : '') . " FROM " . $this->getDatabaseTableName() . " " . $this->getDatabaseTableAlias() . " " . $this->sqlJoins . " " . $this->getConditionBuilder() . " " . (!empty($this->sqlOrderBy) ? "ORDER BY " . $this->sqlOrderBy : ''); $statement = WCF::getDB()->prepareStatement($sql, $this->sqlLimit, $this->sqlOffset); $statement->execute($this->getConditionBuilder()->getParameters()); $this->objects = $statement->fetchObjects(($this->objectClassName ?: $this->className)); } // decorate objects if (!empty($this->decoratorClassName)) { foreach ($this->objects as &$object) { $object = new $this->decoratorClassName($object); } unset($object); } // use table index as array index $objects = []; foreach ($this->objects as $object) { $objectID = $object->getObjectID(); $objects[$objectID] = $object; $this->indexToObject[] = $objectID; } $this->objectIDs = $this->indexToObject; $this->objects = $objects; }}