Tags:
create new tag
view all tags

Question

How can I tell if the AUTOINC function somehow got reset by accident?

I have a form to create a build notes document. We have created 50 build notes documents. Today when we tried to create another one we got this message below.

The "BuildNotesAUTOINC0001" topic already exists.

Why isn't TWiki trying to create a topic named BuildNotes0051 instead of BuildNotes0001?

Thanks in advance for your help.

Environment

TWiki version: TWikiRelease04x02x00
TWiki plugins: DefaultPlugin, EmptyPlugin, InterwikiPlugin
Server OS: Ubuntu 7.10
Web server: Apache
Perl version: 5
Client OS: Windows XP
Web Browser: IE 6
Categories: Javascript

-- MichaelCarter - 23 Dec 2008

Answer

ALERT! If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

Known issue. Remove the BuildNotesAUTOINC0001 page that someone created and you will be OK.

-- PeterThoeny - 23 Dec 2008

Thanks for the quick response Peter. Do you know if then the next time we use our form we created to produce these build notes document it will try and create a topic named BuildNotes0002? Then the next time BuildNotes0003?

Will it simply recycle and go 0001 to 0050 again? Do I need to rename all my existing build note documents?

-- MichaelCarter - 23 Dec 2008

On other thought I had is what if I change the form we're using to create the build notes from name="topic" value="BuildNotesAUTOINC0001"

to

name="topic" value="BuildNotesAUTOINC1001" will that temporarily relieve the issue?

-- MichaelCarter - 23 Dec 2008

You should be OK. It will count up to BuildNotes9999, then BuildNotes10000 and so on. I am not clear how the extra BuildNotesAUTOINC0001 got created, may be during a special case, such "edit anyway" with a locked topic.

-- PeterThoeny - 23 Dec 2008

Problem solved. There was a topic that somehow got created called BuildNotesAUTOINC0001. We're not sure how that got created but I simply renamed it to something else and that solved the problem. Thanks again for your help!

-- MichaelCarter - 24 Dec 2008

Change status to:
Edit | Attach | Watch | Print version | History: r5 < r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r5 - 2008-12-24 - MichaelCarter
 
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.