SP Property (Pricing Problem)
Aslam Ahamed
i want change the pricing to aed and i want increase the pricing.
Save failed with the following error: Out of range value for column 'price' at row 1
Ofi Khan
Accepted AnswerHello Aslam Ahamed
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
Carlos Jimenez
Accepted Answer1st, Backup your database, export the sql
2nd . change the xxxx to the prefix of your tables and the XXX by the number of zeros you want.
execute this in phpmyadmin/sql
ALTER TABLE xxxx_spproperty_properties CHANGE price price FLOAT(XXX,2);
Ofi Khan
Accepted AnswerYou are welcome 😊
I have a humble request. It would be very kind of you if you can manage some moment to give us feedback on
This will inspire us to improve.