Your Cart is currently empty!
Product update
Coupon
add
Coupon code invalid! Please re-enter!
AJAX loader
You are here: HomeForum
Welcome, Guest

Sj-Fashion Template
(1 viewing) (1) Guest
  • Page:
  • 1
  • 2

TOPIC: Sj-Fashion Template

Sj-Fashion Template 11 years, 5 months ago #5529

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
The topic has been locked.

Re: Sj-Fashion Template 11 years, 5 months ago #5548

  • loitt
  • OFFLINE
  • Platinum Boarder
  • Posts: 2222
  • Karma: 48
Dear kismir,

Could you please explain your issues in detail?

Please write them in English if possible.

Thanks
Ticket System | Join our Clubs to download our extensions and templates
The topic has been locked.

Re: Sj-Fashion Template 11 years, 3 months ago #7349

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
The topic has been locked.

Re: Sj-Fashion Template 11 years, 3 months ago #7351

  • loitt
  • OFFLINE
  • Platinum Boarder
  • Posts: 2222
  • Karma: 48
Dear Daria Avtonomova,

We see that your site is normal now.

Could you please explain your mean in detail?

Thanks
Ticket System | Join our Clubs to download our extensions and templates
The topic has been locked.

Re: Sj-Fashion Template 11 years, 3 months ago #7371

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
The topic has been locked.

Re: Sj-Fashion Template 11 years, 3 months ago #7374

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

****
no... it is again this error. Please, check
Last Edit: 11 years, 3 months ago by ablefollow.
The topic has been locked.
  • Page:
  • 1
  • 2
Time to create page: 0.23 seconds

Notification

Please find your issue via Suggested Posts before submitting your question. We have solved the most of issues and maybe your issue was solved before.

Latest My Topics

No posts to display.

Love all our templates?

Join our membership clubs starting at $49 only for access to all of our templates

Join Now
Home Pricing
Your Cart is currently empty!
Product update
Coupon
add
Coupon code invalid! Please re-enter!
AJAX loader
SearchSupport
Magento Themes Magento Extensions Free Magento Extensions Prestashop Themes Prestashop Modules Magento 2 Themes