Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    24
    Plugin Contributions
    0

    Default Database error when click on "Checkout"

    Hi, I'm testing my web site and when I click on "Go to checkout" iget the error:

    I get this error:
    1064 You have an error in your SQL syntax near '(address_book ab left join zones z on (ab.en' 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]

    I'm using version 1.3.0.

    Please help - I'm lost!!

  2. #2
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Database error when click on "Checkout"

    That's a bug that was fixed in v1.3.0.1.

    The download link is in the header of this page "Get Zen Cart"
    .

    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
    May 2006
    Posts
    24
    Plugin Contributions
    0

    Default Re: Database error when click on "Checkout"

    I upgraded to Zen Cart 1.3.0
    Database Patch Level: 1.3.0.1

    But still have the sme error message when I go to Checkout

    Please help!

 

 

Similar Threads

  1. v150 when I click "install" for 2checkout, I get error message
    By maria82g in forum Addon Payment Modules
    Replies: 20
    Last Post: 12 Dec 2014, 06:17 PM
  2. Replies: 1
    Last Post: 30 Oct 2013, 08:26 PM
  3. Replies: 16
    Last Post: 21 Apr 2010, 07:38 PM
  4. Error when i click on the "Home" Link
    By Natural Tone in forum Installing on a Windows Server
    Replies: 5
    Last Post: 10 Dec 2009, 11:01 PM
  5. When I click "PayPal Express Checkout", it doesn't go any further
    By abcdabcd in forum PayPal Express Checkout support
    Replies: 4
    Last Post: 1 Jul 2007, 04:08 AM

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