Liebe Community,
da ich mit diesem Problem schon länger beschäftigt bin und ich keinen passenden Beitrag gefunden habe, hier meine Frage:
Ich habe die Erweiterung fp_setPublicFields installiert (Contao 2.11.4), weil ich die Mitgliederliste auf einer Seite ausgeben möchte, ohne zu warten, wann ein Benutzer seine Felder für die Öffentlichkeit freigibt.
Nach der Installation passe ich noch (wie im ER beschrieben) die config.php an und bekomme dann folgende Fehlermeldungen:
Warning: Invalid argument supplied for foreach() in /share/MD0_DATA/Qweb/intranet/system/libraries/Database.php on line 729
#0 /share/MD0_DATA/Qweb/intranet/system/libraries/Database.php(729): __error(2, 'Invalid argumen...', '/share/MD0_DATA...', 729, Array)
#1 /share/MD0_DATA/Qweb/intranet/system/libraries/Database.php(559): Database_Statement->escapeParams('publicFields')
#2 /share/MD0_DATA/Qweb/intranet/system/modules/registrationPublicFields/registrationPublicFields.php(41): Database_Statement->set('publicFields', Array)
#3 /share/MD0_DATA/Qweb/intranet/system/modules/registration/ModuleRegistration.php(457): registrationPublicFields->setPublicFields(24, Array, Object(ModuleRegistrationExtended))
#4 /share/MD0_DATA/Qweb/intranet/system/modules/registration/ModuleRegistration.php(290): ModuleRegistration->createNewUser(Array)
#5 /share/MD0_DATA/Qweb/intranet/system/modules/xtmembers/ModuleRegistrationExtended.php(65): ModuleRegistration->compile()
#6 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/Module.php(140): ModuleRegistrationExtended->compile()
#7 /share/MD0_DATA/Qweb/intranet/system/modules/registration/ModuleRegistration.php(77): Module->generate()
#8 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/ContentModule.php(72): ModuleRegistration->generate()
#9 /share/MD0_DATA/Qweb/intranet/system/libraries/Controller.php(511): ContentModule->generate()
#10 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/ModuleArticle.php(194): Controller->getContentElement('192')
#11 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/Module.php(140): ModuleArticle->compile()
#12 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/ModuleArticle.php(71): Module->generate()
#13 /share/MD0_DATA/Qweb/intranet/system/libraries/Controller.php(443): ModuleArticle->generate(false)
#14 /share/MD0_DATA/Qweb/intranet/system/libraries/Controller.php(307): Controller->getArticle('81', false, false, 'main')
#15 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/PageRegular.php(100): Controller->getFrontendModule('0', 'main')
#16 /share/MD0_DATA/Qweb/intranet/index.php(266): PageRegular->generate(Object(DB_Mysql_Result))
#17 /share/MD0_DATA/Qweb/intranet/index.php(401): Index->run()
#18 {main}
Warning: Invalid argument supplied for foreach() in /share/MD0_DATA/Qweb/intranet/system/libraries/Database.php on line 574
#0 /share/MD0_DATA/Qweb/intranet/system/libraries/Database.php(574): __error(2, 'Invalid argumen...', '/share/MD0_DATA...', 574, Array)
#1 /share/MD0_DATA/Qweb/intranet/system/modules/registrationPublicFields/registrationPublicFields.php(41): Database_Statement->set('publicFields', Array)
#2 /share/MD0_DATA/Qweb/intranet/system/modules/registration/ModuleRegistration.php(457): registrationPublicFields->setPublicFields(24, Array, Object(ModuleRegistrationExtended))
#3 /share/MD0_DATA/Qweb/intranet/system/modules/registration/ModuleRegistration.php(290): ModuleRegistration->createNewUser(Array)
#4 /share/MD0_DATA/Qweb/intranet/system/modules/xtmembers/ModuleRegistrationExtended.php(65): ModuleRegistration->compile()
#5 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/Module.php(140): ModuleRegistrationExtended->compile()
#6 /share/MD0_DATA/Qweb/intranet/system/modules/registration/ModuleRegistration.php(77): Module->generate()
#7 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/ContentModule.php(72): ModuleRegistration->generate()
#8 /share/MD0_DATA/Qweb/intranet/system/libraries/Controller.php(511): ContentModule->generate()
#9 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/ModuleArticle.php(194): Controller->getContentElement('192')
#10 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/Module.php(140): ModuleArticle->compile()
#11 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/ModuleArticle.php(71): Module->generate()
#12 /share/MD0_DATA/Qweb/intranet/system/libraries/Controller.php(443): ModuleArticle->generate(false)
#13 /share/MD0_DATA/Qweb/intranet/system/libraries/Controller.php(307): Controller->getArticle('81', false, false, 'main')
#14 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/PageRegular.php(100): Controller->getFrontendModule('0', 'main')
#15 /share/MD0_DATA/Qweb/intranet/index.php(266): PageRegular->generate(Object(DB_Mysql_Result))
#16 /share/MD0_DATA/Qweb/intranet/index.php(401): Index->run()
#17 {main}
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 'WHERE id=24' at line 1 (UPDATE tl_memeber SET WHERE id=24) thrown in /share/MD0_DATA/Qweb/intranet/system/libraries/Database.php on line 686
#0 /share/MD0_DATA/Qweb/intranet/system/libraries/Database.php(633): Database_Statement->query()
#1 /share/MD0_DATA/Qweb/intranet/system/modules/registrationPublicFields/registrationPublicFields.php(41): Database_Statement->execute(24)
#2 /share/MD0_DATA/Qweb/intranet/system/modules/registration/ModuleRegistration.php(457): registrationPublicFields->setPublicFields(24, Array, Object(ModuleRegistrationExtended))
#3 /share/MD0_DATA/Qweb/intranet/system/modules/registration/ModuleRegistration.php(290): ModuleRegistration->createNewUser(Array)
#4 /share/MD0_DATA/Qweb/intranet/system/modules/xtmembers/ModuleRegistrationExtended.php(65): ModuleRegistration->compile()
#5 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/Module.php(140): ModuleRegistrationExtended->compile()
#6 /share/MD0_DATA/Qweb/intranet/system/modules/registration/ModuleRegistration.php(77): Module->generate()
#7 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/ContentModule.php(72): ModuleRegistration->generate()
#8 /share/MD0_DATA/Qweb/intranet/system/libraries/Controller.php(511): ContentModule->generate()
#9 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/ModuleArticle.php(194): Controller->getContentElement('192')
#10 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/Module.php(140): ModuleArticle->compile()
#11 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/ModuleArticle.php(71): Module->generate()
#12 /share/MD0_DATA/Qweb/intranet/system/libraries/Controller.php(443): ModuleArticle->generate(false)
#13 /share/MD0_DATA/Qweb/intranet/system/libraries/Controller.php(307): Controller->getArticle('81', false, false, 'main')
#14 /share/MD0_DATA/Qweb/intranet/system/modules/frontend/PageRegular.php(100): Controller->getFrontendModule('0', 'main')
#15 /share/MD0_DATA/Qweb/intranet/index.php(266): PageRegular->generate(Object(DB_Mysql_Result))
#16 /share/MD0_DATA/Qweb/intranet/index.php(401): Index->run()
#17 {main}
Da meine PHP/SQL-Kenntnisse nicht erwähnenswert sind, hoffe ich auf einen Tipp aus dem Forum. Darum wäre ich wirklich sehr dankbar!
Herzliche Grüße,
fusch
Lesezeichen