
Can anyone access this ticket: https://svn.boost.org/trac/boost/ticket/764 ? It's assigned to me, but IE and Firefox return an internal Trac error: Trac detected an internal error: TypeError: a float is required Python Traceback Most recent call last: File "/opt/trac2/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/main.py", line 423, in _dispatch_request Code fragment:try:if not env and env_error:raise HTTPInternalError(env_error)try:dispatcher = RequestDispatcher(env)dispatcher.dispatch(req)except RequestDone:passresp = req._response or []except HTTPException, e:Local variables:NameValueafter[u' except RequestDone:', u' pass', u' resp = ...before[u' try:', u' if not env and env_error:', u' raise ...dispatcher<trac.web.main.RequestDispatcher object at 0xb7aff90c>e<exceptions.TypeError instance at 0xb7a6874c>env<trac.env.Environment object at 0xb7c46aec>env_errorNoneexc_info(<class exceptions.TypeError at 0xb7f782cc>, <exceptions.TypeError ...filename'/opt/trac2/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/main.p ...frames[{'function': '_dispatch_request', 'lines_before': [u' try:', u' ...has_adminTruelineu' dispatcher.dispatch(req)'lineno422messageu'TypeError: a float is required'req<Request "GET u'/ticket/764'">resp[]tb<traceback object at 0xb7a6e324>tb_hideNonetraceback'Traceback (most recent call last):\n File ...File "/opt/trac2/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/web/main.py", line 197, in dispatch Code fragment:req.args.get('__FORM_TOKEN') != req.form_token:raise HTTPBadRequest('Missing or invalid form token. ''Do you have cookies enabled?')# Process the request and render the templateresp = chosen_handler.process_request(req)if resp:if len(resp) == 2: # Clearsilverchrome.populate_hdf(req)template, content_type = \self._post_process_request(req, *resp)Local variables:NameValuechosen_handler<trac.ticket.web_ui.TicketModule object at 0xb7aff96c>chrome<trac.web.chrome.Chrome object at 0xb7c65d6c>err(<class exceptions.TypeError at 0xb7f782cc>, <exceptions.TypeError ...handler<trac.ticket.web_ui.TicketModule object at 0xb7aff96c>req<Request "GET u'/ticket/764'">self<trac.web.main.RequestDispatcher object at 0xb7aff90c>File "/opt/trac2/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/ticket/web_ui.py", line 152, in process_request Code fragment:def process_request(self, req):if 'id' in req.args:if req.path_info.startswith('/newticket'):raise TracError(_("id can't be set for a new ticket request."))return self._process_ticket_request(req)return self._process_newticket_request(req)# ITemplateProvider methodsdef get_htdocs_dirs(self):Local variables:NameValuereq<Request "GET u'/ticket/764'">self<trac.ticket.web_ui.TicketModule object at 0xb7aff96c>File "/opt/trac2/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/ticket/web_ui.py", line 412, in _process_ticket_request Code fragment:version = int(version)except ValueError:version = Nonereq.perm('ticket', id, version).require('TICKET_VIEW')ticket = Ticket(self.env, id, version=version)action = req.args.get('action', ('history' in req.args and 'history' or'view'))data = self._prepare_data(req, ticket)data['comment'] = NoneLocal variables:NameValueid764req<Request "GET u'/ticket/764'">self<trac.ticket.web_ui.TicketModule object at 0xb7aff96c>versionNoneFile "/opt/trac2/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/ticket/model.py", line 47, in __init__ Code fragment:self.env = envself.resource = Resource('ticket', tkt_id, version)self.fields = TicketSystem(self.env).get_ticket_fields()self.values = {}if tkt_id is not None:self._fetch_ticket(tkt_id, db)else:self._init_defaults(db)self.id = self.time_created = self.time_changed = Noneself._old = {}Local variables:NameValuedbNoneenv<trac.env.Environment object at 0xb7c46aec>self<trac.ticket.model.Ticket object at 0xb7affe0c>tkt_id764versionNoneFile "/opt/trac2/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/ticket/model.py", line 105, in _fetch_ticket Any ideas anyone? Thanks, John.

on Mon Dec 29 2008, "John Maddock" <john-AT-johnmaddock.co.uk> wrote:
Can anyone access this ticket: https://svn.boost.org/trac/boost/ticket/764 ?
Unfortunately, no. I reported this problem a while back at http://trac.edgewall.org/ticket/7840 Fortunately for you, John, there are other ways to find out about this ticket: http://tinyurl.com/maddock-boost-bugs However, there has a been a request for more information in that ticket, which I missed. Only Doug or DongInn OSL can do it for us. Would one of you mind running those commands and updating the ticket at http://trac.edgewall.org/ticket/7840? Thanks, -- Dave Abrahams BoostPro Computing http://www.boostpro.com

