Hi guys,
We have set our weight to grams, but have a problem that whenever change the weight in the backend to be over 999 grams eg 4400 just changes back to 999.99 grams when we click save.
Any ideas how to fix this?
Using v1.2.9 on this store.
Thanks
Sheldon
Active Member
This is the solution word by word if anyone having trouble with the actual fix as I spent ages searching ...
In phpmyadmin you'll need to alter the sql table.
BACK UP FIRST
Run this sql
oscommerce had the same problem so I'm glad I didn't forget it all and managed to work it out.
In phpmyadmin you'll need to alter the sql table.
BACK UP FIRST
Run this sql
Code: Select all
ALTER TABLE `product` CHANGE `weight` `weight` DECIMAL( 7, 2 ) NOT NULL
Who is online
Users browsing this forum: Baidu [Spider], Bing [Bot] and 93 guests