Hi,

After upgrading sandbox/workflow to the latest revision (I was about a month back), I keep getting these weird errors. Tickets that are updated with a comment will start failing because the ticket_change is inserted with oldvalue=='2'. This upsets some of the code that handles reply to comment (BRILLIANT feature though!!).

If I update the database and set oldvalue='' everything starts working again.

Is this related to my version of sqlite (has caused problems before with the search feature)? Let me know if you want me to create a ticket.


Kind regards,
Philip


In the database the ticket_change.oldvalue often becomes '2', which breaks the ticket with the following error:

Oops…
Trac detected an internal error:

If you think this really should work and you can reproduce it, you should consider reporting this problem to the Trac team.

Go to http://trac.edgewall.com/ and create a new ticket where you describe the problem, how to reproduce it. Don't forget to include the Python traceback found below.

TracGuide — The Trac User and Administration Guide

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 313, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 198, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.3/site-packages/trac/ticket/web_ui.py", line 204, in process_request
    self._insert_ticket_data(req, db, ticket, reporter_id, fields)
  File "/usr/lib/python2.3/site-packages/trac/ticket/web_ui.py", line 442, in _insert_ticket_data
    assert this_num == str(autonum)
AssertionError



SQLite version 2.8.16
Enter ".help" for instructions
sqlite> select * from ticket where id=864;
864|defect|1148290504|1150288091|wizmain|unset|high|js|jbu|[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED]|-0-|Release-5.9|assigned||Enable localization of buttons|Enable localization (translation to other languages) for AM wizard buttons: CANCEL, BACK, NEXT, FINISH.




|
sqlite> select * from ticket_change where ticket=864;
864|1150118832|js|comment||Related tickets: [[br]]
 * Unlang wizmain: #752[[br]]
 * Use icons for navigation buttons: #968
864|1150288091|js|status|new|assigned
864|1150288091|js|owner|philip|js
864|1150288091|js|comment|2|Changeset [7673] enables this.
864|946684800|trac|comment||||[7711]||js||2006-06-15 08:10:31||German navigation buttons added. #864||


To fix the error:
sqlite> update ticket_change set oldvalue='' where ticket=864 and oldvalue='2';


Attachment: PGP.sig
Description: This is a digitally signed message part

_______________________________________________
Trac-dev mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-dev

Reply via email to