Cog and others,<br><br>I fixed the problem with your help but with some modifications to the instructions. Thought I'd follow up with the fuller story.<br><br>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.<br>
<br>Again, thanks so much!<br><br>Shai<br><br><div class="gmail_quote">On Sun, Apr 27, 2008 at 3:48 AM, Shai Gluskin <<a href="mailto:shai@content2zero.com">shai@content2zero.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
thanks so much, Mike, Earnie and Cog,<br><br>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.<br><font color="#888888"><br>Shai</font><div><div></div>
<div class="Wj3C7c"><br><br><div class="gmail_quote">On Sat, Apr 26, 2008 at 1:43 AM, Cog Rusty <<a href="mailto:cog.rusty@gmail.com" target="_blank">cog.rusty@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>On Sat, Apr 26, 2008 at 8:15 AM, Cog Rusty <<a href="mailto:cog.rusty@gmail.com" target="_blank">cog.rusty@gmail.com</a>> wrote:<br>
> On Fri, Apr 25, 2008 at 8:19 AM, Shai Gluskin <<a href="mailto:shai@content2zero.com" target="_blank">shai@content2zero.com</a>> wrote:<br>
> > Drupallers,<br>
> ><br>
> > When trying to create a new forum, I get this error:<br>
> ><br>
> > > user warning: Duplicate entry '10' for key 1 query: INSERT INTO term_data<br>
> > (tid, name, description, vid, weight) VALUES (10, 'Sellers Forum', '', 4, 0)<br>
> > in /home/cmp/public_html/includes/database.mysql.inc on line 172.<br>
> ><br>
> > Why is Drupal trying to run a query to insert info data into the term_data<br>
> > table?<br>
><br>
> Because forums are terms in the taxonomy vocabulary "Forums". And for<br>
> some reason, Drupal attempted to create a term with ID=10 while there<br>
> was already a term with this ID, instead of taking the next available<br>
> ID. There could be many reasons. It could happen in a bizarre database<br>
> setup or in a multisite with some shared and some separate tables in<br>
> some cases.<br>
><br>
<br>
<br>
</div>A follow-up to add: I am guessing that you are running Drupal 5 or<br>
earlier, because this is very unlikely to happen in Drupal 6. If so,<br>
using phpMyAdmin go to the "sequences" table, select "Browse", and<br>
find the row "term_data_tid". If you see an ID=9 in that row, change<br>
it to 10. So the next term to be created will be 11 and you are<br>
unblocked.<br>
<div><div></div><div><br>
<br>
><br>
> > I'm adding the forum at: <a href="http://example.com/en/admin/content/forum/add/forum" target="_blank">example.com/en/admin/content/forum/add/forum</a> (the<br>
> > "en" is for English, I'm using translation module).<br>
> ><br>
> > As usual, any help would be appreciated!<br>
> ><br>
> > Shai<br>
> ><br>
> > --<br>
><br>
><br>
> > [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
> ><br>
><br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>