update to 1.3 - update.php error when using table prefixes

Was it the first installation for you? MYSQL or postgresql?

Do you use prefixes?

Well yes, my bad:

content_moderation.install

Please change the method

function content_moderation_update_6003() {
  db_query("ALTER TABLE `content_moderation_states` ADD `weight` SMALLINT NOT NULL DEFAULT '0'");
  return array();
}

to

function content_moderation_update_6004() {
  db_query("ALTER TABLE {content_moderation_states} ADD `weight` SMALLINT NOT NULL DEFAULT '0'");
  return array();
}

And run the update.php script once again.

This is not urgent as weights are not yet used, they will be part of the next release. So you can also wait for 1.4 without problems

Actually we should use drupals update functionality in order to display performed database actions.

function content_moderation_update_6003() {
  $ret = array();
  if (db_table_exists('content_moderation_states')) {
    db_add_field($ret, 'content_moderation_states', 'weight', array('type' => 'int', 'not null' => TRUE, 'default' => 0, 'size' => 'tiny'));
  }
  return $ret;
}

I'll put that on my todo list for code cleanup.

Paul use 6004 due to this error

Of course, this was just an example. When cleaning up the code I will increment the numbers.

released in in 1.4