an issue about comment disable. Help Please!

i need this as well

just noticed this too, imported over 1000 nodes that have disabled comments.

I have limited access to the tables via the database module, so I managed to switch comments back on by using the 'query database' option. Note, if you choose to use the example below, do so at your own risk! Backup your tables!! Modifying tables in this manner scares the **** out of me...but like I said, it worked for me.

I have a node type set up as "tvseries" -- first I entered this in the query window:

select * FROM node where type='tvseries'

This then told me that I was dealing with the correct data -- all comments were set to "0". Essentially 'Disabled' = 0, 'Read only' = 1 and 'Read/Write' = 2.

Then, I entered this in the query window:

UPDATE node SET comment=2 WHERE type='tvseries';

Bam, all my tvseries nodes are now set to 2, meaning people can leave comments. Whew.

Just updating the nodes is not a feasible answer when importing large quantities of data.

I know it may be a pain but it doesn't matter if you're importing 1 or 10000 nodes. The query does it all for you.

Here is a patch to import comment options. I have mildly tested it with both valid and unvalid data, but it's fairly simple so it shouldn't give any problem.

I've added a new support file: comment.inc which will be included when comment.module is enabled:

/* $Id$ */

/**
 * Implementation of hook_node_import_fields().
 */
function comment_node_import_fields($type) {
  $fields = array();
  if (user_access('administer nodes')) {
    $fields = array(
      'comment' => t('Node: Comment options'),
    );
  }
  return $fields;
}

/**
 * Implementation of hook_node_import_prepare().
 */
function comment_node_import_prepare(&$node, $preview = FALSE) {
  $errors = array();

  if (isset($node->comment) && !empty($node->comment)) {
    // TODO: find a way to use the comment constants COMMENT_NODE_DISABLED/READ_ONLY/READ_WRITE
    if (!is_numeric($node->comment) or ($node->comment < 0 || $node->comment > 2)) {
      $errors[] = t('The comment option %comment is not a valid option. Valid options are: 0 (disabled), 1 (read only), 2 (read/write).', array('%comment' => $node->comment));
    }
  }
  else {
    $node->comment = variable_get('comment_'. $node->type, COMMENT_NODE_READ_WRITE);
  }

  return $errors;
}

This implements the same functionality as the patch provided.

Committed to DRUPAL-5 branch. It will be included in the next release (5.x-1.3). Thanks!

wonderful. In my situation i had problems with feedapi (now feeds) and nodecomments. Importing using Feeds results in nodes with comments disabled... great review web without reviews possibility, don't you think? :-)

solution:

UPDATE node SET comment=2 WHERE `type` LIKE 'type_of_content'

thanks a lot :-).