Hi,
I use SP Property for my clients website. They sell villa's in Spain for -sometimes- over One million euro. But it seems 1.000.000 is the max value we can fill in. If we say the property costs 2 million (2000000) and click save, the amount is set back to 1 million (1000000). Is there indeed a max value set up? And if yes, where can i change this?
Regards,
Remco
Henk ICT Services
Hello H.G.P. Hendriks
Yes, you are right. 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.
Best regards
Hello,
I have this problem when trying to change values:
Hello Siniša Ravlić
I need to check your site. Please post a new question with your site credentials on the hidden content. I will check and fix your issue.
Best regards