Help! Error PDOException: SQLSTATE[22P02]:

Yup - I get this same error using a PostgreSQL 9 backend and the beta0 drupal 7 module. I tracked it down to the ->condition('uid1', 'uid2') line of this function:

function drupalchat_user_login(&$edit, $account) {
  setcookie("DRUPALCHAT_NEWLOGIN", 1, time()+120);
  // TODO Please review the conversion of this statement to the D7 database API syntax.
  /* db_query('DELETE FROM {drupalchat_msg} WHERE uid1 = uid2 AND uid1 = %d', $account->uid) */
  db_delete('drupalchat_msg')
  ->condition('uid1', 'uid2')
  ->condition('uid1', $account->uid)
  ->execute();
}

This can't be the right way to call this function as it get's turned into the following sort of SQL:

where uid1 = 'uid2' (notice that uid2 is a string literal and not the actual column named uid2).

So I dunno if this is PostgreSQL database driver nuance or what as that would be the wrong thing to do for any database platform, but the attached patch seems to at least generate what the author probably intended and no longer gives an error when logging in to the site. Basically the patch changes the ->condition('uid1', 'uid2') to ->where('uid1 = uid2').

Committed - http://drupalcode.org/project/drupalchat.git/commit/d85d426. Thanks.