Hallo ich verzweifle gerade ein wenig. Ich habe eine bestehende Website (läuft mit COntao 3.0.6) die ich lokal auf dem Rechner installieren wollte. Dafür habe ich mir MAMP (für MAc OSX) installiert und die COntaoversion 3.1.
Hier meine Vorgehensweise im einzelnen:
Ich habe:
1. Contao 3.1 installiert
2.Alle benötigten Erweiterungen installiert, danach ausgeloggt.
3. Ein Datenbank Backup importiert (in PhP MyAdmin)
4. Mich erneut ins Backend eingeloggt.
5. Versucht die Seitenstruktur zu öffnen. Dann bekamm ich ebenfalls die Fehlermeldung*
Bildschirmfoto 2014-02-24 um 20.28.44.png
6. Hab mich aus dem System ausgeloggt.
7. Habe das Installtool nochmal aufgerufen und die Datenbank aktualisiert, da die veraltet war, wie dort stand.
Bildschirmfoto 2014-02-24 um 20.35.01.png
8. Habe dann das Version 3.1 Update ausgeführt und folgende Fehlermeldung laut error.log erhalten:
Fatal error: Uncaught exception Exception with message Query error: Duplicate entry '205' for key 'PRIMARY' (ALTER TABLE `tl_tag` ADD PRIMARY KEY (`id`);) thrown in system/modules/core/library/Contao/Database/Statement.php on line 346
#0 system/modules/core/library/Contao/Database.php(228): Contao\Database\Statement->query('ALTER TABLE `tl...')
#1 contao/install.php(197): Contao\Database->query('ALTER TABLE `tl...')
#2 contao/install.php(971): InstallTool->run()
#3 {main}
9. Die erneut Datenbank gelöscht und neu importiert.
10. Backend aufgerufen und Cache neu aufgebaut (das war oben als Meldung rot hinterlegt).
11. Danach erneut versucht die Seitenstruktur zu öffnen und wieder Fehlermeldung am Bildschirm
Bildschirmfoto 2014-02-24 um 20.30.40.png
12. Erweiterungskatalog aufgerufen alle Erweiterungen aktualisiert.
13. Erneute Fehlermeldung erhalten. (Hier eine Übersicht aller bisherigen Fehlermeldungen)
[24-Feb-2014 19:15:12] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'tl_tag.tid' in 'field list' (SELECT tl_tag.tid FROM tl_tag, tl_page WHERE tl_tag.tid = tl_page.id AND tl_page.tstamp = 0)' thrown in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php on line 346
#0 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php(261): Contao\Database\Statement->query()
#1 /Applications/MAMP/htdocs/system/modules/tags/classes/TagHelper.php(121): Contao\Database\Statement->execute()
#2 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(2851): Contao\TagHelper->deleteIncompleteRecords('tl_page', Array, NULL, Array)
#3 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(309): Contao\DC_Table->reviseTable()
#4 /Applications/MAMP/htdocs/system/modules/core/classes/Backend.php(424): Contao\DC_Table->showAll()
#5 /Applications/MAMP/htdocs/contao/main.php(129): Contao\Backend->getBackendModule('page')
#6 /Applications/MAMP/htdocs/contao/main.php(271): Main->run()
#7 {main}
[24-Feb-2014 19:15:28] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'tl_tag.tid' in 'field list' (SELECT tl_tag.tid FROM tl_tag, tl_page WHERE tl_tag.tid = tl_page.id AND tl_page.tstamp = 0)' thrown in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php on line 346
#0 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php(261): Contao\Database\Statement->query()
#1 /Applications/MAMP/htdocs/system/modules/tags/classes/TagHelper.php(121): Contao\Database\Statement->execute()
#2 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(2851): Contao\TagHelper->deleteIncompleteRecords('tl_page', Array, NULL, Array)
#3 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(309): Contao\DC_Table->reviseTable()
#4 /Applications/MAMP/htdocs/system/modules/core/classes/Backend.php(424): Contao\DC_Table->showAll()
#5 /Applications/MAMP/htdocs/contao/main.php(129): Contao\Backend->getBackendModule('page')
#6 /Applications/MAMP/htdocs/contao/main.php(271): Main->run()
#7 {main}
[24-Feb-2014 19:15:33] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'tl_tag.tid' in 'field list' (SELECT tl_tag.tid FROM tl_tag, tl_article WHERE tl_tag.tid = tl_article.id AND tl_article.tstamp = 0)' thrown in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php on line 346
#0 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php(261): Contao\Database\Statement->query()
#1 /Applications/MAMP/htdocs/system/modules/tags/classes/TagHelper.php(121): Contao\Database\Statement->execute()
#2 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(2851): Contao\TagHelper->deleteIncompleteRecords('tl_article', Array, 'tl_page', Array)
#3 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(309): Contao\DC_Table->reviseTable()
#4 /Applications/MAMP/htdocs/system/modules/core/classes/Backend.php(424): Contao\DC_Table->showAll()
#5 /Applications/MAMP/htdocs/contao/main.php(129): Contao\Backend->getBackendModule('article')
#6 /Applications/MAMP/htdocs/contao/main.php(271): Main->run()
#7 {main}
[24-Feb-2014 19:15:39] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'tl_tag.tid' in 'field list' (SELECT tl_tag.tid FROM tl_tag, tl_page WHERE tl_tag.tid = tl_page.id AND tl_page.tstamp = 0)' thrown in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php on line 346
#0 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php(261): Contao\Database\Statement->query()
#1 /Applications/MAMP/htdocs/system/modules/tags/classes/TagHelper.php(121): Contao\Database\Statement->execute()
#2 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(2851): Contao\TagHelper->deleteIncompleteRecords('tl_page', Array, NULL, Array)
#3 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(309): Contao\DC_Table->reviseTable()
#4 /Applications/MAMP/htdocs/system/modules/core/classes/Backend.php(424): Contao\DC_Table->showAll()
#5 /Applications/MAMP/htdocs/contao/main.php(129): Contao\Backend->getBackendModule('page')
#6 /Applications/MAMP/htdocs/contao/main.php(271): Main->run()
#7 {main}
[24-Feb-2014 19:16:29] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'tl_tag.tid' in 'field list' (SELECT tl_tag.tid FROM tl_tag, tl_page WHERE tl_tag.tid = tl_page.id AND tl_page.tstamp = 0)' thrown in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php on line 346
#0 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php(261): Contao\Database\Statement->query()
#1 /Applications/MAMP/htdocs/system/modules/tags/classes/TagHelper.php(121): Contao\Database\Statement->execute()
#2 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(2851): Contao\TagHelper->deleteIncompleteRecords('tl_page', Array, NULL, Array)
#3 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(309): Contao\DC_Table->reviseTable()
#4 /Applications/MAMP/htdocs/system/modules/core/classes/Backend.php(424): Contao\DC_Table->showAll()
#5 /Applications/MAMP/htdocs/contao/main.php(129): Contao\Backend->getBackendModule('page')
#6 /Applications/MAMP/htdocs/contao/main.php(271): Main->run()
#7 {main}
[24-Feb-2014 19:23:10] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Duplicate entry '205' for key 'PRIMARY' (ALTER TABLE `tl_tag` ADD PRIMARY KEY (`id`);)' thrown in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php on line 346
#0 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database.php(228): Contao\Database\Statement->query('ALTER TABLE `tl...')
#1 /Applications/MAMP/htdocs/contao/install.php(197): Contao\Database->query('ALTER TABLE `tl...')
#2 /Applications/MAMP/htdocs/contao/install.php(971): InstallTool->run()
#3 {main}
[24-Feb-2014 19:27:13] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'tl_tag.tid' in 'field list' (SELECT tl_tag.tid FROM tl_tag, tl_page WHERE tl_tag.tid = tl_page.id AND tl_page.tstamp = 0)' thrown in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php on line 346
#0 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php(261): Contao\Database\Statement->query()
#1 /Applications/MAMP/htdocs/system/modules/tags/classes/TagHelper.php(121): Contao\Database\Statement->execute()
#2 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(2851): Contao\TagHelper->deleteIncompleteRecords('tl_page', Array, NULL, Array)
#3 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(309): Contao\DC_Table->reviseTable()
#4 /Applications/MAMP/htdocs/system/modules/core/classes/Backend.php(424): Contao\DC_Table->showAll()
#5 /Applications/MAMP/htdocs/contao/main.php(129): Contao\Backend->getBackendModule('page')
#6 /Applications/MAMP/htdocs/contao/main.php(271): Main->run()
#7 {main}
[24-Feb-2014 19:29:07] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'tl_tag.tid' in 'field list' (SELECT tl_tag.tid FROM tl_tag, tl_article WHERE tl_tag.tid = tl_article.id AND tl_article.tstamp = 0)' thrown in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php on line 346
#0 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php(261): Contao\Database\Statement->query()
#1 /Applications/MAMP/htdocs/system/modules/tags/classes/TagHelper.php(121): Contao\Database\Statement->execute()
#2 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(2851): Contao\TagHelper->deleteIncompleteRecords('tl_article', Array, 'tl_page', Array)
#3 /Applications/MAMP/htdocs/system/modules/core/drivers/DC_Table.php(309): Contao\DC_Table->reviseTable()
#4 /Applications/MAMP/htdocs/system/modules/core/classes/Backend.php(424): Contao\DC_Table->showAll()
#5 /Applications/MAMP/htdocs/contao/main.php(129): Contao\Backend->getBackendModule('article')
#6 /Applications/MAMP/htdocs/contao/main.php(271): Main->run()
#7 {main}
[24-Feb-2014 19:29:19] PHP Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 53 bytes) in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Model.php on line 114
[24-Feb-2014 19:30:23] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Duplicate entry '205' for key 'PRIMARY' (ALTER TABLE `tl_tag` ADD PRIMARY KEY (`id`);)' thrown in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php on line 346
#0 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database.php(228): Contao\Database\Statement->query('ALTER TABLE `tl...')
#1 /Applications/MAMP/htdocs/system/modules/repository/classes/RepositoryManager.php(466): Contao\Database->query('ALTER TABLE `tl...')
#2 /Applications/MAMP/htdocs/system/modules/repository/classes/RepositoryBackendModule.php(150): RepositoryManager->update('database')
#3 /Applications/MAMP/htdocs/system/modules/core/classes/BackendModule.php(100): RepositoryBackendModule->compile()
#4 /Applications/MAMP/htdocs/system/modules/repository/classes/RepositoryBackendModule.php(72): Contao\BackendModule->generate()
#5 /Applications/MAMP/htdocs/system/modules/repository/classes/RepositoryManager.php(50): RepositoryBackendModule->generate()
#6 /Applications/MAMP/htdocs/system/modules/core/classes/Backend.php(266): RepositoryManager->generate()
#7 /Applications/MAMP/htdocs/contao/main.php(129): Contao\Backend->getBackendModule('repository_mana...')
#8 /Applications/MAMP/htdocs/contao/main.php(271): Main->run()
#9 {main}
[24-Feb-2014 19:32:00] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Duplicate entry '205' for key 'PRIMARY' (ALTER TABLE `tl_tag` ADD PRIMARY KEY (`id`);)' thrown in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php on line 346
#0 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database.php(228): Contao\Database\Statement->query('ALTER TABLE `tl...')
#1 /Applications/MAMP/htdocs/system/modules/repository/classes/RepositoryManager.php(466): Contao\Database->query('ALTER TABLE `tl...')
#2 /Applications/MAMP/htdocs/system/modules/repository/classes/RepositoryBackendModule.php(150): RepositoryManager->update('database')
#3 /Applications/MAMP/htdocs/system/modules/core/classes/BackendModule.php(100): RepositoryBackendModule->compile()
#4 /Applications/MAMP/htdocs/system/modules/repository/classes/RepositoryBackendModule.php(72): Contao\BackendModule->generate()
#5 /Applications/MAMP/htdocs/system/modules/repository/classes/RepositoryManager.php(50): RepositoryBackendModule->generate()
#6 /Applications/MAMP/htdocs/system/modules/core/classes/Backend.php(266): RepositoryManager->generate()
#7 /Applications/MAMP/htdocs/contao/main.php(129): Contao\Backend->getBackendModule('repository_mana...')
#8 /Applications/MAMP/htdocs/contao/main.php(271): Main->run()
#9 {main}
[24-Feb-2014 19:32:03] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Duplicate entry '205' for key 'PRIMARY' (ALTER TABLE `tl_tag` ADD PRIMARY KEY (`id`);)' thrown in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php on line 346
#0 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database.php(228): Contao\Database\Statement->query('ALTER TABLE `tl...')
#1 /Applications/MAMP/htdocs/system/modules/repository/classes/RepositoryManager.php(466): Contao\Database->query('ALTER TABLE `tl...')
#2 /Applications/MAMP/htdocs/system/modules/repository/classes/RepositoryBackendModule.php(150): RepositoryManager->update('database')
#3 /Applications/MAMP/htdocs/system/modules/core/classes/BackendModule.php(100): RepositoryBackendModule->compile()
#4 /Applications/MAMP/htdocs/system/modules/repository/classes/RepositoryBackendModule.php(72): Contao\BackendModule->generate()
#5 /Applications/MAMP/htdocs/system/modules/repository/classes/RepositoryManager.php(50): RepositoryBackendModule->generate()
#6 /Applications/MAMP/htdocs/system/modules/core/classes/Backend.php(266): RepositoryManager->generate()
#7 /Applications/MAMP/htdocs/contao/main.php(129): Contao\Backend->getBackendModule('repository_mana...')
#8 /Applications/MAMP/htdocs/contao/main.php(271): Main->run()
#9 {main}
[24-Feb-2014 19:35:56] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Duplicate key name 'pid_name' (ALTER TABLE `tl_files` ADD UNIQUE KEY `pid_name` (`pid`, `name`))' thrown in /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Statement.php on line 346
#0 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database.php(228): Contao\Database\Statement->query('ALTER TABLE `tl...')
#1 /Applications/MAMP/htdocs/system/modules/core/library/Contao/Database/Updater.php(470): Contao\Database->query('ALTER TABLE `tl...')
#2 /Applications/MAMP/htdocs/contao/install.php(956): Contao\Database\Updater->run31Update()
#3 /Applications/MAMP/htdocs/contao/install.php(530): InstallTool->update31()
#4 /Applications/MAMP/htdocs/contao/install.php(181): InstallTool->runDatabaseUpdates()
#5 /Applications/MAMP/htdocs/contao/install.php(971): InstallTool->run()
#6 {main}
14. Mal versucht den Suchindex neu aufzubauen. Da tat sich nix nur eine weisse Seite baute sich auf.
15. Die Forntendvorschau aufgerufen (unveröffentlichte Elemente anzeigen) und trotzdem Fehlermeldung erhalten: Forward page not found
16. aufgegeben.
Was mache ich falsch bzw. wo liegt der Fehler?
Angehängte Grafiken
Bildschirmfoto 2014-02-24 um 20.27.51.png
(91,1 KB)Bildschirmfoto 2014-02-24 um 20.28.44.png
(22,0 KB)Bildschirmfoto 2014-02-24 um 20.35.01.png
(50,1 KB)
Bildschirmfoto 2014-02-24 um 20.30.40.png
(87,0 KB)