[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?
Re: Checkout_shipping problem
What version of Zen Cart?
What version of PHP?
What version of MySQL?
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
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
Re: Checkout_shipping problem
you may want to upgrade php to meet zen minimums
PHP 4.3.1 is a litle low
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 ...
Re: Checkout_shipping problem
please close thread, fixed the error myself thanks
Re: Checkout_shipping problem
What was the solution? :smile:
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)
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 ...