Removed default Low High Priorities, Now cant edit items.

This forum is now locked, since gold support is no longer offered.

Moderator: SourceGear

Posts: 2
Joined: Thu Aug 11, 2005 2:20 pm

Removed default Low High Priorities, Now cant edit items.

Post by williamstuart » Thu Aug 25, 2005 3:09 pm


I removed the default priorites from DragNet under Administrator / Database. I added my own (1, 2, 3, 4, 5). Now, items that were filed with the old numbers will not open.

Receive this message:
Error 500: The Server is unable to process your request, click the login button to go back to the login page

Any help would be greatly appreciated.


William Stuart

Posts: 490
Joined: Wed Jan 14, 2004 10:22 am
Location: SourceGear

Post by mskrobul » Thu Aug 25, 2005 4:16 pm

Run the following in SQL:

Code: Select all

UPDATE sgdragnet.dbo.itempriorities SET status = 1 WHERE 
COALESCE(status, 0) <> 1
After you run the above query reset IIS.

That should restore the default values. Note that the values you added will still be there.

After that you can do a query on the priorties you want to delete and change those priority values to one of your new values.

Then you can remove the old priority values in the Database options section.

I have logged a bug to prevent users from "deleting" default values that are in use. We don't allow you actually delete values that are in use (if you tried to delete a value that was in use that wasn't a default it wouldn't work), but since the default values aren't ever really deleted the DB check let this go through.
Mary Jo Skrobul