News:

Support the VirtueMart project and become a member

Main Menu

vm3 prduct detail 1064 syntax error

Started by kmogongora, April 17, 2015, 21:59:13 PM

Previous topic - Next topic

kmogongora

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

PabloArias

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
Pablo Arias
www.pabloarias.eu

GJC Web Design

as the error says

it is the " in the href breaking the sql

"www.cablesnavcar.com/ecat2/images/tipos%20bujes/TIPO15.jpg"

have you tried 3.0.8?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation