Categories
View Replies (1)

Resolved DB Error And Data import failing

  1. evolution
    evolution
  2. RO CSVI
  3. Thursday, 05 May 2016
  4.  Subscribe via email
* VirtueMart version 3.0.16
* CSVI version 6.5.7 Pro
* Sample of the file being imported (attached)
* Collected debug information (log attached)
Screen cap of error attached.

Hi I've tried to import data into my site but am continually having a database error stop me. I have no doubt it's my fault :)

Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `#__virtuemart_manufacturers_en_gb` (`virtuemart_manufacturer_id`) VALUES ('LFD001BQ7J')

Can you shed any light on this from the attached files?
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Your import file and error image are missing from the post but still with your debug log i can say there is something wrong in the manufacturer your are trying to import. Look at the below query from your debug log

SELECT * FROM kvhz2_virtuemart_manufacturers_en_gb WHERE `virtuemart_manufacturer_id` = '12A7460'


This cannot be possible because virtuemart_manufacturer_id is a primary key field and it can only have integers. So this shows your import file is wrong.
Also, using a primary key field in import is not recommended as your are trying to play with unique identifier field of the table and you may end up messing with it. You should use manufacturer_name instead, CSVI will look for manufacturer with name and does the new insert or update of record accordingly.
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
  • Page :
  • 1


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