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

[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]

Please

http://forum.virtuemart.net/index.php?topic=79799.0

Jörgen @ Kreativ Fotografi

[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!

[m.davide82]

No-one can help me please?


Thanks.

[Jörgen]

Whats Your database setting MySqli, MySql (PDO) ?

regards

Jörgen @ Kreativ Fotografi

[m.davide82]

Hi Jorgen,

my setting is: MySqli


Thanks.

[jjk]

I wonder where the prd_v in that query comes from. Any idea?

[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

[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.