1064 error after updating VM2 to VM3

[alex4842]

Hello I have updated VM2 to VM3 (with the instructions from here) and Joomla 2.5 to 3.5. Everything so far works fine but in only one category I get this error:
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 'NATURA"" ORDER BY PRODUCT_NAME DESC, `VIRTUEMART_PRODUCT_ID` DESC LIMIT 1' AT LINE 1 SQL=SELECT P.`VIRTUEMART_PRODUCT_ID`, `L`.`PRODUCT_NAME`,`L`.PRODUCT_NAME FROM `#__VIRTUEMART_PRODUCTS` AS P INNER JOIN `#__VIRTUEMART_PRODUCTS_EL_GR` AS L USING (`VIRTUEMART_PRODUCT_ID`) LEFT JOIN `#__VIRTUEMART_PRODUCT_SHOPPERGROUPS` AS PS ON P.`VIRTUEMART_PRODUCT_ID` = `PS`.`VIRTUEMART_PRODUCT_ID` LEFT JOIN `#__VIRTUEMART_PRODUCT_CATEGORIES` AS PC ON P.`VIRTUEMART_PRODUCT_ID` = `PC`.`VIRTUEMART_PRODUCT_ID` WHERE ( `PC`.`VIRTUEMART_CATEGORY_ID` = 1 AND ( `PS`.`VIRTUEMART_SHOPPERGROUP_ID`= "1" OR `PS`.`VIRTUEMART_SHOPPERGROUP_ID` IS NULL ) AND P.`PUBLISHED`="1" ) AND P.`VIRTUEMART_PRODUCT_ID`!="78" AND `L`.PRODUCT_NAME <= "ΠΟΔΟΜΑΚΤΡΑ ΒΕΛΟΥΤΕ "NATURA"" ORDER BY PRODUCT_NAME DESC, `VIRTUEMART_PRODUCT_ID` DESC LIMIT 1

Sorry but I am newbie and still try to figure it out what to do.
Can anyone please help?

[alex4842]

No that I am looking at I start believe that is the "" but if that's the problem,how can i change it?

[alex4842]

also when i use gavick news pro for displaying virtuemart   i get this  error news 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 ')' AT LINE 18 SQL=SELECT DISTINCT C.VIRTUEMART_CATEGORY_ID AS CID FROM #__VIRTUEMART_PRODUCT_CATEGORIES AS CX LEFT JOIN #__VIRTUEMART_CATEGORIES_EL_GR AS C ON CX.VIRTUEMART_CATEGORY_ID = C.VIRTUEMART_CATEGORY_ID LEFT JOIN #__VIRTUEMART_PRODUCTS_EL_GR AS CONTENT ON CX.VIRTUEMART_PRODUCT_ID = CONTENT.VIRTUEMART_PRODUCT_ID LEFT JOIN #__VIRTUEMART_CATEGORIES AS CAT ON C.VIRTUEMART_CATEGORY_ID = CAT.VIRTUEMART_CATEGORY_ID WHERE ( CONTENT.VIRTUEMART_PRODUCT_ID = )

[jenkinhill]

Yes you have an unescaped "  Maybe use &#34 ; instead of "

See http://forum.virtuemart.net/index.php?topic=131755
and  um.virtuemart.net/index.php?topic=130910.msg451183

[alex4842]

Thank you jenkinhill it worked!!  I replace the name of the product (wherever i had " i replace it with &#34;) wherever I got 1064 error and it works fine now. I would like to ask something more. Do you know about the second error that i get from news pro about virtuemart ?

[jenkinhill]

You should ask Gavick about that.

[GJC Web Design]

but it is the prod id missing that is the failure

VIRTUEMART_PRODUCT_ID =

[alex4842]

Thank you both guys for the response. Yes i agree with GJC Web Design i believe it is a VM problem but i asked them.

[GJC Web Design]

no -- I didn't mean it was a VM problem.. it is a Gavik problem not finding the product id or even checking the validity of the query before setting it

[alex4842]

Sorry mistake  Yes it is a gavick problem still trying find a solution.