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 '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="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
I have the same problem, but in cart, not in product details.
Using Joomla 3.4.1 and Virtuemart 3.0.8.
Any solution?
Thank you