Home » Forums » Ubercart » Bug Reports

SQL error from uc_quote for all nodes after latest update, etc.

Submitted by agrathea on Tue, 09/18/2007 - 18:34
agrathea

Posts: 6
 Joined: 09/17/2007

I recently did a bazaar update and had the following error code pop up on all pages, with a different node id depending on the node it popped up on (ie, it appeared on the home page with the home page node id, even though there are no products on that node). It seems primarily to refer to my product node currently, but I can't seem to reproduce a problem where it was actually repeating the error on pages where multiple nodes were referenced:

user warning: Unknown column 'address1' in 'field list' query: SELECT first_name, last_name, company, address1 AS street1, address2 AS street2, city, zone, postal_code, country FROM uc_quote_product_locations  WHERE nid = 72 in /../includes/database.mysql.inc on line 172.

I'm also having a lot of trouble getting the USPS shipping quotes to work properly. I've reviewed all posts regarding the following XML errors, and my settings all appear to be correct, and I have the latest files, and the XML error is still generated (and repeated several times):

# warning: xml_parse() [function.xml-parse]: Unable to call handler _startElement() in /home/.../modules/ubercart/uc_store/includes/simplexml.php on line 244.
# warning: xml_parse() [function.xml-parse]: Unable to call handler _characterData() in /home/.../modules/ubercart/uc_store/includes/simplexml.php on line 244.
# warning: xml_parse() [function.xml-parse]: Unable to call handler _endElement() in /home/.../modules/ubercart/uc_store/includes/simplexml.php on line 244.

I'm running PHP5. At the quote step I get the prices for different shipping options, yet there is the following error displaying below it:

First-Class Mail Parcel: $4.92
Priority Mail, 2 days in transit: $6.90
Parcel Post: $12.59
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.

When the order goes through Paypal and I get to the review order page, the XML errors appear. At the submit order page, where the shipping cost should appear it says:

Subtotal: $10.00
Error calculating shipping: $0.00
Total: $10.00

I'm lost on how to fix these and have scoured the boards and tried everything that everyone suggested, did a bazaar update on the latest files, ran the update script, etc, and am not getting anywhere. Any help would be greatly appreciated.

Thanks,

Theresa
permalink #1 Tue, 09/18/2007 - 19:57
agrathea

Posts: 6
 Joined: 09/17/2007

Regarding this error:
user warning: Unknown column 'address1' in 'field list' query: SELECT first_name, last_name, company, address1 AS street1, address2 AS street2, city, zone, postal_code, country FROM uc_quote_product_locations  WHERE nid = 72 in /../includes/database.mysql.inc on line 172.

I added the columns to the table and it stopped giving me an error. I hope this wasn't a solution that will cause me other problems down the line!

I'm still having the XML error, though.

permalink #2 Tue, 09/18/2007 - 20:40
agrathea

Posts: 6
 Joined: 09/17/2007

I stand corrected on the XML... I was able to get it to go away by commenting out the transit time request code as referenced here:

http://www.ubercart.org/forum/bug_reports/494/xml_parsing_errors_when_us...

However, I didn't think I would need to do that anymore after downloading the update, which is where I think I got confused.

The shipping price is still not going through, and I am still getting the same errors on the "order submit" page:

(I) You must specify a shipping option.

Error calculating shipping: $0.00

Any suggestions?

Theresa

permalink #3 Tue, 09/18/2007 - 21:40
agrathea

Posts: 6
 Joined: 09/17/2007

Well, I've ended up figuring out that many of my problems were ones I could have sorted out myself, though I hope recording them helps others! I usually try to spend as much time as possible finding solutions on my own, figures that I'd find the solutions on my own after a plea for help!

I realized that I had "Paypal Express Checkout" activated in the "Checkout Settings" and had shipping options deactivated (but had incidentally not been using the standard Paypal checkout at all before... I didn't have paypall express as a payment option, yet the button was still showing up in the cart because of the checkout settings, so I had been using the express checkout the entire time thinking it was the standard paypal checkout). Deactivating the paypal express checkout button and going through the longer standard paypal cart process, with the shipping option activated, has got everything working now with the shipping price going through to the paypal payment window.

I am still getting the following error message at the shipping quote stage:
"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."

However, it doesn't impede the order process at all. But I would like to see if I can get rid of the error message so it doesn't confuse customers and make them think they should cancel the order process.

I'll probably figure it out moments after posting this, but I would love if someone had some quick insight.

Thanks!

Theresa

permalink #4 Tue, 09/18/2007 - 21:59
agrathea

Posts: 6
 Joined: 09/17/2007

Wow, I should have posted in the forum before, I'm much smarter all of a sudden! Eye-wink

I was able to get rid of the error message by going into the product settings and choosing under "Default Product Shipping Type: (Store Default)" instead of choosing "(Small Package)". The error is gone!

No further questions (today). Smiling

Theresa

permalink #5 Wed, 09/19/2007 - 07:38
Lyle

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

It looks like I updated uc_quote.install, but not uc_quote.module all the way. So when you ran the update script, those out of date queries didn't know what to do any more. I've committed the fix to that, and you can get rid of the address1 and address2 columns.

Glad to hear you got the other errors straightened out.

permalink #6 Tue, 10/09/2007 - 02:28
scottrigby

Posts: 55
 Joined: 10/08/2007
Getting busy with the Ubercode.

This hasn't been resolved for me - I'm getting hundreds of lines of the same error:

# warning: xml_parse() [function.xml-parse]: Unable to call handler _startElement() in /home/breed/public_html/backroom/modules/ubercart/uc_store/includes/simplexml.php on line 244.
# warning: xml_parse() [function.xml-parse]: Unable to call handler _startElement() in /home/breed/public_html/backroom/modules/ubercart/uc_store/includes/simplexml.php on line 244.
# warning: xml_parse() [function.xml-parse]: Unable to call handler _startElement() in /home/breed/public_html/backroom/modules/ubercart/uc_store/includes/simplexml.php on line 244.

it's when I try to delete an item from the cart by checking the "delete' checkbox, and clicking "update".

http://leastlikely2breed/backroom

permalink #7 Thu, 10/11/2007 - 21:48
scottrigby

Posts: 55
 Joined: 10/08/2007
Getting busy with the Ubercode.

Actually I'm still getting it as an anonymous user, after calculating a shipping quote (which is also presenting problems, like your initial ones - where shipping options show, but says there was an error - verbatim the same as Agathea's orignial post). Then I go to the home page, and get this HUGE list of the same error:

warning: xml_parse() [function.xml-parse]: Unable to call handler _startElement() in /home/breed/public_html/backroom/modules/ubercart/uc_store/includes/simplexml.php on line 244.
warning: xml_parse() [function.xml-parse]: Unable to call handler _startElement() in /home/breed/public_html/backroom/modules/ubercart/uc_store/includes/simplexml.php on line 244.

But like a thousand times or something.

Lyle, or someone, can you help with this? Maybe the two issues are connected? see this other post: http://www.ubercart.org/forum/support/1010/shipping_weight_problem

thaanks in advance!

permalink #8 Fri, 10/12/2007 - 09:59
Lyle

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

Are you using shipping methods other than UPS, that aren't showing up in the quotes? I don't think UPS is the problem because you've been posting the XML replies.

I think there's something wrong with the USPS module because none of the test sites have been getting any information back.