Can't change high grams

Quote

Post by Sheldon.Kirk » 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

Image

Sparx Web Solutions - Affordable Web Design & Internet Marketing

New Zealand Web Design

User avatar
Sheldon.Kirk
Active Member
Posts
113
Joined
Fri Jul 03, 2009 5:58 am
Location - Tauranga, New Zealand
Top

Re: Can't change high grams

Quote

Post by Qphoria » 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)

Image

User avatar
Qphoria
Administrator
Posts
20056
Joined
Tue Jul 22, 2008 3:02 am
Top

Re: Can't change high grams

Quote

Post by freshbreeze » 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.
freshbreeze
Newbie
Posts
14
Joined
Mon Jul 18, 2011 3:36 am
Location - UK
Top

Re: Can't change high grams

Quote

Post by Meeker » Tue Sep 13, 2011 6:02 pm

Just used this solution, worked great.
User avatar
Meeker
Active Member
Posts
171
Joined
Thu Sep 16, 2010 5:45 am
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: Baidu [Spider], Bing [Bot] and 93 guests