Google Checkout module for ZC 1.3.x (beta)

[michelle_rvc]

Hi,

I've attached the added_function_for_google_checkout that I as using. Maybe that would help?

[ropu]

Hi,

I've attached the added_function_for_google_checkout that I as using. Maybe that would help?

the file is the correct one. but still i cant find where the error is.

could you provide some more info on the error? how, step by step, to reproduce it, full error response, etc


ropu

[regenbauma]

I have been getting thsi error message in my google callback error page ........

Your server returned no data in its response; Checkout requires data of type merchant-calculation-results in response to merchant-calculation-callback



what google sends to me is --------------

<?xml version="1.0" encoding="UTF-8"?>
<merchant-calculation-callback xmlns="http://checkout.google.com/schema/2" serial-number="16439351-4dd7-4453-828b-c655a76e1f0d">
<shopping-cart>
<merchant-private-data>


<session-data>4869fb81b0ddd4fcc902e497e4764d0;zenid</session-data>


<product-data>;147</product-data>


<ip-address>68.zzz.yyy.xxx</ip-address>


</merchant-private-data>
<items>
<item>
<quantity>1</quantity>
<unit-price currency="USD">299.95</unit-price>
<item-name>20619 - 7pc Classic Set w/free 8&amp;quot; frypan &amp;amp; free Stack &amp;amp; Steam</item-name>
<item-description></item-description>
<tax-table-selector></tax-table-selector>
</item>
</items>
</shopping-cart>
<buyer-id>12234563</buyer-id>
<calculate>
<addresses>
<anonymous-address id="1112234549972">
<country-code>US</country-code>
<city>Carmel</city>
<region>IN</region>
<postal-code>46033</postal-code>
</anonymous-address>
</addresses>
<merchant-code-strings />
<tax>false</tax>
<shipping>
<method name="Table: Table Rate (vary by weight/price)" />
<method name="UPS: Next Day Air Early AM" />
<method name="UPS: Next Day Air Early AM Letter" />
<method name="UPS: Worldwide Expedited" />
</shipping>
</calculate>
<buyer-language>en_US</buyer-language>
</merchant-calculation-callback>

=======================
I see that this arrives in response_message.log but seems that respondhandler is not responding to it ......

does anyone else see this ..... any clues are helpful ..... thanks

[michelle_rvc]

the file is the correct one. but still i cant find where the error is.

could you provide some more info on the error? how, step by step, to reproduce it, full error response, etc


ropu

This is what google sandbox tells me when I place an order.

Error: Error parsing XML; message from parser is: Unexpected element (div) encountered: div
Warnings: The namespace of all API requests and postings should be "http://checkout.google.com/schema/2", but this document has: "". Try <div xmlns="http://checkout.google.com/schema/2" ...> for your root element.

XML We Received: <div class="systemError">1064 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<br />in:<br />[select products_id, products_weight from products p where products_id in ()]<br /></div>


XML We Sent: <?xml version="1.0" encoding="UTF-8"?>
<merchant-calculation-callback xmlns="http://checkout.google.com/schema/2" serial-number="a8eb5f94-641d-4190-81cc-cb0feaf8c5f9">
<shopping-cart>
<merchant-private-data>


<session-data>f8ea59fda244b925edf63b1a7a885d69;zenid</session-data>


<product-data>;83;45</product-data>


<ip-address>69.128.165.201</ip-address>


</merchant-private-data>
<items>
<item>
<quantity>5</quantity>
<unit-price currency="USD">3.99</unit-price>
<item-name>Robert Kaufman Kona White 42&amp;quot;-45&amp;quot;</item-name>
<item-description></item-description>
<tax-table-selector></tax-table-selector>
</item>
<item>
<quantity>2</quantity>
<unit-price currency="USD">7.49</unit-price>
<item-name>Large Flying Geese</item-name>
<item-description></item-description>
<tax-table-selector></tax-table-selector>
</item>
</items>
</shopping-cart>
<buyer-id>326975014161047</buyer-id>
<calculate>
<addresses>
<anonymous-address id="924377622528329">
<country-code>US</country-code>
<city>Salisbury</city>
<region>NH</region>
<postal-code>03268</postal-code>
</anonymous-address>
</addresses>
<merchant-code-strings />
<tax>false</tax>
<shipping>
<method name="UPS: Next Day Air Early AM" />
<method name="UPS: Next Day Air Early AM Letter" />
<method name="UPS: Worldwide Expedited" />
<method name="USPS: Express Mail" />
<method name="USPS: First-Class Mail" />
<method name="USPS: Priority Mail" />
<method name="USPS: Parcel Post" />
<method name="USPS: Bound Printed Material" />
<method name="USPS: Library" />
</shipping>
</calculate>
<buyer-language>en_US</buyer-language>
</merchant-calculation-callback>

[dhan99]

This is what google sandbox tells me when I place an order.

Error: Error parsing XML; message from parser is: Unexpected element (div) encountered: div
Warnings: The namespace of all API requests and postings should be "http://checkout.google.com/schema/2", but this document has: "". Try <div xmlns="http://checkout.google.com/schema/2" ...> for your root element.

