Virtuemart 3.0.9 SQL error after adding product to the cart

[virtueb]

I get sometimes SQL error after adding new products and goes to the cart, it's like random effect, sometimes is sql error and sometimes is ok. The same is for the guest mode and if a user is logged in.

Code Select Expand

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 country_2_code from #_virtuemart_countries where virtuemart_country_id=

How it's possible to fix this error? I tried with virtuemart tools but nothing is fixed.

[virtueb]

I tried to disable overrides but I have still the same problem, any idea?

[PRO]

did you do the table updater?

[virtueb]

I done this more times, but everytime the same problem, what have I to do?

[PRO]

are you using the default checkout?

or a one page?

[virtueb]

I use classic virtuemart checkout. No extra plugins...

[Studio 42]

Hi,

DO you have removed/disabled the country in the userfields ?
And made the country  as "required", if this is not the case, in your SQL the country_id seems missing

Greets,
Patrick

[virtueb]

Everything is there and not deleted. Can it be a shipping method problem?

[Studio 42]

Hi,
Try to unpublish all and use by weight country and do a full chekout.
Do same for paiment unpublish (if the ug persist) all and set and publish standard paiment for testing, this can come from a paiment plugin. I know one or 2 have bugs on some VM release.
THe best is to unpublish all unused paiment and shiopment in Joomla plugin management because Joomla load all published plugins, used or not.