Staff replied Extensions

Empire Template - *Price now max at 1000000.00

Asked by Wernher 5 years ago Last activity 5 years ago

SP Property

New update or your file send to me for currency correction (sp-property - config.xml) now limit max sell price to R1000000.00

10 replies

Ofi Khan Staff

5 years ago

Hello Wernher

Please share a screenshot of your issue to understand it better. And explain it more.

Best regards

Anne Staff

5 years ago

Hello Wernher,

Thanks for contacting with us. Can you give us a screenshot for better understanding? Do you want the previous version of sp property?

-Regards

Wernher Asked this

5 years ago

![https://www.manzellaestates.co.za/index.php/properties-2]

Note all sell price = R 1,000 000.00 unless its below R 1,000 000.00. This mean the max sell price can not be more then R 1,000 000.00.

This is a problem when you update to SP Property V4

Ofi Khan Staff

5 years ago

I think I got your issue. 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.

Wernher Asked this

5 years ago

Hi Ofi

Many thanks, but please assist fixing same in my website. see cPanel info, your assistance will be greatly appriciated

Thanks Wernher

Ofi Khan Staff

5 years ago

Please take a full site backup with Akeeba Backup in ZIP format and share here. Follow this tutorial. Then I will fix and share you a backup.

Wernher Asked this

5 years ago

Hi Ofi

Many thanks for the help, I will preper same and let you know.

Ofi Khan Staff

5 years ago

Actually, it is not a major issue. It is the database restrictions that you cannot add more than 8 digits in the price. It can be fixed easily on the database.

Wernher Asked this

5 years ago

Hi Ofi
Many thanks for your assistance. I have however decided to move back to Extension - SP Property V3.1. Final note;

Upgrades must improve functionality
Real estate don’t use .00 (Cent) no one use .00
We have become accustom with front end editing, messing with the database is complex all Sp Pagebuild users. your product developers should keep that in mind.

Kindly advice me when you fixed the .00 in Extension - SP Property V.4, its always good to be on the most current version.

I thank you
Wernher

Ofi Khan Staff

5 years ago

Sure. Thank you for your valuable input. I will share this feedback with the developers so that they can improve the product.