Automattic/trac-code-comments-plugin — Issue #4: IntegrityError: null value in column "id" violates not-null constraint
Author: petekalo
Created: 2012-02-25 21:24:47+00:00
State: open

getting a db error:

```
2012-02-25 16:05:05,987 Trac[main] ERROR: Internal Server Error:
Traceback (most recent call last):
File "build/bdist.linux-i686/egg/trac/web/main.py", line 511, in _dispatch_request
dispatcher.dispatch(req)
File "build/bdist.linux-i686/egg/trac/web/main.py", line 237, in dispatch
resp = chosen_handler.process_request(req)
File "build/bdist.linux-i686/egg/code_comments/web.py", line 222, in process_request
id = comments.create(json.loads(req.read()))
File "build/bdist.linux-i686/egg/code_comments/comments.py", line 87, in create
@self.env.with_transaction()
File "build/bdist.linux-i686/egg/trac/db/api.py", line 77, in transaction_wrapper
fn(ldb)
File "build/bdist.linux-i686/egg/code_comments/comments.py", line 91, in insert_comment
cursor.execute(sql, values)
File "build/bdist.linux-i686/egg/trac/db/util.py", line 65, in execute
return self.cursor.execute(sql_escape_percent(sql), args)
IntegrityError: null value in column "id" violates not-null constraint
```

fresh install on 12.2 with postgres