Hi again Pierre,
2011/9/26 David García Granda <dgra...@gmail.com>:
> Hi Pierre,
>
> 2011/9/8 Toystorie69 <toystori...@free.fr>:
>> Le 08/09/2011 17:23, David García Granda a écrit :
>>> Hi Pierre,
>>>
>>>>>> I still have some unexplained crash with latest SVN version on my Gentoo
>>>>>> so I continue to use pytrainer-1.8.0 on ubuntu... :-(
>>>>>> I still try to investigate where the problem could come from but without
>>>>>> success till now.
>>>>>> Nevertheless, using a fresh new database with only one record imported
>>>>>> from .gpx I see this ouput in the terminal :
>>>>>>
>>>>>> pierre@gandalf ~ $ pytrainer
>>>>>> running pytrainer from egg installation
>>>>>> data_path: /usr/share/pytrainer/
>>>>>> gettext_path: /usr/share/locale
>>>>>> site_path: /usr/lib/python2.6/site-packages
>>>>>> Traceback (most recent call last):
>>>>>> File "/usr/lib/python2.6/site-packages/pytrainer/gui/windowmain.py",
>>>>>> line 1904, in on_calendar_selected
>>>>>> self.parent.refreshGraphView(self.selected_view)
>>>>>> File "/usr/lib/python2.6/site-packages/pytrainer/main.py", line 225,
>>>>>> in refreshGraphView
>>>>>> self.refreshRecordGraphView("info")
>>>>>> File "/usr/lib/python2.6/site-packages/pytrainer/main.py", line 301,
>>>>>> in refreshRecordGraphView
>>>>>> self.windowmain.actualize_recordview(activity)
>>>>>> File "/usr/lib/python2.6/site-packages/pytrainer/gui/windowmain.py",
>>>>>> line 454, in actualize_recordview
>>>>>> max_speed = lap['max_speed'] * 3.6
>>>>>> TypeError: unsupported operand type(s) for *: 'NoneType' and 'float'
>>>>>> Traceback (most recent call last):
>>>>>> File "/usr/lib/python2.6/site-packages/pytrainer/gui/popupmenu.py",
>>>>>> line 47, in on_showclassic_activate
>>>>>> self.parent.parent.refreshRecordGraphView("info",
>>>>>> id_record=self.id_record)
>>>>>> File "/usr/lib/python2.6/site-packages/pytrainer/main.py", line 301,
>>>>>> in refreshRecordGraphView
>>>>>> self.windowmain.actualize_recordview(activity)
>>>>>> File "/usr/lib/python2.6/site-packages/pytrainer/gui/windowmain.py",
>>>>>> line 454, in actualize_recordview
>>>>>> max_speed = lap['max_speed'] * 3.6
>>>>>> TypeError: unsupported operand type(s) for *: 'NoneType' and 'float'
>>>>>> pierre@gandalf ~ $
>>>>> Strange... Can you please check what is alreay stored in max_speed
>>>>> field in laps table?
>>>> sqlite> select * from records;
>>>> 12.69|13.720265027|4.22|Jogging|3|356.2003|9.32063647491|2011-08-24
>>>> 18:20:14+0200|810|2011-08-24T16:20:14Z|yyyyyyjjjjjj|6.26|356.6371|4901|156.0||4901|2011-08-24|3|213.0
>>>>
>>>> So, max_speed is 13.72
>>> Was not the issue related to max_speed value in laps?. Quick look at
>>> my db shows that max_speed (actually maxspeed, without underscore) is
>>> stored in km/h in records table but in min/km in laps table
>>>
>>
>> Oups, you're right, I did not check the good table...
>> Here it is:
>> sqlite> .schema laps
>> CREATE TABLE laps (distance float,end_lon float,lap_number
>> integer,start_lon float,id_lap integer primary key
>> autoincrement,calories int,avg_hr int,comments text,elapsed_time
>> varchar(20),record integer,intensity varchar(7),laptrigger
>> varchar(9),max_hr int,end_lat float,start_lat float,max_speed float);
>> sqlite> select * from laps where record=3;
>> 1000.0|5.020118|0|5.010121|47|63|132||363.79|3|resting|distance|145|45.64649|45.64569|
>> 1000.0|5.031386|1|5.020477|48|68|144||343|3|resting|distance|146|45.64326|45.64659|
>> 1000.0|5.033319|2|5.031086|49|72|148||352.013|3|resting|distance|156|45.63546|45.643|
>> 1000.0|5.03241|3|5.033452|50|80|135||512.993|3|resting|distance|158|45.63704|45.63522|
>> 13.51|5.03242|4|5.032376|51|1|99||46.86|3|resting|distance|106|45.63706|45.63702|
>> 386.85|5.02843|5|5.032381|52|27|160||135.638|3|resting|distance|173|45.63579|45.63704|
>> 400.13|5.032432|6|5.028289|53|27|147||146.8|3|resting|distance|172|45.63712|45.63578|
>> 388.98|5.028387|7|5.032376|54|30|164||140.849|3|resting|distance|174|45.63577|45.63707|
>> 393.04|5.032429|8|5.028286|55|27|149||149.5|3|resting|distance|172|45.63709|45.63575|
>> 386.66|5.028426|9|5.032334|56|30|165||139.375|3|resting|distance|177|45.63579|45.63702|
>> 383.86|5.03238|10|5.028307|57|31|172||149.125|3|resting|distance|182|45.63707|45.63577|
>> 382.92|5.028409|11|5.032335|58|21|193||139.6|3|resting|distance|210|45.63579|45.63705|
>> 395.65|5.032362|12|5.028294|59|24|168||154.742|3|resting|distance|199|45.6371|45.63576|
>> 373.69|5.028417|13|5.032322|60|23|164||138.858|3|resting|distance|178|45.63578|45.63706|
>> 383.94|5.032124|14|5.028364|61|38|160||155.3|3|resting|distance|181|45.63716|45.63576|
>> 378.7|5.028369|15|5.032105|62|34|168||137.631|3|resting|distance|174|45.6358|45.63713|
>> 398.08|5.032405|16|5.028255|63|29|163||160.944|3|resting|distance|174|45.63709|45.63577|
>> 385.81|5.028292|17|5.03235|64|27|166||140.376|3|resting|distance|180|45.63581|45.63704|
>> 397.7|5.032428|18|5.028241|65|24|152||159.074|3|resting|distance|177|45.63704|45.63581|
>> 385.39|5.028314|19|5.032243|66|29|165||143.45|3|resting|distance|178|45.63582|45.63694|
>> 1000.0|5.025451|20|5.028221|67|45|149||425.121|3|resting|distance|175|45.6401|45.63579|
>> 1000.0|5.017996|21|5.02532|68|35|158||359.001|3|resting|distance|179|45.64626|45.64042|
>> 856.69|5.009867|22|5.017631|69|25|167||308.118|3|resting|distance|195|45.64608|45.64629|
>> sqlite>
>>
>> Hum... max_speed, with an underscore in this table ;) is described as
>> the last field but no values are stored here...
>> There is certainly a difference if the records comes directly from the
>> watch or from an imported gpx (value unavailable in this case).
>
> Thanks Pierre for investigation. As a summary:
>
> - records table: max_speed. laps table: maxspeed. Definitely would
> lead to confusion.
> - When importing through file no maximum speed stored in laps table.
>
> I would need some time for troubleshooting.
Maybe you have already explained it before (sorry for this), but could
you please detail clickpath when importing file (there are several
ways although unified import shoud be preferred one) which produces
current issue? I would appreciate if you could provide a sample file
(just for troubleshooting) ;)
Thanks!
David
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2dcopy2
_______________________________________________
Pytrainer-devel mailing list
Pytrainer-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pytrainer-devel
