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).
A check to add would be that if no values for this field are present
then no max_speed is computed/displayed.
Regards,
Pierre
------------------------------------------------------------------------------
Doing More with Less: The Next Generation Virtual Desktop
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops? How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/
_______________________________________________
Pytrainer-devel mailing list
Pytrainer-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pytrainer-devel
