VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: mandy_bizinbox on September 11, 2015, 18:35:11 PM

Title: SOLVED: ERROR in Product creation : 1064 You have an error in your SQL syntax
Post by: mandy_bizinbox on September 11, 2015, 18:35:11 PM
Hi, hope someone can help:

I am running VM 3.08 on Joom 3.4.4
PHP version  5.5.42-37.1

I am getting this error:
1064 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 a.published=1 AND a.iscore=0 AND a.type="plugin" ORDER BY a.row, a.id' at line 3 SQL=SELECT a.name FROM joom_dropeditor_plugins AS a WHERE a.id IN (50,85,86,44,47,45,46,41,73,92,13,14,18,28,29,1,23,101,104,72,74,103,102,59,21,-1,11,5,6,7,8,93,-1,4,9,10,88,107,-1,40,42,43,24,80,-1,48,64,63,94,3,) AND a.published=1 AND a.iscore=0 AND a.type="plugin" ORDER BY a.row, a.id
:o :o :o :o :o
I get this only on Product Creation and Editing, I do not get it anywhere else on my website and nowhere else in VM just when i try to create a product or edit a product.

Anyone know what can be the cause and how to fix?

I tried installing VM again, but didn't work.
Title: Re: ERROR in Product creation : 1064 You have an error in your SQL syntax
Post by: mandy_bizinbox on September 11, 2015, 18:45:01 PM
SOLVED!
Sorry guys, it was DropEditor - apparently it doesn't want to work with VM...

Thanks though...
Title: Re: SOLVED: ERROR in Product creation : 1064 You have an error in your SQL syntax
Post by: GJC Web Design on September 11, 2015, 20:08:28 PM
it is the last , before the ) breaking it isn't it?