SP Property - Price Column
K
Kovács Endre
Hi, If I enter a value greater than 999,999 in the “Price” field, I get the following error message: “Out of range value for column ‘price’ at row 1.” Where can I adjust this value? Regard, Endre
4 Answers
Order by
Oldest
Mehtaz Afsana Borsha
Accepted AnswerGlad to know that. You are always welcome. You can now close this post by accepting the answer.
Mehtaz Afsana Borsha
Accepted AnswerHi Endre,
The error is coming from the database field size, not from the SP Property component settings.
The price column in the SP Property database table is currently set with a maximum value that cannot store numbers above 999,999. To allow larger values, you need to increase the column type in the database.
Before making any changes, please create a database backup.
Please note that this is a database-level customization, so keep a backup before modifying the table structure. Also, future SP Property updates may overwrite database changes, so it is a good idea to keep track of this modification.
Regards.