[support] Weird mysql error when creating new forum

[Cog Rusty]

On Fri, Apr 25, 2008 at 8:19 AM, Shai Gluskin <shai at content2zero.com> wrote:
> Drupallers,
>
> When trying to create a new forum, I get this error:
>
> > user warning: Duplicate entry '10' for key 1 query: INSERT INTO term_data
> (tid, name, description, vid, weight) VALUES (10, 'Sellers Forum', '', 4, 0)
> in /home/cmp/public_html/includes/database.mysql.inc on line 172.
>
> Why is  Drupal trying to run a query to insert info data into the term_data
> table?

Because forums are terms in the taxonomy vocabulary "Forums". And for
some reason, Drupal attempted to create a term with ID=10 while there
was already a term with this ID, instead of taking the next available
ID. There could be many reasons. It could happen in a bizarre database
setup or in a multisite with some shared and some separate tables in
some cases.


> I'm adding the forum at: example.com/en/admin/content/forum/add/forum (the
> "en" is for English, I'm using translation module).
>
> As usual, any help would be appreciated!
>
> Shai
>
> --
>  [ Drupal support list | http://lists.drupal.org/ ]
>