Solved Templates

Template Edulif: Error "Out of range value for column 'price' at row 1"

Asked by thanhhx57 3 years ago Last activity 3 years ago

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.

https://prnt.sc/RNzzz15_Zvn0

Please guide me how to fix this error.
Thanks!

Accepted answer

Marked as the solution
Ofi Khan Staff
3 years ago · edited

Hello 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

thanhhx57 Asked this

Thanks Ofi Khan.

I have fixed the problem.

Ofi Khan Staff

You 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 

  1. Joomla Extension Directory
  2. TrustPilot

This will inspire us to improve.

thanhhx57 Asked this

OK. I will do this. You're so great.

Log in to reply.