Skip to: site menu | section menu | main content

Duplicate Keys

  • C (1) |
  • D (1) |

When you change a database so that the tables have a prefix, you end up getting a 'duplicate key' error when creating new nodes or other itmes.

This is because Drupal maintains a 'sequences' table that stores the autoincrement values for various tables. This table has a structure of:

name id
files_fid 114
files_fid 55
menu_mid 120
vocabulary_vid 42
term_data_tid 38
users_uid 6

Back to top