Error 1064 on checkout

-- url of the page with the problem -- : dadshotsauce.net
-- HikaShop version -- :2.2.1 Essential
-- Joomla version -- : 3.1.5
-- PHP version -- :5.3
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- :

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 ajx70_hikashop_zone WHERE zone_id IN (-)

I reached the error above twice. The first time I was testing the UPS shipping plugin, which was showing me a "no shipper" notice.
However, after I registered that error went away and instead a message about (I paraphrase) a "Wrongly configured or no warehouse" showed up.
In the backend I deleted the warehouse from the UPS plugin, which in fact appears not to be a necessary feature and I went to refresh the checkout page in the front end. Upon refreshing I got this "Page not found" with the error below.

I went to the home page again, and added another product but when I clicked on "Checkout" again I received the same error page.
After I deleted both products from the cart and I added a new product I clicked on checkout and it worked fine, except for the fact that I still get a "No shipping method found" even though my UPS plugin seems to be properly configured.

I am not sure if this is a big deal, but I noticed the page is also [pretty badly formatted. Is there a way to redirect to a better 404/error page than this? It's missing most of the CSS.

Thank you for looking ionto this. My biggest issue is that the UPS plugin is giving me a

Message
No shipping method found

Whenever I checkout something. Here is a screenshot of the UPS plugin before I deleted the warehouse (which I can add again easily)
Below itr is a screenshot of my checkout preferences

Here is the checkout screenshot.

Makes sense. So I entered the warehouse again (as shown in the screenshot) but in the Zone I added all 50 states (for now, then I'll add Canada and any other zone necessary).

Unfortunately, now the error message has changed to:

Message
No available warehouse found for your location

At the very least, is this a message from UPS? Neither my client or I have any clue what it's meant by "Warehouse". I have assumed it is their Shipping location.

I added the info again and in the "zone" I have opened up the zone editor, selected "states" and then USA and I selected all 57 and pressed OK.
However, here it looks like only Alaska is chosen. That's why I picked Colorado before. What do I have to chose as a warehouse zone? I tried nothing and it still gave me the same error.

This is what it looks like when I choose all the 57 options and click "OK":



The relative error is:
Message
No available warehouse found for your location

This is what it looks like without a zone at all:

And its relative error is:
Message
No shipping method found

But I noticed in the "Zone" popup that there is a class of zones called "Shipping Zones. In my case it's empty. Is that what I am missing?

PS: I am on my way to see a doctor, so I'll get back to this tomorrow or Monday. But I need to make this UPS plugin work one way or another. Thank you

We'll, then that means something else is happening because without a warehouse specified I get the old

Message
No shipping method found

I am sure that:

1) I have an address
2) The product diomensions are specified as is the weight
3) The UPS plugin has been filled as best I could, but I took most opf the data not from my clieent,rather I logged into their account.

This is what the error looks like without the warehouse specified:

Actually, the UPS plugin is active and the reason there is no warehouse specified is because we have already tried with a warehouse and that produced another error.

If you read the previous posts, there is a list of all the things I tried, including what the other moderator suggested. One of the last things he suggested I tried was to take out the Warehouse completely to see what the results were. My last post was a report on that test I performed.

What would be interesting to know for me is to take screenshots of all the areas in hikashop where there could be an error in setting up the UPS plugin. I'll be happy to take screeshots and publish them so you guys can tell me what I may be doing wrong.

Thank you.

Hi,

Thanks to set again some warehouses, and give us a screenshot of the error returned.

Xavier wrote: Hi,

Thanks to set again some warehouses, and give us a screenshot of the error returned.

I also have the error. And confirming..was this ever resolved please?

No shipping method found

All UPS data correct, if I select "M" for dimensions, UPS tells me incorrect.. If I use "inches" I get this error.

How do I get the screen shot in the message? I have tried to "paste" and it does not populate here:

Using CTRL > PrintScreen I works going to email fine.

OK, I figured that I guess.. I just saw others had done it...and other BB systems allow it...this one must not. Normally I would have just used Irfanview (but I do not have it installed yet on this laptop.

Please stand by...but I do have an update.

I found The client had made a mistake in Product, For "VOLUME" he had "Feet" instead of inches !!

Just letting others know, that is could be a cause also...I mean UPS does Not allow "FT" for measurements

1) The cart zone is United States of America > PA is and he was able to then SELECT the various UPS Methods Properly

2) I am in Illinois, but I still see the error... Do I have to add every single state of the United States?

I will go look for Zone Restriction as you mention..

Here is Screenshot...sorry for delay, had to install program

Attched

?? www.hikashop.com/support/documentation/9...ipping-ups-form.html ??

Zone Restriction? The word "zone" is not on that page

1) Zone from Screenshot removed

2) Cart = No available warehouse found for your location

3) Zone, sorry... I must not set Focus for Edit>Find [on page]

4) re: don't set any zone restriction, as explained in the UPS plugin documentation

5) The word > restriction is non-existent on that page as well as > zone restriction