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?
No that I am looking at I start believe that is the "" but if that's the problem,how can i change it?
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 = )
Yes you have an unescaped " Maybe use " ; instead of "
See http://forum.virtuemart.net/index.php?topic=131755
and um.virtuemart.net/index.php?topic=130910.msg451183
Thank you jenkinhill it worked!! :) I replace the name of the product (wherever i had " i replace it with ") 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 ?
You should ask Gavick about that.
but it is the prod id missing that is the failure
VIRTUEMART_PRODUCT_ID =
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.
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
Sorry mistake :) Yes it is a gavick problem still trying find a solution.