Categories
View Replies (6)

Resolved Duplicate entry in clean table

  1. microweb
    microweb
  2. RO CSVI
  3. Monday, 07 December 2015
  4.  Subscribe via email
Hi.

Try to import categories for virtuemart but got this message

Duplicate entry 'ποδήλατα-1' for key 'slug' SQL=UPDATE `phidb_virtuemart_categories_en_gb` SET `category_name`='Ποδήλατα',`category_description`='',`metadesc`='',`metakey`='',`customtitle`='',`slug`='ποδήλατα-1' WHERE `virtuemart_category_id`='445'

There are no other entries with the same "slug"

CSVI Pro 6.4.2
Virtuemart 3.0.12
Joomla! 3.4.5
PHP 5.4.45


Kind Regards

Goran
0
Responses (6)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Goran,
The duplicate slug message happens in certain cases with partial names matching. The attached patch file should fix this for you.
patch_vmslug_20151208.zip
Attachments (1)
patch_vmslug_20151208.zip
Kind regards,

Tharuna

=========================
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
microweb
microweb
Accepted Answer Pending Moderation
No it doesn't .... It still there...

Kind Regards

Goran
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Goran,

Please post the debug log of your import as requested at the top of the page so we can see what happens during your import. Please also post a sample of your import file so we can check with your file.
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. # 3
microweb
microweb
Accepted Answer Pending Moderation
Here you are ...


Regards

Goran
Attachments (2)
csv_cat_r_imp_podil.csv
com_csvi.log.27.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Goran,

Your import file seems to tell me that you don't know what you are importing. There is no use for the virtuemart_category_id, category_name, category_path and category_path_trans fields. So let's clean up your file first.

Remove the virtuemart_category_id, category_name and category_path_trans fields. You have a bunch of empty fields as well, they can be removed as well.

The virtuemart_vendor_id field can be removed as well, CSVI will find that for you. Any field ending with _id shouldn't be used unless you know what you are doing.

The slugs cannot be created at the moment because you don't appear to be logged in with Greek, so the names cannot be transliterated.

Tharuna will post a new patch to deal with the slug field in your CSV file, but a clean up will be good to do.
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. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Goran,
Please use the attached patch file using tutor How to load Patch file


patch_vmslug_20151209.zip
Attachments (1)
patch_vmslug_20151209.zip
Kind regards,

Tharuna

=========================
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. # 6
  • Page :
  • 1


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