Weird mysql error when creating new forum
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? 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
Normally it's due to a duplicate record in your SQL. On Thu, Apr 24, 2008 at 11:19 PM, Shai Gluskin <shai@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?
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/ ]
Quoting Shai Gluskin <shai@content2zero.com>:
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.
Which version of Drupal?
Why is Drupal trying to run a query to insert info data into the term_data table?
Because (any number of reasons). Have you modified the term_data table structure to add a UNIQUE KEY? What is the output of 'SELECT * FROM term_data WHERE tid = 10'?
I'm adding the forum at: example.com/en/admin/content/forum/add/forum (the "en" is for English, I'm using translation module).
Does the term 'Sellers Forum' exist already?
As usual, any help would be appreciated!
HTH Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
On Fri, Apr 25, 2008 at 8:19 AM, Shai Gluskin <shai@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/ ]
On Sat, Apr 26, 2008 at 8:15 AM, Cog Rusty <cog.rusty@gmail.com> wrote:
On Fri, Apr 25, 2008 at 8:19 AM, Shai Gluskin <shai@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.
A follow-up to add: I am guessing that you are running Drupal 5 or earlier, because this is very unlikely to happen in Drupal 6. If so, using phpMyAdmin go to the "sequences" table, select "Browse", and find the row "term_data_tid". If you see an ID=9 in that row, change it to 10. So the next term to be created will be 11 and you are unblocked.
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/ ]
thanks so much, Mike, Earnie and Cog, Yes I'm using D 5.7. There is lots of information here to get me started on solving this problem. Thank you so much. Shai On Sat, Apr 26, 2008 at 1:43 AM, Cog Rusty <cog.rusty@gmail.com> wrote:
On Sat, Apr 26, 2008 at 8:15 AM, Cog Rusty <cog.rusty@gmail.com> wrote:
On Fri, Apr 25, 2008 at 8:19 AM, Shai Gluskin <shai@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.
A follow-up to add: I am guessing that you are running Drupal 5 or earlier, because this is very unlikely to happen in Drupal 6. If so, using phpMyAdmin go to the "sequences" table, select "Browse", and find the row "term_data_tid". If you see an ID=9 in that row, change it to 10. So the next term to be created will be 11 and you are unblocked.
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/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Cog and others, I fixed the problem with your help but with some modifications to the instructions. Thought I'd follow up with the fuller story. The problem occurred because I imported hundreds of categories without ever manually resetting the term_data_tid row in the sequences table. In order to found what what I should set the value to, I needed to browse the term_data table to see what the highest used number was. Again, thanks so much! Shai On Sun, Apr 27, 2008 at 3:48 AM, Shai Gluskin <shai@content2zero.com> wrote:
thanks so much, Mike, Earnie and Cog,
Yes I'm using D 5.7. There is lots of information here to get me started on solving this problem. Thank you so much.
Shai
On Sat, Apr 26, 2008 at 1:43 AM, Cog Rusty <cog.rusty@gmail.com> wrote:
On Sat, Apr 26, 2008 at 8:15 AM, Cog Rusty <cog.rusty@gmail.com> wrote:
On Fri, Apr 25, 2008 at 8:19 AM, Shai Gluskin <shai@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.
A follow-up to add: I am guessing that you are running Drupal 5 or earlier, because this is very unlikely to happen in Drupal 6. If so, using phpMyAdmin go to the "sequences" table, select "Browse", and find the row "term_data_tid". If you see an ID=9 in that row, change it to 10. So the next term to be created will be 11 and you are unblocked.
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/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
participants (4)
-
Cog Rusty -
Earnie Boyd -
Mike Johnston -
Shai Gluskin