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!
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!
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
Thanks Ofi Khan.
I have fixed the problem.
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
This will inspire us to improve.
OK. I will do this. You're so great.