Author Topic: 1064 You have an error in your SQL syntax; - When I create children  (Read 966 times)

m.davide82

  • Jr. Member
  • **
  • Posts: 121
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

  • Global Moderator
  • Full Member
  • *
  • Posts: 1804
    • Kreativ Fotografi
  • VirtueMart Version: 3.2.12
Re: 1064 You have an error in your SQL syntax; - When I create children
« Reply #1 on: January 09, 2018, 11:46:51 am »
Joomla 3.8.3
Virtuemart 3.2.12
Olympiantheme Hera (customized)

m.davide82

  • Jr. Member
  • **
  • Posts: 121
Re: 1064 You have an error in your SQL syntax; - When I create children
« Reply #2 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!

m.davide82

  • Jr. Member
  • **
  • Posts: 121
Re: 1064 You have an error in your SQL syntax; - When I create children
« Reply #3 on: January 11, 2018, 10:55:54 am »
No-one can help me please?


Thanks.

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 1804
    • Kreativ Fotografi
  • VirtueMart Version: 3.2.12
Re: 1064 You have an error in your SQL syntax; - When I create children
« Reply #4 on: January 11, 2018, 13:25:20 pm »
Whats Your database setting MySqli, MySql (PDO) ?

regards

Jörgen @ Kreativ Fotografi

Joomla 3.8.3
Virtuemart 3.2.12
Olympiantheme Hera (customized)

m.davide82

  • Jr. Member
  • **
  • Posts: 121
Re: 1064 You have an error in your SQL syntax; - When I create children
« Reply #5 on: January 11, 2018, 17:32:50 pm »
Hi Jorgen,

my setting is: MySqli


Thanks.

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3376
  • using Matomo instead of Google Analytics
Re: 1064 You have an error in your SQL syntax; - When I create children
« Reply #6 on: January 12, 2018, 00:00:12 am »
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

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 3522
  • Joomla & Virtuemart addon developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3.0.x.y
Re: 1064 You have an error in your SQL syntax; - When I create children
« Reply #7 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.

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 1804
    • Kreativ Fotografi
  • VirtueMart Version: 3.2.12
Re: 1064 You have an error in your SQL syntax; - When I create children
« Reply #8 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
Joomla 3.8.3
Virtuemart 3.2.12
Olympiantheme Hera (customized)

jjk

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3376
  • using Matomo instead of Google Analytics
Re: 1064 You have an error in your SQL syntax; - When I create children
« Reply #9 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.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations