Home » Forums » Ubercart » Support

Link missing to create packages

Submitted by nokinrecycler on Mon, 08/18/2008 - 06:09
nokinrecycler
Posts: 4
 Joined: 05/13/2008

Hi, I'm testing the ordering system, and have manually created an order for a customer. According to the documentation, there is supposed to be a link to to the "New Package" page.

The link is missing from that tab. I have the products in the order set as shippable, and am using a flat rate shipping cost. The order is marked as paid, and all address information is filled in.

Anyone have any idea why the link is missing from the packages page to create the package for shipment? I have attached a screenshot of the packages pane for reference.

AttachmentSize
pane.jpg21.03 KB
permalink #1 Mon, 08/18/2008 - 10:31
Lyle

Posts: 2244
 Joined: 08/07/2007
AdministratoreLiTe!

Just to make absolutely sure, the products in the uc_order_products table have s:9:"shippable";s:1:"1"; in their data column?

I expect you won't get any results, but try running this query directly in your database:

SELECT op.order_product_id, CAST(SUM(op.qty) / COUNT(pp.qty) AS UNSIGNED) AS total, SUM(pp.qty) AS packaged FROM uc_order_products AS op LEFT JOIN uc_packaged_products AS pp ON op.order_product_id = pp.order_product_id WHERE op.order_id = 4 AND op.data LIKE '%s:9:"shippable";s:1:"1"%' GROUP BY op.order_product_id HAVING SUM(pp.qty) IS NULL OR CAST(SUM(op.qty) / COUNT(pp.qty) AS UNSIGNED) > SUM(pp.qty)

Maybe it'll give some clue to what's wrong.

permalink #2 Mon, 08/18/2008 - 21:08
nokinrecycler
Posts: 4
 Joined: 05/13/2008

Thanks for the reply Lyle. If I create an order as a customer, I am able to make a package. The data in the uc_order_products table shows up as:

a:3:{s:9:"shippable";s:1:"1";s:6:"module";s:10:"uc...

But if I create the order as an admin, the link is missing as stated before. The data in the column shows up as:

s:24:"a:1:{s:7:"contact";i:0;}";

Is this normal where I will not be able to create packages if I created the order as an admin?

permalink #3 Tue, 08/19/2008 - 10:38
Lyle

Posts: 2244
 Joined: 08/07/2007
AdministratoreLiTe!

I've never seen "contact" in the product data before. It sounds like you've got a module that's got a bad hook_add_to_cart_data() that's screwing up all the other modules. But I'm not sure why it would only happen when the admin adds the product to the order.

I'm afraid I have to say I can't duplicate it.