masterpatje commented 2 years ago

Describe the bug No League Data shown after download of data. First data is downloaded via the preferred "F11 method" menu as indicated in the first image. But when I check the League Data tab no data is shown (second image).

In #1412 I reported that the loop of importing league data never ends. This might be connected to this bug.

To Reproduce Steps to reproduce the behavior:

Download data using F11 data download menu
Check "old league data" to be included in the download
Click Download
After download finishes check Data League tab
Click on 'refresh arrows' [note: I do this because no league data is shown]
It loops without ending.

Screenshots

Platform information:

OS: Windows 10
Version 6.0 DEV (r250)

Additional context I also had this problem in HO 5.2. I did a clean install with that version, prior to updating to 6.0. In 3.0 functionality of data download worked. Leagues 56 untill 69 are shown.

wsbrenk commented 2 years ago

@masterpatje did you try to select some of the listed seasons like this:

masterpatje commented 2 years ago

Below are screenshots using this method. I got the same result no league data.

wsbrenk commented 2 years ago

could you please check if there are some errors in your log file (%APPDATA%/HO/logs)

masterpatje commented 2 years ago

=====Error log on 21-03-2021 [Fatal Error] :1:1: Premature end of file.

======HO-2021-02-23 log -Today I again tried to download data and included season 69- 14:43:46 [Info] core.HO: VERSION: 6.0 versionType: DEV RevisionNumber: 250 14:43:51 [Info] core.model.HOVerwaltung: language used for interface is: Nederlands 14:43:52 [Info] core.training.TrainingWeekManager: Next week training date: 2022-03-25 01:05:00 14:43:52 [Info] core.gui.HOMainFrame: This is HO! version 6.0 DEV (r250), have fun! 14:43:52 [Info] core.gui.HOMainFrame: Operating system found: Windows 10 on amd64 (10.0) 14:43:52 [Info] core.gui.HOMainFrame: Using java: 17.0.1 (Eclipse Adoptium) 14:44:14 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) Statement: INSERT INTO TOURNAMENTDETAILS (TOURNAMENTID, NAME, TOURNAMENTTYPE, SEASON, LOGOURL, TROPHYTYPE, NUMBEROFTEAMS, NUMBEROFGROUPS, LASTMATCHROUND, FIRSTMATCHROUNDDATE, NEXTMATCHROUNDDATE, ISMATCHESONGOING, CREATOR_USERID, CREATOR_LOGINNAME) VALUES (3686714, 'Division Battle', 10, 8, null, 97, 280, 62, 10, 2022-01-07 17:00:00.0, 2022-03-11 17:00:00.0, false, 0, null) java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.TournamentDetailsTable.storeTournamentDetails(TournamentDetailsTable.java:123) at core.db.DBManager.storeTournamentDetailsIntoDB(DBManager.java:829) at core.file.xml.XMLMatchesParser.createMatches(XMLMatchesParser.java:95) at core.file.xml.XMLMatchesParser.parseMatchesFromString(XMLMatchesParser.java:30) at core.file.xml.ConvertXml2Hrf.createHrf(ConvertXml2Hrf.java:197) at core.net.OnlineWorker.getHrf(OnlineWorker.java:79) at core.net.DownloadDialog.startDownload(DownloadDialog.java:305) at core.net.DownloadDialog.actionPerformed(DownloadDialog.java:96) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: unexpected token: 17 required: ) at org.hsqldb.error.Error.parseError(Unknown Source) at org.hsqldb.ParserBase.unexpectedTokenRequire(Unknown Source) at org.hsqldb.ParserBase.readThis(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpressionWithContext(Unknown Source) at org.hsqldb.ParserDQL.readRow(Unknown Source) at org.hsqldb.ParserDQL.XreadContextuallyTypedTable(Unknown Source) at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 47 more

14:44:14 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) Statement: INSERT INTO TOURNAMENTDETAILS (TOURNAMENTID, NAME, TOURNAMENTTYPE, SEASON, LOGOURL, TROPHYTYPE, NUMBEROFTEAMS, NUMBEROFGROUPS, LASTMATCHROUND, FIRSTMATCHROUNDDATE, NEXTMATCHROUNDDATE, ISMATCHESONGOING, CREATOR_USERID, CREATOR_LOGINNAME) VALUES (3686714, 'Division Battle', 10, 8, null, 97, 280, 62, 10, 2022-01-07 17:00:00.0, 2022-03-11 17:00:00.0, false, 0, null) java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.TournamentDetailsTable.storeTournamentDetails(TournamentDetailsTable.java:123) at core.db.DBManager.storeTournamentDetailsIntoDB(DBManager.java:829) at core.file.xml.XMLMatchesParser.createMatches(XMLMatchesParser.java:95) at core.file.xml.XMLMatchesParser.parseMatchesFromString(XMLMatchesParser.java:30) at core.file.xml.ConvertXml2Hrf.createHrf(ConvertXml2Hrf.java:197) at core.net.OnlineWorker.getHrf(OnlineWorker.java:79) at core.net.DownloadDialog.startDownload(DownloadDialog.java:305) at core.net.DownloadDialog.actionPerformed(DownloadDialog.java:96) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: unexpected token: 17 required: ) at org.hsqldb.error.Error.parseError(Unknown Source) at org.hsqldb.ParserBase.unexpectedTokenRequire(Unknown Source) at org.hsqldb.ParserBase.readThis(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpressionWithContext(Unknown Source) at org.hsqldb.ParserDQL.readRow(Unknown Source) at org.hsqldb.ParserDQL.XreadContextuallyTypedTable(Unknown Source) at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 47 more

14:44:17 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) Statement: INSERT INTO TOURNAMENTDETAILS (TOURNAMENTID, NAME, TOURNAMENTTYPE, SEASON, LOGOURL, TROPHYTYPE, NUMBEROFTEAMS, NUMBEROFGROUPS, LASTMATCHROUND, FIRSTMATCHROUNDDATE, NEXTMATCHROUNDDATE, ISMATCHESONGOING, CREATOR_USERID, CREATOR_LOGINNAME) VALUES (3686714, 'Division Battle', 10, 8, null, 97, 280, 62, 10, 2022-01-07 17:00:00.0, 2022-03-11 17:00:00.0, false, 0, null) java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.TournamentDetailsTable.storeTournamentDetails(TournamentDetailsTable.java:123) at core.db.DBManager.storeTournamentDetailsIntoDB(DBManager.java:829) at core.file.xml.XMLMatchesParser.createMatches(XMLMatchesParser.java:95) at core.file.xml.XMLMatchesParser.parseMatchesFromString(XMLMatchesParser.java:30) at core.net.OnlineWorker.getMatches(OnlineWorker.java:550) at core.net.DownloadDialog.startDownload(DownloadDialog.java:320) at core.net.DownloadDialog.actionPerformed(DownloadDialog.java:96) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: unexpected token: 17 required: ) at org.hsqldb.error.Error.parseError(Unknown Source) at org.hsqldb.ParserBase.unexpectedTokenRequire(Unknown Source) at org.hsqldb.ParserBase.readThis(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpressionWithContext(Unknown Source) at org.hsqldb.ParserDQL.readRow(Unknown Source) at org.hsqldb.ParserDQL.XreadContextuallyTypedTable(Unknown Source) at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 46 more

14:44:21 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLDataException: data exception: invalid datetime format Statement: INSERT INTO SPIELPLAN ( LigaID , LigaName , Saison, FetchDate ) VALUES(2226,'IV.11',69,'core.util.HODateTime@75ef2874' ) java.sql.SQLDataException: data exception: invalid datetime format at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.SpielplanTable.storeSpielplan(SpielplanTable.java:185) at core.db.DBManager.storeSpielplan(DBManager.java:654) at core.model.HOModel.saveFixtures(HOModel.java:588) at core.net.DownloadDialog.startDownload(DownloadDialog.java:392) at core.net.DownloadDialog.actionPerformed(DownloadDialog.java:96) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: data exception: invalid datetime format at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.types.DateTimeType.convertToDatetimeSpecial(Unknown Source) at org.hsqldb.types.DateTimeType.convertToType(Unknown Source) at org.hsqldb.ExpressionOp.getConvertExpression(Unknown Source) at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 44 more

14:44:21 [Info] core.training.TrainingWeekManager: Next week training date: 2022-03-25 01:05:00 14:45:17 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: unknown token: Statement: (%APPDATA%/HO/logs) java.sql.SQLSyntaxErrorException: unknown token: at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.frontend.SQLDialog.refresh(SQLDialog.java:189) at core.db.frontend.SQLDialog.actionPerformed(SQLDialog.java:264) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: unknown token: at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ParserBase.read(Unknown Source) at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source) at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source) at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source) at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 41 more

