News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

SOLVED: ERROR in Product creation : 1064 You have an error in your SQL syntax

Started by mandy_bizinbox, September 11, 2015, 18:35:11 PM

Previous topic - Next topic

mandy_bizinbox

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.

mandy_bizinbox

SOLVED!
Sorry guys, it was DropEditor - apparently it doesn't want to work with VM...

Thanks though...

GJC Web Design

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation