Error 1064 checkout "zones"

  • Posts: 2
  • Thank you received: 0
11 years 8 months ago #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 (-)

Please Log in or Create an account to join the conversation.

  • Posts: 2
  • Thank you received: 0
11 years 8 months ago #119934

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 or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum