Hi everyone,

I am trying to build a streetwebsite for my neighbourhood and all is going well, except for one problem i have encountered so far.
The problem lies within the newsletter subscription module.

If i make a page wich uses the newsletter sign on it comes back with the following error:

Code:

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 ')' at line 1 (SELECT id, title FROM tl_newsletter_channel WHERE id IN()) thrown in /var/www/vhosts/geldersehoek.nl/httpdocs/system/libraries/Database.php on line 502

#0 /var/www/vhosts/geldersehoek.nl/httpdocs/system/libraries/Database.php(161): Database_Statement->execute()
#1 /var/www/vhosts/geldersehoek.nl/httpdocs/system/modules/newsletter/ModuleSubscribe.php(115): Database->execute('SELECT id, titl...')
#2 /var/www/vhosts/geldersehoek.nl/httpdocs/system/modules/frontend/Module.php(121): ModuleSubscribe->compile()
#3 /var/www/vhosts/geldersehoek.nl/httpdocs/system/modules/newsletter/ModuleSubscribe.php(70): Module->generate()
#4 /var/www/vhosts/geldersehoek.nl/httpdocs/system/libraries/Controller.php(219): ModuleSubscribe->generate()
#5 /var/www/vhosts/geldersehoek.nl/httpdocs/system/modules/frontend/PageRegular.php(68): Controller->getFrontendModule('59', 'main')
#6 /var/www/vhosts/geldersehoek.nl/httpdocs/index.php(187): PageRegular->generate(Object(DB_Mysql_Result))
#7 /var/www/vhosts/geldersehoek.nl/httpdocs/index.php(254): Index->run()
#8 {main}

Hopefully someone will know what the problem is so I can continu with the website.

Thx in advance

Ronny

Make sure you have selected an existing channel in the subscribe module.

Hi acenes,

I just checked the module and indeed, i forgot to select an existing channel..

A typical case of my boo :/

Thx for the help