#3494: Error when trying to submit bug report
----------------------------+-----------------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: jonas
Type: defect | Status: closed
Priority: highest | Milestone:
Component: general | Version: 0.9.6
Severity: blocker | Resolution: invalid
Keywords: |
----------------------------+-----------------------------------------------
Changes (by mgood):
* status: new => closed
* resolution: => invalid
Old description:
> I hit the following problem when I tried to report a suggestion to
> [EMAIL PROTECTED] regarding SortableList Demo at script.aculo.us:
> Python Traceback
>
> Traceback (most recent call last):
> File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line
> 314, in dispatch_request
> dispatcher.dispatch(req)
> File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line
> 199, in dispatch
> resp = chosen_handler.process_request(req)
> File "/usr/local/lib/python2.4/site-packages/trac/ticket/web_ui.py",
> line 109, in process_request
> self._do_create(req, db)
> File "/usr/local/lib/python2.4/site-packages/trac/ticket/web_ui.py",
> line 170, in _do_create
> ticket.insert(db=db)
> File "/usr/local/lib/python2.4/site-packages/trac/ticket/model.py",
> line 162, in insert
> [self[name] for name in std_fields] +
> File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 47,
> in execute
> return self.cursor.execute(sql_escape_percent(sql), args)
> File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 47,
> in execute
> return self.cursor.execute(sql_escape_percent(sql), args)
> File "/usr/local/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line
> 3111, in execute
> raise OperationalError, msg
> OperationalError: ERROR: null value in column "id" violates not-null
> constraint
New description:
I hit the following problem when I tried to report a suggestion to
[EMAIL PROTECTED] regarding SortableList Demo at script.aculo.us:
Python Traceback
{{{
Traceback (most recent call last):
File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line
314, in dispatch_request
dispatcher.dispatch(req)
File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line
199, in dispatch
resp = chosen_handler.process_request(req)
File "/usr/local/lib/python2.4/site-packages/trac/ticket/web_ui.py",
line 109, in process_request
self._do_create(req, db)
File "/usr/local/lib/python2.4/site-packages/trac/ticket/web_ui.py",
line 170, in _do_create
ticket.insert(db=db)
File "/usr/local/lib/python2.4/site-packages/trac/ticket/model.py", line
162, in insert
[self[name] for name in std_fields] +
File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 47,
in execute
return self.cursor.execute(sql_escape_percent(sql), args)
File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 47,
in execute
return self.cursor.execute(sql_escape_percent(sql), args)
File "/usr/local/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line
3111, in execute
raise OperationalError, msg
OperationalError: ERROR: null value in column "id" violates not-null
constraint
}}}
Comment:
It looks like RoR has broken their Trac database. The "id" column on the
ticket table should be declared "SERIAL" in order to automatically
increment. This is done when Trac creates its tables, but the RoR appears
to have made changes to the database structure which were incorrect.
Please report the issue to their administrators and ask them to fix it.
The are welcome to ask for help on the Trac MailingList in fixing the
problem.
Also, please attach screenshots as PNG or JPG images. PDF files are
inconvenient when they just contain a single image.
--
Ticket URL: <http://trac.edgewall.org/ticket/3494#comment:1>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
