user warning: Unknown column 'nlr.limit' in 'field list' query

Are you using the latest dev version? I don't see those queries in the version I have...

Dave

I had the same problem as doknet with the latest dev.
I tracked down the probleme to the node_limit.install

/**
 * Implementation of hook_schema().
 */
function node_limit_schema() {
  $schema['node_limit'] = array(
    'description' => t('The base Node Limit table'),
    'fields' => array(
      'lid' => array(
        'description' => t('The limit id'),
        'type' => 'int',
        'not null' => TRUE
      ),
      'type' => array( /////// THIS IS THE DB COLUMN THAT GENERATES THE ERROR <-------
        'description' => t('The {node}.type to which this limit applies'),
        'type' => 'varchar',
        'length' => 32,
        'not null' => TRUE,
        'default' => ''
      ),
      'limit' => array(
        'description' => t('The node limit for this limit'),
        'type' => 'int',
        'not null' => TRUE,
        'default' => NODE_LIMIT_NO_LIMIT
      ),
      'title' => array(
        'description' => t('The display name for this limit'),
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => ''
      ),
      'weight' => array(
        'description' => t('The weight of this limit'),
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0
      ),
    ),
    'primary key' => array('lid')
  );
  return $schema;
}

function node_limit_update_6001() { //IN FACT I CAN GUESS THAT THE COLUMN SHOUD NOT BE THERE :)      <-------
  if (!module_exists('node_limit_type')) {
    $ret = array();
    drupal_set_message(t('node_limit module cannot be updated until after node_limit_type has been enabled. Please enable node_limit_type and then return to <a href="@update-php">update.php</a> and run the remaining updates.', array('@update-php' => base_path() .'update.php?op=selection')), 'warning', FALSE);
    $ret['#abort'] = array('success' => FALSE, 'query' => t('node_limit.module has updates, but cannot be updated until after node_limit_type.module is enabled.'));
    
    return $ret;
  }
  db_query("INSERT INTO {node_limit_type} (SELECT lid, type FROM {node_limit})");
  $ret = update_sql("ALTER TABLE {node_limit} DROP COLUMN `type`");
  return $ret;
}

Manually removing the 'type' column from the node_limit table should fixed the issue.
cheers

Re #7: That's a duplicate of #451644: can't create or edit content. As for the column issue, I'm learning how the schema hooks work, and it would seem that my first impressions weren't correct.

I'll try and get a new version up soon. (I'm rather busy w/ school and a full-time job)

Dave

#4 Happens on fresh install making it impossible to add any content, thus making this module unusable... happens in both release and dev.

I would suggest warning people so that they don't bother downloading till its fixed... Thanks for the hard work and sorry this doesn't work - it was just what I needed otherwise and doesn't appear to be an alternative!

Adam

suggest this is moved to critical...

same problem:

warning:

user warning: Column count doesn't match value count at row 1 query: INSERT INTO node_limit VALUES('1', '1', '1 Listing per member', '0') in (my directory)\sites\all\modules\node_limit\node_limit.module on line 521.

below:

Array ( [lid] => 1 [limit] => 1 [title] => 1 Listing per member [weight] => [node_limit_role] => 5 [node_limit_type] => my_listing ) 
my_listing 
Saved limit "1 Listing per member" 

no node limits found in "List"

I have Node Limit 6.x-1.x-dev (2009-Apr-29), just installed and started to configure on localhost wamp

Is there a working version?
Vitis

I have looked into this issue a little bit. It seems it has to do with the node_type limit. The module has the node-type data but is not able to submit it into the database because the insert query on the node_limit module is incomplete. I have seemed to found the reason why this is taking place.

What I did:

Edited node_limit.module,

On line 521 of node_limit.module I replaced
db_query("INSERT INTO {node_limit} VALUES('%d', '%d', '%s', '%d')", $limit['lid'], $limit['limit'], $limit['title'], $limit['weight']);
with
db_query("INSERT INTO {node_limit} VALUES('%d', '%s', '%d', '%s', '%d')", $limit['lid'], $limit['type'], $limit['limit'], $limit['title'], $limit['weight']);

Thanks for the update.
Has this change been included in the latest dev?

It seems that there is something else causing issues as #13's update makes a dev screen of death when you try to create a node of any type.

Seems to be a duplicate of #468266: Mismatched fields, values
(Cleaning the issues list)