Staff replied Templates

Empire - The Database Cannot Store amounts above 10000000

Asked by Dariusz 4 years ago Last activity 4 years ago

Empire (shaper empire template)
The Database Cannot Store amounts above 1000000? If it is e.g. 1000001 or 2500000 it changes to 1000000. A similar problem was here, but no solution was given: (https://www.joomshaper.com/forum/question/1809 Need to change something in the database, but I don't know what...can anyone help?

1 reply

Ofi Khan Staff
4 years ago

Hello Dariusz

I think I got your issue. 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

Log in to reply.