Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: m.davide82 on January 09, 2018, 10:41:07 AM

Title: 1064 You have an error in your SQL syntax; - When I create children
Post by: m.davide82 on January 09, 2018, 10:41:07 AM
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
Title: Re: 1064 You have an error in your SQL syntax; - When I create children
Post by: Jörgen on January 09, 2018, 11:46:51 AM
Please

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

Jörgen @ Kreativ Fotografi
Title: Re: 1064 You have an error in your SQL syntax; - When I create children
Post by: m.davide82 on January 09, 2018, 18:37:10 PM
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!
Title: Re: 1064 You have an error in your SQL syntax; - When I create children
Post by: m.davide82 on January 11, 2018, 10:55:54 AM
No-one can help me please?


Thanks.
Title: Re: 1064 You have an error in your SQL syntax; - When I create children
Post by: Jörgen on January 11, 2018, 13:25:20 PM
Whats Your database setting MySqli, MySql (PDO) ?

regards

Jörgen @ Kreativ Fotografi

Title: Re: 1064 You have an error in your SQL syntax; - When I create children
Post by: m.davide82 on January 11, 2018, 17:32:50 PM
Hi Jorgen,

my setting is: MySqli


Thanks.
Title: Re: 1064 You have an error in your SQL syntax; - When I create children
Post by: jjk on January 12, 2018, 00:00:12 AM
I wonder where the prd_v in that query comes from. Any idea?
Title: Re: 1064 You have an error in your SQL syntax; - When I create children
Post by: Studio 42 on January 12, 2018, 01:59:29 AM
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.
Title: Re: 1064 You have an error in your SQL syntax; - When I create children
Post by: Jörgen on January 12, 2018, 07:11:09 AM
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
Title: Re: 1064 You have an error in your SQL syntax; - When I create children
Post by: jjk on January 12, 2018, 09:23:27 AM
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.
Text only | Text with Images