1.3.7 bug?

[jerkynet]

My upgrade from 1.3.6 was flawless, been on 1.3.7 for a couple weeks. Just caught something that I can not find the answer for, BUT have confirmed this started with the upgrade.

The zen_orders table when updated with new orders is getting consistantly a '-1' inserted to the total_weight field. I have already been through redoing my upgrade and can only tie this to the upgrade timeline.

Zen 1.3.7
Shipping module: zone rates (also happens if enables cod or table)
Payment module: PayPal IPN

Anybody else?

Dave........

[Ajeh]

What are the settings that you are using on Zones when you see this happen?

[jerkynet]

Hi Linda,

Here you go.........
=============
Enable Zones Method
True

Calculation Method
Weight

Tax Class
--none--

Tax Basis
Shipping

Sort Order
0

Skip Countries, use a comma separated list of the two character ISO country codes


Zone 1 Countries
US

Zone 1 Shipping Table
1:4.75,6:9.50,12:15.50,18:21.50,100:24.95

Zone 1 Handling Fee
0

Zone 2 Countries
CA

Zone 2 Shipping Table
1:9.75,2:14.00,4:28.00,6:42.00,8:56.00,10:70.00,12:84.00,14:98.00,50:112.00

Zone 2 Handling Fee
0

Zone 3 Countries


Zone 3 Shipping Table


Zone 3 Handling Fee
0

[Ajeh]

And what was the order weight for this when it happened?

[Ajeh]

Oh and the country on the order ...

[jerkynet]

Country on all: US
Weight per order:
4
5
12
1
1
6
1
2
12
3
5
6

[Ajeh]

What settings in Shipping/Packaging are you using on the Tare weight?

[jerkynet]

Shipping/Packaging Tare 0:0
(This setting and shipping module not changed in some time)

[Ajeh]

The zen_orders table when updated with new orders is getting consistantly a '-1' inserted to the total_weight field. I have already been through redoing my upgrade and can only tie this to the upgrade timeline.

Umm ... do you have an add-on or something for your orders table?

There isn't a field for total_weight in the orders table with Zen Cart and I do not see any error on the display of the text for the Shipping ...

[jerkynet]

OK, sorry to bother you.....

I *had* been using prior to upgrade the "autofill" upsp mod.....did not put that in this vers, since I am using something much better now.

You got me thinking, and sure nuf.....the sql file that came with that mod is pretty obvious...
ALTER TABLE `orders` ADD `total_weight` FLOAT NOT NULL DEFAULT '-1';

OK, so guide me through this one please.....I thought I had everything I needed in a single table. What I am doing is I have an app that uses ODBC to dig into the zen table zen_orders, retrieves the delivery name, addr, city,st,zip (and was trying to) get total_weight fields.

This is all the info I need for my postage app to mass produce my labels.

Anywhere else I can grab this info, or just throw that autofill mod back on?
Dave........