×

Notice

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

TOPIC: Importing from jomcomment

Importing from jomcomment 12 years 11 months ago #14690

  • Randy Fabien
  • Randy Fabien's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 15
  • Thank you received: 1
I had jomcomment installed and decided to change to compojoom comment system on my joomla 1.5.
The first problem i noticed is that it is not listed nor is any other system listed in the 'Import from standard comment system component' drop-down list.
When i attempt to map manually, even with all the columns mapping appropriated i get a message saying that 'Contentid field is obligatory. check your settings.'

Please help with this.
Thanks

Importing from jomcomment 12 years 11 months ago #14691

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Hey Randy,
Please use the contact us button at the bottom of the page and send me username and password for your backend. I want to look at this myself.
Thanks,
Daniel

Importing from jomcomment 12 years 11 months ago #14692

  • Randy Fabien
  • Randy Fabien's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 15
  • Thank you received: 1
wow. that is very quick support response. I just sent the information you asked for using 'contact us'

Importing from jomcomment 12 years 11 months ago #14693

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Hey Randy,
I just sent you a mail. Please give me the additional data that I requested and I'll solve this asap!
Daniel

Importing from jomcomment 12 years 11 months ago #14694

  • Randy Fabien
  • Randy Fabien's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 15
  • Thank you received: 1
Ok, I sent the information. Thanks so far.

Importing from jomcomment 12 years 11 months ago #14695

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Hey Randy,
Comments are imported!

Here is what I did...
Since I couldn't connect with ftp, I logged into phpmyadmin, made a dump of the jomcomment table and imported it on my localhost. Then I went to the import option in the component, made the matching, clicked import and it worked out of the box!

I'm not sure what was wrong on your site as I wasn't able to debug it there. I made a dump of the comments and imported them in your site.

There is something that you should know. I saw a table that is called comment. The table for our component is called comment. I renamed this tableto comment_old. I don't know to which extension this table belongs(you have so much stuff on your site, that you are most probably not using :)), but if you encounter any problems with db connections to that table you should know that it is still there, but not with the same name...

I hope that you are happy with the support that you received. If you have any other troubles let me know!

Have a nice weekend,
Daniel

Importing from jomcomment 12 years 11 months ago #14696

  • Randy Fabien
  • Randy Fabien's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 15
  • Thank you received: 1
Well i must say i am quite please with the support and thank you very much for the extra information. The comment for content like my articles are well set and works ok. Only one problem. The comments on videos in hwdvideoshare and hwdphotoshare don't seem to appear even when i create a new plugin setting for them. I would appreciate your extended help.
Thanks

Importing from jomcomment 12 years 11 months ago #14697

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Have you followed the documentation? If yes and it is not working, then I'll have a look. If the answer is no, then please check the docs and let me know if it works after that :)

Kind regards,
Daniel

Importing from jomcomment 12 years 11 months ago #14698

  • Randy Fabien
  • Randy Fabien's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 15
  • Thank you received: 1
I used the documentation.
Part of the current problem seem to be that all the posts were migrated as posted for the com_content component while in the original database table there were some for com_content, com_hwdphotoshare_p, etc.
But in addition the video component, hwdvideoshare keeps showing the following error: joomlacomment: unexpected error. No plugin found for component '' !

Importing from jomcomment 12 years 11 months ago #14699

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
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

Importing from jomcomment 12 years 11 months ago #14701

  • Randy Fabien
  • Randy Fabien's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 15
  • Thank you received: 1
I sent the ftp access information to you. Thank you.
Your help is greatly appreciated so far.

Importing from jomcomment 12 years 11 months ago #14707

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Hey Randy,
I've fixed the problem! (the bug will be fixed in next release as well)
Hope that you enjoy the component and the support :)
Cheers,
Daniel
P.S. I hope that you will find few minutes to write a review about compojoomComment here: extensions.joomla.org/extensions/contact...icles-comments/12259
Thank you in advance!

Importing from jomcomment 12 years 11 months ago #14710

  • Randy Fabien
  • Randy Fabien's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 15
  • Thank you received: 1
That is great. It now shows up in hwdvideoshare. Could I know what you did?
I still have one problem though. The posts made for the joomla content are perfectly migrated. I am very happy about that. But those posted in the past on videos and photos in hwdvideoshare and hwdphotoshare, respectively, are not there on frontend.
I really love the component and i want it to work for me. So far i am very pleased with the support.

Importing from jomcomment 12 years 11 months ago #14712

  • Randy Fabien
  • Randy Fabien's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 15
  • Thank you received: 1
Hi, I am just informing that i recognized the the problem was with the component names. instead of com_hwdvideosharevideo and com_hwdvideosharephoto, it should have been com_hwdvideoshare and com_hwdphotoshare respectively. So i changed it manually on the database. Works perfectly now.

Thank you so much.

This component is great!
  • Page:
  • 1
Time to create page: 0.161 seconds