1064 You have an error in your SQL syntax; - When I create children

Started by m.davide82, January 09, 2018, 10:41:07 AM

Previous topic - Next topic

m.davide82

Hello,

I have a serious problem when I create children.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND prd_v.virtuemart_product_id=785' at line 3


The child is created, but when I go to save I receive this error.

Any idea on how can I solve it?


Thanks a lot,
Davide

Jörgen

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

m.davide82

Hi Jorgen,

sorry, here's the details.

Joomla 3.8.3
Virtuemart 3.2.12
Php 7.0.22
DB 5.5.5-10.0.32-MariaDB
Apache cgi-fcgi


Thank you very much!


Jörgen

Whats Your database setting MySqli, MySql (PDO) ?

regards

Jörgen @ Kreativ Fotografi

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

m.davide82


jjk

I wonder where the prd_v in that query comes from. Any idea?
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

Studio 42

Disable all your vmcustom plugins and try again
If it's not resolved, try to disable your system plugins that can have something to do with products.

Jörgen

prd_v could very well come from some plugin for Product management. I think studio42 is on the right track, check Your plugins, this table does not exist in a normal Virtuemart installation.

regards

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

jjk

Perhaps it would be easier to have a look into the database and try to find that variable. Might be simply an entered character (syntax error) which it doesn't like.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations