[BUG]

[Chilimonster]

Describe the bug
Error opening HO

To Reproduce
Steps to reproduce the behavior:

1. Startup four HO apps for my four teams.
2. Click on icon for each team in turn
3. Three of the databases open normally and can be updated
4. Get error for one team only:
   

java.lang.ClassCastException: class java.lang.Integer cannot be cast to class java.lang.String (java.lang.Integer and java.lang.String are in module java.base of loader 'bootstrap')
at org.hsqldb.jdbc.JDBCResultSet.getString(Unknown Source)
at org.hsqldb.jdbc.JDBCResultSet.getString(Unknown Source)
at core.db.ModuleConfigTable.findAll(ModuleConfigTable.java:51)
at core.db.DBManager.loadModuleConfigs(DBManager.java:1914)
at core.module.config.ModuleConfig.load(ModuleConfig.java:168)
at core.module.config.ModuleConfig.instance(ModuleConfig.java:25)
at module.playeranalysis.PlayerAnalysisModule.initialize(PlayerAnalysisModule.java:23)
at module.playeranalysis.PlayerAnalysisModule.(PlayerAnalysisModule.java:19)
at core.module.ModuleManager.initMap(ModuleManager.java:54)
at core.module.ModuleManager.initialize(ModuleManager.java:68)
at core.module.ModuleManager.(ModuleManager.java:46)
at core.module.ModuleManager.instance(ModuleManager.java:41)
at core.gui.HOMainFrame.initComponents(HOMainFrame.java:445)
at core.gui.HOMainFrame.(HOMainFrame.java:153)
at core.gui.HOMainFrame.instance(HOMainFrame.java:215)
at core.HO.lambda$main$1(HO.java:225)
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)

Platform information:

• OS: Windows 10
• Version 22H2 (OS Build 19045.3324)

Additional context
Yesterday this same database would only update if CHPP authorisation was provided each time. Backup was loaded which seemed to work ok until today.

Thanks

[wsbrenk]

@Chilimonster could you please upload the backup of your database to this thread? with that i'm hopefully able to debug this issue.

Do you have a backup of your database that's still working?

[Chilimonster]

db_Fly Suckers-2023-07-28.zip
@wsbrenk This is the most recent backup that will open. I backed up to this one a couple of days ago, did an update. then the next day it wouldn't open again.

Thanks

[wsbrenk]

hmm, with the current version i could start and download without any problem:

[Chilimonster]

I was able to download and update the database again last night without any issue. I will check again tonight. If all is well, we may be able to close this one down.

Thanks