14:45:22 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: unknown token: Statement: %APPDATA%/HO/logs java.sql.SQLSyntaxErrorException: unknown token: at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.frontend.SQLDialog.refresh(SQLDialog.java:189) at core.db.frontend.SQLDialog.actionPerformed(SQLDialog.java:264) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: unknown token: at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ParserBase.read(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 41 more

=======Output log (date 23-03-2022) [Info] HO: VERSION: 6.0 versionType: DEV RevisionNumber: 250 [Debug] DBUpdater: Update to 600 complete but this is a development version so DBVersion will remain unchanged [Info] HOVerwaltung: language used for interface is: Nederlands [Debug] DBConfigUpdater: Updating configuration to version 5.0 ... [Info] TrainingWeekManager: Next week training date: 2022-03-25 01:05:00 [Info] HOMainFrame: This is HO! version 6.0 DEV (r250), have fun! [Info] HOMainFrame: Operating system found: Windows 10 on amd64 (10.0) [Info] HOMainFrame: Using java: 17.0.1 (Eclipse Adoptium) [Debug] FileLoader: File will not be searched anymore: /prediction\predictionTypes.conf [Debug] RatingPredictionManager: Rebuilding RPM cache! [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Error] JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) Statement: INSERT INTO TOURNAMENTDETAILS (TOURNAMENTID, NAME, TOURNAMENTTYPE, SEASON, LOGOURL, TROPHYTYPE, NUMBEROFTEAMS, NUMBEROFGROUPS, LASTMATCHROUND, FIRSTMATCHROUNDDATE, NEXTMATCHROUNDDATE, ISMATCHESONGOING, CREATOR_USERID, CREATOR_LOGINNAME) VALUES (3686714, 'Division Battle', 10, 8, null, 97, 280, 62, 10, 2022-01-07 17:00:00.0, 2022-03-11 17:00:00.0, false, 0, null) java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.TournamentDetailsTable.storeTournamentDetails(TournamentDetailsTable.java:123) at core.db.DBManager.storeTournamentDetailsIntoDB(DBManager.java:829) at core.file.xml.XMLMatchesParser.createMatches(XMLMatchesParser.java:95) at core.file.xml.XMLMatchesParser.parseMatchesFromString(XMLMatchesParser.java:30) at core.file.xml.ConvertXml2Hrf.createHrf(ConvertXml2Hrf.java:197) at core.net.OnlineWorker.getHrf(OnlineWorker.java:79) at core.net.DownloadDialog.startDownload(DownloadDialog.java:305) at core.net.DownloadDialog.actionPerformed(DownloadDialog.java:96) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: unexpected token: 17 required: ) at org.hsqldb.error.Error.parseError(Unknown Source) at org.hsqldb.ParserBase.unexpectedTokenRequire(Unknown Source) at org.hsqldb.ParserBase.readThis(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpressionWithContext(Unknown Source) at org.hsqldb.ParserDQL.readRow(Unknown Source) at org.hsqldb.ParserDQL.XreadContextuallyTypedTable(Unknown Source) at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 47 more

[Error] JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) Statement: INSERT INTO TOURNAMENTDETAILS (TOURNAMENTID, NAME, TOURNAMENTTYPE, SEASON, LOGOURL, TROPHYTYPE, NUMBEROFTEAMS, NUMBEROFGROUPS, LASTMATCHROUND, FIRSTMATCHROUNDDATE, NEXTMATCHROUNDDATE, ISMATCHESONGOING, CREATOR_USERID, CREATOR_LOGINNAME) VALUES (3686714, 'Division Battle', 10, 8, null, 97, 280, 62, 10, 2022-01-07 17:00:00.0, 2022-03-11 17:00:00.0, false, 0, null) java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.TournamentDetailsTable.storeTournamentDetails(TournamentDetailsTable.java:123) at core.db.DBManager.storeTournamentDetailsIntoDB(DBManager.java:829) at core.file.xml.XMLMatchesParser.createMatches(XMLMatchesParser.java:95) at core.file.xml.XMLMatchesParser.parseMatchesFromString(XMLMatchesParser.java:30) at core.file.xml.ConvertXml2Hrf.createHrf(ConvertXml2Hrf.java:197) at core.net.OnlineWorker.getHrf(OnlineWorker.java:79) at core.net.DownloadDialog.startDownload(DownloadDialog.java:305) at core.net.DownloadDialog.actionPerformed(DownloadDialog.java:96) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: unexpected token: 17 required: ) at org.hsqldb.error.Error.parseError(Unknown Source) at org.hsqldb.ParserBase.unexpectedTokenRequire(Unknown Source) at org.hsqldb.ParserBase.readThis(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpressionWithContext(Unknown Source) at org.hsqldb.ParserDQL.readRow(Unknown Source) at org.hsqldb.ParserDQL.XreadContextuallyTypedTable(Unknown Source) at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 47 more

[Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Error] JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) Statement: INSERT INTO TOURNAMENTDETAILS (TOURNAMENTID, NAME, TOURNAMENTTYPE, SEASON, LOGOURL, TROPHYTYPE, NUMBEROFTEAMS, NUMBEROFGROUPS, LASTMATCHROUND, FIRSTMATCHROUNDDATE, NEXTMATCHROUNDDATE, ISMATCHESONGOING, CREATOR_USERID, CREATOR_LOGINNAME) VALUES (3686714, 'Division Battle', 10, 8, null, 97, 280, 62, 10, 2022-01-07 17:00:00.0, 2022-03-11 17:00:00.0, false, 0, null) java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.TournamentDetailsTable.storeTournamentDetails(TournamentDetailsTable.java:123) at core.db.DBManager.storeTournamentDetailsIntoDB(DBManager.java:829) at core.file.xml.XMLMatchesParser.createMatches(XMLMatchesParser.java:95) at core.file.xml.XMLMatchesParser.parseMatchesFromString(XMLMatchesParser.java:30) at core.net.OnlineWorker.getMatches(OnlineWorker.java:550) at core.net.DownloadDialog.startDownload(DownloadDialog.java:320) at core.net.DownloadDialog.actionPerformed(DownloadDialog.java:96) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: unexpected token: 17 required: ) at org.hsqldb.error.Error.parseError(Unknown Source) at org.hsqldb.ParserBase.unexpectedTokenRequire(Unknown Source) at org.hsqldb.ParserBase.readThis(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpressionWithContext(Unknown Source) at org.hsqldb.ParserDQL.readRow(Unknown Source) at org.hsqldb.ParserDQL.XreadContextuallyTypedTable(Unknown Source) at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 46 more

[Error] JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) Statement: INSERT INTO TOURNAMENTDETAILS (TOURNAMENTID, NAME, TOURNAMENTTYPE, SEASON, LOGOURL, TROPHYTYPE, NUMBEROFTEAMS, NUMBEROFGROUPS, LASTMATCHROUND, FIRSTMATCHROUNDDATE, NEXTMATCHROUNDDATE, ISMATCHESONGOING, CREATOR_USERID, CREATOR_LOGINNAME) VALUES (3686714, 'Division Battle', 10, 8, null, 97, 280, 62, 10, 2022-01-07 17:00:00.0, 2022-03-11 17:00:00.0, false, 0, null) java.sql.SQLSyntaxErrorException: unexpected token: 17 required: ) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.TournamentDetailsTable.storeTournamentDetails(TournamentDetailsTable.java:123) at core.db.DBManager.storeTournamentDetailsIntoDB(DBManager.java:829) at core.file.xml.XMLMatchesParser.createMatches(XMLMatchesParser.java:95) at core.file.xml.XMLMatchesParser.parseMatchesFromString(XMLMatchesParser.java:30) at core.net.OnlineWorker.getMatches(OnlineWorker.java:550) at core.net.DownloadDialog.startDownload(DownloadDialog.java:320) at core.net.DownloadDialog.actionPerformed(DownloadDialog.java:96) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: unexpected token: 17 required: ) at org.hsqldb.error.Error.parseError(Unknown Source) at org.hsqldb.ParserBase.unexpectedTokenRequire(Unknown Source) at org.hsqldb.ParserBase.readThis(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source) at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpression(Unknown Source) at org.hsqldb.ParserDQL.XreadValueExpressionWithContext(Unknown Source) at org.hsqldb.ParserDQL.readRow(Unknown Source) at org.hsqldb.ParserDQL.XreadContextuallyTypedTable(Unknown Source) at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 46 more

