Can't change high grams

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

that field was likely a Decimal (3,2) in the database. You should change that field to something like Decimal (5,4)

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.

Just used this solution, worked great.