Categories
View Replies (1)

Resolved 1064 syntax error

  1. Navcar
    Navcar
  2. RO CSVI
  3. Friday, 17 April 2015
  4.  Subscribe via email
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
0
Responses (1)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!