[Debug] OnlineWorker: Get Lineup : 690594140 [Error] JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLDataException: data exception: invalid datetime format Statement: INSERT INTO SPIELPLAN ( LigaID , LigaName , Saison, FetchDate ) VALUES(2226,'IV.11',69,'core.util.HODateTime@75ef2874' ) java.sql.SQLDataException: data exception: invalid datetime format at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.SpielplanTable.storeSpielplan(SpielplanTable.java:185) at core.db.DBManager.storeSpielplan(DBManager.java:654) at core.model.HOModel.saveFixtures(HOModel.java:588) at core.net.DownloadDialog.startDownload(DownloadDialog.java:392) at core.net.DownloadDialog.actionPerformed(DownloadDialog.java:96) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: data exception: invalid datetime format at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.types.DateTimeType.convertToDatetimeSpecial(Unknown Source) at org.hsqldb.types.DateTimeType.convertToType(Unknown Source) at org.hsqldb.ExpressionOp.getConvertExpression(Unknown Source) at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 44 more

[Info] TrainingWeekManager: Next week training date: 2022-03-25 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Error] JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: unknown token: Statement: (%APPDATA%/HO/logs) java.sql.SQLSyntaxErrorException: unknown token: at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.frontend.SQLDialog.refresh(SQLDialog.java:189) at core.db.frontend.SQLDialog.actionPerformed(SQLDialog.java:264) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: unknown token: at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ParserBase.read(Unknown Source) at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source) at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source) at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source) at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source) at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 41 more

