Categories
View Replies (3)

Resolved SQL error on connecting products and manufactures

  1. jaak69
    jaak69
  2. RO CSVI
  3. Tuesday, 20 December 2016
  4.  Subscribe via email
Joomla 3.6.5 and Virtuemart 3.0.18 CSVI Pro 6.6.4

The SQL error message then trying connect producta and manufacures:
Duplicate entry '' for key 'slug' SQL=INSERT INTO `#__virtuemart_manufacturers_et_ee` (`virtuemart_manufacturer_id`) VALUES ('103').

Then I trying to import manufacatures:
Duplicate entry '' for key 'slug' SQL=INSERT INTO `#__virtuemart_manufacturers_et_ee` (`virtuemart_manufacturer_id`) VALUES ('107') and value number simply increases by 1 if I'll to rerun.
0
Responses (3)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Post your debug log please as explained at the top of the page under Where to get the debug information?.
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. # 1
jaak69
jaak69
Accepted Answer Pending Moderation
Sorry. I attach the debug log.
Attachments (1)
com_csvi.log.97.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The file used for import as per the debug log and the attachments in your previous post looks different. Do they have the same content and just filename is different? As per the SQL error there seems to be an empty slug field entry in your database table #__virtuemart_manufacturers__et_ee, slug is also a unique field and cannot be empty. Please check for these empty entries in this table.
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. # 3
  • Page :
  • 1


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