Closed masterpatje closed 2 years ago
wsbrenk
commented
2 years ago @masterpatje i can not reproduce this.
could you please check with sql editor if this 3 columns were created in table SPIELER
if only the first is created, the upgrade procedure was interrupted!?
masterpatje
commented
2 years ago Downloaded 7.0 v318 Still got those errors. And when I opened the SQL editor I didn't see those specific columns. Made some screen shots for you:
wsbrenk
commented
2 years ago changed log level of db update.
@masterpatje could you please check if your HO7 shows error logs on start (db update)?
masterpatje
commented
2 years ago I think that there were no errors other then the output in the comments and unsure if there are errors in the error log (not from what I have seen). But in order to verify I need to again install HO7. Meaning de-install HO6 again. That is bit tedious, and the reason for a feature request #1535 to be able to do a standalone installation. #1535
If you see no other option I will check it and do the installation of HO7 to check and be sure.
wsbrenk
commented
2 years ago there were no errors - that's correct, since the log level of upgrade exception was LOG and not ERROR, what it should be.
i will try to find a description of portable installation.
wsbrenk
commented
2 years ago https://ho.readthedocs.io/en/latest/installing_ho.html there you find some words concerning portable installation. Please try to download for example HO-7.0.320.0-portable-win-DEV-JRE.zip and extract it. tbh myself didn't try it for a long time - hope it will still work without problems.
masterpatje
commented
2 years ago Portable file is corrupt. When I downloaded it, it appears to be empty. Although 65MB file size.
wsbrenk
commented
2 years ago @masterpatje please try another zip program - preferably 7zip
masterpatje
commented
2 years ago Yes 7-zip worked:
Error still exists, but only in the output log.
21:03:49 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE
Statement: INSERT INTO SPIELER ( GelbeKarten , SpielerID , ArrivalDate, FirstName , NickName, LastName , Age , AgeDays , Kondition , Form , Torwart , Verteidigung , Spielaufbau , Fluegel , Torschuss , Passpiel , Standards , SubTorwart , SubVerteidigung , SubSpielaufbau , SubFluegel , SubTorschuss , SubPasspiel , SubStandards , OffsetTorwart , OffsetVerteidigung , OffsetSpielaufbau , OffsetFluegel , OffsetTorschuss , OffsetPasspiel , OffsetStandards , iSpezialitaet , iCharakter , iAnsehen , iAgressivitaet , Fuehrung , Erfahrung , Gehalt , Bonus , Land , Marktwert , Verletzt , ToreFreund , ToreLiga , TorePokal , GoalsCurrentTeam , ToreGesamt , Hattrick , Bewertung , TrainerTyp, Trainer, HRF_ID, Datum, PlayerNumber, TransferListed, Caps, CapsU20, TrainingBlock, Loyalty, HomeGrown, SubExperience, NationalTeamID, LastMatchDate, LastMatchRating, LastMatchId, LAST_MATCH_TYPE, LastMatch_PositionCode, LastMatch_PlayedMinutes, LastMatch_RatingEndOfGame, Statement, OwnerNotes, PlayerCategory ) VALUES(0,434040548,'2019-06-30 12:18:00','Jarne','','Clarebout',31,33,6,7,15,12,3,3,1,8,16,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0,0,0,0,0,0,0,1,2,2,6,11,182880,20,38,48830,-1,0,0,0,1,2,0,13,-1,0,0,'2022-06-24 10:57:55.0',1,0,0,0,false,20,false,0.0,0,'2022-06-22 17:25:00',13,696240852,0,-1,0,0,'', '', 0)
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE
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.SpielerTable.saveSpieler(SpielerTable.java:213)
at core.db.SpielerTable.saveSpieler(SpielerTable.java:228)
at core.db.DBManager.saveSpieler(DBManager.java:562)
at core.model.HOModel.saveHRF(HOModel.java:578)
at core.file.hrf.HRFImport.
21:03:49 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE
Statement: INSERT INTO SPIELER ( GelbeKarten , SpielerID , ArrivalDate, FirstName , NickName, LastName , Age , AgeDays , Kondition , Form , Torwart , Verteidigung , Spielaufbau , Fluegel , Torschuss , Passpiel , Standards , SubTorwart , SubVerteidigung , SubSpielaufbau , SubFluegel , SubTorschuss , SubPasspiel , SubStandards , OffsetTorwart , OffsetVerteidigung , OffsetSpielaufbau , OffsetFluegel , OffsetTorschuss , OffsetPasspiel , OffsetStandards , iSpezialitaet , iCharakter , iAnsehen , iAgressivitaet , Fuehrung , Erfahrung , Gehalt , Bonus , Land , Marktwert , Verletzt , ToreFreund , ToreLiga , TorePokal , GoalsCurrentTeam , ToreGesamt , Hattrick , Bewertung , TrainerTyp, Trainer, HRF_ID, Datum, PlayerNumber, TransferListed, Caps, CapsU20, TrainingBlock, Loyalty, HomeGrown, SubExperience, NationalTeamID, LastMatchDate, LastMatchRating, LastMatchId, LAST_MATCH_TYPE, LastMatch_PositionCode, LastMatch_PlayedMinutes, LastMatch_RatingEndOfGame, Statement, OwnerNotes, PlayerCategory ) VALUES(2,443473562,'2021-05-08 19:39:00','Daniele','','Ferrua',27,61,7,8,1,15,6,7,4,4,16,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0,0,0,0,0,0,2,4,2,2,3,8,226680,20,4,79080,-1,0,3,1,14,33,1,0,-1,0,0,'2022-06-24 10:57:55.0',2,0,0,0,false,20,false,0.0,0,'2022-06-19 20:00:00',16,694456491,1,-1,0,0,'', '', 0)
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE
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.SpielerTable.saveSpieler(SpielerTable.java:213)
at core.db.SpielerTable.saveSpieler(SpielerTable.java:228)
at core.db.DBManager.saveSpieler(DBManager.java:562)
at core.model.HOModel.saveHRF(HOModel.java:578)
at core.file.hrf.HRFImport.
21:03:49 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE
Statement: INSERT INTO SPIELER ( GelbeKarten , SpielerID , ArrivalDate, FirstName , NickName, LastName , Age , AgeDays , Kondition , Form , Torwart , Verteidigung , Spielaufbau , Fluegel , Torschuss , Passpiel , Standards , SubTorwart , SubVerteidigung , SubSpielaufbau , SubFluegel , SubTorschuss , SubPasspiel , SubStandards , OffsetTorwart , OffsetVerteidigung , OffsetSpielaufbau , OffsetFluegel , OffsetTorschuss , OffsetPasspiel , OffsetStandards , iSpezialitaet , iCharakter , iAnsehen , iAgressivitaet , Fuehrung , Erfahrung , Gehalt , Bonus , Land , Marktwert , Verletzt , ToreFreund , ToreLiga , TorePokal , GoalsCurrentTeam , ToreGesamt , Hattrick , Bewertung , TrainerTyp, Trainer, HRF_ID, Datum, PlayerNumber, TransferListed, Caps, CapsU20, TrainingBlock, Loyalty, HomeGrown, SubExperience, NationalTeamID, LastMatchDate, LastMatchRating, LastMatchId, LAST_MATCH_TYPE, LastMatch_PositionCode, LastMatch_PlayedMinutes, LastMatch_RatingEndOfGame, Statement, OwnerNotes, PlayerCategory ) VALUES(1,429284820,'2017-08-13 10:31:00','Folkert','','van Keeken',33,9,6,4,1,15,13,7,3,12,16,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0,0,0,0,0,0,0,2,0,1,5,13,162400,20,12,57120,-1,0,1,0,61,62,2,0,-1,0,0,'2022-06-24 10:57:55.0',3,0,0,0,false,20,true,0.0,0,'2022-06-19 20:00:00',14,694456491,1,-1,0,0,'D6 30-12-2012', '', 0)
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE
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.SpielerTable.saveSpieler(SpielerTable.java:213)
at core.db.SpielerTable.saveSpieler(SpielerTable.java:228)
at core.db.DBManager.saveSpieler(DBManager.java:562)
at core.model.HOModel.saveHRF(HOModel.java:578)
at core.file.hrf.HRFImport.
wsbrenk
commented
2 years ago @masterpatje very strange- could you please check the first lines of your output log. should show this:
[Debug] DBUpdater: Update to 700 complete but this is a development version so DBVersion will remain unchangedJust tested version 7.0.334. Error is fixed.
Describe the bug Lots of errors in the output.log
To Reproduce Steps to reproduce the behavior:
Platform information:
Additional context 23:21:30 [Info] core.HO: VERSION: 7.0 versionType: DEV RevisionNumber: 311 23:21:34 [Info] core.model.HOVerwaltung: language used for interface is: English 23:21:36 [Info] core.gui.HOMainFrame: This is HO! version 7.0 DEV (r311), have fun! 23:21:36 [Info] core.gui.HOMainFrame: Operating system found: Windows 10 on amd64 (10.0) 23:21:36 [Info] core.gui.HOMainFrame: Using java: 17.0.3 (Eclipse Adoptium) 23:22:33 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE Statement: INSERT INTO SPIELER ( GelbeKarten , SpielerID , ArrivalDate, FirstName , NickName, LastName , Age , AgeDays , Kondition , Form , Torwart , Verteidigung , Spielaufbau , Fluegel , Torschuss , Passpiel , Standards , SubTorwart , SubVerteidigung , SubSpielaufbau , SubFluegel , SubTorschuss , SubPasspiel , SubStandards , OffsetTorwart , OffsetVerteidigung , OffsetSpielaufbau , OffsetFluegel , OffsetTorschuss , OffsetPasspiel , OffsetStandards , iSpezialitaet , iCharakter , iAnsehen , iAgressivitaet , Fuehrung , Erfahrung , Gehalt , Bonus , Land , Marktwert , Verletzt , ToreFreund , ToreLiga , TorePokal , GoalsCurrentTeam , ToreGesamt , Hattrick , Bewertung , TrainerTyp, Trainer, HRF_ID, Datum, PlayerNumber, TransferListed, Caps, CapsU20, TrainingBlock, Loyalty, HomeGrown, SubExperience, NationalTeamID, LastMatchDate, LastMatchRating, LastMatchId, LAST_MATCH_TYPE, LastMatch_PositionCode, LastMatch_PlayedMinutes, LastMatch_RatingEndOfGame, Statement, OwnerNotes, PlayerCategory ) VALUES(0,434040548,'2019-06-30 12:18:00','Jarne','','Clarebout',31,20,6,7,15,12,3,2,1,8,16,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0,0,0,0,0,0,0,1,2,2,6,11,182880,20,38,48280,-1,0,0,0,1,2,0,0,-1,0,0,'2022-06-11 23:22:16.0',1,0,0,0,false,20,false,0.0,0,'2022-06-05 20:00:00',17,694456482,0,100,93,13,'', '', 0) java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE 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.SpielerTable.saveSpieler(SpielerTable.java:213) at core.db.SpielerTable.saveSpieler(SpielerTable.java:228) at core.db.DBManager.saveSpieler(DBManager.java:573) at core.model.HOModel.saveHRF(HOModel.java:578) at core.net.OnlineWorker.getHrf(OnlineWorker.java:114) at core.net.DownloadDialog.startDownload(DownloadDialog.java:309) 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: user lacks privilege or object not found: LASTMATCH_POSITIONCODE at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ParserDQL.readSimpleColumnName(Unknown Source) at org.hsqldb.ParserDQL.readSimpleColumnNames(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
23:22:33 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE Statement: INSERT INTO SPIELER ( GelbeKarten , SpielerID , ArrivalDate, FirstName , NickName, LastName , Age , AgeDays , Kondition , Form , Torwart , Verteidigung , Spielaufbau , Fluegel , Torschuss , Passpiel , Standards , SubTorwart , SubVerteidigung , SubSpielaufbau , SubFluegel , SubTorschuss , SubPasspiel , SubStandards , OffsetTorwart , OffsetVerteidigung , OffsetSpielaufbau , OffsetFluegel , OffsetTorschuss , OffsetPasspiel , OffsetStandards , iSpezialitaet , iCharakter , iAnsehen , iAgressivitaet , Fuehrung , Erfahrung , Gehalt , Bonus , Land , Marktwert , Verletzt , ToreFreund , ToreLiga , TorePokal , GoalsCurrentTeam , ToreGesamt , Hattrick , Bewertung , TrainerTyp, Trainer, HRF_ID, Datum, PlayerNumber, TransferListed, Caps, CapsU20, TrainingBlock, Loyalty, HomeGrown, SubExperience, NationalTeamID, LastMatchDate, LastMatchRating, LastMatchId, LAST_MATCH_TYPE, LastMatch_PositionCode, LastMatch_PlayedMinutes, LastMatch_RatingEndOfGame, Statement, OwnerNotes, PlayerCategory ) VALUES(1,443473562,'2021-05-08 19:39:00','Daniele','','Ferrua',27,48,7,7,1,15,6,7,4,4,16,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0,0,0,0,0,0,2,4,2,2,3,8,226680,20,4,74160,-1,0,2,1,13,32,1,0,-1,0,0,'2022-06-11 23:22:16.0',2,0,0,0,false,20,false,0.0,0,'2022-06-05 20:00:00',15,694456482,0,105,93,13,'', '', 0) java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE 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.SpielerTable.saveSpieler(SpielerTable.java:213) at core.db.SpielerTable.saveSpieler(SpielerTable.java:228) at core.db.DBManager.saveSpieler(DBManager.java:573) at core.model.HOModel.saveHRF(HOModel.java:578) at core.net.OnlineWorker.getHrf(OnlineWorker.java:114) at core.net.DownloadDialog.startDownload(DownloadDialog.java:309) 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: user lacks privilege or object not found: LASTMATCH_POSITIONCODE at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ParserDQL.readSimpleColumnName(Unknown Source) at org.hsqldb.ParserDQL.readSimpleColumnNames(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
23:22:33 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE Statement: INSERT INTO SPIELER ( GelbeKarten , SpielerID , ArrivalDate, FirstName , NickName, LastName , Age , AgeDays , Kondition , Form , Torwart , Verteidigung , Spielaufbau , Fluegel , Torschuss , Passpiel , Standards , SubTorwart , SubVerteidigung , SubSpielaufbau , SubFluegel , SubTorschuss , SubPasspiel , SubStandards , OffsetTorwart , OffsetVerteidigung , OffsetSpielaufbau , OffsetFluegel , OffsetTorschuss , OffsetPasspiel , OffsetStandards , iSpezialitaet , iCharakter , iAnsehen , iAgressivitaet , Fuehrung , Erfahrung , Gehalt , Bonus , Land , Marktwert , Verletzt , ToreFreund , ToreLiga , TorePokal , GoalsCurrentTeam , ToreGesamt , Hattrick , Bewertung , TrainerTyp, Trainer, HRF_ID, Datum, PlayerNumber, TransferListed, Caps, CapsU20, TrainingBlock, Loyalty, HomeGrown, SubExperience, NationalTeamID, LastMatchDate, LastMatchRating, LastMatchId, LAST_MATCH_TYPE, LastMatch_PositionCode, LastMatch_PlayedMinutes, LastMatch_RatingEndOfGame, Statement, OwnerNotes, PlayerCategory ) VALUES(1,429284820,'2017-08-13 10:31:00','Folkert','','van Keeken',32,108,6,5,1,15,13,7,3,12,16,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0,0,0,0,0,0,0,2,0,1,5,13,199500,20,12,85010,1,0,0,0,60,61,2,0,-1,0,0,'2022-06-11 23:22:16.0',3,0,0,0,false,20,true,0.0,0,'2022-05-29 20:00:00',17,694456479,0,102,85,10,'D6 30-12-2012', '', 0) java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE 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.SpielerTable.saveSpieler(SpielerTable.java:213) at core.db.SpielerTable.saveSpieler(SpielerTable.java:228) at core.db.DBManager.saveSpieler(DBManager.java:573) at core.model.HOModel.saveHRF(HOModel.java:578) at core.net.OnlineWorker.getHrf(OnlineWorker.java:114) at core.net.DownloadDialog.startDownload(DownloadDialog.java:309) 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: user lacks privilege or object not found: LASTMATCH_POSITIONCODE at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ParserDQL.readSimpleColumnName(Unknown Source) at org.hsqldb.ParserDQL.readSimpleColumnNames(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
23:22:33 [Error] core.db.JDBCAdapter: JDBCAdapter.executeUpdate : java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE Statement: INSERT INTO SPIELER ( GelbeKarten , SpielerID , ArrivalDate, FirstName , NickName, LastName , Age , AgeDays , Kondition , Form , Torwart , Verteidigung , Spielaufbau , Fluegel , Torschuss , Passpiel , Standards , SubTorwart , SubVerteidigung , SubSpielaufbau , SubFluegel , SubTorschuss , SubPasspiel , SubStandards , OffsetTorwart , OffsetVerteidigung , OffsetSpielaufbau , OffsetFluegel , OffsetTorschuss , OffsetPasspiel , OffsetStandards , iSpezialitaet , iCharakter , iAnsehen , iAgressivitaet , Fuehrung , Erfahrung , Gehalt , Bonus , Land , Marktwert , Verletzt , ToreFreund , ToreLiga , TorePokal , GoalsCurrentTeam , ToreGesamt , Hattrick , Bewertung , TrainerTyp, Trainer, HRF_ID, Datum, PlayerNumber, TransferListed, Caps, CapsU20, TrainingBlock, Loyalty, HomeGrown, SubExperience, NationalTeamID, LastMatchDate, LastMatchRating, LastMatchId, LAST_MATCH_TYPE, LastMatch_PositionCode, LastMatch_PlayedMinutes, LastMatch_RatingEndOfGame, Statement, OwnerNotes, PlayerCategory ) VALUES(1,453125802,'2021-07-18 18:56:00','Alejandro','','Gamboa',23,43,8,7,1,13,11,11,2,6,4,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0,0,0,0,0,0,0,0,2,3,7,7,160200,20,18,157500,-1,0,0,1,4,15,1,18,-1,0,0,'2022-06-11 23:22:16.0',4,0,0,0,false,19,false,0.0,0,'2022-06-08 17:25:00',18,696053158,0,106,51,18,'[Future Coach]', '', 0) java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: LASTMATCH_POSITIONCODE 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.SpielerTable.saveSpieler(SpielerTable.java:213) at core.db.SpielerTable.saveSpieler(SpielerTable.java:228) at core.db.DBManager.saveSpieler(DBManager.java:573) at core.model.HOModel.saveHRF(HOModel.java:578) at core.net.OnlineWorker.getHrf(OnlineWorker.java:114) at core.net.DownloadDialog.startDownload(DownloadDialog.java:309) 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: user lacks privilege or object not found: LASTMATCH_POSITIONCODE at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ParserDQL.readSimpleColumnName(Unknown Source) at org.hsqldb.ParserDQL.readSimpleColumnNames(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
more errors...