Datenbankfehler bei googlemaps 2.2.0 und Contao 3.5.17

**closeup** · 08.10.2016, 16:04

Hallo zusammen,

hatte vorher Contao 3.5.15 und die Erweiterung dlh_googlemaps in der Version 2.1.1 laufen.

Nach den Update auf Contao 3.5.17 und dlh_googlemaps 2.2.0 erhalte ich beim Aufruf des Frontends folgende Fehlermeldung:

Code:

Fatal error: Uncaught exception Exception with message Query error: Unknown column 'j1.dlh_googlemaps_apikey' in 'field list' (SELECT tl_module.*, j1.id AS jumpTo__id, j1.pid AS jumpTo__pid, j1.sorting AS jumpTo__sorting, j1.tstamp AS jumpTo__tstamp, j1.title AS jumpTo__title, j1.alias AS jumpTo__alias, j1.type AS jumpTo__type, j1.pageTitle AS jumpTo__pageTitle, j1.language AS jumpTo__language, j1.robots AS jumpTo__robots, j1.description AS jumpTo__description, j1.redirect AS jumpTo__redirect, j1.jumpTo AS jumpTo__jumpTo, j1.url AS jumpTo__url, j1.target AS jumpTo__target, j1.dns AS jumpTo__dns, j1.staticFiles AS jumpTo__staticFiles, j1.staticPlugins AS jumpTo__staticPlugins, j1.fallback AS jumpTo__fallback, j1.adminEmail AS jumpTo__adminEmail, j1.dateFormat AS jumpTo__dateFormat, j1.timeFormat AS jumpTo__timeFormat, j1.datimFormat AS jumpTo__datimFormat, j1.createSitemap AS jumpTo__createSitemap, j1.sitemapName AS jumpTo__sitemapName, j1.useSSL AS jumpTo__useSSL, j1.autoforward AS jumpTo__autoforward, j1.protected AS jumpTo__protected, j1.groups AS jumpTo__groups, j1.includeLayout AS jumpTo__includeLayout, j1.layout AS jumpTo__layout, j1.mobileLayout AS jumpTo__mobileLayout, j1.includeCache AS jumpTo__includeCache, j1.cache AS jumpTo__cache, j1.includeChmod AS jumpTo__includeChmod, j1.cuser AS jumpTo__cuser, j1.cgroup AS jumpTo__cgroup, j1.chmod AS jumpTo__chmod, j1.noSearch AS jumpTo__noSearch, j1.cssClass AS jumpTo__cssClass, j1.sitemap AS jumpTo__sitemap, j1.hide AS jumpTo__hide, j1.guests AS jumpTo__guests, j1.tabindex AS jumpTo__tabindex, j1.accesskey AS jumpTo__accesskey, j1.published AS jumpTo__published, j1.start AS jumpTo__start, j1.stop AS jumpTo__stop, j1.dlh_googlemaps_apikey AS jumpTo__dlh_googlemaps_apikey, j1.ga_analyticsid AS jumpTo__ga_analyticsid, j1.ga_anonymizeip AS jumpTo__ga_anonymizeip, j1.ga_ignoreadmins AS jumpTo__ga_ignoreadmins, j1.ga_ignoremembers AS jumpTo__ga_ignoremembers, j1.ga_externaltracking AS jumpTo__ga_externaltracking, j1.ga_addlinktracking AS jumpTo__ga_addlinktracking, j1.ga_setdomainname AS jumpTo__ga_setdomainname, j1.ga_titlelinktracking AS jumpTo__ga_titlelinktracking, j1.ga_bounceseconds AS jumpTo__ga_bounceseconds, j1.ga_eventtracking AS jumpTo__ga_eventtracking FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id IN(4,1,0,3,23,6) ORDER BY FIND_IN_SET(tl_module.id, '4,1,0,3,23,6')) thrown in system/modules/core/library/Contao/Database/Statement.php on line 295
#0 system/modules/core/library/Contao/Database/Statement.php(264): Contao\Database\Statement->query()
#1 system/modules/core/library/Contao/Model.php(1082): Contao\Database\Statement->execute(NULL)
#2 system/modules/core/library/Contao/Model.php(883): Contao\Model::find(Array)
#3 system/modules/core/pages/PageRegular.php(83): Contao\Model::findMultipleByIds(Array)
#4 system/modules/core/controllers/FrontendIndex.php(285): Contao\PageRegular->generate(Object(Contao\PageModel), true)
#5 index.php(20): Contao\FrontendIndex->run()
#6 {main}

Klickt man im Backend auf das Googlemaps-Modul erscheint folgender Fehler:

Code:

Fatal error: Uncaught exception Exception with message Query error: Table 'DB1543416.tl_dlh_googlemaps' doesn't exist (DELETE FROM tl_dlh_googlemaps WHERE id IN(1,2) AND tstamp=0) thrown in system/modules/core/library/Contao/Database/Statement.php on line 295
#0 system/modules/core/library/Contao/Database/Statement.php(264): Contao\Database\Statement->query()
#1 system/modules/core/library/Contao/Database.php(194): Contao\Database\Statement->execute()
#2 system/modules/core/drivers/DC_Table.php(3171): Contao\Database->execute('DELETE FROM tl_...')
#3 system/modules/core/drivers/DC_Table.php(336): Contao\DC_Table->reviseTable()
#4 system/modules/core/classes/Backend.php(650): Contao\DC_Table->showAll()
#5 system/modules/core/controllers/BackendMain.php(131): Contao\Backend->getBackendModule('dlh_googlemaps')
#6 contao/main.php(20): Contao\BackendMain->run()
#7 {main}

Hattet ihr ähnliche Probleme bei Update oder Ideen wie man das beheben kann?

**Spooky** · 08.10.2016, 16:35

Hast du die Datenbank aktualisiert?

**closeup** · 08.10.2016, 16:49

Danke für den Hinweis. Vermutlich lag darin der Fehler.
Hatte die Datenbank eigentlich aktualisiert, nachdem ich nun nochmal im Backend auf "Datenbank aktualisieren" gegangen bin, hat es funktioniert.
Sowohl Frontend als auch die Erweiterung im Backend sind nun aufrufbar.