×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Import from JComment

Import from JComment 6 years 3 months ago #12927

  • SAM&more Onlineshop
  • SAM&more Onlineshop's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 8
Hi there,
i've got problems importing comments from JComments into !joomlacomment.
I can get some stuff imported, but as soon as i set the "Commented component column" to "object_group" the preview doesn't import anything anymore...

Isn't there a default import filter for JComments??

Thanx,
Lucky.

Import from JComment 6 years 3 months ago #12937

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 154
  • Thank you received: 1081
I though that joomlacomment had one. Can you send me a copy of your jcomments tables. I'll test it and let you know if there is a bug on our end.
Daniel

Import from JComment 6 years 2 months ago #13100

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 154
  • Thank you received: 1081
Hey Lucky,
I'm sorry for the delay! It is really a busy week.... So, the problem comes from the fact that the name of the plugin in jcomment is
com_hwdvideoshare_p and in compojoomComment the name of the component is com_hwdvideoshare or com_hwdvideoshareGroup(if you want to comment in your groups) or com_hwdphotoshare and com_hwdphotoshareGroup... Anyway because of this the query that the component creates is wrong. It has a WHERE clause object_name="com_hwdvideoshare" and none of your entries in jcomment has an object_name of com_hwdvideoshare. That is why nothing is shown in the preview and nothing gets imported. To go around this you will need to manually execute the following queries (in phpmyadmin)
INSERT INTO `vpo_comment`(`importid`,`contentid`,`ip`,`userid`,`date`,`name`,`email`,`website`,`notify`,`title`,`comment`,`published`,`voting_yes`,`voting_no`,`importparentid`,`component`,`importtable`) 
SELECT `id`,`object_id`,`ip`,`userid`,`date`,`name`,`email`,`homepage`,`subscribe`,`title`,`comment`,`published`,`isgood`,`ispoor`,`parent`,'com_hwdvideoshare','jos_jcomments' FROM `vpo_jcomments` AS f WHERE f.object_group='com_hwdphotoshare_p';
 
UPDATE `vpo_comment` AS `cupdate` JOIN `vpo_comment` AS `cselect` ON cselect.importtable = cupdate.importtable AND cselect.importid = cupdate.importparentid SET cupdate.parentid = cselect.id WHERE cupdate.parentid <= 0 	AND cupdate.importparentid > 0;
 
UPDATE `vpo_comment` SET `parentid`=-1 WHERE `parentid` = 0;

Do you have comments on com_content? I'm wondering if they can be properly imported with the mapping tool :)

Kind regards,
Daniel

Import from JComment 6 years 2 months ago #13122

  • pascal88
  • pascal88's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 8
Tnx it works now fine. I have completely remove the comment system and after that install the new one with the script.
  • Page:
  • 1
Time to create page: 0.112 seconds