User warning: Table 'DATABASE.comments' doesn't exist

Every time I try to post a comment, I receive this error:

user warning: Table 'DATABASE.comments' doesn't exist query: update comments set notify = 0 where cid = 130 in /DRUPAL_PATH/includes/database.mysql.inc on line 172.

database.mysql.inc, line 172:
trigger_error(check_plain(mysql_error($active_db) ."\nquery: ". $query), E_USER_WARNING);

For my Drupal installation in my DATABASE I've created tables with a prefix "one", so the MySQL query should point to the table "DATABASE.one_comments", instead to "DATABASE.comments"!

I've located the problem within your module, and here it is:

comment_notify.module, line 298:

- $sql = "update comments set notify = %d where cid = %d";
+ $sql = "update {comments} set notify = %d where cid = %d";