L
L
Lehich782017-11-28 16:35:36
Joomla
Lehich78, 2017-11-28 16:35:36

How to fix Joomla (virtuemart)??

Falls on this request, what's wrong??

spoiler
[query:JDatabaseExceptionExecuting:private] => SELECT p.`virtuemart_product_id`, `l`.`product_name`,virtuemart_product_id ASC FROM `VAP_virtuemart_products` as p LEFT JOIN `VAP_virtuemart_products_ru_ru` as l ON l.`virtuemart_product_id` = p.`virtuemart_product_id` LEFT JOIN `VAP_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `VAP_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` WHERE ( `pc`.`virtuemart_category_id` = 13 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) AND p.`virtuemart_product_id`!="3829" AND virtuemart_product_id ASC >= "ICE LAIR Sweet Frost" ORDER BY `p`.virtuemart_product_id ASC LIMIT 1
[message:protected] => 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 'ASC FROM `#__virtuemart_products` as p LEFT JOIN `#__virtuemart_products_ru_ru' at line 1
[string:Exception:private] =>
[code:protected] => 1064
[file:protected] => /home/c10452/new/libraries/joomla/database/driver/mysqli.php
[line:protected] => 660

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question