[Skip to main content](#vessel-content) # Error 1064 checkout "zones" ## - **[davez](/forum/user/26995-davez "View davez's Profile")** - [![davez's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26995-davez "View davez's Profile") Topic Author - [ Offline](/forum/user/26995-davez) Less More - Posts: 2 - Thank you received: 0 - - 13 years 2 months ago [\#119933](#119933) by [davez](/forum/user/26995-davez "View davez's Profile") *[Error 1064 checkout "zones"](/forum/27-checkout/861320-error-1064-checkout-zones#119933 "Hi, I can't figure this one out. I've reinstalled HikaShop. If you login this issue occurs. It does't occur if your not logged in. Any idea how to solve it. It happens when you login and go to checkout. -- url of the page with the problem -- : dev.marketsquarefood.com/products/2-ounce/checkout.html -- HikaShop version -- : HikaShop Starter: 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.20 -- Browser(s) name and version -- : Firefox/IE/All -- Error-message(debug-mod must be tuned on) -- : Error: 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 SQL=SELECT zone_id, zone_code_2 FROM p5ths_hikashop_zone WHERE zone_id IN (-)")* was created by *[davez](/forum/user/26995-davez "View davez's Profile")* Hi, I can't figure this one out. I've reinstalled HikaShop. If you login this issue occurs. It does't occur if your not logged in. Any idea how to solve it. It happens when you login and go to checkout. -- url of the page with the problem -- : [ dev.marketsquarefood.com/products/2-ounce/checkout.html](http://dev.marketsquarefood.com/products/2-ounce/checkout.html) -- HikaShop version -- : HikaShop Starter: 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.20 -- Browser(s) name and version -- : Firefox/IE/All -- Error-message(debug-mod must be tuned on) -- : Error: 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 SQL=SELECT zone_id, zone_code_2 FROM p5ths_hikashop_zone WHERE zone_id IN (-) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2MTMyMC1lcnJvci0xMDY0LWNoZWNrb3V0LXpvbmVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[davez](/forum/user/26995-davez "View davez's Profile")** - [![davez's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26995-davez "View davez's Profile") Topic Author - [ Offline](/forum/user/26995-davez) Less More - Posts: 2 - Thank you received: 0 - - 13 years 2 months ago [\#119934](#119934) by [davez](/forum/user/26995-davez "View davez's Profile") Replied by *[davez](/forum/user/26995-davez "View davez's Profile")* on topic *[Error 1064 checkout "zones"](/forum/27-checkout/861320-error-1064-checkout-zones#119934 "Hi, I can't figure this one out. I've reinstalled HikaShop. If you login this issue occurs. It does't occur if your not logged in. Any idea how to solve it. It happens when you login and go to checkout. -- url of the page with the problem -- : dev.marketsquarefood.com/products/2-ounce/checkout.html -- HikaShop version -- : HikaShop Starter: 2.2.0 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.20 -- Browser(s) name and version -- : Firefox/IE/All -- Error-message(debug-mod must be tuned on) -- : Error: 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 SQL=SELECT zone_id, zone_code_2 FROM p5ths_hikashop_zone WHERE zone_id IN (-)")* Okay, I think I figured it out. The problem was in the UPS plugin in how I have configured our billing and shipping method. It looks like if there's no shipping method, the UPS plugin gives an error because it doesn't know what state or country to pull from. [resolved enough for now] Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2MTMyMC1lcnJvci0xMDY0LWNoZWNrb3V0LXpvbmVzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.103 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)