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.
> A check to add would be that if no values for this field are present
> then no max_speed is computed/displayed.
Yep, fully agree.
Regards,
David
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Pytrainer-devel mailing list
Pytrainer-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pytrainer-devel
