Hello. I'm getting a SQL error when adding a "Manage Company Offers" menu item. The error reads:
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 ') and (1 or op.id in ( select min(op1.id) as min from jom_jbusinessdirecto' at line 3 SQL=select co.*, op.picture_path from jom_jbusinessdirectory_company_offers co left join jom_jbusinessdirectory_company_offer_pictures op on co.id=op.offerId where companyId in () and (1 or op.id in ( select min(op1.id) as min from jom_jbusinessdirectory_company_offers co1 left join jom_jbusinessdirectory_company_offer_pictures op1 on co1.id=op1.offerId where companyId in () group by co1.id)) group by co.id
Joomla version is 3.2.3
Any help with this is appreciated.
Hi,
The problem is that a new offer is being created but no business listings exists.
For site users we provide on front-end a Control Panel which contains all needed administration management.