Hi

- Wenn ich German sprache admin installiere und site german ist, dann virtuemart macht probleme.

" vmError: exeSortSearchListQuery 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 ') AND (s.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) I' at line 3 SQL=SELECT * FROM `d7gcf_virtuemart_products_de_de` as l JOIN `d7gcf_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `d7gcf_virtuemart_product_categories` ON p.`virtuemart_product_id` = `d7gcf_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `d7gcf_virtuemart_categories_de_de` as c ON c.`virtuemart_category_id` = `d7gcf_virtuemart_product_categories`.`virtuemart_category_id` LEFT JOIN `d7gcf_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `d7gcf_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `d7gcf_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `d7gcf_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `d7gcf_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `d7gcf_virtuemart_product_categories`.`virtuemart_category_id` IN () AND (s.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) IS NULL )) group by p.`virtuemart_product_id` ORDER BY RAND() ASC LIMIT 0, 3 "

- wenn ich Hauptseite wechsel Virtuemart Categorie dann hängt ein Bild geht nicht mehr.
- Wenn ich home seite KATEGORIE LAYOUT wechsel, dann Bilder kommt ganz klein.

Kann jemand mich helfen.
danke

Dear kismir,

Could you please explain your issues in detail?

Please write them in English if possible.

Thanks

The error appears on the home page after the slides and over feaured productsafter some manipulations wih vm and site design.


vmError: exeSortSearchListQuery 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 ') AND (s.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) I' at line 3 SQL=SELECT * FROM `mar9z_virtuemart_products_en_gb` as l JOIN `mar9z_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `mar9z_virtuemart_product_categories` ON p.`virtuemart_product_id` = `mar9z_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `mar9z_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `mar9z_virtuemart_product_categories`.`virtuemart_category_id` LEFT JOIN `mar9z_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `mar9z_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `mar9z_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `mar9z_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `mar9z_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `mar9z_virtuemart_product_categories`.`virtuemart_category_id` IN () AND (s.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) IS NULL )) group by p.`virtuemart_product_id` ORDER BY RAND() ASC LIMIT 0, 3

Dear Daria Avtonomova,

We see that your site is normal now.

Could you please explain your mean in detail?

Thanks

please, see the site again. I tried to reinstall vm, that's why you haven't seen the errors.
I've added russian names to products and catagories - after that the errors came up

ok. it disappers somehow. Maybe you solved it. anyway, it is fixed now

****
no... it is again this error. Please, check