- Posts: 9
- Thank you received: 0
OS Property support center
SQL error `064 when approving property
- lee
- Topic Author
- Offline
- New Member
-
Less
More
11 years 8 months ago #33573
by lee
SQL error `064 when approving property was created 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
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.
- Mr. Dam
-
- Offline
- Administrator
-
Less
More
- Posts: 13024
- Thank you received: 1690
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 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.
- lee
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 9
- Thank you received: 0
11 years 8 months ago #33576
by lee
Replied by lee on topic Re: SQL error `064 when approving property
wow that was quick, I will post shortly.
Great support !
Great support !
Please Log in or Create an account to join the conversation.
- lee
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 9
- Thank you received: 0
11 years 8 months ago #33628
by lee
Replied by lee on topic Re: SQL error `064 when approving property
Issue resolved
very good support, thanks you
lee
very good support, thanks you
lee
Please Log in or Create an account to join the conversation.
Moderators: Mr. Dam, Nguyen Phu Quan
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.