Empire - The Database Cannot Store Amounts Above 10000000
D
Dariusz
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 Answers
Order by
Oldest
Ofi Khan
Accepted AnswerHello 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