Fehlermeldung wenn News aktiviert werden [GELÖST]

**Sebeljaner** · 22.04.2014, 21:51

Hallo,

ich benutze Contao noch nicht solange, daher kann ich mit einem Fehler nichts anfangen.
Zuerst ich habe Contao installiert und alles eingerichtet. Alles funktioniert. Danach habe ich die Erweiterungen die ich nicht brauchte deaktiviert. Darunter auch Nachrichten. Wenn ich nun die Nachrichten aktiviere, bekomme ich eine Fehlermeldung im Frontend. Das Backend funktioniert weiterhin, bis auf das Nachrichten Modul.

Code:

[22-Apr-2014 20:17:59 GMT] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'j1.news' in 'field list' (SELECT tl_article.*, j1.id AS author__id, j1.tstamp AS author__tstamp, j1.username AS author__username, j1.name AS author__name, j1.email AS author__email, j1.google AS author__google, j1.language AS author__language, j1.backendTheme AS author__backendTheme, j1.uploader AS author__uploader, j1.showHelp AS author__showHelp, j1.thumbnails AS author__thumbnails, j1.useRTE AS author__useRTE, j1.useCE AS author__useCE, j1.password AS author__password, j1.pwChange AS author__pwChange, j1.admin AS author__admin, j1.groups AS author__groups, j1.inherit AS author__inherit, j1.modules AS author__modules, j1.themes AS author__themes, j1.pagemounts AS author__pagemounts, j1.alpty AS author__alpty, j1.filemounts AS author__filemounts, j1.fop AS author__fop, j1.forms AS author__forms, j1.formp AS author__formp, j1.disable AS author__disable, j1.start AS author__start, j1.stop AS author__stop, j1.session AS author__session, j1.dateAdded AS author__dateAdded, j1.lastLogin AS author__lastLogin, j1.currentLogin AS author__currentLogin, j1.loginCount AS author__loginCount, j1.locked AS author__locked, j1.dlh_googlemapss AS author__dlh_googlemapss, j1.dlh_googlemapsp AS author__dlh_googlemapsp, j1.news AS author__news, j1.newp AS author__newp, j1.newsfeeds AS author__newsfeeds, j1.newsfeedp AS author__newsfeedp FROM tl_article LEFT JOIN tl_user j1 ON tl_article.author=j1.id WHERE tl_article.pid='2' AND tl_article.inColumn='main' AND (tl_article.start='' OR tl_article.start<1398197879) AND (tl_article.stop='' OR tl_article.stop>1398197879) AND tl_article.published=1 ORDER BY tl_article.sorting)' thrown in /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Database/Statement.php on line 283
#0 /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Database/Statement.php(254): Contao\Database\Statement->query()
#1 /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Model.php(937): Contao\Database\Statement->execute(Array)
#2 /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Model.php(833): Contao\Model::find(Array)
#3 /www/htdocs/w00e6a8e/system/modules/core/models/ArticleModel.php(111): Contao\Model::findBy(Array, Array, Array)
#4 /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Controller.php(220): Contao\ArticleModel::findPublishedByPidAndColumn('2', 'main')
#5 /www/htdocs/w00e6a8e/system/modules/core/pages/PageRegular.php(138): Contao\Controller->getFrontendModule('0', 'main')
#6 /www/htdocs/w00e6a8e/index.php(249): Contao\PageRegular->generate(Object(Contao\PageModel), true)
#7 /www/htdocs/w00e6a8e/index.php(433): Index->run()
#8 {main}
[22-Apr-2014 20:18:25 GMT] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'j1.news' in 'field list' (SELECT tl_article.*, j1.id AS author__id, j1.tstamp AS author__tstamp, j1.username AS author__username, j1.name AS author__name, j1.email AS author__email, j1.google AS author__google, j1.language AS author__language, j1.backendTheme AS author__backendTheme, j1.uploader AS author__uploader, j1.showHelp AS author__showHelp, j1.thumbnails AS author__thumbnails, j1.useRTE AS author__useRTE, j1.useCE AS author__useCE, j1.password AS author__password, j1.pwChange AS author__pwChange, j1.admin AS author__admin, j1.groups AS author__groups, j1.inherit AS author__inherit, j1.modules AS author__modules, j1.themes AS author__themes, j1.pagemounts AS author__pagemounts, j1.alpty AS author__alpty, j1.filemounts AS author__filemounts, j1.fop AS author__fop, j1.forms AS author__forms, j1.formp AS author__formp, j1.disable AS author__disable, j1.start AS author__start, j1.stop AS author__stop, j1.session AS author__session, j1.dateAdded AS author__dateAdded, j1.lastLogin AS author__lastLogin, j1.currentLogin AS author__currentLogin, j1.loginCount AS author__loginCount, j1.locked AS author__locked, j1.dlh_googlemapss AS author__dlh_googlemapss, j1.dlh_googlemapsp AS author__dlh_googlemapsp, j1.news AS author__news, j1.newp AS author__newp, j1.newsfeeds AS author__newsfeeds, j1.newsfeedp AS author__newsfeedp FROM tl_article LEFT JOIN tl_user j1 ON tl_article.author=j1.id WHERE tl_article.pid='2' AND tl_article.inColumn='main' AND (tl_article.start='' OR tl_article.start<1398197905) AND (tl_article.stop='' OR tl_article.stop>1398197905) AND tl_article.published=1 ORDER BY tl_article.sorting)' thrown in /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Database/Statement.php on line 283
#0 /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Database/Statement.php(254): Contao\Database\Statement->query()
#1 /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Model.php(937): Contao\Database\Statement->execute(Array)
#2 /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Model.php(833): Contao\Model::find(Array)
#3 /www/htdocs/w00e6a8e/system/modules/core/models/ArticleModel.php(111): Contao\Model::findBy(Array, Array, Array)
#4 /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Controller.php(220): Contao\ArticleModel::findPublishedByPidAndColumn('2', 'main')
#5 /www/htdocs/w00e6a8e/system/modules/core/pages/PageRegular.php(138): Contao\Controller->getFrontendModule('0', 'main')
#6 /www/htdocs/w00e6a8e/index.php(249): Contao\PageRegular->generate(Object(Contao\PageModel), true)
#7 /www/htdocs/w00e6a8e/index.php(433): Index->run()
#8 {main}
[22-Apr-2014 20:18:37 GMT] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'j1.news' in 'field list' (SELECT tl_article.*, j1.id AS author__id, j1.tstamp AS author__tstamp, j1.username AS author__username, j1.name AS author__name, j1.email AS author__email, j1.google AS author__google, j1.language AS author__language, j1.backendTheme AS author__backendTheme, j1.uploader AS author__uploader, j1.showHelp AS author__showHelp, j1.thumbnails AS author__thumbnails, j1.useRTE AS author__useRTE, j1.useCE AS author__useCE, j1.password AS author__password, j1.pwChange AS author__pwChange, j1.admin AS author__admin, j1.groups AS author__groups, j1.inherit AS author__inherit, j1.modules AS author__modules, j1.themes AS author__themes, j1.pagemounts AS author__pagemounts, j1.alpty AS author__alpty, j1.filemounts AS author__filemounts, j1.fop AS author__fop, j1.forms AS author__forms, j1.formp AS author__formp, j1.disable AS author__disable, j1.start AS author__start, j1.stop AS author__stop, j1.session AS author__session, j1.dateAdded AS author__dateAdded, j1.lastLogin AS author__lastLogin, j1.currentLogin AS author__currentLogin, j1.loginCount AS author__loginCount, j1.locked AS author__locked, j1.dlh_googlemapss AS author__dlh_googlemapss, j1.dlh_googlemapsp AS author__dlh_googlemapsp, j1.news AS author__news, j1.newp AS author__newp, j1.newsfeeds AS author__newsfeeds, j1.newsfeedp AS author__newsfeedp FROM tl_article LEFT JOIN tl_user j1 ON tl_article.author=j1.id WHERE tl_article.pid='2' AND tl_article.inColumn='main' AND (tl_article.start='' OR tl_article.start<1398197917) AND (tl_article.stop='' OR tl_article.stop>1398197917) AND tl_article.published=1 ORDER BY tl_article.sorting)' thrown in /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Database/Statement.php on line 283
#0 /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Database/Statement.php(254): Contao\Database\Statement->query()
#1 /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Model.php(937): Contao\Database\Statement->execute(Array)
#2 /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Model.php(833): Contao\Model::find(Array)
#3 /www/htdocs/w00e6a8e/system/modules/core/models/ArticleModel.php(111): Contao\Model::findBy(Array, Array, Array)
#4 /www/htdocs/w00e6a8e/system/modules/core/library/Contao/Controller.php(220): Contao\ArticleModel::findPublishedByPidAndColumn('2', 'main')
#5 /www/htdocs/w00e6a8e/system/modules/core/pages/PageRegular.php(138): Contao\Controller->getFrontendModule('0', 'main')
#6 /www/htdocs/w00e6a8e/index.php(249): Contao\PageRegular->generate(Object(Contao\PageModel), true)
#7 /www/htdocs/w00e6a8e/index.php(433): Index->run()
#8 {main}

