user warning: Unknown column 'type' in 'where clause' query

I'm getting it as well with 5.x-1.4; error message is

Unknown column 'type' in 'where clause'; query: SELECT nc.nid FROM node_comment_statistics nc WHERE (type <> 'sitenotes') AND ( nc.comment_count > 0 ) ORDER BY nc.last_comment_timestamp DESC LIMIT 0, 10 in /includes/database.mysql.inc on line 172.

I committed a fix to tighten up my checks on which db_rewrite_sql's I intercept. This should be in the -dev release that rolls out around midnight GMT. Please test it and make sure. Thanks.

While the last patch seems to fix the problem, there may be situations where $primary_table has a different value, so this would expose sitenotes nodes to other users.

Instead, you could use the value in $primary_table to append sitenotes condition.

function sitenotes_db_rewrite_sql($query, $primary_table, $primary_field, $args) {
  $return = array();
  // Check for node query if the user shouldn't see sitenotes.
  if ($primary_field == 'nid' && !user_access('access site notes')) {
    $sql = drupal_strtolower($query);
    // Locate the WHERE clause if there is one.
    if ($where = strpos($sql, ' where ')) {
      // If the query noes not already have 'type=' then add our test.
      if (!(strpos($sql, 'type=', $where + 6) || strpos($sql, 'type =', $where + 6) || strpos($sql, 'type in', $where + 6))) {
        $return['where'] = $primary_table .".type <> 'sitenotes'";  // <--- here we can use $primary_table value
      }
    }
  }
  return $return;
}

Good point, thanks.

I am running 5.x-1.4 on 2 sites. On one site I get the same error as #2 on the other site Site Notes works fine.

You need the -dev version.