Template Edulif: Error "Out Of Range Value For Column 'price' At Row 1"
thanhhx57
Hello, I am installing a test template on localhost. I got an error when converting the selling price to Vietnamese currency. In Vietnam, 1$ is converted to about 24,000VND.
Please guide me how to fix this error. Thanks!
4 Answers
Order by
Oldest
Ofi Khan
Accepted AnswerHello thanhhx57
You cannot set course price to 10,00,000 (6 digits) or more due to SQL limit. If you want to change it, then use this SQL query
ALTER TABLE `xxxxx_splms_courses` CHANGE `price` `price` FLOAT(9,2) NOT NULL,
CHANGE `sale_price` `sale_price` FLOAT(9,2) NULL DEFAULT NULL;Use your table prefix instead of xxxxx. If you want 10 digit price, then set FLOAT(10,2)
Best regards
Ofi Khan
Accepted AnswerYou are welcome 😊
I have a humble request. It would be very kind of you if you can manage some moment to give us feedback on
This will inspire us to improve.