Problem with items with attributes

[SpottyCupcakes]

I have a group of products on my website with specific attributes. I think I have set them up correctly. People can add them to their shopping basket ok but when they try and check out they get the following message.

WARNING: An Error occurred, please refresh the page and try again.

Here are the items in question. Disregard the first product as I had to remove the attributes to allow someone to place their order. http://www.spottycupcakes.co.uk/inde...index&cPath=80

I have checked my logs and this is what is recorded. Anyone know what I should do (bearing in mind I'm a complete novice at this)?

[01-Feb-2014 20:41:22 Europe/London] PHP Fatal 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 ':e9884d55e58e203da17a351accf67ead, 198) AND po.products_options_name = "Minimum ' at line 1 :: SELECT ifnull(max(pov.products_options_values_sort_order), 0) as postage_attribute FROM products_options_values pov INNER JOIN products_attributes pa ON pov.products_options_values_id = pa.options_values_id INNER JOIN products_options po ON po.products_options_id = pa.options_id WHERE pa.products_id IN (250, 182, 215:e9884d55e58e203da17a351accf67ead, 198) AND po.products_options_name = "Minimum Delivery Method:" in /home/spott698/public_html/includes/classes/db/mysql/query_factory.php on line 120

Many thanks in advance.

[twitchtoo]

Just placed a test order on your site with the items in question, no errors. Which one specifically caused this?

[SpottyCupcakes]

This one for example http://www.spottycupcakes.co.uk/inde...8e5bae8b127c6a

It can be added to the basket but when you try and checkout the error message comes up.

P.s. I see that you have placed a test order did you not encounter any problems at all?

[stevesh]

Works OK for me, too (Jim Dandy).

[SpottyCupcakes]

I have no idea what is going on then. I had two customers this evening report the same problem which is why I tried it out. I can't even get to the checkout never mind place an order.

[SpottyCupcakes]

Thanks for taking the time to test it. I don't know what is wrong then.

[SpottyCupcakes]

Ok, I set up a dummy account registered to the US and I can check out no problem. Does anyone know why this fault is only occurring with UK accounts?

[SpottyCupcakes]

Sorry for all the updates but I'm just posting them in the hope that someone can help.

I removed the shipping modules I have installed ie "Royal Mail 1st Class "Large Letter" ver. 3.2.0" just leaving me with store pickup and I can check out using that.

I think I have narrowed it down to that. If I can't get it fixed I will have to list each option individually which isn't ideal but my only option.

[twitchtoo]

This one for example http://www.spottycupcakes.co.uk/inde...8e5bae8b127c6a

It can be added to the basket but when you try and checkout the error message comes up.

P.s. I see that you have placed a test order did you not encounter any problems at all?

No problems the first time, no problems with the product you specified, check order #9 :)

[SpottyCupcakes]

No problems the first time, no problems with the product you specified, check order #9 :)

Thanks again for testing. I think it is a problem with UK shipping. All UK orders can be processed if I remove UK shipping options from my admin panel and store pickup is the only option remaining. I think this is why the US orders are being processed as the only option is Store Pickup.