[Error] JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: unknown token: Statement: %APPDATA%/HO/logs java.sql.SQLSyntaxErrorException: unknown token: at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source) at core.db.JDBCAdapter.executeUpdate(JDBCAdapter.java:90) at core.db.frontend.SQLDialog.refresh(SQLDialog.java:189) at core.db.frontend.SQLDialog.actionPerformed(SQLDialog.java:264) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2313) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279) at java.desktop/java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:297) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6626) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3389) at java.desktop/java.awt.Component.processEvent(Component.java:6391) at java.desktop/java.awt.Container.processEvent(Container.java:2266) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5001) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4833) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:773) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:97) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:746) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:744) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:743) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: org.hsqldb.HsqlException: unknown token: at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ParserBase.read(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 41 more

[Info] LeaguePromotionHandler: Status of league: 14 : {"status_code": 1, "status_desc": "NOT_AVAILABLE", "nbBlocks": 14, "nbBlocksReady": 0, "nbBlocksInProgress": 0}

masterpatje commented 2 years ago

I don't know if I should share the log file in the comments? So please let me know how to provide you the information?

Please note the latest line in output log, referencing to LeaguePromotionHandler and text "not available". Do you consider this related to the problem I am having or is it referencing to another module? (see line below) [Info] LeaguePromotionHandler: Status of league: 14 : {"status_code": 1, "status_desc": "NOT_AVAILABLE", "nbBlocks": 14, "nbBlocksReady": 0, "nbBlocksInProgress": 0}

wsbrenk commented 2 years ago

@masterpatje thanks for the log info - it is helpful.

and yes the not available is related to your other ticket.

wsbrenk commented 2 years ago

the new version should fix the errors in the logs - i'm not sure if they are responsible for your empty series panel

masterpatje commented 2 years ago

Yes, in build 6.0.253 the issue is fixed! Now league data is shown (!)

There are still 2 (minor) bugs that I encountered, that might be related to each other:

I selected season 68 and 69 league data to be included in the download
it processed one part, the orange bar showed a 50% complete rate, and then I got the message "waiting..." and it stayed that way
at some time I decide to just click League data menu, now both season 68 and 69 are shown, but the error message "promotion league data not shown" was still there: (image 1) -- I closed the application and again went to the League Data menu
clicking the red download icon again resulted in a loop that did not finish (image 2)

HO-2022-03-26 and output.log are included below: HO-2022-03-26.log output.log

masterpatje commented 2 years ago

I tried to again download the data including all season data:
Again "please wait...." and orange bar 50% complete (I made a screenshot this time, image 2)

going to the League Data tab did not show additional seasons (besides season 68 and 69) that were downloaded before (see last comment)
closing application and again going to League Data tab gave the same results, no additional seasons are added

Again bith logs are included HO-2022-03-26.log output.log

masterpatje commented 2 years ago

I also did a test by fully de-installing the application and manually deleting the files in the Roaming data HO folder located under AppData/Roaming/HO. [Note: I added a feature request for the optional choice to delete all data when uninstalling] (#1420)

When I tried to download and include all seasonal data by checking Old League Data box, but not specifying which seasons to included. I again got the please wait... 50% orange bar. This time no League Data is shown (steps are the same as in previous comment screenshots).

I included the LOG files below, they are completely different from last output: error.log HO-2022-03-26.log output.log

PS. Next TEST; I will again to a fresh install by manually deleting all AppData/Roaming/HO files and now I will only select season 69 to see what the results are and will post the results in the next comment.

masterpatje commented 2 years ago

NEW TEST: Full uninstall and only downloading Team Data

uninstalling HO
deleting AppData/Roaming/HO folder
installing HO_6.0.253 (DEV+JRE 64 bit)
downloading data (excluding previous matched and excluding League data)

Again "please wait..." and 50% orange completion bar

Because this time I did not included old matched or old league data, this might be a different bug (!) I am not sure if this was already in build 250. It might have been, but I might just close and open the application again and then it is gone.

New Test - second download Second download with only Season 69 data checked. Again when it was processing the data I got the same "please wait..." message and 50% orange completion bar. League Data season 69 was shown. Closing and opening the application and the message is gone.

I am 99% sure this error was not in the 250 build, so this potentially is a new bug introduced by a newer build. I will post the output. NOTE this is the output directly after the SECOND download (!):

_[Info] HO: VERSION: 6.0 versionType: DEV RevisionNumber: 253 [Debug] DBUpdater: No DB update necessary. [Info] HOVerwaltung: language used for interface is: Nederlands [Info] TrainingWeekManager: Next week training date: 2022-04-01 01:05:00 [Info] HOMainFrame: This is HO! version 6.0 DEV (r253), have fun! [Info] HOMainFrame: Operating system found: Windows 10 on amd64 (10.0) [Info] HOMainFrame: Using java: 17.0.1 (Eclipse Adoptium) [Debug] FileLoader: File will not be searched anymore: /prediction\predictionTypes.conf [Debug] RatingPredictionManager: Rebuilding RPM cache! [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] OnlineWorker: Get Lineup : 690730964 [Debug] OnlineWorker: Get Lineup : 690787141 [Info] TrainingWeekManager: Next week training date: 2022-04-01 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Error] TeamsLogoTable: logo information not available in database for team ID=206241 [Error] ThemeManager: logo not found for team 206241 [Error] TeamsLogoTable: logo information not available in database for team ID=1009780 [Error] ThemeManager: logo not found for team 1009780 [Error] TeamsLogoTable: logo information not available in database for team ID=1322134 [Error] ThemeManager: logo not found for team 1322134 [Info] LeaguePromotionHandler: Status of league: 14 : {"status_code": 1, "status_desc": "NOTAVAILABLE", "nbBlocks": 14, "nbBlocksReady": 0, "nbBlocksInProgress": 0}

masterpatje commented 2 years ago

TEST [32 bit version and downloading all but league data]:

Again message "Please wait..." and orange 50% completion bar. Not finishing.....

After closing application, I directly looked at the log files, so that the errors are shown: Hopefully this helps...

HO-2022-03-26 17:23:36 [Info] core.HO: VERSION: 6.0 versionType: DEV RevisionNumber: 253 17:23:44 [Info] core.model.HOVerwaltung: language used for interface is: Nederlands 17:23:45 [Error] core.db.XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty 17:23:45 [Error] core.db.XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty 17:23:45 [Error] core.db.XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty 17:23:45 [Info] core.gui.HOMainFrame: This is HO! version 6.0 DEV (r253), have fun! 17:23:45 [Info] core.gui.HOMainFrame: Operating system found: Windows 10 on x86 (10.0) 17:23:45 [Info] core.gui.HOMainFrame: Using java: 17.0.1 (Eclipse Adoptium) 17:23:45 [Error] core.db.XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty 17:23:46 [Error] core.db.XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty 17:23:46 [Error] core.gui.comp.table.TableSorter: java.lang.NullPointerException: Cannot invoke "core.gui.comp.entry.ColorLabelEntry.getText()" because the return value of "core.gui.comp.table.TableSorter.getValueAt(int, int)" is null 17:23:46 [Error] core.gui.comp.table.TableSorter: core.gui.comp.table.TableSorter.getSpieler(TableSorter.java:161) 17:23:46 [Error] core.gui.comp.table.TableSorter: module.playerOverview.PlayerDetailsPanel.setPlayer(PlayerDetailsPanel.java:120) 17:23:46 [Error] core.gui.comp.table.TableSorter: module.playerOverview.PlayerDetailsPanel.refresh(PlayerDetailsPanel.java:183) 17:23:46 [Error] core.gui.comp.table.TableSorter: core.gui.RefreshManager.doRefresh(RefreshManager.java:69) 17:23:46 [Error] core.gui.comp.table.TableSorter: core.gui.HOMainFrame.(HOMainFrame.java:155) 17:23:46 [Error] core.gui.comp.table.TableSorter: core.gui.HOMainFrame.instance(HOMainFrame.java:213) 17:23:46 [Error] core.gui.comp.table.TableSorter: core.HO.lambda$main$2(HO.java:212) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:318) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:771) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.base/java.security.AccessController.doPrivileged(AccessController.java:399) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:741) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) 17:23:46 [Error] core.gui.comp.table.TableSorter: java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) 17:23:46 [Warning] module.lineup.Lineup: no match to determine location 17:23:46 [Error] core.db.XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty 17:23:46 [Error] core.db.XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty 17:24:46 [Info] core.gui.theme.ThemeManager: Donwloading player's avatar: 1/24 .. I deleted rows.. 17:25:21 [Info] core.gui.theme.ThemeManager: Donwloading player's avatar: 24/24 17:26:16 [Info] core.training.TrainingWeekManager: Next week training date: 2022-04-01 01:05:00 17:31:25 [Info] core.gui.HOMainFrame$1: shutting down HO... 17:31:26 [Info] core.gui.HOMainFrame: Shutdown complete! isAppTerminated: true 17:31:26 [Info] core.gui.HOMainFrame$1: exiting...

