Xavier, Si abro Chronojump con las librerías sqlitedll-3_4_0.zip, abro una sesión de saltos, en el menú selecciono "Vista / Ventana de estadística", me aparece la pantalla que adjunto en la imagen, y cuando pongo "Printar grafico" se cierra el programa y devuelve el error que adjunto en el .txt. Si abro Chronojump con las librerías sqlitedll-3_4_2.zip o sqlitedll-3_5_0.zip, apenas selecciono en el menú "Vista / Ventana de estadística" se cierra el programa, no llega a mostrar la pantalla de la imagen adjunta, y devuelve los errores de los .txt adjuntos. En Linux tampoco funciona. Apenas selecciono "Vista / Ventana de estadística" se cierra el programa. También adjunto .txt con el eror. Espero que se entienda mejor. Saludos Juanfer -----Mensaje original----- De: Xavi de Blas [mailto:xaviblas gmail com] Enviado el: Miércoles, 12 de Septiembre de 2007 06:55 a.m. Para: Juan Fernando Pardo CC: For Chronojump developers (english,spanish) Asunto: Re: RV: Estadisticas en Chronojump 0.6-pre6 Hola, no te entendí del todo: Los sqlite que hay en la web de sqlite.org son el 3.4.2 y el 3.5.0 http://www.sqlite.org/download.html Pero esto no debería tener relación con tu error, ya que según el archivo que me has indicado el error es de la parte gráfica, y no de la base de datos. Creo que el problema es de NPlot, que es la librería usada para los gráficos en las estadísticas. El otro día detecté que en windows, si el PATH hacia donde está el ejcutable (y por tanto también los NPlot) tiene algún acento o carácter no estándard, el programa no encuentra NPlot y falla. Quizás debería tratar de linkar NPlot de otra manera (incluirlo en el ejecutable como un assemblie, aunque no se si esto viola su licencia) Hay un bug sobre eso (mirar comentario 1 donde pone "windows chars") http://bugzilla.gnome.org/show_bug.cgi?id=473543 ¿Puedes comprobar lo del path? ¿Puedes mover la carpeta de chronojump a c:\ y mirar si falla también desde allá? ¿Puedes hacer pruebas que descarten que el fallo es del sqlite.dll? Saludos y gracias como siempre, el software se vuelve mucho más estable y funcional gracias a tu ayuda Saludos 2007/9/12, 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 > > >
Attachment:
Estadisticas.JPG
Description: JPEG image
Mono version 1.2.5 Build 5
Prepending 'C:\ARCHIV~1\MONO-1~1.5\bin' to PATH
C:\Documents and Settings\root>cd \chronojump
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:3436): 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>Mono version 1.2.5 Build 5
Prepending 'C:\ARCHIV~1\MONO-1~1.5\bin' to PATH
C:\Documents and Settings\root>cd \chronojump
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:3100): 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
Exception in Gtk# callback delegate
Note: Applications can use GLib.ExceptionManager.UnhandledException to handle
the exception.
Mono.Data.Sqlite.SqliteException: Sqlite error
near "ORDER": syntax error
at Mono.Data.Sqlite.Sqlite3.Prepare (System.String strSql, Mono.Data.Sqlite.Sq
liteStatement previous, System.String& strRemain) [0x00000]
at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x00000]
at GLib.ExceptionManager.RaiseUnhandledException(System.Exception e, Boolean
is_terminal)
at GLib.Signal.voidObjectCallback(IntPtr handle, IntPtr gch)
at GLib.Signal.voidObjectCallback(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>Mono version 1.2.5 Build 5
Prepending 'C:\ARCHIV~1\MONO-1~1.5\bin' to PATH
C:\Documents and Settings\root>cd \chronojump
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:2772): 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
Exception in Gtk# callback delegate
Note: Applications can use GLib.ExceptionManager.UnhandledException to handle
the exception.
Mono.Data.Sqlite.SqliteException: Sqlite error
near "ORDER": syntax error
at Mono.Data.Sqlite.Sqlite3.Prepare (System.String strSql, Mono.Data.Sqlite.Sq
liteStatement previous, System.String& strRemain) [0x00000]
at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x00000]
at GLib.ExceptionManager.RaiseUnhandledException(System.Exception e, Boolean
is_terminal)
at GLib.Signal.voidObjectCallback(IntPtr handle, IntPtr gch)
at GLib.Signal.voidObjectCallback(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>[root juanfer 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 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 sessionID 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 sessionID SELECT sessionID, count(*) FROM REACTIONTIME GROUP BY sessionID ORDER BY sessionID 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 AND person.uniqueID == personSession.personID ORDER BY upper(person.name) 1 SELECT name, sex, dateborn, height, weight, description FROM person WHERE uniqueID == 1 CurrentPerson: id:1, name:Juanfer SELECT name, sex, dateborn, height, weight, description FROM person WHERE uniqueID == 1 CurrentPerson: id:1, name:Juanfer SELECT person.name, jump.* FROM person, jump WHERE person.uniqueID == jump.personID AND jump.sessionID == 1 ORDER BY person.uniqueID, jump.uniqueID SELECT person.name, jumpRj.* FROM person, jumpRj WHERE person.uniqueID == jumpRj.personID AND jumpRj.sessionID == 1 ORDER BY person.uniqueID, jumpRj.uniqueID SELECT person.name, run.* FROM person, run WHERE person.uniqueID == run.personID AND run.sessionID == 1 ORDER BY person.uniqueID, run.uniqueID SELECT person.name, runInterval.* FROM person, runInterval WHERE person.uniqueID == runInterval.personID AND runInterval.sessionID == 1 ORDER BY person.uniqueID, 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.uniqueID == reactionTime.personID AND reactionTime.sessionID == 1 ORDER BY person.uniqueID, reactionTime.uniqueID hide SELECT * FROM session WHERE uniqueID == 1 ----------FILLING treeview stats--------------- SELECT type, sessionID, AVG(tv) FROM jump WHERE ( sessionID == 1) GROUP BY type, 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 AND j1.type == 'CMJ' AND j2.type == 'SJ' GROUP by j1.sessionID, ORDER by j1.sessionID Unhandled Exception: Mono.Data.Sqlite.SqliteException: Sqlite error near "ORDER": syntax error at Mono.Data.Sqlite.Sqlite3.Prepare (System.String strSql, Mono.Data.Sqlite.SqliteStatement previous, System.String& strRemain) [0x00000] at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x00000] [root juanfer chronojump]#