Out of range value for column 'price' at row 1 - Forum | JoomShaper
Awaiting an answer Extensions

Out of range value for column 'price' at row 1

Asked by Glenn Heino 3 years ago Last activity 3 years ago

SP Property
Error Message: Out of range value for column 'price' at row 1
Solution to price being too many digits

Open phpMyAdmin -
Find TABLE xxxxx_spproperty_properties -
Go to the Structure tab -
Scroll down to price (currently #15) -
Change "FLOAT(8,2)" to "FLOAT(10,2)" -
Click Save -
Can this be hard-coded in the program? Home prices in 2023 are much higher than 10 years ago.

4 replies

Oldest first Newest first Most helpful
Ofi Khan Staff
3 years ago

Hello Luis

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.

Thanks for sharing the solution.

Best regards

Glenn Heino Asked this
3 years ago

I changed it in phpMyAdmin and it works just fine.

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.

Dimitris
3 years ago · edited

Hello,

I am having the same problem. I run the SQL query but i get this error :

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘0.00’' at line 1

Any suggestions?

Thank you

Edit : I fixed it.

Log in to reply.