Fatal error when activating module

On home page:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1: SELECT n.uid AS uid, n.created AS created FROM {node} n WHERE (n.status = :db_condition_placeholder_0) AND (n.type IN ()) ; Array ( [:db_condition_placeholder_0] => 1 ) in _archive_post_count() (line 385 of /home/mysite/public_html/sites/all/modules/archive/archive.module).

Maybe error is because block already displayed on home page, when activating module.

This patch helped me:

In file: archive.module

$node_query->condition('n.type', $final_types, 'IN');

change it to this:

if (!empty($final_types)) {
  $node_query->condition('n.type', $final_types, 'IN');
}