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
Solved
Extensions
SP Property - Price column
Accepted answer
Marked as the solution
Mehtaz Afsana Borsha Staff
Glad to know that. You are always welcome. You can now close this post by accepting the answer.
Mehtaz Afsana Borsha Staff
Thanks for accepting the answer.
2 more replies
Mehtaz Afsana Borsha Staff
Hi 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.
Kovács Endre Asked this
Hi Mehtaz Afsana Borsha,
Thx, your answare. Working.
Regards
Log in to reply.