I added property, that is estimated to 1.100.000 PLN (about 250.000 USD), when trying to save changes, I can see the error:
it seems the extention has limitation to 999.999
how to fixit ?
You cannot add more than 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.
Best regards
Thank you. Since property prices in PLN don't require decimal places, can I safely change the price column to FLOAT(9,0) instead of FLOAT(9,2)?
This would allow prices up to 999,999,999 PLN. Does SP Property require two decimal places for the price field anywhere in its PHP code?
Yes, you can change the value to this. It will work fine.