Categories
View Replies (2)

Resolved Overwriting content articles, creates new articles

  1. renewmyid
    renewmyid
  2. RO CSVI
  3. Wednesday, 26 October 2016
  4.  Subscribe via email
My imports are running incorrect. I am using Joomla 3.6.4 and CSVI 6.6.4.

The joomla content import creates new articles instead of overwriting the existing ones.

The debug log says the following:
2016-10-26 14:33:24 1 [QUERY] SELECT `id` FROM `zb3xu_categories` WHERE `extension` = 'com_content' AND `path` = 'blog/nieuws'
2016-10-26 14:33:24 1 [DEBUG] COM_CSVI_FIND_CONTENT_ID
2016-10-26 14:33:24 1 [QUERY] SELECT id FROM `zb3xu_content` WHERE `alias` = 'exampletitle' AND `catid` = 2

It checks if the category_path 'blog/nieuws' exists, and if so get the ID of this category.
The category does exist, but the returned catid isn't correct and defaults to catid = 2 instead of catid = 9 which in my case it should be.

The problem seems to be in the function: convertCategoryPath which checks what the category should be by the categorytitle instead of the path. I think this should be looked at and fixed.

I think i temporarily fixed it by changing line 185 of file administrator/components/com_csvi/addon/com_content/helper/com_content.php ->where($this->db->quoteName('title') . ' = ' . $this->db->quote($title));

by replacing quoteName('title') to quoteName('path'). but PLEASE do correct me if im wrong.

Thanks in advance
0
Responses (2)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

You are absolutely correct, there is something fishy there. Instead of doing your fix, it works, so you don't have to change it, but the final fix will be to change line 100 to 
$catid = $this->getCategoryId($category_path);


Thanks for informing us.
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
renewmyid
renewmyid
Accepted Answer Pending Moderation
Much better, thanks for the quick reply!
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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