1. owegen
  2. RO CSVI
  3. Tuesday, 05 November 2019
  4.  Subscribe via email
Hello,

Have anyone an idea what is the problem here?

Status error: 200
Status message: OK
Warning: strstr(): Empty needle in ....../plugins/csviaddon/virtuemart/com_virtuemart/table/productprice.php on line 152 {"error":true,"process":false,"url":"administrator\/index.php?option=com_csvi&view=imports","message":"Duplicate entry '0' for key 'PRIMARY'"}

Many thanks
Accepted Answer Pending Moderation
Hello,
Can you tell us which version of RO CSVI you are using? Can you also post your import file to check?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,
Can you tell us which version of RO CSVI you are using? Can you also post your import file to check?


Hello, I use CSVI Pro 7.7.1

I also send you the import file.

Many thanks for your help.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Please update your CSVI to latest 7.14.0 version. This issue has been addressed and fixed with RO CSVI 7.13.0 version.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
Please update your CSVI to latest 7.14.0 version. This issue has been addressed and fixed with RO CSVI 7.13.0 version.


I made the update to 7.14.0 version and started the import process again. But I still become the same kind of error:

An error has occured during the import. Below the information received from the server.
Duplicate entry '0' for key 'PRIMARY'
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
I made the update to 7.14.0 version and started the import process again.

Yes, the "Warning strstr(): Empty needle in...." error is gone with the update.

An error has occured during the import. Below the information received from the server.
Duplicate entry '0' for key 'PRIMARY'

This error could be because of your previous broken import. Debug log has only 20 entries by default so i am not able to find on which record your import is breaking. The error says there is an entry in database table with 0 for primary key. We need to find that entry and delete it. There are quite a lot of VirtueMart tables which are used in VirtueMart Product import. So to find which of your VirtueMart tables has this 0 as entry in it, Go to RO CSVI Dashboard page, click Options button, on Site tab increase Number of lines in log file and run the import. Send the latest import debug log.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,

I made the changes and started the import process again. I send you the new log file.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
Looks like you have set debug log entries to 200, there is no error in the latest debug log. So i checked your file in RO CSVI Analyser and could see there is a problem with your import file. See the attached screenshots. There seems to be an extra delimiter around the record with product_sku "A_22_7" . You need to correct your file and run the import. You can also check the database for entries after "A_22_7" as product_sku to check if there is any entry with 0 for duplicate error.
Attachments (2)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
Looks like you have set debug log entries to 200, there is no error in the latest debug log. So i checked your file in RO CSVI Analyser and could see there is a problem with your import file. See the attached screenshots. There seems to be an extra delimiter around the record with product_sku "A_22_7" . You need to correct your file and run the import. You can also check the database for entries after "A_22_7" as product_sku to check if there is any entry with 0 for duplicate error.


can you provide a bit more details about this "delimiter"? We tried to delete this article but still the same kind of error.
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
I was wrong but it is not the problem with "A_22_7" as product_sku but check all the records with product_sku as number, like "1000000001570". The delimiters are broken for 3 fields at the end. Check the screenshot.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
hello,

I started the import process and still have the same problem:

Duplicate entry '0' for key 'PRIMARY'


Many thanks for your help
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,
I was able to reproduce this error with your file and that is because of manufacturer_id field. The entries for manufacturer_id which is the primary key field of manufacturers table goes as 0 in the database and so the error. I see that you have both manufacturer_id and manufacturer_name in your file. You can skip the use of manufacturer_id field in your import, RO CSVI will create manufacturer using manufacturer_name. If there is an existing record with same manufacturer_name, the row will be updated else a new manufacturer row will be created. Can you skip the manufacturer_id field and see how the import goes?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
hello,

ok I can try. But can you explain me how I can skip the manufacturer_id field?

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,
You need to add template fields for your template in the order of column headers as in your import file. Check Adding template fields document to know on how to add template fields. For manufacturer_id you need to add Skip as the template field so RO CSVI will skip this column on import. Also in your import template settings on File tab set Use file for configuration as No so RO CSVI will use the template fields as headers and not the column headers from the import file. Let me know if you need any more clarification.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello, I did it (set Use file for configuration as No) but still the same error. Maybe the best way is I give you the access to administration?
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,
Before i look into your site, can you send me your template XML file? To get your template XML file, in CSVI maintenance menu select CSVI Pro on first option, backup templates on second option, select your template and download the XML file. Post the XML file so i can check it.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
please find the xml

Kind regards
Raphael
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello Raphael,
I checked your template and you still have manufacturer_id in the template fields. You need to replace manufacturer_id with Skip field. Check attached screenshot. Please try import after that.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
hello, I made this change. Import seems to work now.

But I don't see any visible article in Virtuemart.

Can you help me?
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
something is strange with the new created categories
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 19
Accepted Answer Pending Moderation
Hello Raphael,
But I don't see any visible article in Virtuemart.

Do you mean that you are not seeing the imported products on VirtueMart Products page? Can you post a screenshot on what you have on VirtueMart Products page?

something is strange with the new created categories

It is because of order of your template fields. You have added custom_title field in place of category_path and so the fields are messed up. product_price field has been used as category_path. You need to place custom_title field in the right place in your template fields and run the import again.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


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