11 replies [Last post]
jimi089's picture
Offline
Uber Donor
Joined: 09/07/2007
Juice: 219
Was this information Helpful?

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.

jimi089's picture
Offline
Uber Donor
Joined: 09/07/2007
Juice: 219
Re: Shipping calculation on "Create Order" page doesn't work

Giving this one the ol' Monday bump Eye-wink

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15438
Re: Re: Shipping calculation on "Create Order" page doesn't work

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.

jimi089's picture
Offline
Uber Donor
Joined: 09/07/2007
Juice: 219
Re: Re: Re: Shipping calculation on "Create Order" page doesn't

Rocking 7e on this site!

jimi089's picture
Offline
Uber Donor
Joined: 09/07/2007
Juice: 219
Re: Re: Re: Re: Shipping calculation on "Create Order" page does

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

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15438
Re: Re: Re: Re: Re: Shipping calculation on "Create Order" page

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.

jimi089's picture
Offline
Uber Donor
Joined: 09/07/2007
Juice: 219
Re: Re: Re: Re: Re: Re: Shipping calculation on "Create Order" p

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

jimi089's picture
Offline
Uber Donor
Joined: 09/07/2007
Juice: 219
Re: Re: Re: Re: Re: Re: Re: Shipping calculation on "Create Orde

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!

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15438
Re: Re: Re: Re: Re: Re: Re: Re: Shipping calculation on "Create

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.

jimi089's picture
Offline
Uber Donor
Joined: 09/07/2007
Juice: 219
Re: Re: Re: Re: Re: Re: Re: Re: Re: Shipping calculation on "Cre

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

jimi089's picture
Offline
Uber Donor
Joined: 09/07/2007
Juice: 219
Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Shipping calculation on

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.

steingard's picture
Offline
Joined: 03/30/2008
Juice: 70
Same issue in 1.0?

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