On a clean install of 4.7 beta2 the first time I changed a theme the following error message came up

Duplicate entry '2' for key 1 query: INSERT INTO 47beta2_menu (mid, pid, path, title, description, weight, type) VALUES (2, 16, 'admin/block', 'blocks', '', 0, 22) in /srv/www/htdocs/000_drupal/20051220-47beta2/includes/database.mysql.inc on line 108.

it had no real consequences as far as I can see, but is a bit intimidating for new users..

(server info: apache 2.0.48, php 4.3.3, mysql 4.0.15)

CommentFileSizeAuthor
#1 menu_prefixed_tables_dupes.patch1.08 KBRichard Archer

Comments

Richard Archer’s picture

Richard Archer commented
Status: Active » Needs review
StatusFileSize
new menu_prefixed_tables_dupes.patch1.08 KB

There is a nasty problem with prefixed tables. The install process fails to add the prefix to the name of the next_id sequence. There was a work-around in menu.inc for this problem but it went stale with the addition of primary links.

Here's a patch that updates the work-around.

Hopefully one day an installer will make this redundant.

Richard Archer’s picture

Richard Archer commented

also over here: http://drupal.org/node/41434

drumm’s picture

drumm
he/him
Location NY, US
commented

+1 Looks consistent with database.mysql.

Richard Archer’s picture

Richard Archer commented
Status: Needs review » Fixed

Fixed in http://drupal.org/node/39430

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)