RV: Estadisticas en Chronojump 0.6-pre6

["Juan Fernando Pardo" <juanfer juanfer com ar>]

Xavier,
Encontré que el error ocurre si uso las librerias sqlitedll-3_4_2.zip.
Si uso las sqlitedll-3_4_0.zip muestra una ventana más, pero si selecciono
"Printar gráfico" se cierra el programa y muestra el siguiente error.

Saludos
Juanfer


-----Mensaje original-----
Xavier,
Estoy probando el pre6 en Windows, recién bajado del SVN, y me encuentro que
al querer ver las estadísticas en "Vista / Estadística" me surge un error y
se cierra el programa.
No sé en Linux ya que tengo instalado el mono 1.2.5 que no funciona.

Adjunto archivo .txt con el log de la ventana.

Saludos
Juanfer

C:\chronojump>mono chronojump.prg
SELECT value FROM preferences  WHERE name == 'chronopicPort'
SELECT value FROM preferences  WHERE name == 'databaseVersion'
tablas creadas
SELECT MAX(uniqueID) FROM tempJumpRj
exists = 0
SELECT MAX(uniqueID) FROM tempRunInterval
exists = 0
made a database backup

(chronojump:4008): Gtk-WARNING **: No se ha podido encontrar el icono ½+. El tem
a ½hicolor+
no se encontr¾ o quizß necesite instalarlo.
Puede obtener una copia desde:
        http://icon-theme.freedesktop.org/releases
SELECT * FROM session WHERE uniqueID == -1
SELECT * FROM session WHERE uniqueID == -1
SELECT value FROM preferences  WHERE name == 'databaseVersion'
Versión de la base de datos de Chronojump: 0.52
SELECT value FROM preferences  WHERE name == 'chronopicPort'
SELECT value FROM preferences  WHERE name == 'digitsNumber'
SELECT value FROM preferences  WHERE name == 'allowFinishRjAfterTime'
SELECT value FROM preferences  WHERE name == 'showHeight'
SELECT value FROM preferences  WHERE name == 'showInitialSpeed'
SELECT value FROM preferences  WHERE name == 'showQIndex'
SELECT value FROM preferences  WHERE name == 'showDjIndex'
SELECT value FROM preferences  WHERE name == 'simulated'
SELECT value FROM preferences  WHERE name == 'askDeletion'
SELECT value FROM preferences  WHERE name == 'heightPreferred'
SELECT value FROM preferences  WHERE name == 'metersSecondsPreferred'
Preferencias cargadas
SELECT *  FROM jumpType  ORDER BY uniqueID
SELECT *  FROM jumpRjType  ORDER BY uniqueID
SELECT *  FROM runType  ORDER BY uniqueID
SELECT *  FROM runIntervalType  ORDER BY uniqueID
SELECT *  FROM pulseType  ORDER BY uniqueID
open session
SELECT * FROM session ORDER BY uniqueID
SELECT sessionID, count(*) FROM PERSONSESSION GROUP BY sessionID ORDER BY sessio
nID
SELECT sessionID, count(*) FROM JUMP GROUP BY sessionID ORDER BY sessionID
SELECT sessionID, count(*) FROM JUMPRJ GROUP BY sessionID ORDER BY sessionID
SELECT sessionID, count(*) FROM RUN GROUP BY sessionID ORDER BY sessionID
SELECT sessionID, count(*) FROM RUNINTERVAL GROUP BY sessionID ORDER BY sessionI
D
SELECT sessionID, count(*) FROM REACTIONTIME GROUP BY sessionID ORDER BY session
ID
SELECT sessionID, count(*) FROM PULSE GROUP BY sessionID ORDER BY sessionID
1
SELECT * FROM session WHERE uniqueID == 1
SELECT person.* FROM person, personSession  WHERE personSession.sessionID == 1 A
ND person.uniqueID == personSession.personID  ORDER BY upper(person.name)
1
SELECT name, sex, dateborn, height, weight, description FROM person WHERE unique
ID == 1
CurrentPerson: id:1, name:Juanfer
SELECT name, sex, dateborn, height, weight, description FROM person WHERE unique
ID == 1
CurrentPerson: id:1, name:Juanfer
SELECT person.name, jump.*  FROM person, jump  WHERE person.uniqueID == jump.per
sonID AND jump.sessionID == 1 ORDER BY person.uniqueID, jump.uniqueID
SELECT person.name, jumpRj.*  FROM person, jumpRj  WHERE person.uniqueID == jump
Rj.personID AND jumpRj.sessionID == 1 ORDER BY person.uniqueID, jumpRj.uniqueID
SELECT person.name, run.*  FROM person, run  WHERE person.uniqueID == run.person
ID AND run.sessionID == 1 ORDER BY person.uniqueID, run.uniqueID
SELECT person.name, runInterval.*  FROM person, runInterval  WHERE person.unique
ID == runInterval.personID AND runInterval.sessionID == 1 ORDER BY person.unique
ID, runInterval.uniqueID
SELECT person.name, pulse.*  FROM person, pulse  WHERE person.uniqueID == pulse.
personID AND pulse.sessionID == 1 ORDER BY person.uniqueID, pulse.uniqueID
SELECT person.name, reactionTime.*  FROM person, reactionTime  WHERE person.uniq
ueID == reactionTime.personID AND reactionTime.sessionID == 1 ORDER BY person.un
iqueID, reactionTime.uniqueID
hide
SELECT * FROM session WHERE uniqueID == 1
----------FILLING treeview stats---------------
SELECT type, sessionID, AVG(tv)  FROM jump WHERE ( sessionID == 1)  GROUP BY typ
e, sessionID  ORDER BY type, sessionID
SELECT j1.sessionID, ( ( AVG(j1.tv) - AVG(j2.tv) )*100/AVG(j2.tv) ) AS myIndex
FROM jump AS j1, jump AS j2, person WHERE ( (j1.sessionID == 1 AND j2.sessionID
== 1))  AND j1.personID == person.uniqueID AND j2.personID == person.uniqueID AN
D j1.type == 'CMJ' AND j2.type == 'SJ' GROUP by j1.sessionID,  ORDER by j1.sessi
onID
no rows Clicking in stats/main.cs multi session
fakeButtonNoRowsSelected in statType.cs
SELECT j1.sessionID, ( ( AVG(j1.tv) - AVG(j2.tv) )*100/AVG(j2.tv) ) AS myIndex
FROM jump AS j1, jump AS j2, person WHERE ( (j1.sessionID == 1 AND j2.sessionID
== 1))  AND j1.personID == person.uniqueID AND j2.personID == person.uniqueID AN
D j1.type == 'ABK' AND j2.type == 'CMJ' GROUP by j1.sessionID,  ORDER by j1.sess
ionID
no rows Clicking in stats/main.cs multi session
fakeButtonNoRowsSelected in statType.cs
SELECT j1.sessionID,  ( AVG( 100*4.9* (j1.tv/2) * (j1.tv/2) ) )*100/AVG( 100*4.9
* (j2.tv/2) * (j2.tv/2) ) AS myIndex, AVG( 100*4.9* (j1.tv/2) * (j1.tv/2) ), AVG
( 100*4.9* (j2.tv/2) * (j2.tv/2) ) FROM jump AS j1, jump AS j2, person WHERE ( (
j1.sessionID == 1 AND j2.sessionID == 1))  AND j1.personID == person.uniqueID AN
D j2.personID == person.uniqueID AND j1.type == 'SJl' AND j2.type == 'SJ' GROUP
by j1.sessionID,  ORDER by j1.sessionID
no rows Clicking in stats/main.cs multi session
fakeButtonNoRowsSelected in statType.cs
SELECT *  FROM jumpType  WHERE startIn == 0  ORDER BY uniqueID
SELECT sessionID, type, AVG(100*((tv-tc)/tc)) FROM jump WHERE ( sessionID == 1)
 AND ( type == 'DJ' )  GROUP by sessionID, type  ORDER by type, sessionID
