×

Notice

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

TOPIC: Trouble importing comments from WP

Trouble importing comments from WP 14 years 3 months ago #8197

  • jon
  • jon's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
Hello,

Converting from WP to Joomla. I have the articles moved over and the post IDs in joomla articles match the ones that were used in WP. Installed JoomlaComment. I go and post a new comment and everything works fine.

I have 7000 comments to import. I am manually matching them up in "importcomment." I have tried matching different columns and I still can't get the comments attached to the proper articles. the comments are imported though. I think the article id is getting placed under the "importid" column in jos_comments.

Do you happen to have a list of the column heading in the jos_comments table and what each of them do. I might be able to fix it with that info.

Thanks

Trouble importing comments from WP 14 years 3 months ago #8198

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
articleid = contentid

Trouble importing comments from WP 14 years 3 months ago #8205

  • jon
  • jon's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
More info,

The comment was being attached to the correct article after matching it as stated. The problem is/was that the comments are not being published. The joomlacomment component lists them as published. If you unpublish each one and then republish them, everything works correctly.

Upon examining the database, jos_comment is listing a value of "2" for coments that should be approved (or were in WP). The value in my wordpress database is 1. After I go through the unpublish/republish the value of the joomacomment database is 1 and everything works.

Any idea why the values of 1 in my wordpress database are given a value of 2 upon inmport. Is there an easy way to fix this besides manually doing each one. I could batch them but then I would be approving a lot of spam comments and then I'd have to deal with them.

Trouble importing comments from WP 14 years 3 months ago #8206

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
I don't know. I will try and see for myself.
an easy way to update all comments to published would be to open phpmyadmin and execute the following SQL(you have to be in the right database)
UPDATE jos_comment SET published = "1"
WHERE published = 2;

Trouble importing comments from WP 14 years 3 months ago #8207

  • jon
  • jon's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
That fixed the issue. Now I have migrated my WP articles to Joomla and have the comments attached.
  • Page:
  • 1
Time to create page: 0.140 seconds