Home » Forums » Ubercart » Bug Reports
6 replies [Last post]
Sat, 10/13/2007 - 23:10
WesleyTx
WesleyTx's picture
Offline
Bug Finder
Joined: 09/14/2007
Juice: 89
Was this information Helpful?

I got the following error when I tried creating my first product kit:

user warning: Unknown column 'units' in 'field list' query: UPDATE uc_products SET model = 'WTX / WAZ', list_price = 0, cost = 0, sell_price = 33.92, weight = 0, units = 'lb' WHERE vid = 114 in /home/bigwaste/public_html/includes/database.mysql.inc on line 172.

Should that not be "weight_units"?

I'm using 7e (upgraded from 7c).

Top
Mon, 10/15/2007 - 06:10
#1 View page
zmove
zmove's picture
Offline
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.Internationalizationizer
Joined: 08/13/2007
Juice: 1192
Re: Error When Creating Product Kit

I have the same problem on Alpha 7e upgraded from a Alpha 7d

Top
Mon, 10/15/2007 - 08:50
#2 View page
Lyle
Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: Error When Creating Product Kit

It should be weight_units. I think I noticed it earlier because it's already fixed, just not in time for the 7e release.

Top
Mon, 10/15/2007 - 17:43
#3 View page
WesleyTx
WesleyTx's picture
Offline
Bug Finder
Joined: 09/14/2007
Juice: 89
Re: Re: Error When Creating Product Kit

Okay, I replaced all occurrences of "units" with "weight_units" in uc_product_kit.module and it appears to be working now.

Top
Thu, 10/18/2007 - 16:39
#4 View page
xerbutter
xerbutter's picture
Offline
Bug Finder
Joined: 09/07/2007
Juice: 146
Lyle, I was still getting

Lyle,

I was still getting this error with the latest Bazaar checkout (at least I think it's the latest... Smiling)

Line 70 of uc_product_kit.module had "units" rather than "weight_units" - changing that seemed to fix it.

Best,
Xerxes

Top
Thu, 10/18/2007 - 17:03
#5 View page
Lyle
Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: Lyle, I was still getting

It's funny how I can miss one line like that. Had it right on 71 and 72.

Fixed.

Top
Wed, 11/21/2007 - 01:03
#6 View page
incaic
incaic's picture
Offline
Joined: 10/13/2007
Juice: 115
weight_units?

Shouldn't line 522 of uc_product.module also use 'weight_units' instead of 'units'.
I changed it and now get the actual selector in the create product form.

I'm on 7e.

Top