SELECT *  FROM jumpType  WHERE startIn == 0  ORDER BY uniqueID
SELECT sessionID, type, AVG(tv/tc) FROM jump WHERE ( sessionID == 1)  AND ( type
 == 'DJ' )  GROUP by sessionID, type  ORDER by type, sessionID
SELECT *  FROM jumpRjType  ORDER BY uniqueID
SELECT sessionID, type, AVG(100*((tvavg-tcavg)/tcavg)) FROM jumpRj WHERE ( sessi
onID == 1)  AND ( type == 'RJ(j)' OR  type == 'RJ(t)' OR  type == 'RJ(unlimited)
' OR  type == 'triple jump' )  GROUP by sessionID, type  ORDER by type, sessionI
D
SELECT *  FROM jumpRjType  ORDER BY uniqueID
SELECT sessionID, type, AVG(9.81*9.81 * tvavg*jumps * time / (4*jumps*(time - tv
avg*jumps)) ) FROM jumpRj WHERE ( sessionID == 1)  AND ( type == 'RJ(j)' OR  typ
e == 'RJ(t)' OR  type == 'RJ(unlimited)' OR  type == 'triple jump' )  GROUP by s
essionID, type  ORDER by type, sessionID
fakeButtonRowsSelected in statType.cs
fakeButtonRowsSelected in gui/stats.cs !!
----------FILLING treeview stats---------------
SELECT type, sessionID, AVG(tv)  FROM jump WHERE ( sessionID == 1)  GROUP BY typ
e, sessionID  ORDER BY type, sessionID
SELECT j1.sessionID, ( ( AVG(j1.tv) - AVG(j2.tv) )*100/AVG(j2.tv) ) AS myIndex
FROM jump AS j1, jump AS j2, person WHERE ( (j1.sessionID == 1 AND j2.sessionID
== 1))  AND j1.personID == person.uniqueID AND j2.personID == person.uniqueID AN
D j1.type == 'CMJ' AND j2.type == 'SJ' GROUP by j1.sessionID,  ORDER by j1.sessi
onID
no rows Clicking in stats/main.cs multi session
fakeButtonNoRowsSelected in statType.cs
SELECT j1.sessionID, ( ( AVG(j1.tv) - AVG(j2.tv) )*100/AVG(j2.tv) ) AS myIndex
FROM jump AS j1, jump AS j2, person WHERE ( (j1.sessionID == 1 AND j2.sessionID
== 1))  AND j1.personID == person.uniqueID AND j2.personID == person.uniqueID AN
D j1.type == 'ABK' AND j2.type == 'CMJ' GROUP by j1.sessionID,  ORDER by j1.sess
ionID
no rows Clicking in stats/main.cs multi session
fakeButtonNoRowsSelected in statType.cs
SELECT j1.sessionID,  ( AVG( 100*4.9* (j1.tv/2) * (j1.tv/2) ) )*100/AVG( 100*4.9
* (j2.tv/2) * (j2.tv/2) ) AS myIndex, AVG( 100*4.9* (j1.tv/2) * (j1.tv/2) ), AVG
( 100*4.9* (j2.tv/2) * (j2.tv/2) ) FROM jump AS j1, jump AS j2, person WHERE ( (
j1.sessionID == 1 AND j2.sessionID == 1))  AND j1.personID == person.uniqueID AN
D j2.personID == person.uniqueID AND j1.type == 'SJl' AND j2.type == 'SJ' GROUP
by j1.sessionID,  ORDER by j1.sessionID
no rows Clicking in stats/main.cs multi session
fakeButtonNoRowsSelected in statType.cs
SELECT *  FROM jumpType  WHERE startIn == 0  ORDER BY uniqueID
SELECT sessionID, type, AVG(100*((tv-tc)/tc)) FROM jump WHERE ( sessionID == 1)
 AND ( type == 'DJ' )  GROUP by sessionID, type  ORDER by type, sessionID
SELECT *  FROM jumpType  WHERE startIn == 0  ORDER BY uniqueID
SELECT sessionID, type, AVG(tv/tc) FROM jump WHERE ( sessionID == 1)  AND ( type
 == 'DJ' )  GROUP by sessionID, type  ORDER by type, sessionID
SELECT *  FROM jumpRjType  ORDER BY uniqueID
SELECT sessionID, type, AVG(100*((tvavg-tcavg)/tcavg)) FROM jumpRj WHERE ( sessi
onID == 1)  AND ( type == 'RJ(j)' OR  type == 'RJ(t)' OR  type == 'RJ(unlimited)
' OR  type == 'triple jump' )  GROUP by sessionID, type  ORDER by type, sessionI
D
SELECT *  FROM jumpRjType  ORDER BY uniqueID
SELECT sessionID, type, AVG(9.81*9.81 * tvavg*jumps * time / (4*jumps*(time - tv
avg*jumps)) ) FROM jumpRj WHERE ( sessionID == 1)  AND ( type == 'RJ(j)' OR  typ
e == 'RJ(t)' OR  type == 'RJ(unlimited)' OR  type == 'triple jump' )  GROUP by s
essionID, type  ORDER by type, sessionID
9:7:9
9:7:9
500x400+0+0
Exception in Gtk# callback delegate
  Note: Applications can use GLib.ExceptionManager.UnhandledException to handle
the exception.
System.DllNotFoundException: libgdk-x11-2.0.so.0
  at (wrapper managed-to-native) Gdk.Graphics:gdk_x11_drawable_get_xdisplay (int
ptr)
  at Gdk.Graphics.FromDrawable (Gdk.Drawable drawable) [0x00000]
  at NPlot.Gtk.PlotSurface2D.OnExposeEvent (Gdk.EventExpose args) [0x00000]
  at Gtk.Widget.exposeevent_cb (IntPtr widget, IntPtr evnt) [0x00000]
   at GLib.ExceptionManager.RaiseUnhandledException(System.Exception e, Boolean
is_terminal)
   at Gtk.Widget.exposeevent_cb(IntPtr widget, IntPtr evnt)
   at Gtk.Widget.exposeevent_cb(IntPtr , IntPtr )
   at Gtk.Application.gtk_main()
   at Gtk.Application.gtk_main()
   at Gtk.Application.Run()
   at ChronoJump..ctor(System.String[] args)
   at ChronoJump.Main(System.String[] args)

C:\chronojump>