Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2006
    Posts
    8
    Plugin Contributions
    0

    [DONE] Checkout_shipping problem -- user error

    Not sure if this is a bug or what. I was trying to run a test purchase on my store to make sure everything is functioning properly before going live sometime next week and when i went to check out, this was the error that i got:

    1064 You have an error in your SQL syntax near '(address_book ab left join zones z on (ab.ent' at line 7
    in:
    [select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, co.countries_id, co.countries_name, co.countries_iso_code_2, co.countries_iso_code_3, co.address_format_id, ab.entry_state from customers c, (address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries co on (ab.entry_country_id = co.countries_id) ) where c.customers_id = '1' and ab.customers_id = '1' and c.customers_default_address_id = ab.address_book_id]


    Any suggestions?

  2. #2
    Join Date
    Jan 2004
    Posts
    66,363
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Checkout_shipping problem

    What version of Zen Cart?
    What version of PHP?
    What version of MySQL?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Jun 2006
    Posts
    8
    Plugin Contributions
    0

    Default Re: Checkout_shipping problem

    Latest version of Zencart, just installed it 3 days ago. Mysql 3.23.56 older i know (i dread upgrading, lastime i did it was an absolute mess), and PHP 4.3.1

  4. #4
    Join Date
    Jun 2006
    Posts
    8
    Plugin Contributions
    0

    Default Re: Checkout_shipping problem

    apparently someone else had the same problem but the link for the fix was cut off

    http://www.zen-cart.com/forum/showthread.php?t=33036

  5. #5
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: Checkout_shipping problem

    you may want to upgrade php to meet zen minimums
    PHP 4.3.1 is a litle low

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Checkout_shipping problem

    Check to be sure that you actually have v1.3.0.1 ... that is a bug that was in v1.3 and was fixed in v1.3.0.1 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  7. #7
    Join Date
    Jun 2006
    Posts
    8
    Plugin Contributions
    0

    Default Re: Checkout_shipping problem

    please close thread, fixed the error myself thanks

  8. #8
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Checkout_shipping problem

    What was the solution?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  9. #9
    Join Date
    Jun 2006
    Posts
    8
    Plugin Contributions
    0

    Default Re: Checkout_shipping problem

    Line 238 of order.php reads:

    from " . TABLE_CUSTOMERS . " c, (" . TABLE_ADDRESS_BOOK . " ab

    when it should read:

    from " . TABLE_CUSTOMERS . " c, " . TABLE_ADDRESS_BOOK . " ab


    and Line 240 of order.php reads:

    left join " . TABLE_COUNTRIES . " co on (ab.entry_country_id = co.countries_id) )

    when it should read:

    left join " . TABLE_COUNTRIES . " co on (ab.entry_country_id = co.countries_id)

  10. #10
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Checkout_shipping problem

    Thanks for the info ...

    Do take some time to check that you did in fact update all of your files to v1.3.0.1 when you upgraded ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 

Similar Threads

  1. Checkout_shipping error message
    By ericny in forum General Questions
    Replies: 4
    Last Post: 2 Apr 2010, 12:37 AM
  2. checkout_shipping template problem
    By BlessIsaacola in forum Bug Reports
    Replies: 42
    Last Post: 18 Oct 2007, 10:25 PM
  3. [user error] Sendmail CRLF problem
    By patski in forum Bug Reports
    Replies: 2
    Last Post: 12 Sep 2006, 04:05 PM
  4. checkout_shipping problem I think
    By TheWetFish in forum Built-in Shipping and Payment Modules
    Replies: 15
    Last Post: 31 May 2006, 04:51 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR