Mailing List Archive

[The Trac Project] #3654: No notification on new ticket
#3654: No notification on new ticket
-------------------------------------------+--------------------------------
Reporter: trac@erre.user.lysator.liu.se | Owner: jonas
Type: defect | Status: new
Priority: normal | Milestone:
Component: ticket system | Version: devel
Severity: normal | Keywords:
-------------------------------------------+--------------------------------
From the log:
{{{
Trac[web_ui] ERROR: Failure sending notification on creation of ticket
#1386: unpack non-sequence
Traceback (most recent call last):
File "/usr/local/lib/python2.3/site-packages/trac/ticket/web_ui.py",
line 181, in _do_create
tn.notify(ticket, newticket=True)
File "/usr/local//lib/python2.3/site-
packages/trac/ticket/notification.py", line 127, in notify
NotifyEmail.notify(self, ticket.id, subject)
File "/usr/local//lib/python2.3/site-packages/trac/notification.py",
line 208, in notify
Notify.notify(self, resid)
File "/usr/local//lib/python2.3/site-packages/trac/notification.py",
line 105, in notify
(torcpts, ccrcpts) = self.get_recipients(resid)
File "/usr/local//lib/python2.3/site-
packages/trac/ticket/notification.py", line 225, in get_recipients
(updater, ) = cursor.fetchone()
TypeError: unpack non-sequence
}}}

Running r3680 with MySQL backend. Ticket update notifications work.

--
Ticket URL: <http://trac.edgewall.org/ticket/3654>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---
Re: [The Trac Project] #3654: No notification on new ticket [ In reply to ]
#3654: No notification on new ticket
-------------------------------------------+--------------------------------
Reporter: trac@erre.user.lysator.liu.se | Owner: jonas
Type: defect | Status: new
Priority: normal | Milestone:
Component: ticket system | Version: devel
Severity: normal | Resolution:
Keywords: |
-------------------------------------------+--------------------------------
Comment (by timwatt+trac@gmail.com):

In my specific case (as in yours), I had `always_notify_updater = false`,
which is needed to trigger the code path you quote. The problem, as the
exception implies, is that the query
{{{
#!sql
SELECT author FROM ticket_change WHERE ticket=%s ORDER BY time DESC LIMIT
1
}}}
returns no results (naturally, since there are no changes recorded yet).

The patch I'm attaching solved it for my configuration, but deserves more
testing (and possibly cleanup/beautification).

I wrote it against 0.10b1, but it looks like that file has not been
touched since that tag (so it should apply to trunk as well).

--
Ticket URL: <http://trac.edgewall.org/ticket/3654#comment:1>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---
Re: [The Trac Project] #3654: No notification on new ticket [ In reply to ]
#3654: No notification on new ticket
-------------------------------------------+--------------------------------
Reporter: trac@erre.user.lysator.liu.se | Owner: jonas
Type: defect | Status: new
Priority: normal | Milestone: 0.10.1
Component: ticket system | Version: devel
Severity: normal | Resolution:
Keywords: mysql notification |
-------------------------------------------+--------------------------------
Changes (by cboos):

* keywords: => mysql notification
* milestone: => 0.10.1

--
Ticket URL: <http://trac.edgewall.org/ticket/3654#comment:2>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---
Re: [The Trac Project] #3654: No notification on new ticket [ In reply to ]
#3654: No notification on new ticket
-------------------------------------------+--------------------------------
Reporter: trac@erre.user.lysator.liu.se | Owner: cboos
Type: defect | Status: assigned
Priority: normal | Milestone: 0.10.1
Component: ticket system | Version: devel
Severity: minor | Resolution:
Keywords: notification |
-------------------------------------------+--------------------------------
Changes (by cboos):

* keywords: mysql notification => notification
* owner: jonas => cboos
* status: new => assigned
* severity: normal => minor

Comment:

Actually, it's specific to the database backend.

--
Ticket URL: <http://trac.edgewall.org/ticket/3654#comment:3>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---
Re: [The Trac Project] #3654: No notification on new ticket [ In reply to ]
#3654: No notification on new ticket
-------------------------------------------+--------------------------------
Reporter: trac@erre.user.lysator.liu.se | Owner: cboos
Type: defect | Status: assigned
Priority: normal | Milestone: 0.10.1
Component: ticket system | Version: devel
Severity: minor | Resolution:
Keywords: notification |
-------------------------------------------+--------------------------------
Changes (by cboos):

* keywords: mysql notification => notification
* owner: jonas => cboos
* status: new => assigned
* severity: normal => minor

Comment:

Actually, it's ''not'' specific to the database backend.

--
Ticket URL: <http://trac.edgewall.org/ticket/3654#comment:3>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---
Re: [The Trac Project] #3654: No notification on new ticket [ In reply to ]
#3654: No notification on new ticket
-------------------------------------------+--------------------------------
Reporter: trac@erre.user.lysator.liu.se | Owner: cboos
Type: defect | Status: closed
Priority: normal | Milestone: 0.10.1
Component: ticket system | Version: devel
Severity: minor | Resolution: fixed
Keywords: notification |
-------------------------------------------+--------------------------------
Changes (by cboos):

* status: assigned => closed
* resolution: => fixed

Comment:

Fixed by r3808.

--
Ticket URL: <http://trac.edgewall.org/ticket/3654#comment:4>
The Trac Project <http://trac.edgewall.org/>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Tickets" group.
To post to this group, send email to trac-tickets@googlegroups.com
To unsubscribe from this group, send email to trac-tickets-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.se/group/trac-tickets
-~----------~----~----~----~------~----~------~--~---