×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
CComment
Pro
Installation questions
What does this mean? Manage comments, some kind of error. Pleas help
  • Page:
  • 1
  • 2

TOPIC: What does this mean? Manage comments, some kind of error. Pleas help

What does this mean? Manage comments, some kind of error. Pleas help 13 years 7 months ago #11926

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Online
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
actually, let me improve something. I'll disable the comments for few more minutes.

What does this mean? Manage comments, some kind of error. Pleas help 13 years 7 months ago #11927

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Online
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Ok, I'm done:
This query is better:
INSERT INTO `comment` ( `importid` , `contentid` , `userid` , `date` , `name` , `title` , `comment` , `published` , `importparentid` , `component` , `importtable` )
SELECT f.`id` , `parentid` , `created_by` , `created` , u.name, `title` , `fulltext` , 1, 'parentid', 'com_content', 'yvcomment'
FROM `content` AS f
LEFT JOIN users AS u ON f.created_by = u.id
WHERE catid ='category id'
it also takes the name of the user.

P.S. I hope that you'll write a good review about my component :) extensions.joomla.org/extensions/contact...icles-comments/12259

What does this mean? Manage comments, some kind of error. Pleas help 13 years 7 months ago #11934

  • tassie
  • tassie's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 25
  • Thank you received: 0
Hi Daniel,

Thank you for all the effort you 've done. I saw that the comments were placed in the title area. So some comments that are very long are not visible completely. I think something went wrong during the importation. But I will manually adjust the comments, cause I think that is now the best way to do that and probably the easiest way. Maybe for other people who need this code you need to adjust it a little bit so it will come in the right table.

For now, a lot of thanks! Am very happy that it works now. Will need some minor adjustments with the template, but I will ask that in another post. When I am completely finished, I'll write a positive review on the Joomla site.

Best wishes,
Natasja
  • Page:
  • 1
  • 2
Forum
CComment
Pro
Installation questions
What does this mean? Manage comments, some kind of error. Pleas help
Time to create page: 0.122 seconds