Error after add customfield to new product:You have an error in your SQL syntax;

Started by parfumylacno, July 01, 2017, 15:34:34 PM

Previous topic - Next topic

parfumylacno

Hello,

I m using custom field for All - https://breakdesigns.net/extensions/joomla/custom-fields-for-all/documentation . There was no problem and all works fine. But now (after 7 month) i m trying add new products to shop - it works. But when i add customfiled (customfield that are using in every old product) to that new product then its broke up and show this error message (print screen):

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 ')' at line 1 SQL=DELETE FROM `#__virtuemart_product_custom_plg_param_ref` WHERE `virtuemart_product_id` = 509 AND `virtuemart_custom_id` NOT IN ()

Funny thing is, that when i add first new product it works fine. Later, when i was trying to add another new products, it is broken and I cant add any customfields to this products = funniest is that i cannot add/edit  customfield nowhere, even not in old products which was working before...


I have no idea what is wrong, why i can not add customfileds to new products.
Can anyone help me?
thank you
Owner of e-shop https://www.parfumylacno.sk with perfumes FM Group

Jörgen

Hello
You don't which joomla, vm or custom fields you are using and what you have done that could break the code.
Updated joomla. Updated vm. Updated custom fields perhaps?
Anyway you should first check with breakdesigns.
Regards
Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

parfumylacno

hi, thank you, finally i find solution.

i found out that I was "using" two diferent plugins for custom fields filtering (one was old, which one i later replace with another one - but that old was still enabled the whole time..  I have no idea why there was no problem before)

so i disabled that old plugin for filtering and sudenly all works and errors gone.

im very happy that it was so little problem  ;D . nevermind it take so many time to find it out  8)
Owner of e-shop https://www.parfumylacno.sk with perfumes FM Group