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
Cheers man, thanks again
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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)What happens here is that a manufacturer is inserted with no alias and there is already a manufacturer with no alias.
p.s. there are no duplicates....
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 »