Hello,

We have a problem on check-out.

When ordering a producte we get the following error in the send adres.

No valid database connection 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 'AND state_2_code=''' at line 1 SQL=SELECT * FROM jos_vm_state WHERE country_id= AND state_2_code=''

Alse the Send adres can not be selected, it skips that step.

After purging the SEF urls on joomsef it all works again.

Can you tell me what is going wrong or how we can disable the creation for SEF urls on the checkout process.

Site: www.gereedschappelijk.nl
Joomla 1.5.15
Virtuemart 1.1.3
JoomSef 3.5.3
JoomSef Virtuemart extension 2.0.15
Joomfish 2.0.4

Order ID: 6780

Regards,
Bastiaan

Hello,

by checking the code, the problem is that there is no value for country_id.
Syntax contry_id= with no value causes the error. Same it may be with state_2_code.
However, I do not see a relation between JoomSEF and this query.

Do you have the checkout process somehow customized?
Try checking the stored SEO URLs, maybe there is some conflict. (that can occur, when there exists some invalid link that generates same SEO URL as the "original" URL you have problem with - in this case the VM checkout link)

You can also exclude the link from being SEFed by decarinf some a variables as non-SEF ones or defining a non-SEF filter. This can be done in JoomSEF VM extension settings.

Hello Jan, thank you for te response.

Can you give an example on how I get the whole check-out process non seffed?

Thanks in advance.

Regards,
Bastiaan

Hello,

that can be configured in the VirtueMart JoomSEF extension settings.
You can define that in
Do not SEF URLs matching regular expression, no URLs containing e.g. "checkout" will be ignored in the SEF process.
(we will also consider adding this option to standard predefined settings)

Hello,

in meantime, please see:
www.artio.net/support-forums/joomsef-pai...mer-can-t-send-order

Anyway, we probably identified the problem, so we will release the new extension version very soon.

Hello,
new VirtueMart JoomSEF extension - version 2.0.18 is available. It addresses this issue also, please upgrade.