PostgreSql error in datetime format

[m.massarini@…]

Hi to all,

I'm trying to use bitten with Trac 0.11dev-r6538, I created a build recipe through the trac interface but the bitten-master is unable to start the building process since the following exception.

---

trac@trac-pc:~$ bitten-master --verbose --port=xxxx --host=xxx.yyy.zzz.aaa --log=bitten.log /project Traceback (most recent call last):

File "/usr/bin/bitten-master", line 8, in <module>

load_entry_point('Bitten==0.5.3', 'console_scripts', 'bitten-master')()

File "build/bdist.linux-i686/egg/bitten/master.py", line 437, in main File "build/bdist.linux-i686/egg/bitten/util/beep.py", line 149, in run File "build/bdist.linux-i686/egg/bitten/master.py", line 61, in _enqueue_builds File "build/bdist.linux-i686/egg/bitten/queue.py", line 173, in populate File "build/bdist.linux-i686/egg/bitten/model.py", line 412, in insert File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r6538-py2.5.egg/trac/db/util.py", line 50, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r6538-py2.5.egg/trac/db/util.py", line 50, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "/usr/lib/python2.5/site-packages/pyPgSQL/PgSQL.py", line 3111, in execute

raise Operational Error?, msg

libpq.Operational Error?: ERROR: syntax error at or near ""UTC"" at character 176

---

I printed out the query content but I'm unable to fix the problem:

('INSERT INTO bitten_build (config,rev,rev_time,platform,slave,started,stopped,status) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)', (u'Stack Konnex?', '171', datetime.datetime(2008, 3, 4, 16, 32, 36, tzinfo=<Fixed Offset? "UTC" 0:00:00>), 2, , 0, 0, 'P'))

[osimons]

This is quite an old ticket, using a Bitten version not made for Trac 0.11, and the Trac 0.11 version used was further a pre-release development build.

I'm closing this ticket. Please update to latest Bitten trunk version and use a recent Trac 0.11.x version, and reopen the ticket if problem persists.