osCmax v2.5 User Manual
Page 3 of 3 FirstFirst 123
Results 21 to 26 of 26

Google checkout / oscmax 2.5 beta2 not wolrking

This is a discussion on Google checkout / oscmax 2.5 beta2 not wolrking within the osCmax v2 Customization/Mods forums, part of the osCmax v2.0 Forums category; ok i empty the zones then incorporated the file you gave me and received this error. There seems to be ...

      
  1. #21
    Active Member
    Join Date
    Apr 2007
    Posts
    207
    Rep Power
    6


    Default Re: Google checkout / oscmax 2.5 beta2 not wolrking

    ok i empty the zones then incorporated the file you gave me and received this error.

    There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
    ERROR: Unknown Punctuation String @ 23STR: ://SQL: dds World Zones - osCommerce Community Add-Ons INTO zones VALUES (1, 1, 'BDS', 'Badakhshan');

    SQL query:
    dds World Zones - osCommerce Community Add-Ons INSERT INTO zones VALUES (1, 1, 'BDS', 'Badakhshan');
    MySQL said:
    #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 'dds World Zones - osCommerce Community Add-Ons
    INSERT INTO zones VALU' at line 1

  2. #22
    osCMax Development Team
    pgmarshall's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    2,678
    Rep Power
    49


    Smile Re: Google checkout / oscmax 2.5 beta2 not wolrking

    Only copy the stuff from the second line onwards - phpMyAdmin or similar will not like you trying to insert the program information in the first line!

    This will drop the current zones table and then re-install it:
    Code:
    DROP TABLE IF EXISTS zones;
    CREATE TABLE zones (
      zone_id int NOT NULL auto_increment,
      zone_country_id int NOT NULL,
      zone_code varchar(32) NOT NULL,
      zone_name varchar(32) NOT NULL,
      PRIMARY KEY (zone_id),
      KEY idx_zones_country_id (zone_country_id),
      KEY idx_zones_to_geo_zones_country_id (zone_country_id)
    );
    Then use the zip from Michael making sure you only post from the below onwards:
    Code:
    INSERT INTO `zones` VALUES(1, 1, 'BDS', 'Badakhshan');
    INSERT INTO `zones` VALUES(2, 1, 'BDG', 'Badghis');
    INSERT INTO `zones` VALUES(3, 1, 'BGL', 'Baghlan');
    Regards,
    pgmarshall
    _______________________________

  3. #23
    Active Member
    Join Date
    Apr 2007
    Posts
    207
    Rep Power
    6


    Default Re: Google checkout / oscmax 2.5 beta2 not wolrking

    i fixed it another way i just went to my other site and exported the zones then i inported it to the site with the problem got all countries and citys back, but i changed the country and cioty saved it went back in changed it back to united states and wisconsin still recving error:




    <?xml version="1.0" encoding="UTF-8"?>
    <checkout-shopping-cart xmlns="http://checkout.google.com/schema/2">
    <shopping-cart>
    <items>
    <item>
    <item-name>Spanish Cutwork Candle Lantern</item-name>
    <item-description>&lt;p&gt;
    &lt;span style=&quot;font-size:16px&quot;&gt;&lt;span style=&quot;font-family:comic sans ms, cursive&quot;&gt;Reminiscent of the glasswork found in the finest Spanish estates, the panels of this candle lantern delight the eye with radiant patterns of light. The very essence of timeless design!&lt;br&gt;
    &lt;br&gt;
    Weight 1.5 lbs. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
    &lt;p&gt;
    &lt;span style=&quot;font-size:16px&quot;&gt;&lt;span style=&quot;font-family:comic sans ms, cursive&quot;&gt;Iron and glass. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
    &lt;p&gt;
    &lt;span style=&quot;font-size:16px&quot;&gt;&lt;span style=&quot;font-family:comic sans ms, cursive&quot;&gt;Candle not included. &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
    &lt;p&gt;
    &lt;span style=&quot;font-size:16px&quot;&gt;&lt;span style=&quot;font-family:comic sans ms, cursive&quot;&gt;4 3/4&amp;quot; square x 7 1/2&amp;quot; high; 9 3/4&amp;quot; high with handle&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;</item-description>
    <unit-price currency="USD">6.9</unit-price>
    <quantity>1</quantity>
    <merchant-private-item-data>
    <item>YToxMDp7czozOiJxdHkiO2k6MTtzOjQ6Im5hbWUiO3M6 MzA6IlNwYW5pc2ggQ3V0d29yayBDYW5kbGUgTGFudGVybiI7cz o1OiJtb2RlbCI7czo1OiIxMzE4MiI7czo0OiJjb2RlIjtzOjU6 IjEzMTgyIjtzOjM6InRheCI7aTowO3M6MTU6InRheF9kZXNjcm lwdGlvbiI7czoxNjoiVW5rbm93biB0YXggcmF0ZSI7czo1OiJw cmljZSI7czo2OiI2LjkwMDAiO3M6MTE6ImZpbmFsX3ByaWNlIj tkOjYuOTAwMDAwMDAwMDAwMDAwMzU1MjcxMzY3ODgwMDUwMDky OTM1NTYyMTMzNzg5MDYyNTtzOjY6IndlaWdodCI7czo1OiIxLj UwMCI7czoyOiJpZCI7aTozMTQ7fQ==</item>
    </merchant-private-item-data>
    <merchant-item-id>314</merchant-item-id>
    <tax-table-selector>Taxable Goods</tax-table-selector>
    <item-weight unit="LB" value="1.5" />
    </item>
    <item>
    <item-name>Low Order Fee:</item-name>
    <item-description></item-description>
    <unit-price currency="USD">0</unit-price>
    <quantity>1</quantity>
    <merchant-private-item-data>
    <order_total>YTo1OntzOjQ6ImNvZGUiO3M6MTQ6Im90X2xvd 29yZGVyZmVlIjtzOjU6InRpdGxlIjtzOjE0OiJMb3cgT3JkZXI gRmVlOiI7czo0OiJ0ZXh0IjtzOjU6IiQyLjAwIjtzOjU6InZhb HVlIjtzOjQ6IjIuMDAiO3M6MTA6InNvcnRfb3JkZXIiO3M6MTo iNCI7fQ==</order_total>
    </merchant-private-item-data>
    <item-weight unit="LB" value="0" />
    </item>
    </items>
    <merchant-private-data>
    <session-data>8e613ce0729ecf3f4b670ad33e58c242;osCsid</session-data>
    <oscommerce-version>osCmax v2.5 Beta 2</oscommerce-version>
    <google-checkout-module-version>v1.5.0</google-checkout-module-version>
    </merchant-private-data>
    </shopping-cart>
    <checkout-flow-support>
    <merchant-checkout-flow-support>
    <edit-cart-url>http://www.cujosinc.com/catalog/shopping_cart.php</edit-cart-url>
    <continue-shopping-url>http://www.cujosinc.com/catalog/gc_return.php</continue-shopping-url>
    <shipping-methods>
    <flat-rate-shipping name="Table: Table">
    <price currency="USD">0</price>
    <shipping-restrictions>
    <allow-us-po-box>true</allow-us-po-box>
    <allowed-areas>
    <us-country-area country-area="ALL" />
    </allowed-areas>
    </shipping-restrictions>
    </flat-rate-shipping>
    <flat-rate-shipping name="Table: Table intl">
    <price currency="USD">0</price>
    <shipping-restrictions>
    <allow-us-po-box>true</allow-us-po-box>
    <allowed-areas>
    <world-area />
    </allowed-areas>
    <excluded-areas>
    <postal-area>
    <country-code>US</country-code>
    </postal-area>
    </excluded-areas>
    </shipping-restrictions>
    </flat-rate-shipping>
    <carrier-calculated-shipping>
    <carrier-calculated-shipping-options>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>FedEx</shipping-company>
    <shipping-type>Ground</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>FedEx</shipping-company>
    <shipping-type>Home Delivery</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>FedEx</shipping-company>
    <shipping-type>Express Saver</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>FedEx</shipping-company>
    <shipping-type>2Day</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>FedEx</shipping-company>
    <shipping-type>Standard Overnight</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>FedEx</shipping-company>
    <shipping-type>Priority Overnight</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>FedEx</shipping-company>
    <shipping-type>First Overnight</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>UPS</shipping-company>
    <shipping-type>Ground</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>UPS</shipping-company>
    <shipping-type>3 Day Select</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>UPS</shipping-company>
    <shipping-type>2nd Day Air</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>UPS</shipping-company>
    <shipping-type>2nd Day Air AM</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>UPS</shipping-company>
    <shipping-type>Next Day Air Saver</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>UPS</shipping-company>
    <shipping-type>Next Day Air</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>UPS</shipping-company>
    <shipping-type>Next Day Air Early AM</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>USPS</shipping-company>
    <shipping-type>Media Mail</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>USPS</shipping-company>
    <shipping-type>Parcel Post</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>USPS</shipping-company>
    <shipping-type>Express Mail</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    <carrier-calculated-shipping-option>
    <price currency="USD">10</price>
    <shipping-company>USPS</shipping-company>
    <shipping-type>Priority Mail</shipping-type>
    <carrier-pickup>REGULAR_PICKUP</carrier-pickup>
    </carrier-calculated-shipping-option>
    </carrier-calculated-shipping-options>
    <shipping-packages>
    <shipping-package>
    <ship-from id="Store_origin">
    <city></city>
    <region>WI</region>
    <postal-code>53186</postal-code>
    <country-code>US</country-code>
    </ship-from>
    <width unit="IN" value="1" />
    <length unit="IN" value="1" />
    <height unit="IN" value="1" />
    <delivery-address-category>RESIDENTIAL</delivery-address-category>
    </shipping-package>
    </shipping-packages>
    </carrier-calculated-shipping>
    </shipping-methods>
    <request-buyer-phone-number>true</request-buyer-phone-number>
    <tax-tables>
    <default-tax-table>
    <tax-rules>
    <default-tax-rule>
    <shipping-taxed>false</shipping-taxed>
    <rate>0</rate>
    <tax-area>
    <world-area />
    </tax-area>
    </default-tax-rule>
    </tax-rules>
    </default-tax-table>
    <alternate-tax-tables>
    <alternate-tax-table standalone="false" name="Taxable Goods">
    <alternate-tax-rules>
    <alternate-tax-rule>
    <rate>0.07</rate>
    <tax-area>
    <us-state-area>
    <state>KDZ</state>
    </us-state-area>
    </tax-area>
    </alternate-tax-rule>
    </alternate-tax-rules>
    </alternate-tax-table>
    </alternate-tax-tables>
    </tax-tables>
    <rounding-policy>
    <mode>HALF_EVEN</mode>
    <rule>PER_LINE</rule>
    </rounding-policy>
    <platform-id>352459354768565</platform-id>
    </merchant-checkout-flow-support>
    </checkout-flow-support>
    </checkout-shopping-cart>

  4. #24
    Active Member
    Join Date
    Apr 2007
    Posts
    207
    Rep Power
    6


    Default Re: Google checkout / oscmax 2.5 beta2 not wolrking

    well i got the googlecheckout to go to google had to go into the product and were it says taxable good taxable item i put it at None and it worked but when i get to google it does not put in shipping price or low order cost it ahs a drop down for shipping and list all shipping for fedex and UPS i do not have either installed i use table rate i wnet to settings in google and created table still same think.

    1.JPG

  5. #25
    Active Member
    Join Date
    Apr 2007
    Posts
    207
    Rep Power
    6


    Default Re: Google checkout / oscmax 2.5 beta2 not wolrking

    Have we found a fix for this Yet Thank you for all your help

  6. #26
    Active Member
    Join Date
    Apr 2007
    Posts
    207
    Rep Power
    6


    Default Re: Google checkout / oscmax 2.5 beta2 not wolrking

    sorry it took so long to get back to this but to fix this problem all i did was in each of my products i changed from taxable goods to none and everything works. the only thing googlecheckout does not do is Create a order in OSCMAX no order in orders do get order from google. any ideas.

Page 3 of 3 FirstFirst 123

Similar Threads

  1. Replies: 4
    Last Post: 03-17-2011, 02:22 PM
  2. Google Checkout for osCMax
    By michael_s in forum osCmax Projects Discussion
    Replies: 15
    Last Post: 10-01-2010, 01:48 PM
  3. [Beta Module] Google Checkout for osCMax v1.4.5 CCS
    By michael_s in forum Google Checkout
    Replies: 14
    Last Post: 08-19-2010, 08:22 AM
  4. osCMax Google Checkout Integration Failure
    By schlottke in forum osCMax v2 Features Discussion
    Replies: 2
    Last Post: 07-22-2010, 09:56 AM
  5. Official Google Checkout v1.4 for osCMax 2.0 thread
    By michael_s in forum Google Checkout
    Replies: 16
    Last Post: 05-21-2009, 09:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •