Hey Randy,
I hope that you will excuse me. I had to delete some of the comments that you guys made from yesterday evening...
I imported again the comments using this query:
INSERT INTO `vpo_comment`(`importid`,`contentid`,`ip`,`userid`,`date`,`name`,`email`,`website`,`title`,`comment`,`published`,`voting_yes`,`importparentid`,`component`,`importtable`)
SELECT `id`,`contentid`,`ip`,`user_id`,`date`,`name`,`email`,`website`,`title`,`comment`,`published`,`star`,`parentid`,`option`,'jos_jomcomment' FROM `vpo_jomcomment` AS f ORDER BY f.`id`;
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 ;
UPDATE `vpo_comment` SET `parentid`=-1 WHERE `parentid` = 0;
UPDATE `vpo_comment` SET `component`="com_hwdvideosharephoto" WHERE `component` = "com_hwdphotoshare_p";
UPDATE `vpo_comment` SET `component`="com_hwdvideosharevideo" WHERE `component` = "com_hwdvideoshare_v";
This way I imported the comments from all the components.
Hwdphotoshare is working as I see.
Now about hwdvideoshare. I'll need ftp access to figure that out. Would you please talk to your host and fix the problems that you have with it? Using a browser file manager will mean that I'll have to waste all my Saturday trying to debug this... (where in reality I'll need only around 30mins)
Cheers,
Daniel