David Abrahams wrote:
Fortunately for you, John, there are other ways to find out about this ticket: http://tinyurl.com/maddock-boost-bugs
Doesn't help much, I *could* remember what it was about anyway, but I believe it's been obsoleted by other changes, so I was going to close it down, but to do that I need to access the actual ticket itself :-( Cheers, Dave.

In article <EB988BEDA6A7408781E6864A1332CB77@fuji>, "John Maddock" <john@johnmaddock.co.uk> wrote:
Can anyone access this ticket: https://svn.boost.org/trac/boost/ticket/764 ?
If someone with access to the Trac server could tell me what you get when you run echo 'select time,changetime from ticket where id=10;' | sqlite3 tracenv/db/trac.db where tracenv is the path to your Trac environment, I can probably tell you why Trac is losing and how to fix it.

On Tue, Dec 30, 2008 at 12:12 PM, Ben Artin <macdev@artins.org> wrote:
In article <EB988BEDA6A7408781E6864A1332CB77@fuji>, "John Maddock" <john@johnmaddock.co.uk> wrote:
Can anyone access this ticket: https://svn.boost.org/trac/boost/ticket/764 ?
If someone with access to the Trac server could tell me what you get when you run
echo 'select time,changetime from ticket where id=10;' | sqlite3 tracenv/db/trac.db
where tracenv is the path to your Trac environment, I can probably tell you why Trac is losing and how to fix it.
Here's the result: -bash-3.00$ echo 'select time,changetime from ticket where id=10;' | sqlite3 /opt/trac/boost/db/trac.db 1005174885| - Doug

In article <24b520d20812300954u8a15d27y6df83b7ab1a4581d@mail.gmail.com>, "Doug Gregor" <doug.gregor@gmail.com> wrote:
If someone with access to the Trac server could tell me what you get when you run
echo 'select time,changetime from ticket where id=10;' | sqlite3 tracenv/db/trac.db
where tracenv is the path to your Trac environment, I can probably tell you why Trac is losing and how to fix it.
Here's the result:
-bash-3.00$ echo 'select time,changetime from ticket where id=10;' | sqlite3 /opt/trac/boost/db/trac.db 1005174885|
OK, the issue is that the changetime field on that ticket is blank for some reason. It can be fixed up: 1. Make a backup of the trac.db file. 2. echo 'update ticket set changetime = (select max(tc.time) from ticket_change as tc where ticket=id) where changetime="" or changetime is null;' | sqlite3 tracenv/db/trac.db echo 'update ticket set changetime = time where changetime is null;' | sqlite3 tracenv/db/trac.db This will fix changetimes on all tickets that have blank changetimes now, and the web UI will stop crapping out Hope this helps.

On Tue, Dec 30, 2008 at 1:43 PM, Ben Artin <macdev@artins.org> wrote:
In article <24b520d20812300954u8a15d27y6df83b7ab1a4581d@mail.gmail.com>, "Doug Gregor" <doug.gregor@gmail.com> wrote:
If someone with access to the Trac server could tell me what you get when you run
echo 'select time,changetime from ticket where id=10;' | sqlite3 tracenv/db/trac.db
where tracenv is the path to your Trac environment, I can probably tell you why Trac is losing and how to fix it.
Here's the result:
-bash-3.00$ echo 'select time,changetime from ticket where id=10;' | sqlite3 /opt/trac/boost/db/trac.db 1005174885|
OK, the issue is that the changetime field on that ticket is blank for some reason. It can be fixed up:
1. Make a backup of the trac.db file. 2.
echo 'update ticket set changetime = (select max(tc.time) from ticket_change as tc where ticket=id) where changetime="" or changetime is null;' | sqlite3 tracenv/db/trac.db
echo 'update ticket set changetime = time where changetime is null;' | sqlite3 tracenv/db/trac.db
This will fix changetimes on all tickets that have blank changetimes now, and the web UI will stop crapping out
Hope this helps.
Success! Thank you very, very much. - Doug

In article <24b520d20812311026i305f271axbf4ca81ce9549732@mail.gmail.com>, "Doug Gregor" <doug.gregor@gmail.com> wrote:
This will fix changetimes on all tickets that have blank changetimes now, and the web UI will stop crapping out
Success! Thank you very, very much.
Hooray! You are welcome.
participants (4)
-
Ben Artin
-
David Abrahams
-
Doug Gregor
-
John Maddock