Installing drupal from cvs, using mysql (postgres seemed to have worse problems) and then going into the administer blocks section reports lots of:

user error: Duplicate entry '' for key 1
query: INSERT INTO blocks (module, delta, status, weight, region, path, custom) VALUES ('blog', '0', '0', '0', '0', '', '0') in /var/www/html/cvsdrupal/includes/database.mysql.inc on line 69.
user error: Duplicate entry '' for key 1
query: INSERT INTO blocks (module, delta, status, weight, region, path, custom) VALUES ('cloud', '0', '0', '0', '0', '', '0') in /var/www/html/cvsdrupal/includes/database.mysql.inc on line 69.

checking the blocks table there is only one entry and that is:

+------+---------+-------+--------+--------+--------+--------+------+--------+
| name | module  | delta | status | weight | region | remove | path | custom |
+------+---------+-------+--------+--------+--------+--------+------+--------+
|      | archive |     0 |      0 |      0 |      0 |      0 |      |      0 |
+------+---------+-------+--------+--------+--------+--------+------+--------+

This set of inserts seems to be missing the "name" column and that column (aside from being NOT NULL) is the primary key.

Comments

stilders’s picture

stilders CreditAttribution: stilders commented
Priority: Major » Normal

Ok, my bad. I see from hunting in the cvs log for the block.module that I should update the database.
Of course I thought the datamodel script in cvs would have matched the code in cvs...
Lets see how the update.php goes.