×

Notice

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

TOPIC: yvcomment import into joomlacomment help please

yvcomment import into joomlacomment help please 10 years 2 months ago #6736

  • glenn
  • glenn's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
I want to convert to joomlacomment from yvcomment.

Joomlacomment (beta2) is installed, seems fine so now is the import and where I am unclear how to continue (safely).

there is nothing listed under "Import from standard comment system component" so it looks like I have to do a manual mapping from yvcomment to joomlacomment.

Could someone tell me the mappings for this?

I have yvcomments set as follows:

Use Content Table = Yes
Section = Comments
Category = Comments/Unsorted comments

Thanks in advance for your help!

Glenn

yvcomment import into joomlacomment help please 10 years 2 months ago #6790

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
what is the problem to do the matching of the 2 tables?

id = id
comment = commment
date = date and so on. It is that easy. If you get an error message, then write it here and I will tell you what to do.

yvcomment import into joomlacomment help please 10 years 2 months ago #6890

  • glenn
  • glenn's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
Well the explanation of each field made little sense to me so I just ran a query myself that works, here it is:
 
insert into jos_comment(contentid, date, name, title, comment)
select parentid, created, created_by_alias, title, `fulltext` from jos_content where sectionid=XXX and state=1

Replace "XXX" with whatever your sectionid is for your yvcomments.

Then also update jos_comment set published=1 where 1 to finish it off (if doing entire table)

yvcomment import into joomlacomment help please 10 years 2 months ago #6893

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
I'm happy you sorted your problem!
cheers
  • Page:
  • 1
Time to create page: 0.099 seconds