SP property (Pricing problem) - Forum | JoomShaper
Solved Extensions

SP property (Pricing problem)

Asked by Aslam Ahamed 3 years ago Last activity 3 years ago

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

Accepted answer

Marked as the solution
Ofi Khan Staff
3 years ago

Hello 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

5 more replies

Oldest first Newest first Most helpful
Carlos Jimenez
3 years ago

1st, 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);

Aslam Ahamed Asked this
3 years ago

Please can you give me proper guide for this.

thanks

Aslam Ahamed Asked this
3 years ago

i want the currency to AED

Aslam Ahamed Asked this
3 years ago

Great its working

Thanks

Ofi Khan Staff
3 years ago

You 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 

  1. Joomla Extension Directory
  2. TrustPilot

This will inspire us to improve.

Log in to reply.