Categories
View Replies (10)

Resolved Duplicate entry 'xxx' for key 'slug'

  1. studiob
    studiob
  2. RO CSVI
  3. Thursday, 25 February 2016
  4.  Subscribe via email
I am trying to import categories to Virtuemart, but I recieve this error:

Duplicate entry 'methanolxx-d4xx' for key 'slug' SQL=UPDATE `dev2_virtuemart_categories_cs_cz` SET `category_name`='Methanolxx D4xx',`category_description`='\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Jméno Methanolxx D4xx
\r\n

*I.E (Isotopic Enrichment) = istop obohac
',`metadesc`='',`metakey`='',`customtitle`='',`slug`='methanolxx-d4xx' WHERE `virtuemart_category_id`='170304'

//

Any hint please?

I tried patch from here: https://www.csvimproved.com/forum?view=topic&catid=44&id=32789

But it didn't help.
0
Responses (10)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
It seems like you are trying to import duplicate slug name in your import file. Which version of CSVI are you using? Can you send the import file used?
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
studiob
studiob
Accepted Answer Pending Moderation
It looks like, but I don't think so.

I have version 6.5.2

I don't want to upload the file here, publicly. If you want, I can send you the file by e-mail and please don't publish it anywhere. Please send me your e-mail, if you agree.
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Send email to tharuna@csvimproved.com
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. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Try importing loading the attached patch file.


patch_vmslug_2016-02-25.zip
Attachments (1)
patch_vmslug_2016-02-25.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. # 4
studiob
studiob
Accepted Answer Pending Moderation
Thank you, it works now.

Just a little note... I am not sure if it's a problem, but it says this:
Import file contains 5312 lines

But when it's done, the result is this:
Processed 357

Shouldn't it be 5312 too?
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Have a look at the Manage timeouts document as I am sure your server won't be importing over 5000 records within 30 seconds :)
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. # 6
studiob
studiob
Accepted Answer Pending Moderation
Thank you for your suggestion.
I set number of lines to 200. But nothing changed. The import is fast and at the end it always says Processed 357.
Import was slow first time, but I guess that now it"s not really importing, because everything is the same. I don't know.
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Can you post or send in a private message the debug log of your import?
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. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Your csv file has content till 5312 lines and so you are seeing that count but the actual number of category records are only 357. Please check into your categories, all are imported till the end and there is no problem at all.
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. # 9
studiob
studiob
Accepted Answer Pending Moderation
You are absolutely right. I didn't realize, that there are more lines then categories.

Thank you.
  1. more than a month ago
  2. RO CSVI
  3. # 10
  • Page :
  • 1


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