Are professional services available for drupal production implementation ?
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of support-request@drupal.org Sent: Monday, April 28, 2008 4:41 AM To: support@drupal.org Subject: support Digest, Vol 64, Issue 43
Send support mailing list submissions to support@drupal.org
To subscribe or unsubscribe via the World Wide Web, visit http://lists.drupal.org/listinfo/support or, via email, send a message with subject or body 'help' to support-request@drupal.org
You can reach the person managing the list at support-owner@drupal.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of support digest..."
Today's Topics:
1. Re: Weird mysql error when creating new forum (Shai Gluskin) 2. Drupal's Audio Module and Accessibility to Screen Readers (Stuart Lawler) 3. Re: Problem with file upload (Cog Rusty) 4. Re: Problem with file upload (Davide Michel 'ZioBudda' Morelli) 5. Re: Drupal's Audio Module and Accessibility to Screen Readers (Simone Dal Maso) 6. Re: Drupal's Audio Module and Accessibility to Screen Readers (Stuart Lawler) 7. Views incorrect default order (Marolijo - Pol maresma)
----------------------------------------------------------------------
Message: 1 Date: Sun, 27 Apr 2008 10:38:03 -0400 From: "Shai Gluskin" shai@content2zero.com Subject: Re: [support] Weird mysql error when creating new forum To: support@drupal.org Message-ID: 9f68efb70804270738k112a99e5sf8aca328b1b6acfd@mail.gmail.com Content-Type: text/plain; charset="iso-8859-1"
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/ ]