Inst Google Analytics für Contao 3.3.6 'repository_unsafe_catalog'

[Metromedia]

Hallo Contao Freunde

Ich habe in der Version 3.3.6 das noch nicht erprobte Modul Google Analytics installiert und einen vollen Absturz eingefahren. Nicht Anfängerpech aber schon sehr unvorsichtig.

Back und Frontend ist tot Auch contao/install.php funkt nicht mehr. Ha jemand eine Idee um eine Neuinstallation zu vermeiden und die bereits gemachte Arbeit nicht zu verlieren.


Ich habe im File localconfig.php diesen Eintag:
$GLOBALS['TL_CONFIG']['repository_unsafe_catalog'] = true;


und folgendes error log.


[22-Nov-2014 11:26:47 GMT] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'j1.ga_analyticsid' 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.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(24,47,1,2,28,0,0,61,38,66) ORDER BY FIND_IN_SET(tl_module.id, '24,47,1,2,28,0,0,61,38,66'))' thrown in /var/www/vhosts/erotic-club25.ch/httpdocs/system/modules/core/library/Contao/Database/Statement.php on line 283
#0 /var/www/vhosts/erotic-club25.ch/httpdocs/system/modules/core/library/Contao/Database/Statement.php(254): Contao\Database\Statement->query()
#1 /var/www/vhosts/erotic-club25.ch/httpdocs/system/modules/core/library/Contao/Model.php(952): Contao\Database\Statement->execute(NULL)
#2 /var/www/vhosts/erotic-club25.ch/httpdocs/system/modules/core/library/Contao/Model.php(760): Contao\Model::find(Array)
#3 /var/www/vhosts/erotic-club25.ch/httpdocs/system/modules/core/pages/PageRegular.php(88): Contao\Model::findMultipleByIds(Array)
#4 /var/www/vhosts/erotic-club25.ch/httpdocs/index.php(260): Contao\PageRegular->generate(Object(Contao\PageModel), true)
#5 /var/www/vhosts/erotic-club25.ch/httpdocs/index.php(444): Index->run()
#6 {main}
[22-Nov-2014 11:26:50 GMT] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'j1.ga_analyticsid' 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.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(24,47,1,2,28,0,0,61,38,66) ORDER BY FIND_IN_SET(tl_module.id, '24,47,1,2,28,0,0,61,38,66'))' thrown in /var/www/vhosts/erotic-club25.ch/httpdocs/system/modules/core/library/Contao/Database/Statement.php on line 283
#0 /var/www/vhosts/erotic-club25.ch/httpdocs/system/modules/core/library/Contao/Database/Statement.php(254): Contao\Database\Statement->query()
#1 /var/www/vhosts/erotic-club25.ch/httpdocs/system/modules/core/library/Contao/Model.php(952): Contao\Database\Statement->execute(NULL)
#2 /var/www/vhosts/erotic-club25.ch/httpdocs/system/modules/core/library/Contao/Model.php(760): Contao\Model::find(Array)
#3 /var/www/vhosts/erotic-club25.ch/httpdocs/system/modules/core/pages/PageRegular.php(88): Contao\Model::findMultipleByIds(Array)
#4 /var/www/vhosts/erotic-club25.ch/httpdocs/index.php(260): Contao\PageRegular->generate(Object(Contao\PageModel), true)
#5 /var/www/vhosts/erotic-club25.ch/httpdocs/index.php(444): Index->run()
#6 {main}

[tab]

Spontan würde ich sagen: Den Ordner des Moduls unter system/modules löschen oder eine Datei namens ".skip" in den Ordner des Moduls legen. Dann, falls das nicht so schon reicht, nochmal install.php aufrufen und die Datenbank aktualisieren lassen.

[magicsepp]

entweder mit myphpadmin die Spalte ga_analyticsid' in tl_module. hinzufügen und sehen was dann passiert oder im modules/analytics oder wie das genau heisst* eine .skip Datei anlegen damit die Erweiterung erstmal inaktiv ist.

[Metromedia]

Vielen Dank schon mal vorerst
Gelöscht habe ich das Modul. Die skip Datei? Wie sieht die aus?

entweder mit myphpadmin die Spalte ga_analyticsid' in tl_module. hinzufügen und sehen was dann passiert oder im modules/analytics oder wie das genau heisst* eine .skip Datei anlegen damit die Erweiterung erstmal inaktiv ist.

[tab]

Das ist egal, Hauptsache sie heisst .skip
Aber wenn du das Modul schon gelöscht hast, dann brauchst du die wohl nicht mehr. Die wird ja nur benutzt, damit man das Verzeichnis nicht gleich löschen muss, um die Erweiterung zu deaktivieren.

[Metromedia]

Und es funkt wieder

Besen Dank für die rasche Hilfe und lieber Gruss aus dem nebligen Zürich

entweder mit myphpadmin die Spalte ga_analyticsid' in tl_module. hinzufügen und sehen was dann passiert oder im modules/analytics oder wie das genau heisst* eine .skip Datei anlegen damit die Erweiterung erstmal inaktiv ist.