OS Property support center

SQL error `064 when approving property

More
11 years 8 months ago #33573 by lee
Morning,

Very happy with component, but am getting this error when I try and approve a property in the front end as an agent.

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=Update ab_osrs_properties set published = '0' where id in ()

Can approve in the backend as admin and I do not get the error.

At the moment this means an agent cannot approve or un-approve a property they have listed.

Any ideas what it could be ?

thanks
lee

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #33574 by Mr. Dam
Replied by Mr. Dam on topic Re: SQL error `064 when approving property
Hi Lee,
Please send your site information with super admin account, ftp account to damdt@joomservices.com. i will check the issue for you
Thanks
Dam

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #33576 by lee
wow that was quick, I will post shortly.

Great support !

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #33628 by lee
Issue resolved

very good support, thanks you

lee

Please Log in or Create an account to join the conversation.

Moderators: Mr. DamNguyen Phu Quan