Nach Google Maps installation wird die Seite und dfas backend nicht mehr angezeigt.

Version 3.5.36

Bei der Ausführung des Skriptes ist ein Fehler aufgetreten. Irgendetwas funktioniert nicht richtig.

Mit der Fehlermeldung in der Error.log datei komm ich nicht weiter.

Kann ich direkt in der Installation auf dem FTP-Server was machen, damit das Backend wieder aufrufbar ist?

Code:

[26-Nov-2018 12:40:44 Europe/Berlin] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Table 'db310228.tl_dlh_googlemaps_elements' doesn't exist (DELETE FROM tl_dlh_googlemaps_elements WHERE NOT EXISTS (SELECT * FROM tl_dlh_googlemaps WHERE tl_dlh_googlemaps_elements.pid = tl_dlh_googlemaps.id))' thrown in /kunden/310228_60437/webseiten/Contao/system/modules/core/library/Contao/Database/Statement.php on line 295 #0 /kunden/310228_60437/webseiten/Contao/system/modules/core/library/Contao/Database/Statement.php(264): Contao\Database\Statement->query() #1 /kunden/310228_60437/webseiten/Contao/system/modules/core/library/Contao/Database.php(194): Contao\Database\Statement->execute() #2 /kunden/310228_60437/webseiten/Contao/system/modules/core/drivers/DC_Table.php(3216): Contao\Database->execute('DELETE FROM tl_...') #3 /kunden/310228_60437/webseiten/Contao/system/modules/core/drivers/DC_Table.php(336): Contao\DC_Table->reviseTable() #4 /kunden/310228_60437/webseiten/Contao/system/modules/core/classes/Backend.php(650): Contao\DC_Table->showAll() #5 /kunden/310228_60437/webseiten/Contao/system/modules/core/controllers/BackendMain.php(131): Contao\Backend->getBackendModule('dlh_googlemaps') #6 /kunden/310228_60437/webseiten/Contao/contao/main.php(20): Contao\BackendMain->run() #7 {main} [26-Nov-2018 12:40:53 Europe/Berlin] PHP 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 FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id IN(123,0,0,0,122) ORDER BY FIND_IN_SET(tl_module.id, '123,0,0,0,122'))' thrown in /kunden/310228_60437/webseiten/Contao/system/modules/core/library/Contao/Database/Statement.php on line 295 #0 /kunden/310228_60437/webseiten/Contao/system/modules/core/library/Contao/Database/Statement.php(264): Contao\Database\Statement->query() #1 /kunden/310228_60437/webseiten/Contao/system/modules/core/library/Contao/Model.php(1095): Contao\Database\Statement->execute(NULL) #2 /kunden/310228_60437/webseiten/Contao/system/modules/core/library/Contao/Model.php(890): Contao\Model::find(Array) #3 /kunden/310228_60437/webseiten/Contao/system/modules/core/pages/PageRegular.php(83): Contao\Model::findMultipleByIds(Array) #4 /kunden/310228_60437/webseiten/Contao/system/modules/core/controllers/FrontendIndex.php(285): Contao\PageRegular->generate(Object(Contao\PageModel), true) #5 /kunden/310228_60437/webseiten/Contao/index.php(20): Contao\FrontendIndex->run() #6 {main} [26-Nov-2018 12:41:38 Europe/Berlin] PHP 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 FROM tl_module LEFT JOIN tl_page j1 ON tl_module.jumpTo=j1.id WHERE tl_module.id IN(123,0,0,0,122) ORDER BY FIND_IN_SET(tl_module.id, '123,0,0,0,122'))' thrown in /kunden/310228_60437/webseiten/Contao/system/modules/core/library/Contao/Database/Statement.php on line 295 #0 /kunden/310228_60437/webseiten/Contao/system/modules/core/library/Contao/Database/Statement.php(264): Contao\Database\Statement->query() #1 /kunden/310228_60437/webseiten/Contao/system/modules/core/library/Contao/Model.php(1095): Contao\Database\Statement->execute(NULL) #2 /kunden/310228_60437/webseiten/Contao/system/modules/core/library/Contao/Model.php(890): Contao\Model::find(Array) #3 /kunden/310228_60437/webseiten/Contao/system/modules/core/pages/PageRegular.php(83): Contao\Model::findMultipleByIds(Array) #4 /kunden/310228_60437/webseiten/Contao/system/modules/core/controllers/FrontendIndex.php(285): Contao\PageRegular->generate(Object(Contao\PageModel), true) #5 /kunden/310228_60437/webseiten/Contao/index.php(20): Contao\FrontendIndex->run() #6 {main}

:rolleyes:

Nach der Installation einer Extension musst du das Install Tool aufrufen. Die Datenbankaktualisierung fehlt in deinem Fall.

Google Maps Fehlermeldung

Zitat:

Zitat von Spooky

Nach der Installation einer Extension musst du das Install Tool aufrufen. Die Datenbankaktualisierung fehlt in deinem Fall.

Super danke, das war es.....

Google Maps Problem

ich möchte die Karte auf folgender Seite anpassen: http://www.bz-a.de/Contao/kontakt-ar...zahradnik.html

Ich möchte in der Karte lediglich die Adresse anpassen!???

Selbst wenn die die identischen HTML Einträge doppele zeigt sich die zweite Karte als Text!

Danke im Voraus

Warum doppelst du HTML Einträge? Die Karten und deren Einstellungen verwaltest du über das Backend.

Zitat:

Zitat von Spooky

Warum doppelst du HTML Einträge? Die Karten und deren Einstellungen verwaltest du über das Backend.

Die Karte von Hannover ist im Theme enthalten. Ich wollte jetzt die Adresse meines Kunden dort austauschen.

In Google Maps habe ich die GPS Daten herauskopiert und wollte diese dann austauschen. Das funktioniert über diesen Weg nicht.

Hast du einen Tipp wie ich am besten die Adresse in der bestehenden Karte austausche?

Die Karte ist als Element eingebaut:

HTML-Code:

<div class="dlh_googlemap"> <iframe width="1000" height="600" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://www.google.de/maps?f=q[&]source=s_q[&]hl=de[&]geocode=[&]q=hannover[&]aq=[&]sll=52.340077,9.823602[&]sspn=0.744224,1.783905[&]ie=UTF8[&]hq=[&]hnear=Hannover,+Niedersachsen[&]t=m[&]ll=52.375809,9.73217[&]spn=0.062877,0.242043[&]z=12[&]iwloc=A[&]output=embed"></iframe> </div>

Nach dem du dir jetzt schon dlh_googlemaps installiert hast: baue dir einfach eine neue Karte mit der richtigen Adresse.

Zitat:

Zitat von Spooky

Nach dem du dir jetzt schon dlh_googlemaps installiert hast: baue dir einfach eine neue Karte mit der richtigen Adresse.

okay ich dachte ich könnte das umgehen ;-)