OpenCart Community

Posted: **Mon Nov 29, 2010 8:01 am**

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

Posted: **Mon Nov 29, 2010 8:20 am**

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

Posted: **Thu Jul 21, 2011 3:10 am**

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

Code: Select all

ALTER TABLE `product` CHANGE `weight` `weight` DECIMAL( 7, 2 ) NOT NULL

oscommerce had the same problem so I'm glad I didn't forget it all and managed to work it out.

Posted: **Tue Sep 13, 2011 6:02 pm**

Just used this solution, worked great.

OpenCart Community

Can't change high grams

Can't change high grams

Re: Can't change high grams

Re: Can't change high grams

Re: Can't change high grams