function nodequeue_update_6003 in Nodequeue 6.2

Same name and namespace in other branches

1. 7.3 nodequeue.install \nodequeue_update_6003()
2. 7.2 nodequeue.install \nodequeue_update_6003()

Remove invalid entries from the nodequeue_nodes table created as a result of bugs like http://drupal.org/node/593858.

File

./nodequeue.install, line 439

Install, update and uninstall functions for the nodequeue module.

Code

function nodequeue_update_6003() {
  $ret = array();
  $invalid = db_result(db_query("SELECT count(nid) FROM {nodequeue_nodes} WHERE nid = 0"));
  if (!empty($invalid)) {
    $ret[] = update_sql("DELETE FROM {nodequeue_nodes} WHERE nid = 0");
    $t = get_t();
    $ret[] = array(
      'success' => TRUE,
      'query' => $t("Deleted @invalid invalid entries from the {nodequeue_nodes} table.", array(
        '@invalid' => $invalid,
      )),
    );
  }
  else {
    $ret[] = array(
      'success' => TRUE,
      'query' => "No invalid entries found in the {nodequeue_nodes} table.",
    );
  }
  return $ret;
}