Bug in new version of Sp Property - Forum | JoomShaper
Solved Extensions

Bug in new version of Sp Property

Asked by Libor 5 years ago Last activity 5 years ago

Hi, the new version will not allow you to enter a price higher than 1,000,000. For items already entered, were higher than 1 000 000, the price changed to 1 000 000
many thanks for help

Accepted answer

Marked as the solution

4 more replies

Mehtaz Afsana Borsha Staff

ok then follow this

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

Libor Asked this

ok, now works fine

many thanks

Log in to reply.