Problem with block support

The block support has a little problem.
It is reimplemented in a better way.

For Drupal 4 :

Download
http://cvs.drupal.org/viewcvs/*checkout*/drupal/contributions/modules/lo...
http://cvs.drupal.org/viewcvs/*checkout*/drupal/contributions/modules/lo...

Patch for block module
http://cvs.drupal.org/viewcvs/*checkout*/drupal/contributions/modules/lo...
or simply change the line 608 of your block.module file to become :
$result = db_query(db_rewrite_sql("SELECT * FROM {blocks} WHERE theme = '%s' AND status = 1 ORDER BY region, weight, module", 'blocks', 'module'), $theme_key);

For Drupal 5 :

Download
http://cvs.drupal.org/viewcvs/*checkout*/drupal/contributions/modules/lo...
http://cvs.drupal.org/viewcvs/*checkout*/drupal/contributions/modules/lo...

Patch for block module
http://cvs.drupal.org/viewcvs/*checkout*/drupal/contributions/modules/lo...
become :
$result = db_query(db_rewrite_sql("SELECT DISTINCT b.* FROM {blocks} b LEFT JOIN {blocks_roles} r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = '%s' AND b.status = 1 AND (r.rid IN (%s) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module", 'blocks', 'module'), $theme_key, implode(',', array_keys($user->roles)));