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. one week 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. one week 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. one week 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. one week 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. one week 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. one week 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. one week 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. one week 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. one week ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


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