VirtueMart 3.0.6.2
Joomla! 3.4.1
csvi pro 5.20
PHP version 5.4.32
Hello
Right now am having a problem,
Some of the products are givin me 1064 syntax error on the details at the front end.
I have uploaded again, and everithing is "Success"
but in the front end when i click on the product detail i get this mesage:
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 'http://www.cablesnavcar.com/ecat2/images/tipos%20bujes/TIPO15.jpg"><br><b>MEDIDA' at line 1 SQL=SELECT p.virtuemart_product_id, l.product_name FROM nbuzy_virtuemart_products as p INNER JOIN nbuzy_virtuemart_products_es_es as l using (virtuemart_product_id) LEFT JOIN nbuzy_virtuemart_product_shoppergroups as ps ON p.virtuemart_product_id = ps.virtuemart_product_id LEFT JOIN nbuzy_virtuemart_product_categories as pc ON p.virtuemart_product_id = pc.virtuemart_product_id WHERE ( pc.virtuemart_category_id = 1201 AND ( ps.virtuemart_shoppergroup_id= "1" OR ps.virtuemart_shoppergroup_id IS NULL ) AND p.published="1" ) AND p.virtuemart_product_id!="5683" AND l.product_desc <= "<b>REF. NAVCAR: </b>BJ-9675<br><b>APLICACION: </b>BUJE BALANCIN<br><b>MARCA VEHICULO: </b>AMPRO<br><b>MODELO: </b>TRAILER<br><b>MOTOR/TRANS: </b>NO INFO<br><b>DESCRIPCION: </b>TRAILER AMPRO<br><b>OEM: </b><br><b>TIPO: </b><br> <img src="http://www.cablesnavcar.com/ecat2/images/tipos%20bujes/TIPO15.jpg"><br><b>MEDIDAS: (mm)</b><br><b>A: </b>30<b> B: </b>54.9<b> C: </b>62.5<b> D: </b>46<b> E: </b>N/A<br><b>U x VEHICULO: </b>16 /2 ejes 24 /3 ejes<b> U DE EMPAQUE: </b>12<br><b>DUREZA: </b>80 SHORE A" ORDER BY l.product_desc DESC LIMIT 1
any idea of whats going on? this products were working a few days ago!
Thanks for your help
Hello,
I have no idea what is going on, it is a weird query. The problem is that your product description has a URL in it and the " in the URL breaks the query. The question for the VM team would be why the product description is even in that query. If it needs to be in there, they should properly handle the quotes.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.