VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: alex4842 on April 13, 2016, 16:12:58 PM

Title: 1064 error after updating VM2 to VM3
Post by: alex4842 on April 13, 2016, 16:12:58 PM
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?
Title: Re: 1064 error after updating VM2 to VM3
Post by: alex4842 on April 13, 2016, 16:18:52 PM
No that I am looking at I start believe that is the "" but if that's the problem,how can i change it?
Title: Re: 1064 error after updating VM2 to VM3
Post by: alex4842 on April 13, 2016, 17:23:05 PM
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 = )
Title: Re: 1064 error after updating VM2 to VM3
Post by: jenkinhill on April 13, 2016, 17:27:47 PM
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
Title: Re: 1064 error after updating VM2 to VM3
Post by: alex4842 on April 14, 2016, 10:48:03 AM
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 ?
Title: Re: 1064 error after updating VM2 to VM3
Post by: jenkinhill on April 14, 2016, 12:00:21 PM
You should ask Gavick about that.
Title: Re: 1064 error after updating VM2 to VM3
Post by: GJC Web Design on April 14, 2016, 13:19:32 PM
but it is the prod id missing that is the failure

VIRTUEMART_PRODUCT_ID =
Title: Re: 1064 error after updating VM2 to VM3
Post by: alex4842 on April 14, 2016, 14:32:13 PM
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.
Title: Re: 1064 error after updating VM2 to VM3
Post by: GJC Web Design on April 14, 2016, 22:42:46 PM
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
Title: Re: 1064 error after updating VM2 to VM3
Post by: alex4842 on April 18, 2016, 11:49:34 AM
Sorry mistake  :) Yes it is a gavick problem still trying find a solution.