Changing component makes owner "none" while owner should be empty

[linuxificator@…]

I have a set of tickets of type "defect"

When an action "add comment" is performed, the ticket is disowned (owner is empty), and status becomes new. The ticket shows up in "new defects", this is exactly as expected.

When I change the component of a "defect" ticket, the owner becomes "None" (seen when listing all tickets), the ticket itself shows "new defect". But when the owner is "None" in stead of empty, the ticket does not show up in the "new defects list", while the ticket is a new defect.

so:

1) changing the component of "defect" tickets makes it's owner "None" while it should be empty.

2) lisitng "new defect" does not list the new defects with owner "None", only the ones with an empty owner field

3) the "None" owner is seen in the "list all tickets", but when showing ​http://trac/xx/ticket/<number>, the "owned by" field of a ticket owned by "None" is empty

[linuxificator@…]

trac.ini

[linuxificator@…]

Workaround:

in the original "list new defects" query change:

… and owner = ''

to:

… and ( owner = '' or owner is null )

The issue is now: Why is the owner sometimes empty and sometimes null (listed as "None" in "view all tickets" and listed as empty in the ticket itself)

[Carsten Klein <carsten.klein@…>]

In you configuration, on new, test_gefaald → new you do the operation del_owner.

Now, in your configuration, see trac admin components, you have assigned None as the owner to all or some of your components, right?

Now, when setting the component to a different one, then the owner that was assigned to that component will be set as the owner of the ticket.

Perhaps that would solve your problem.

[Ryan J Ollos]

See also #11018.

[Ryan J Ollos]

Based on the testing I've done, the issue is fixed in #11018. NULL is stored in the database when saving an owner with value None or an empty string.