Closed (fixed)
Project:
Drupal core
Version:
x.y.z
Component:
block.module
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
29 Oct 2002 at 10:50 UTC
Updated:
29 Oct 2002 at 11:06 UTC
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
Comment #1
stilders commentedOk, 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.