Contao-Version: 3.2.4
Aktive Module: Arikel, Formulargenerator, GoogleMaps, FlexSlider, Facebook Widget, Google Analytics

Vielleicht kann mir jemand bei der Lösung helfen.

MfG
Sebastian

**Flex** · 22.04.2014, 21:57

Einmal die Datenbank aktualisieren, dann geht das auch wieder.

Seit Contao 3 werden die Tabellen von deaktivierten Erweiterungen gelöscht.

**Sebeljaner** · 22.04.2014, 22:49

Aha, ok und wie mache ich das richtig ohne das ich gleich meinen Datenbankinhalt lösche oder beschädige?

**magicsepp** · 23.04.2014, 06:54

unter "Erweiterungsverwaltung" einfach im Header "Datenbank aktualisieren" auswählen - danch kommen die SQL Sequenzen mit den Änderungen - man kann zur absoluten Sicherheit natürlich zuerst ein SQL Dump zur Sicherung erstellen - bei Erweiterungen bzw nach Installation von Erweiterung werden nur Spalten angefügt und ein Backup ist idR nicht nötig

**Samson1964** · 23.04.2014, 15:13

Zitat von Flex

Einmal die Datenbank aktualisieren, dann geht das auch wieder.

Seit Contao 3 werden die Tabellen von deaktivierten Erweiterungen gelöscht.

Echt? Ist mir zum Glück noch nicht untergekommen. Ich bekomme nur die Option für "DROP TABLE" angeboten. Die ist aber nie aktiv. Ist auch besser so, damit ich die Tabellen nicht versehentlich lösche.

**Sebeljaner** · 23.04.2014, 18:11

Hat ohne Probleme funktioniert. Vielen Dank.

**Flex** · 23.04.2014, 19:13

Zitat von Samson1964

Echt? Ist mir zum Glück noch nicht untergekommen. Ich bekomme nur die Option für "DROP TABLE" angeboten. Die ist aber nie aktiv. Ist auch besser so, damit ich die Tabellen nicht versehentlich lösche.

Ja, die sind nicht automatisch ausgewählt... Aber viele klicken da beim Aktualisieren mit rein und realisieren nicht direkt, dass es die Drops daher kommen.