SP Property - Price Limitation - Question | JoomShaper

is live, now with multi-currency selling.

Learn More
Back to the questions

SP Property - Price Limitation

PP

Pawel P

Extension 13 hours ago

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:

  • Save failed with the following error: Out of range value for column 'price' at row 1

it seems the extention has limitation to 999.999 how to fixit ?

0
Website
http://f1it.pl
1 Answers
Order by
Oldest Newest Votes
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 20 minutes ago #234067

Hello Pawel P

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

0