Hello,
i am happy for finishing my work makeing a template with my fields.
no i wanted to import and looked at the preview, everything looks good, but i have an error:
Duplicate entry '2' for key 'PRIMARY' SQL=UPDATE `qtq7l_virtuemart_products` SET `virtuemart_product_id`='2',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`='',`product_mpn`='',`product_weight_uom`='KG',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='999',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='2015-10-07 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='Stck',`product_packaging`='1',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`intnotes`='',`metarobot`='Duftkalender, Kalender A3, Wandkalender, Kalendergeschenk, Cocktails',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-10-07 14:19:25',`created_by`='930',`modified_on`='2015-10-14 12:16:48',`modified_by`='930',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='K0001'
CSVI Pro 6.2.0 | Copyright (C) 2006 - 2015 RolandD Cyber Produksi
Where can i say to override the products like in the free version?
Thank you very much for your help.
Brigitte
- kuschel
- RO CSVI
- Wednesday, 14 October 2015
- Subscribe via email
0
Accepted Answer
Pending Moderation
i found some proucts in the database without the language-code and deletet then. now i have another error
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 `product_currency` IS NULL) AND `product_price_publish_up` = '0000-00-00 0' at line 3 SQL=SELECT `virtuemart_product_price_id` FROM `qtq7l_virtuemart_product_prices` WHERE `virtuemart_product_id` = 9 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` IS NULL) AND `product_currency` IS NULL) AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
and now all the existing articels ar still in the database, but i dont see at frontend and backend
He importet the first line in the database without the countrycodes. i said skip the first line.
Please help me
Brigitte
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 `product_currency` IS NULL) AND `product_price_publish_up` = '0000-00-00 0' at line 3 SQL=SELECT `virtuemart_product_price_id` FROM `qtq7l_virtuemart_product_prices` WHERE `virtuemart_product_id` = 9 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` IS NULL) AND `product_currency` IS NULL) AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
and now all the existing articels ar still in the database, but i dont see at frontend and backend
He importet the first line in the database without the countrycodes. i said skip the first line.
Please help me
Brigitte
Accepted Answer
Pending Moderation
Hello Brigitte,
This error has been posted as a sticky topic, see here for the solution.
Where can i say to override the products like in the free version?Existing products are automatically updated.
This error has been posted as a sticky topic, see here for the solution.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello,
i installed the fix and now i have the error
Duplicate entry 'duftkalender-dancin-cocktail' for key 'slug' SQL=INSERT INTO `qtq7l_virtuemart_products_de_de` (`virtuemart_product_id`,`slug`) VALUES (12, 'duftkalender-dancin-cocktail')
And i dont see any of my prodcts in backend and frontend. But there are in the database.
i see that he write 1 article into the databas products without the language code.
i did not installed anything i only importet my products, We also can make the shop not multilanguage. Is this better, but i dont know how to set this, because if i set the plugin language disable and make a new import, i also don't see anything.
Please help me.
Brigitte
i installed the fix and now i have the error
Duplicate entry 'duftkalender-dancin-cocktail' for key 'slug' SQL=INSERT INTO `qtq7l_virtuemart_products_de_de` (`virtuemart_product_id`,`slug`) VALUES (12, 'duftkalender-dancin-cocktail')
And i dont see any of my prodcts in backend and frontend. But there are in the database.
i see that he write 1 article into the databas products without the language code.
i did not installed anything i only importet my products, We also can make the shop not multilanguage. Is this better, but i dont know how to set this, because if i set the plugin language disable and make a new import, i also don't see anything.
Please help me.
Brigitte
Accepted Answer
Pending Moderation
Hello Brigitte,
You don't need to make the shop multi-lingual, the fact that the products are stored in the de_de table means, you are storing products in German. This means you must also access the site in German otherwise VirtueMart won't show the products.
As for the duplicate slugs, this can happen when you have duplicate product names. You can load this patch and that should deal with the slugs.
You don't need to make the shop multi-lingual, the fact that the products are stored in the de_de table means, you are storing products in German. This means you must also access the site in German otherwise VirtueMart won't show the products.
As for the duplicate slugs, this can happen when you have duplicate product names. You can load this patch and that should deal with the slugs.
i see that he write 1 article into the databas products without the language code.What do you mean by that?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »