Estadisticas en Chronojump 0.6-pre6

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

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

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:2640): 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>