Edgewall Software

Opened 15 years ago

Closed 14 years ago

Last modified 8 years ago

#2154 closed defect (duplicate)

webadmin: Adding Ticket Types fails if Order > 10

Reported by: Norbert Unterberg <nunterberg@…> Owned by: Christopher Lenz
Priority: normal Milestone:
Component: ticket system Version: devel
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


When adding or editing ticket types with the webadmin plugin, from ticket type #10 on, all new ticket types get the order number (id) of 10. When you delete one ticket type with the number 10, all other #10 types are removed, too.

Does the web admin module only support ticket type ids with one digit?

Attachments (0)

Change History (7)

comment:1 by Christopher Lenz, 15 years ago

Owner: changed from Jonas Borgström to Christopher Lenz
Status: newassigned

Why in the world would you need more then 10 types of tickets? ;-)

Anyway, I'll look into this.

comment:2 by Norbert Unterberg <nunterberg@…>, 15 years ago

Actually we did not need 10 ticket types, we only needed 8 ;-)

When you add new types and delete the old ones, the number always increases, so when you are fiddling around with ticket type for some time, you quickly get numbers above 10 since ids of deleted ticket types are not reused.

And the ticket types are used for hardware project tracking and are something like Improvement, Layout, Development, Quality Control, Manufacturing etc. I guess we could have used ticket custom fields, but the ticket type was just there with no extra effort.

comment:3 by anonymous, 14 years ago

It's not just ticket types. It's any AbstractEnum. First of all, the options should probably be sorted in the table by numeric order rather than lexicographic. Also, things break horribly if trying to add anything more than 10 options to any AbstractEnum. I haven't been able to figure out why yet.

comment:4 by hyuga@…, 14 years ago

The problem seems to arise, at least in the case of 0.10dev that cast has not yet been properly implemented in sqlite_backend.py I made a simple implementation for my own purposes as:

def cast(self, column, type):
    return 'CAST(' + ' AS '.join((column, type)) + ')'

comment:5 by Christian Boos, 14 years ago

Milestone: 0.10

Wasn't this one also fixed by r3690?

in reply to:  5 comment:6 by Matthew Good, 14 years ago

Resolution: duplicate
Status: assignedclosed

Replying to cboos:

Wasn't this one also fixed by r3690?

Yeah, this is the same issue raised in #3490.

comment:7 by Christian Boos, 8 years ago

Milestone: 0.10

(clearing report:35)

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Christopher Lenz.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Christopher Lenz to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.