Hello Silvio Parisi

1. You cannot add more that 10,00,000 in SP Property -> Property Price. If you want to increase the digits, then you have to change in the database. Please run this SQL query on your database. By default, the value is FLOAT(8,2). If you make it FLOAT(9,2), then you can add 1 more digit in the price 1,00,00,000

   ALTER TABLE `xxxxx_spproperty_properties` CHANGE `price` `price` FLOAT(9,2) NOT NULL DEFAULT ‘0.00’;

   Use your table prefix instead of xxxxx on the table name.

2. Apology for the inconvenience. Please share your administrator access and Fixed Price Issue Page Link here to check the issue. Use the Hidden Content box to share the credentials. Make sure that you have a full site backup with you before sharing.

Best regards

Hi Ofi! Thank You for your answer.

1. Unfortunately, when I try to change it in phpmyadmin it brings error " #1067 invalid default value for 'created' " What can I do about it?
2. I will bring it on production server in few days and send You access data.. It is still on my localhost.

Best regards

1. in the table name I have used example xxxxx_spproperty_properties. You will use your table prefix instead of xxxxx. Table prefix is unique and will be 5 digits/letters.
2. okay, share the access then.

Dear Ofi,

yes, i have used my table prefix, which is "gl4", like this:

ALTER TABLE gl4_spproperty_properties CHANGE price price FLOAT(9,2) NOT NULL DEFAULT ‘0.00’;

and it brings error " #1067 invalid default value for 'created' ".

Thank You.

Dear Ofi,

I have uploaded website online and I am sending You credentials in Hidden Content box. To resume, there are few issues on the site:

1. On search map, when clicked on the property, property title and link to property page in the opened popup window are missing. link: https://gracelusso-realestate.com/en/by-map/map-search

2. On the same page and on the Half Map list ( https://gracelusso-realestate.com/en/by-map/half-map-list-2 ), the price in the map property popup is written as price/ m2. Idea is to enter fixed price, so m2 is not needed.

3. When used "fixed price for property, I still cannot enter price greater 6 digits in SP Property. The solution that You suggested earlier brings the error "#1067 invalid default value for 'created' so it does not change FLOAT to (9,2).

4. Site is multilingual (german and english). The problem is that all entered properties (EN and DE) are shown all on the same map. (you can see number "2" on the map on https://gracelusso-realestate.com/en/by-map/map-search . I have created separate categories for DE and EN property versions, and I wanted to define it's showing on the map, but I cannot select that newly created categories in SP Builder Pro -> Pages -> Home Search by map EN (on the bottom) -> spproperties map (first row).

5. Defined icon for the map pin is not showing (only the price). For example, Components -> SP Property -> Categories -> Investment project

6. In language switcher module "full language names" option when turnet do "off" is not working (always are full names).

Also, I would like to:

• that the property link in the popup on map opens a property single page a new window.
• adjust property listing view (biger title above the price etc.. in what view file is that defined?)
• add field to property description. It could be text field "surroundings" that should be possible to style in css. How can I do it?

• Thank You very much.. I am looking forward to bring all the functionalities that are needed.

Dear Ofi,

I managed to change FLOAT to (9,2) (it's working on production site). But now another issue occurs. I have 3 test properties entered. On the first page - http://gracelusso-realestate.com/en/ from 3 listed properties, one shows correct fixed price (property Volosko), but other two are showing calculated price when I set it to "fixed price - YES", and fixed price when I set it to "fixed price - NO".

On property single page

http://gracelusso-realestate.com/en/buy/49-volosko-building-plot-with-idea-project

and on map on

http://gracelusso-realestate.com/en/by-map/map-search

http://gracelusso-realestate.com/en/by-map/half-map-list-2

everything is fine. Please take and other issues in consideration. I am looking forward to Your reply.

Homepage pricing issue is fixed. Do you have any other issues?

Dear Ofi Khan,

thank You for fixing pricing issue. Unfortunately, yes, as You can see in previous comments there are few more issues to be solved, but let me emphasyse three that are urgent for us (I have explained them earlier so let me just post few screenshots with notes here so that You understand more clearly):

1. Screenshot 1 - issue 1 and 2:

https://prnt.sc/BfcMn8VPJlOq

2. Screenshot 2 - issue 3.

https://prnt.sc/4JI1OFMJq5OI

Also, is there a possibility to open properties single page in new window, when clicked on map? Thank You very much! :)

Half map view is fixed.

Everything is not customizable but I am trying to help you as much as I can.

Please go to this location: components/com_spproperty/models and replace maps.php file with the attached file. You need to unzip the file and then replace. It might fix the full map view.

maps.php.zip

Dear Ofi,

thank You for maps.php patch. It removed unnecessary "m2" on the map. But the problem with showing property pins of ALL languages on the same map is still here. I think it is really important issue to be solved because without this funcionality Estate actually isn't multilanguage template since you cannot use any kind of map on it. And in our project it is obligatory to have multiple languages. I am bringing this to your attention. Is there a way to fix it.. or any other way to get it work properly in multi language mode? I hope there is. Thank You!

Apology for the delayed response. Please record a screencast and share via any drive link. I will check and if needed, then will forward to the developer team.