Output log [Info] HO: users.json file not found => a new one will be created [Info] HO: VERSION: 6.0 versionType: DEV RevisionNumber: 253 [Info] HOVerwaltung: language used for interface is: Nederlands [Error] XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty [Error] XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty [Error] XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty [Info] HOMainFrame: This is HO! version 6.0 DEV (r253), have fun! [Info] HOMainFrame: Operating system found: Windows 10 on x86 (10.0) [Info] HOMainFrame: Using java: 17.0.1 (Eclipse Adoptium) [Error] XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty [Debug] FileLoader: File will not be searched anymore: /prediction\predictionTypes.conf [Error] XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty [Debug] RatingPredictionManager: Rebuilding RPM cache! [Error] TableSorter: java.lang.NullPointerException: Cannot invoke "core.gui.comp.entry.ColorLabelEntry.getText()" because the return value of "core.gui.comp.table.TableSorter.getValueAt(int, int)" is null [Error] TableSorter: core.gui.comp.table.TableSorter.getSpieler(TableSorter.java:161) [Error] TableSorter: module.playerOverview.PlayerDetailsPanel.setPlayer(PlayerDetailsPanel.java:120) [Error] TableSorter: module.playerOverview.PlayerDetailsPanel.refresh(PlayerDetailsPanel.java:183) [Error] TableSorter: core.gui.RefreshManager.doRefresh(RefreshManager.java:69) [Error] TableSorter: core.gui.HOMainFrame.(HOMainFrame.java:155) [Error] TableSorter: core.gui.HOMainFrame.instance(HOMainFrame.java:213) [Error] TableSorter: core.HO.lambda$main$2(HO.java:212) [Error] TableSorter: java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:318) [Error] TableSorter: java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:771) [Error] TableSorter: java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) [Error] TableSorter: java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) [Error] TableSorter: java.base/java.security.AccessController.doPrivileged(AccessController.java:399) [Error] TableSorter: java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) [Error] TableSorter: java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:741) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) [Warning] Lineup: no match to determine location [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Error] XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty [Error] XtraDataTable: Error while loading XtraData model: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty [Info] ThemeManager: Donwloading player's avatar: 1/24 .. I deleted rows.. [Info] ThemeManager: Donwloading player's avatar: 24/24 [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] OnlineWorker: Get Lineup : 688688809 [Debug] OnlineWorker: Get Lineup : 690345180 [Debug] OnlineWorker: Get Lineup : 24754890 [Debug] OnlineWorker: Get Lineup : 688688813 [Debug] OnlineWorker: Get Lineup : 690461455 [Debug] OnlineWorker: Get Lineup : 24794119 [Debug] OnlineWorker: Get Lineup : 688688816 [Debug] OnlineWorker: Get Lineup : 690536315 [Debug] OnlineWorker: Get Lineup : 688688822 [Debug] OnlineWorker: Get Lineup : 690594140 [Debug] OnlineWorker: Get Lineup : 690730964 [Debug] OnlineWorker: Get Lineup : 690787141 [Info] TrainingWeekManager: Next week training date: 2022-04-01 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Info] : shutting down HO... [Debug] HOMainFrame: Shutting down HO! [Debug] HOMainFrame: UserParameters saved [Debug] HOMainFrame: ScoutList saved [Debug] HOMainFrame: FormulaFactors saved [Debug] HOMainFrame: Module configurations saved [Debug] HOMainFrame: Disconnected [Info] HOMainFrame: Shutdown complete! isAppTerminated: true [Info] : exiting...

wsbrenk commented 2 years ago

@masterpatje thanks again for that report.

i hope now, that you can start from scratch without errors.

masterpatje commented 2 years ago

Thanks a lot for build v254.

I downloaded all data (but unchecked league data, see image)
It seemed to work properly, there were no problems, Yeah!
output files still gave some errors (see comments below, I thought it was still good to share it with you)
when I re-open (close then open) the application, the output log doesn't have any errors anymore, so maybe it is irrelevant

TO DO: Now I will check by doing a second download (with previous League Data).

Output file: [Info] HO: users.json file not found => a new one will be created [Info] HO: VERSION: 6.0 versionType: DEV RevisionNumber: 254 [Info] HOVerwaltung: language used for interface is: Nederlands [Info] HOMainFrame: This is HO! version 6.0 DEV (r254), have fun! [Info] HOMainFrame: Operating system found: Windows 10 on amd64 (10.0) [Info] HOMainFrame: Using java: 17.0.1 (Eclipse Adoptium) [Debug] FileLoader: File will not be searched anymore: /prediction\predictionTypes.conf [Debug] RatingPredictionManager: Rebuilding RPM cache! [Error] TableSorter: java.lang.NullPointerException: Cannot invoke "core.gui.comp.entry.ColorLabelEntry.getText()" because the return value of "core.gui.comp.table.TableSorter.getValueAt(int, int)" is null [Error] TableSorter: core.gui.comp.table.TableSorter.getSpieler(TableSorter.java:160) [Error] TableSorter: module.playerOverview.PlayerDetailsPanel.setPlayer(PlayerDetailsPanel.java:120) [Error] TableSorter: module.playerOverview.PlayerDetailsPanel.refresh(PlayerDetailsPanel.java:183) [Error] TableSorter: core.gui.RefreshManager.doRefresh(RefreshManager.java:69) [Error] TableSorter: core.gui.HOMainFrame.(HOMainFrame.java:155) [Error] TableSorter: core.gui.HOMainFrame.instance(HOMainFrame.java:213) [Error] TableSorter: core.HO.lambda$main$2(HO.java:212) [Error] TableSorter: java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:318) [Error] TableSorter: java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:771) [Error] TableSorter: java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) [Error] TableSorter: java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) [Error] TableSorter: java.base/java.security.AccessController.doPrivileged(AccessController.java:399) [Error] TableSorter: java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) [Error] TableSorter: java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:741) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) [Warning] Lineup: no match to determine location [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Info] ThemeManager: Donwloading player's avatar: 1/24 ..I deleted rows [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized ..I deleted rows [Warning] HOVerwaltung: getLanguageString: 'ls.update_status.fixtures' not found! [Warning] HOVerwaltung: getLanguageString: 'ls.update_status.calc_subskills' not found! [Info] TrainingWeekManager: Next week training date: 2022-04-01 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called

masterpatje commented 2 years ago

Downloading League Data - Season 63 till 69 (see image 1)
All was working well, yeah!
Again errors in the output log, but causing no problems (see comments below, for feedback purpose)
League Data Season 63-39 is available (see image 2), but now there is a new bug. It shows the history from a certain division (2226) and not the historic data from my team.
In the seasons 66-65-64-63 I was in a different league (see image 3 for expected result from HO 3.0)

H.O. 6.0.254 result

H.O. 3.0 result

Output file

[Info] HO: VERSION: 6.0 versionType: DEV RevisionNumber: 254 [Debug] DBUpdater: No DB update necessary. [Info] HOVerwaltung: language used for interface is: Nederlands [Info] TrainingWeekManager: Next week training date: 2022-04-01 01:05:00 [Info] HOMainFrame: This is HO! version 6.0 DEV (r254), have fun! [Info] HOMainFrame: Operating system found: Windows 10 on amd64 (10.0) [Info] HOMainFrame: Using java: 17.0.1 (Eclipse Adoptium) [Debug] FileLoader: File will not be searched anymore: /prediction\predictionTypes.conf [Debug] RatingPredictionManager: Rebuilding RPM cache! [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Warning] HOVerwaltung: getLanguageString: 'ls.update_status.fixtures' not found! [Warning] HOVerwaltung: getLanguageString: 'ls.update_status.fixtures' not found! [Warning] HOVerwaltung: getLanguageString: 'ls.update_status.calc_subskills' not found! [Info] TrainingWeekManager: Next week training date: 2022-04-01 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Error] TeamsLogoTable: logo information not available in database for team ID=206241 [Error] ThemeManager: logo not found for team 206241 [Error] TeamsLogoTable: logo information not available in database for team ID=1009780 [Error] ThemeManager: logo not found for team 1009780 [Error] TeamsLogoTable: logo information not available in database for team ID=1322134 [Error] ThemeManager: logo not found for team 1322134 [Info] LeaguePromotionHandler: Status of league: 14 : {"status_code": 1, "status_desc": "NOT_AVAILABLE", "nbBlocks": 14, "nbBlocksReady": 0, "nbBlocksInProgress": 0} [Error] TeamsLogoTable: logo information not available in database for team ID=146165 [Error] ThemeManager: logo not found for team 146165 [Error] TeamsLogoTable: logo information not available in database for team ID=502240 [Error] ThemeManager: logo not found for team 502240 [Error] TeamsLogoTable: logo information not available in database for team ID=367501 [Error] ThemeManager: logo not found for team 367501 [Error] TeamsLogoTable: logo information not available in database for team ID=212722 [Error] ThemeManager: logo not found for team 212722 [Error] TeamsLogoTable: logo information not available in database for team ID=146391 [Error] ThemeManager: logo not found for team 146391 [Error] TeamsLogoTable: logo information not available in database for team ID=505975 [Error] ThemeManager: logo not found for team 505975 [Error] TeamsLogoTable: logo information not available in database for team ID=147517 [Error] ThemeManager: logo not found for team 147517 [Error] TeamsLogoTable: logo information not available in database for team ID=1228881 [Error] ThemeManager: logo not found for team 1228881 [Error] TeamsLogoTable: logo information not available in database for team ID=366391 [Error] ThemeManager: logo not found for team 366391 [Error] TeamsLogoTable: logo information not available in database for team ID=212722 [Error] ThemeManager: logo not found for team 212722 [Error] TeamsLogoTable: logo information not available in database for team ID=367501 [Error] ThemeManager: logo not found for team 367501 [Error] TeamsLogoTable: logo information not available in database for team ID=146391 [Error] ThemeManager: logo not found for team 146391 [Error] TeamsLogoTable: logo information not available in database for team ID=146165 [Error] ThemeManager: logo not found for team 146165 [Error] TeamsLogoTable: logo information not available in database for team ID=502240 [Error] ThemeManager: logo not found for team 502240 [Error] TeamsLogoTable: logo information not available in database for team ID=1321520 [Error] ThemeManager: logo not found for team 1321520 [Error] TeamsLogoTable: logo information not available in database for team ID=763774 [Error] ThemeManager: logo not found for team 763774 [Error] TeamsLogoTable: logo information not available in database for team ID=1322134 [Error] ThemeManager: logo not found for team 1322134 [Error] TeamsLogoTable: logo information not available in database for team ID=506686 [Error] ThemeManager: logo not found for team 506686 [Error] TeamsLogoTable: logo information not available in database for team ID=208661 [Error] ThemeManager: logo not found for team 208661 [Error] TeamsLogoTable: logo information not available in database for team ID=151185 [Error] ThemeManager: logo not found for team 151185 [Error] TeamsLogoTable: logo information not available in database for team ID=1322134 [Error] ThemeManager: logo not found for team 1322134 [Error] TeamsLogoTable: logo information not available in database for team ID=766384 [Error] ThemeManager: logo not found for team 766384 [Error] TeamsLogoTable: logo information not available in database for team ID=212332 [Error] ThemeManager: logo not found for team 212332 [Error] TeamsLogoTable: logo information not available in database for team ID=502240 [Error] ThemeManager: logo not found for team 502240 [Error] TeamsLogoTable: logo information not available in database for team ID=212332 [Error] ThemeManager: logo not found for team 212332 [Error] TeamsLogoTable: logo information not available in database for team ID=1281344 [Error] ThemeManager: logo not found for team 1281344 [Error] TeamsLogoTable: logo information not available in database for team ID=212722 [Error] ThemeManager: logo not found for team 212722 [Error] TeamsLogoTable: logo information not available in database for team ID=1363727 [Error] ThemeManager: logo not found for team 1363727

wsbrenk commented 2 years ago

@masterpatje i will see if i could get the leagues of your team from ancient series

masterpatje commented 2 years ago

Thanks @wsbrenk . And also for fixing previous bugs. Really great work.

Please tell me if you want me to test something specific. I will do so and give you the results.

I think that this button below (image) is still not working, but maybe better if I put it in a different bug thread, because it is not connected to the Download function were No League Data was shown. Please let me know if you want me to open a new one.

wsbrenk commented 2 years ago

until now, i never had a look on this part of the organizer. i fear this function might be broken.

wsbrenk commented 2 years ago

matchdetails file contains info about league:

MatchContextId : [unsigned Integer] This will be either LeagueLevelUnitId (for League), CupId (Cup, Hattrick Masters, World Cup and U-20 World Cup), LadderId, TournamentId, or 0 for friendly, qualification, single matches and preparation matches.

masterpatje commented 2 years ago

I might have a different idea. I have older .hrf files. Would it be possible to extract Old League Data from it?

For example. When doing a fresh install you can choose either to first import older files before downloading latest .hrf

Otherwise manually entering league numbers is maybe the easiest (less user friendly) solution, but for sure will do the trick.

wsbrenk commented 2 years ago

@masterpatje download of old leagues should now fetch the correct league id by default.

masterpatje commented 2 years ago

v6.0.258.0 downloaded First test: fresh install and using the "Old League Data" option Result: download succesfully completed, no League Data shown

download succesfully completed

Result output log: [Info] HO: VERSION: 6.0 versionType: DEV RevisionNumber: 258 [Error] JDBCAdapter: JDBCAdapter.connect : Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@aedcaef2[file =C:\Use [Info] HOMainFrame: This is HO! version 6.0 DEV (r258), have fun! [Info] HOMainFrame: Operating system found: Windows 10 on amd64 (10.0) [Info] HOMainFrame: Using java: 17.0.1 (Eclipse Adoptium) [Debug] FileLoader: File will not be searched anymore: /prediction\predictionTypes.conf [Debug] RatingPredictionManager: Rebuilding RPM cache! [Error] TableSorter: java.lang.NullPointerException: Cannot invoke "core.gui.comp.entry.ColorLabelEntry.getText()" because the return value of "core.gui.comp.table.TableSorter.getValueAt(int, int)" is null [Error] TableSorter: core.gui.comp.table.TableSorter.getSpieler(TableSorter.java:160) [Error] TableSorter: module.playerOverview.PlayerDetailsPanel.setPlayer(PlayerDetailsPanel.java:120) [Error] TableSorter: module.playerOverview.PlayerDetailsPanel.refresh(PlayerDetailsPanel.java:183) [Error] TableSorter: core.gui.RefreshManager.doRefresh(RefreshManager.java:69) [Error] TableSorter: core.gui.HOMainFrame.(HOMainFrame.java:155) [Error] TableSorter: core.gui.HOMainFrame.instance(HOMainFrame.java:213) [Error] TableSorter: core.HO.lambda$main$2(HO.java:212) [Error] TableSorter: java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:318) [Error] TableSorter: java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:771) [Error] TableSorter: java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) [Error] TableSorter: java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) [Error] TableSorter: java.base/java.security.AccessController.doPrivileged(AccessController.java:399) [Error] TableSorter: java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) [Error] TableSorter: java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:741) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) [Error] TableSorter: java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) [Warning] Lineup: no match to determine location [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Info] ThemeManager: Donwloading player's avatar: 1/26 deleted some rows [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] OnlineWorker: Get Lineup : 688688813 [Debug] OnlineWorker: Get Lineup : 690461455 [Debug] OnlineWorker: Get Lineup : 24794119 [Debug] OnlineWorker: Get Lineup : 688688816 [Debug] OnlineWorker: Get Lineup : 690536315 [Debug] OnlineWorker: Get Lineup : 688688822 [Debug] OnlineWorker: Get Lineup : 690594140 [Debug] OnlineWorker: Get Lineup : 690730964 [Debug] OnlineWorker: Get Lineup : 690787141 [Debug] OnlineWorker: Get Lineup : 690946633 [Debug] OnlineWorker: Get Lineup : 691022449 [Warning] HOVerwaltung: getLanguageString: 'ls.update_status.fixtures' not found! [Warning] HOVerwaltung: getLanguageString: 'ls.update_status.calc_subskills' not found! [Info] TrainingWeekManager: Next week training date: 2022-04-08 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called

Note: When I don't select "Old League Data" (screenshot below) I get the same output file. It seems like the check box itself doesn't do anything on the initial download.

masterpatje commented 2 years ago

v6.0.258.0 downloaded Second test: building on first download, again downloading Old League Data 1) fresh install as commented above and closing application 2) again downloading data using "Old League Data" option

Result: Correct Old League Data. Yes!!; you got it working.

..

Output file gives errors: (don't know if it is relevant, because application was not giving any errors) [Info] HO: VERSION: 6.0 versionType: DEV RevisionNumber: 258 [Debug] DBUpdater: No DB update necessary. [Info] HOVerwaltung: language used for interface is: Nederlands [Info] TrainingWeekManager: Next week training date: 2022-04-08 01:05:00 [Info] HOMainFrame: This is HO! version 6.0 DEV (r258), have fun! [Info] HOMainFrame: Operating system found: Windows 10 on amd64 (10.0) [Info] HOMainFrame: Using java: 17.0.1 (Eclipse Adoptium) [Debug] FileLoader: File will not be searched anymore: /prediction\predictionTypes.conf [Debug] RatingPredictionManager: Rebuilding RPM cache! [Error] MyConnector: Failed to select a proxy java.io.IOException: Failed to select a proxy at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1234) at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1128) at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:175) at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.connect(HttpsURLConnectionImpl.java:142) at com.github.scribejava.core.httpclient.jdk.JDKHttpClient.doExecute(JDKHttpClient.java:138) at com.github.scribejava.core.httpclient.jdk.JDKHttpClient.execute(JDKHttpClient.java:94) at com.github.scribejava.core.oauth.OAuthService.execute(OAuthService.java:114) at core.net.MyConnector.getNonCHPPWebFile(MyConnector.java:764) at core.net.MyConnector.getFileFromWeb(MyConnector.java:649) at tool.updater.UpdateHelper.download(UpdateHelper.java:26) at core.db.TeamsLogoTable.getTeamLogoFileName(TeamsLogoTable.java:87) at core.db.DBManager.getTeamLogoFileName(DBManager.java:2624) at core.gui.theme.ThemeManager.getClubLogo(ThemeManager.java:191) at core.gui.theme.ThemeManager.getClubLogo(ThemeManager.java:186) at module.lineup.lineup.MatchBanner.refresh(MatchBanner.java:188) at core.gui.RefreshManager.doRefresh(RefreshManager.java:69) at core.gui.HOMainFrame.(HOMainFrame.java:155) at core.gui.HOMainFrame.instance(HOMainFrame.java:213) at core.HO.lambda$main$2(HO.java:212) at java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:318) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:771) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:722) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:716) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:741) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90) Caused by: java.lang.IllegalArgumentException: protocol = https host = null at java.base/sun.net.spi.DefaultProxySelector.select(DefaultProxySelector.java:186) at java.base/sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1232) ... 31 more

[Debug] UpdateHelper: Error downloading from 'https:http://res.hattrick.org/teamlogo/21/207/2069/2068706/2068706.png': java.lang.NullPointerException: Cannot invoke "java.io.InputStream.read()" because "in" is null [Error] TeamsLogoTable: error when trying to download logo of team ID: 2068706 https:http://res.hattrick.org/teamlogo/21/207/2069/2068706/2068706.png [Error] ThemeManager: logo not found for team 2068706 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] OnlineWorker: Get Lineup : 690946633 [Debug] OnlineWorker: Get Lineup : 691022449 [Warning] HOVerwaltung: getLanguageString: 'ls.update_status.fixtures' not found! [Warning] HOVerwaltung: getLanguageString: 'ls.update_status.calc_subskills' not found! [Info] TrainingWeekManager: Next week training date: 2022-04-08 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Error] TeamsLogoTable: logo information not available in database for team ID=206241 [Error] ThemeManager: logo not found for team 206241 [Error] TeamsLogoTable: logo information not available in database for team ID=1009780 [Error] ThemeManager: logo not found for team 1009780 [Error] TeamsLogoTable: logo information not available in database for team ID=1322134 [Error] ThemeManager: logo not found for team 1322134 [Error] TeamsLogoTable: logo information not available in database for team ID=210035 [Error] ThemeManager: logo not found for team 210035 [Error] TeamsLogoTable: logo information not available in database for team ID=208958 [Error] ThemeManager: logo not found for team 208958 [Error] TeamsLogoTable: logo information not available in database for team ID=366873 [Error] ThemeManager: logo not found for team 366873 [Error] TeamsLogoTable: logo information not available in database for team ID=21174 [Error] ThemeManager: logo not found for team 21174 [Error] TeamsLogoTable: logo information not available in database for team ID=818182 [Error] ThemeManager: logo not found for team 818182 [Error] TeamsLogoTable: logo information not available in database for team ID=769768 [Error] ThemeManager: logo not found for team 769768 [Error] TeamsLogoTable: logo information not available in database for team ID=147631 [Error] ThemeManager: logo not found for team 147631 [Error] TeamsLogoTable: logo information not available in database for team ID=1363408 [Error] ThemeManager: logo not found for team 1363408 [Error] TeamsLogoTable: logo information not available in database for team ID=208958 [Error] ThemeManager: logo not found for team 208958 [Error] TeamsLogoTable: logo information not available in database for team ID=366873 [Error] ThemeManager: logo not found for team 366873 [Error] TeamsLogoTable: logo information not available in database for team ID=21174 [Error] ThemeManager: logo not found for team 21174 [Error] TeamsLogoTable: logo information not available in database for team ID=818182 [Error] ThemeManager: logo not found for team 818182 [Error] TeamsLogoTable: logo information not available in database for team ID=769768 [Error] ThemeManager: logo not found for team 769768 [Error] TeamsLogoTable: logo information not available in database for team ID=147631 [Error] ThemeManager: logo not found for team 147631 [Error] TeamsLogoTable: logo information not available in database for team ID=1363408 [Error] ThemeManager: logo not found for team 1363408 [Info] : shutting down HO... [Debug] HOMainFrame: Shutting down HO! [Debug] HOMainFrame: UserParameters saved [Debug] HOMainFrame: ScoutList saved [Debug] HOMainFrame: FormulaFactors saved [Debug] HOMainFrame: Module configurations saved [Debug] HOMainFrame: Disconnected [Info] HOMainFrame: Shutdown complete! isAppTerminated: true [Info] : exiting...

masterpatje commented 2 years ago

Conclusion from above tests:

Fixed: Yes, you fixed the problem of downloading incorrect leagues shown when downloading Old League Data.
Bug 1: You can't download "Old League Data" on the initial build (first download). It needs to be done on the second download.
Bug 2: on the fresh install, the "Old League Data" checkbox doesn't do anything.
Feature 1: Instead of manually selecting the correct league by hand one by a time with the pop-up screens and selecting the seasons one at a time by selecting "actual division" (see screenshot below). It would be nice to download "all actual divisions" by default, no pop-up screens and automate it (user friendly). [The pop-ups one at a time can be optional if you would manually want to add a certain league instead.]
Feature 2: It would be nice if you check the checkbox for "Old League Data" to by default include all previous seasons. This would also fix bug 1.
Last note/compliment: Feature below is great, you included the Old League Data league divisions in the download menu (see below), so that you can see which seasons are already downloaded. Well done:
Other cool thing in your code, that you can only include the seasons that you actually played. I could go back untill season 12. That is a long time ago! So apparently your code could detect the starting season. That is really nice.

wsbrenk commented 2 years ago

@masterpatje thank you very much for great test report.

concerning bug 1: i fear this is intentional. there is no information about team's leagues and corresponding season before the initial download succeeded. next commit will disable this download option on initial download.
concerning bug 2: that's right - will be disabled now
concerning feature 1: good idea
concerning feature 2: the download of old series is needed only one time, since the data is stored in the database. downloading them with each download would be to heavy

masterpatje commented 2 years ago

@wsbrenk good idea that you are disabling it (bug 2). That will make clear that you can't download Old League Data on the first download. Request: For clarification purposes include a message that the option to download Old League Data is available after the first download is completed.

Festure/Bug 3: On the initial download also the "League Data tab" stays empty (see image below). Maybe you can include the Current League Data from the initial download? This will look nicer for people that want to use Hattrick Organizer for the first time. Otherwise it is confusing that League Data tab is empty.

masterpatje commented 2 years ago

wsbrink: "concerning feature 2: the download of old series is needed only one time, since the data is stored in the database. downloading them with each download would be to heavy"

Referencing to "Feature 2: It would be nice if you check the checkbox for "Old League Data" to by default include all previous seasons. This would also fix bug 1."

I think that I explained myself incorrectly. What I meant is that when selecting the checkbox "Old League Data" you automatically include all previous seasons by default. As you said it is used only one time, only when you want to download previous seasons. So in this way it is not included in every download (would not make sense), but I would suggest downloading all seasons by default only when checking the box below, that was my suggestion.

I'm interested if you could reflect on it.

wsbrenk commented 2 years ago

@masterpatje at the moment hattrick has not yet determined the current fixtures of the upcoming season. i hope that users starting next week will see their fixtures

masterpatje commented 2 years ago

Oke I will do a fresh install next week and check if after 1st week of the league, after I played the first match, that League Data it is available. The league is however already determined, but this data is not included in the .hrf downloadable data?

wsbrenk commented 2 years ago

@masterpatje the teams are already there, but not the fixtures.

masterpatje commented 2 years ago

Oke did some testwork (v261):

fixed: disabling the "old league data" checkbox on the initial download / first build
fixed: a lot of error notifications from the output log (there are now only warnings and debug info left)

[Info] HO: users.json file not found => a new one will be created [Info] HO: VERSION: 6.0 versionType: DEV RevisionNumber: 261 [Info] HOVerwaltung: language used for interface is: Nederlands [Info] HOMainFrame: This is HO! version 6.0 DEV (r261), have fun! [Info] HOMainFrame: Operating system found: Windows 10 on amd64 (10.0) [Info] HOMainFrame: Using java: 17.0.1 (Eclipse Adoptium) [Debug] FileLoader: File will not be searched anymore: /prediction\predictionTypes.conf [Debug] RatingPredictionManager: Rebuilding RPM cache! [Warning] Lineup: no match to determine location [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called [Info] ThemeManager: Donwloading player's avatar: 1/26 removed lines [Debug] TrainingManager: HOVerwaltung model changed => TrainingManager and TrainingWeekManager are reinitialized [Debug] OnlineWorker: Get Lineup : 690461455 [Debug] OnlineWorker: Get Lineup : 24794119 [Debug] OnlineWorker: Get Lineup : 688688816 [Debug] OnlineWorker: Get Lineup : 690536315 [Debug] OnlineWorker: Get Lineup : 688688822 [Debug] OnlineWorker: Get Lineup : 690594140 [Debug] OnlineWorker: Get Lineup : 690730964 [Debug] OnlineWorker: Get Lineup : 690787141 [Debug] OnlineWorker: Get Lineup : 690946633 [Debug] OnlineWorker: Get Lineup : 691022449 [Debug] OnlineWorker: Get Lineup : 694456449 [Debug] OnlineWorker: Get Lineup : 694456454 [Debug] TeamsLogoTable: storeTeamLogoInfo: logo URI was null for team 365613 [Debug] OnlineWorker: Get Lineup : 694456459 [Debug] OnlineWorker: Get Lineup : 694456462 [Debug] OnlineWorker: Get Lineup : 694456467 [Debug] OnlineWorker: Get Lineup : 694456470 [Debug] OnlineWorker: Get Lineup : 694456471 [Debug] OnlineWorker: Get Lineup : 694456479 [Debug] OnlineWorker: Get Lineup : 694456482 [Debug] OnlineWorker: Get Lineup : 694456485 [Debug] OnlineWorker: Get Lineup : 694456491 [Debug] OnlineWorker: Get Lineup : 694456494 [Debug] OnlineWorker: Get Lineup : 694456499 [Debug] TeamsLogoTable: storeTeamLogoInfo: logo URI was null for team 365613 [Debug] OnlineWorker: Get Lineup : 694456505 [Info] TrainingWeekManager: Next week training date: 2022-04-08 01:05:00 [Debug] LineupRatingAssistantPanel: refresh() has been called [Debug] LineupPositionsPanel: refresh() has been called
note: when I close the application and restart I get the following errors in the log: 09:15:19 [Error] core.db.TeamsLogoTable: logo information not available in database for team ID=-58231560 09:15:19 [Error] core.gui.theme.ThemeManager: logo not found for team -58231560 09:15:21 [Error] core.db.TeamsLogoTable: logo information not available in database for team ID=-58231560 09:15:21 [Error] core.gui.theme.ThemeManager: logo not found for team -58231560
not fixed: "League data" tab stays empty on initial download (fixtures are available now) I think this is because I did not yet play a match as indicated in the output log "[Warning] Lineup: no match to determine location" I created a feature request #1435 so that it can be seperated from the fixed one.

Lastly I created the bug/feature request #1434 the checkbox "old league data" for functionally to include all seasons.

masterpatje commented 2 years ago

1413 is tested and works. So consider this one done aka fixed.

New bug and feature request following this one are created under #1434 and #1435

ho-dev / HattrickOrganizer

[BUG] Download F11 Old League Data, No Data Shown on League Data Tab #1413

1413 is tested and works. So consider this one done aka fixed.