1. delicati
  2. RO CSVI
  3. Friday, 13 February 2015
  4.  Subscribe via email
Database Version 5.5.40-cll
PHP Version 5.4.37
Joomla! Version Joomla! 3.3.6 Stable [ Ember ] 01-October-2014 02:00 GMT
VirtueMart 3.0.4

this is the error: 1062 Duplicate entry '' for key 'slug' SQL=INSERT INTO tdyx_virtuemart_manufacturers_it_it (virtuemart_manufacturer_id) VALUES (78)

Can you give advice please? :)
Accepted Answer Pending Moderation
exactly. We have imported all the database with Migrator, it worked really fine but maybe something was forgiven in Virtuemart 1,5 and it is not in 3xxx

Cheers man, thanks again
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Thanks for the feedback. This means that the HTML code has not been properly enclosed and/or quoted and as such created problems. It happens :)
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. # 2
Accepted Answer Pending Moderation
I have just solved the problem right now: I noticed that 4 manufacturers had some "html" in the description. I removed that and changed also some names that were capital...I can confirm it is working ( well it seems to work , non errors this far and 6000 lines confirmed as imported). I will let you know if there is any news, thank you so much for your precious help.
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
I doubt you have much influence on the execution time but you have all the control over the number of items per iteration, that is why you should adjust those. Lower them until you have no longer a timeout.

So the debug log you posted, I see all goes fine with the first 5 records as a manufacturer is set for those records. This means we need to look a little further. Go to Settings -> Log and there you see the number of lines for debug logging. This is set to 5, this number needs to be increased to the same number of lines you have in your import file. This will create a huge debug log but we will have recorded all of the records so we can see where what goes wrong. Once that is done, import your file and post the new debug log. I will check that to see what happens with the manufacturers.
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. # 4
Accepted Answer Pending Moderation
sorry, here attached...

I did changed the execution time as well but with no important result.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,

The debug log is not attached but I see you are not even importing any manufacturer_name field. This means CSVI looks for a default manufacturer, have you set a default manufacturer?

The debug log must be zipped, otherwise it can't be attached.

Changing the maximum execution time I could process 1000 lines more or less...but it stops anyway, not always in the same line or time...
That is why you don't change the maximum execution time but you set the number of lines for CSVI to process within the give time limit as explained in the article I gave you in the other post.
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
Accepted Answer Pending Moderation
You will find log and file attached. Do you think that there is a product with no manufacturer or similar?
It happens after a while. Changing the maximum execution time I could process 1000 lines more or less...but it stops anyway, not always in the same line or time...
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Post the debug log of your import and I will check what is going on. Also post a sample of your import file as I need it to compare it against the debug log. Does this happen at the beginning or somewhere in the middle?

What do you think of this message: 1062 Duplicate entry '' for key 'slug' SQL=INSERT INTO tdyx_virtuemart_manufacturers_it_it (virtuemart_manufacturer_id) VALUES (78)

p.s. there are no duplicates....
What happens here is that a manufacturer is inserted with no alias and there is already a manufacturer with no alias.
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
  • Page :
  • 1


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