Joomla Real Estate

The first error happens when there is a ' character inside the description of a house

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 '', '35000 EUR',now())' at line 4 SQL=INSERT INTO #__rem_orders(fk_user_id, status, name,email, fk_house_id,fk_houses_htitle, order_calculated_price, order_date) VALUES ('', 'Pending', 'Giorgio Mancuso', 'g.mancuso@itacad.it', '13', 'CUORGNE' - APPARTAMENTO', '35000 EUR',now())

In all other cases I get an "0 - invalid address" error

Hello


Could you give us full FTP and admin access
and our team will try to find solution special for You, FTP and admin access You can send to our contact form.
ordasoft.com/contact-us-form


Link on website

Joomla Admin

username
password


FTP

FTP host

FTP username

FTP password

Thanks,
Taras
OrdaSoft team.

Now it's ok. What do you do? Only to avoid the same error in the future

Hello,

Problem was connected with symbols in title of property.

Try add title without any symbols.

For example " - " (hyphen) or " ' " (single quote)

thanks