Hallo,
ich hoffe der Thread hier ist noch aktuell ... folgendes Problem tritt seit kurzem auf:
Setup:
Contao 3.5.28
cm_membergooglemaps 1.8.1 / 34
memberlist 1.3.2 / 10
PHP 5.6
Das Modul ist [Mitglieder mit Google Maps] mit aktivierter Umkreissuche. Und diese funktioniert nicht mehr, es werden einfach alle Marker gezeigt.
Im Errorlog stehen diese Fehler:
Code:
[19-Sep-2017 12:43:10 Europe/Berlin] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''A=0 LIMIT 0,10' at line 1 (SELECT id, alias,username, publicFields, groups, company, street, postal, city, website, cm_membergooglemaps_coords, cm_membergooglemaps_allowmap FROM tl_member WHERE (groups LIKE '%\"4\"%') AND (groups LIKE '%\"4\"%') AND publicFields!='' AND disable!=1 AND (start='' OR start<=1505817790) AND (stop='' OR stop>=1505817790) ORDER BY 'A=0 LIMIT 0,10)' thrown in /is/htdocs/.../system/modules/core/library/Contao/Database/Statement.php on line 295
#0 /is/htdocs/.../system/modules/core/library/Contao/Database/Statement.php(264): Contao\Database\Statement->query()
#1 /is/htdocs/.../system/modules/cm_membergooglemaps/modules/ModuleMemberGoogleMapsTags.php(638): Contao\Database\Statement->execute(Array)
#2 /is/htdocs/.../system/modules/memberlist/modules/ModuleMemberlist.php(80): ChrMue\cm_MemberGoogleMaps\ModuleMemberGoogleMapsTags->listAllMembers()
#3 /is/htdocs/.../system/modules/cm_membergooglemaps/modules/ModuleMemberGoogleMapsTags.php(155): Contao\ModuleMemberlist->compile()
#4 /is/htdocs/.../system/modules/core/modules/Module.php(287): ChrMue\cm_MemberGoogleMaps\ModuleMemberGoogleMapsTags->compile()
#5 /is/htdocs/.../system/modules/memberlist/modules/ModuleMemberlist.php(61): Contao\Module->generate()
#6 /is/htdocs/.../system/modules/cm_membergooglemaps/modules/ModuleMemberGoogleMapsTags.php(138): Contao\ModuleMemberlist->generate()
#7 /is/htdocs/.../system/modules/core/elements/ContentModule.php(59): ChrMue\cm_MemberGoogleMaps\ModuleMemberGoogleMapsTags->generate()
#8 /is/htdocs/.../system/modules/core/library/Contao/Controller.php(484): Contao\ContentModule->generate()
#9 /is/htdocs/.../system/modules/core/modules/ModuleArticle.php(213): Contao\Controller::getContentElement(Object(Contao\ContentModel), 'main')
#10 /is/htdocs/.../system/modules/core/modules/Module.php(287): Contao\ModuleArticle->compile()
#11 /is/htdocs/.../system/modules/core/modules/ModuleArticle.php(67): Contao\Module->generate()
#12 /is/htdocs/.../system/modules/core/library/Contao/Controller.php(417): Contao\ModuleArticle->generate(false)
#13 /is/htdocs/.../system/modules/core/library/Contao/Controller.php(277): Contao\Controller::getArticle(Object(Contao\ArticleModel), false, false, 'main')
#14 /is/htdocs/.../system/modules/core/pages/PageRegular.php(133): Contao\Controller::getFrontendModule('0', 'main')
#15 /is/htdocs/.../index.php(256): Contao\PageRegular->generate(Object(Contao\PageModel), true)
#16 /is/htdocs/.../index.php(440): Index->run()
#17 {main}
[19-Sep-2017 12:43:17 Europe/Berlin] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''A=0' at line 1 (SELECT id, alias,username, publicFields, groups, company, street, postal, city, website, cm_membergooglemaps_coords, cm_membergooglemaps_allowmap FROM tl_member WHERE (groups LIKE '%\"4\"%') AND (groups LIKE '%\"4\"%') AND publicFields!='' AND disable!=1 AND (start='' OR start<=1505817797) AND (stop='' OR stop>=1505817797) ORDER BY company asc LIMIT 0,10'A=0)' thrown in /is/htdocs/.../system/modules/core/library/Contao/Database/Statement.php on line 295
#0 /is/htdocs/.../system/modules/core/library/Contao/Database/Statement.php(264): Contao\Database\Statement->query()
#1 /is/htdocs/.../system/modules/cm_membergooglemaps/modules/ModuleMemberGoogleMapsTags.php(638): Contao\Database\Statement->execute(Array)
#2 /is/htdocs/.../system/modules/memberlist/modules/ModuleMemberlist.php(80): ChrMue\cm_MemberGoogleMaps\ModuleMemberGoogleMapsTags->listAllMembers()
#3 /is/htdocs/.../system/modules/cm_membergooglemaps/modules/ModuleMemberGoogleMapsTags.php(155): Contao\ModuleMemberlist->compile()
#4 /is/htdocs/.../system/modules/core/modules/Module.php(287): ChrMue\cm_MemberGoogleMaps\ModuleMemberGoogleMapsTags->compile()
#5 /is/htdocs/.../system/modules/memberlist/modules/ModuleMemberlist.php(61): Contao\Module->generate()
#6 /is/htdocs/.../system/modules/cm_membergooglemaps/modules/ModuleMemberGoogleMapsTags.php(138): Contao\ModuleMemberlist->generate()
#7 /is/htdocs/.../system/modules/core/elements/ContentModule.php(59): ChrMue\cm_MemberGoogleMaps\ModuleMemberGoogleMapsTags->generate()
#8 /is/htdocs/.../system/modules/core/library/Contao/Controller.php(484): Contao\ContentModule->generate()
#9 /is/htdocs/.../system/modules/core/modules/ModuleArticle.php(213): Contao\Controller::getContentElement(Object(Contao\ContentModel), 'main')
#10 /is/htdocs/.../system/modules/core/modules/Module.php(287): Contao\ModuleArticle->compile()
#11 /is/htdocs/.../system/modules/core/modules/ModuleArticle.php(67): Contao\Module->generate()
#12 /is/htdocs/.../system/modules/core/library/Contao/Controller.php(417): Contao\ModuleArticle->generate(false)
#13 /is/htdocs/.../system/modules/core/library/Contao/Controller.php(277): Contao\Controller::getArticle(Object(Contao\ArticleModel), false, false, 'main')
#14 /is/htdocs/.../system/modules/core/pages/PageRegular.php(133): Contao\Controller::getFrontendModule('0', 'main')
#15 /is/htdocs/.../index.php(256): Contao\PageRegular->generate(Object(Contao\PageModel), true)
#16 /is/htdocs/.../index.php(440): Index->run()
#17 {main}
Ich sehe dort einen String (?), der den Query zerstört - aber wo kann der herkommen, und wieso steht er an verschiedenen Stellen?
Für jeden Denkanstoss wäre ich extremst dankbar.
Lesezeichen