Google Checkout module for ZC 1.3.x (beta)

[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.