J-BusinessDirectory - 1064 - You have an error in your SQL syntax

Support Forum

 
 

 

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.

1 replies

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.

 
 
 

2 Item(s)

Show per page