Home » Forums » Ubercart » Support

Shipping calculation on "Create Order" page doesn't work

Submitted by jimi089 on Fri, 10/05/2007 - 14:55
jimi089
Posts: 104
 Joined: 09/07/2007
Uber Donor

Greetings,

I just tried to create an order from the admin pages and it couldn't create a shipping quote.

I get this error:

There were problems getting a shipping quote. Please verify the delivery and product information and try again.
If this does not resolve the issue, please call in to complete your order.

I have verified that shipping is still working find in the cart/checkout.

Any ideas?

I also got this nasty looking error when I was working on the Create Order page, although I haven't been able to replicate it when I just tried:

    * warning: Invalid argument supplied for foreach() in /home/sassy/public_html/shop/modules/node/node.module on line 504.
    * warning: implode() [function.implode]: Bad arguments. in /home/sassy/public_html/shop/modules/node/node.module on line 508.
    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /home/sassy/public_html/shop/includes/database.mysql.inc on line 172.
    * warning: Invalid argument supplied for foreach() in /home/sassy/public_html/shop/modules/node/node.module on line 504.
    * warning: implode() [function.implode]: Bad arguments. in /home/sassy/public_html/shop/modules/node/node.module on line 508.
    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /home/sassy/public_html/shop/includes/database.mysql.inc on line 172.

Not sure if it's related or not.

Thanks guys.
permalink #1 Mon, 10/08/2007 - 11:54
jimi089
Posts: 104
 Joined: 09/07/2007
Uber Donor

Giving this one the ol' Monday bump Eye-wink

permalink #2 Mon, 10/08/2007 - 13:29
Ryan

Posts: 5269
 Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Curious to know what version of UC you're on. I believe I forgot to update the quote module for shipping quotes on the order edit screen after I first modified the checkout pane API. This was fixed in the subsequent version.

permalink #3 Mon, 10/08/2007 - 14:22
jimi089
Posts: 104
 Joined: 09/07/2007
Uber Donor

Rocking 7e on this site!

permalink #4 Fri, 10/12/2007 - 14:31
jimi089
Posts: 104
 Joined: 09/07/2007
Uber Donor

Bumping this one for consideration. Is it working on the livetest? I'd be curious to know.

permalink #5 Fri, 10/12/2007 - 15:29
Ryan

Posts: 5269
 Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Hmm... I just tested it on the Livetest and it worked as expected. It could always be something related to your quote method itself. I was using UPS.

permalink #6 Fri, 10/12/2007 - 15:37
jimi089
Posts: 104
 Joined: 09/07/2007
Uber Donor

Interesting. I am using FedEx and USPS. I'll talk to Cosmo about his FedEx module and see if he has the same issue.

permalink #7 Mon, 10/15/2007 - 19:14
jimi089
Posts: 104
 Joined: 09/07/2007
Uber Donor

Well it's not the FedEx module itself since Cosmo says its working fine for him.

Two ideas, and maybe you might have some insight Ryan:

Could it be related to not deleting a duplicate directory when upgrading to 7e since some of the file structure changed? I deleted uc_quote but nothing else when I upgraded.

Could it have anything to do with the workflow module? Was this integrated as of 7e?

Thanks!

permalink #8 Tue, 10/16/2007 - 09:10
Ryan

Posts: 5269
 Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

I don't know... it doesn't seem like it would be either one of your problems... workflow has only been integrated post 7e. The errors are coming up with the node_load, so I'm curious if it's simply the product node you're trying to add to the order. Perhaps some data didn't get updated properly? Try it out with a newly created product to see if that solves the problem and we can always go from there.

permalink #9 Tue, 10/16/2007 - 15:15
jimi089
Posts: 104
 Joined: 09/07/2007
Uber Donor

Thanks for your help Ryan. I'll take a look and report back.

permalink #10 Sat, 10/20/2007 - 13:15
jimi089
Posts: 104
 Joined: 09/07/2007
Uber Donor

Update: I got the nasty error to go away by re-submitting the product nodes. Not sure why I needed to do that but it did the trick. Still not getting shipping quotes on the Create Order page though. I'm going to update to the Bazaar code and give it a go this weekend.

permalink #11 Wed, 06/11/2008 - 08:42
steingard
Posts: 19
 Joined: 03/30/2008

I am now having this same issue in version 1.0. I'm only using UPS shipping quotes, but I am able to pull up quotes just fine when an order is created on the web site.

Could I have my configurations wrong?

Is anyone else experiencing this since the upgrade?

Cheers