Removed default Low High Priorities, Now cant edit items.

[williamstuart]

Hi

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.

Thanks,

William Stuart

[mskrobul]

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.