Custom Query (332 matches)

i am trying to install it in fedora 9,but couldn't be able to do it.The installation guide is not helpful to me.i have rpm manager installed,tried it ,but returns no packages available.plshelp me. i am a layman regarding fedora is considered.

This email is sent by logcheck. If you wish to no-longer receive it,
you can either deinstall the logcheck package or modify its
configuration file (/etc/logcheck/logcheck.conf).

System Events
=-=-=-=-=-=-=
Dec 14 15:45:41 subtrac email2trac: etype = _sqlite.IntegrityError, evalue = columns ticket, time, field are not unique
Dec 14 15:45:41 subtrac email2trac: Traceback (most recent call last):
Dec 14 15:45:41 subtrac email2trac:   File "/usr/bin/email2trac", line 1071, in ?     tktparser.parse(sys.stdin)
Dec 14 15:45:41 subtrac email2trac:   File "/usr/bin/email2trac", line 671, in parse     if self.ticket_update(m):
Dec 14 15:45:41 subtrac email2trac:   File "/usr/bin/email2trac", line 542, in ticket_update     tkt.save_changes(self.author, body_text, when)
Dec 14 15:45:41 subtrac email2trac:   File "/usr/lib/python2.3/site-packages/trac/ticket/model.py", line 250, in save_changes     (self.id, when, author, cnum, comment))
Dec 14 15:45:41 subtrac email2trac:   File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 50, in execute     return self.cursor.execute(sql_escape_percent(sql), args)
Dec 14 15:45:41 subtrac email2trac:   File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 255, in execute     self.rs = self.con.db.execute(SQL % parms)
Dec 14 15:45:41 subtrac email2trac: IntegrityError: columns ticket, time, field are not unique

_______________________________________________
Rc_root mailing list
Rc_root@mailman.rc.sara.nl
http://mailman.rc.sara.nl/cgi-bin/mailman/listinfo/rc_root

I started to port this script for trac 0.11 and I founded two errors.

The first is in the notify method and it is described in the #34 ticket. The solution, for me, was to remove the hack.

# create false {abs_}href properties, to trick Notify()
#
self.env.abs_href = Href(self.get_config('project', 'url'))
self.env.href = Href(self.get_config('project', 'url'))

The env members(abs_href and href) don't need to be overwritten.

The second problem was that in ticket_modify method. When saving the modifications made on a ticket it was passed an integer as the modification time.

Traceback (most recent call last):
  File "/home/andrei/workspace/etf/trunk/share/bin/email2trac.py", line 1062, in ?
    tktparser.parse(file('/tmp/tests/tm.eml', 'r'))
  File "/home/andrei/workspace/etf/trunk/share/bin/email2trac.py", line 663, in parse
    if self.ticket_update(m):
  File "/home/andrei/workspace/etf/trunk/share/bin/email2trac.py", line 542, in ticket_update
    tkt.save_changes(self.author, body_text, when)
  File "/home/andrei/workspace/etf/trunk/vendor/trac-0.11dev/trac/ticket/model.py", line 207, in save_changes
    when_ts = to_timestamp(when)
  File "/home/andrei/workspace/etf/trunk/vendor/trac-0.11dev/trac/util/datefmt.py", line 55, in to_timestamp
    diff = dt - _epoc
TypeError: unsupported operand type(s) for -: 'int' and 'datetime.datetime'

In trac 0.11 if the modification time is None then datetime.now() is assumed. So the solution is to send a None.

A patch is attached.