hello

When accessing an announcements(ads) list (contents list) I get the following message:

1064 - 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 ') ORDER BY c.ordering' at line 1 SQL=SELECT c.* FROM p9jzm_adsmanager_categories as c WHERE c.parent = 1 AND c.published = 1 AND c.id IN (1,2,3,4,5,6,7, AND c.id IN () ORDER BY c.ordering.

thank you for your help.

Hello,

I use AdsManager Free Version 302 and Joomla 336.
I solved my issue by uninstalling, drop tables adsmanager and reinstalling AdsManager component.

Thanks,

I'm having a similar issue: When a user submits an ad they get the following message:


1064

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 SQL=INSERT INTO ove83_adsmanager_adcat(adid,catid) VALUES (36,)

there are other issues as well:

there is no way to ad pictures and the calander button doesn't do anything (won't let you select a date)


using joomla 3.36
php 5.3.29
adsManager 3.0.3