XML We Received: <div class="systemError">1064 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<br />in:<br />[select products_id, products_weight from products p where products_id in ()]<br /></div>


XML We Sent: <?xml version="1.0" encoding="UTF-8"?>
<merchant-calculation-callback xmlns="http://checkout.google.com/schema/2" serial-number="a8eb5f94-641d-4190-81cc-cb0feaf8c5f9">
<shopping-cart>
<merchant-private-data>


<session-data>f8ea59fda244b925edf63b1a7a885d69;zenid</session-data>


<product-data>;83;45</product-data>


<ip-address>69.128.165.201</ip-address>


</merchant-private-data>
<items>
<item>
<quantity>5</quantity>
<unit-price currency="USD">3.99</unit-price>
<item-name>Robert Kaufman Kona White 42&amp;quot;-45&amp;quot;</item-name>
<item-description></item-description>
<tax-table-selector></tax-table-selector>
</item>
<item>
<quantity>2</quantity>
<unit-price currency="USD">7.49</unit-price>
<item-name>Large Flying Geese</item-name>
<item-description></item-description>
<tax-table-selector></tax-table-selector>
</item>
</items>
</shopping-cart>
<buyer-id>326975014161047</buyer-id>
<calculate>
<addresses>
<anonymous-address id="924377622528329">
<country-code>US</country-code>
<city>Salisbury</city>
<region>NH</region>
<postal-code>03268</postal-code>
</anonymous-address>
</addresses>
<merchant-code-strings />
<tax>false</tax>
<shipping>
<method name="UPS: Next Day Air Early AM" />
<method name="UPS: Next Day Air Early AM Letter" />
<method name="UPS: Worldwide Expedited" />
<method name="USPS: Express Mail" />
<method name="USPS: First-Class Mail" />
<method name="USPS: Priority Mail" />
<method name="USPS: Parcel Post" />
<method name="USPS: Bound Printed Material" />
<method name="USPS: Library" />
</shipping>
</calculate>
<buyer-language>en_US</buyer-language>
</merchant-calculation-callback>

I wonder which version of responsehandler.php are you using? I got very similar errors when I used the file from GldRush98 and I found the reason that I explained in post #472
(the calculation of $total_weight depends on the merchant-item-id tag which simply does not exist in the actual XML, even though it is mentioned in Google API document.)

I don't know if you may have had the same problem.

[michelle_rvc]

I wonder which version of responsehandler.php are you using? I got very similar errors when I used the file from GldRush98 and I found the reason that I explained in post #472
(the calculation of $total_weight depends on the merchant-item-id tag which simply does not exist in the actual XML, even though it is mentioned in Google API document.)

I don't know if you may have had the same problem.

Yes, I am using the file from GldRush98 and the updated gco105_zc137 files. When I use any other responsehandler I get the error that I don't ship to that address.

[dhan99]

Yes, I am using the file from GldRush98 and the updated gco105_zc137 files. When I use any other responsehandler I get the error that I don't ship to that address.

That address they wouldn't allow you to ship to, is it a US address or a foreign address? I got that "don't ship to that address" error every single time if my ship-to address is non-US. But for US addresses I'm fine (with gco105_zc137 and nothing else).

[kebeid]

Is anyone getting this error in the admin side:

Warning: Invalid argument supplied for foreach() in /admin/includes/functions/extra_functions/added_function_for_google_checkout.php on line 267

saying somethings wrong with the foreach() - it looks good to me.

[BBG]

This is what google sandbox tells me when I place an order.

Error: Error parsing XML; message from parser is: Unexpected element (div) encountered: div
Warnings: The namespace of all API requests and postings should be "http://checkout.google.com/schema/2", but this document has: "". Try <div xmlns="http://checkout.google.com/schema/2" ...> for your root element.

XML We Received: <div class="systemError">1064 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<br />in:<br />[select products_id, products_weight from products p where products_id in ()]<br /></div>

The problem you're encountering is shown in the "XML We Received" part:

1064 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
in:
[select products_id, products_weight from products p where products_id in ()]

This SQL string is coming from GldRush98's responsehandler.php line 393:

$item_weights_result = $db->Execute("select products_id, products_weight from " . TABLE_PRODUCTS . " p where products_id in (" . $item_id_list . ")");

Prior to line 393, the code is supposed to populate the $item_id_list variable with a list of products id from the merchant-item-id value in the XML- which as dhan99 mentioned a couple posts back, doesn't exist. So $item_id_list just returns nothing (which is why there is nothing in between the parenthesis at the end of the SQL string), which causes your SQL error.

I'm not using GldRush98's responsehandler.php, but perhaps someone else who is using it can help you out.

Shawn

[Jefflam]

[FONT=Arial]Hi everyone,[/FONT]

[FONT=Arial]I could not get google checkout payment module 1.0.4 option in my 1.3.7 zencart"s admin-modules-payments. I did follow all the instructions but failed again and again.[/FONT]

[FONT=Arial]Please give me a hand/hint. Thanks alot.[/FONT]