Log4OM

Dear OMs,
I'am missing all awards. Trying to update causes error SQLlogic error "no such table: Awards".
Any ideas?

Thanks, DD6DO, Stephan


**********************************************************
You're running Log4OM V2 version: 2.29.0.0
Application is running in INSTALLED mode
You're running Log4OM without ADMIN privileges
Your program settings are OK. User is initialized
**********************************************************

**********************************************************
2023-09-16 12:03:09.0998 INFO: [SplashScreen] : Checking internet connection...
2023-09-16 12:03:09.3498 INFO: [SplashScreen] : Loading countries...
2023-09-16 12:03:09.3498 INFO: [SplashScreen] : Loading Awards...
2023-09-16 12:03:09.3654 INFO: [dje_z6J2NKJSWVWGYU9BJR7KZDS7FM3XCSGF4VS_ejd] : [COUNTRY] Loading countries...
2023-09-16 12:03:09.3654 INFO: [AwardsDatabase] : Loading Awards list from database
2023-09-16 12:03:09.5060 INFO: [dje_z6J2NKJSWVWGYU9BJR7KZDS7FM3XCSGF4VS_ejd] : [COUNTRY] Found 402 last updated 11.05.2023 09:05:37
2023-09-16 12:03:09.6310 ERROR: * [AwardsDatabase][LoadAwards][265 ms] : [EXCEPTION] SQL logic error
no such table: Awards code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error
no such table: Awards
bei System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
bei System.Data.SQLite.SQLiteCommand.BuildNextCommand()
bei System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
bei System.Data.SQLite.SQLiteDataReader.NextResult()
bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
bei System.Data.SQLite.SQLiteCommand.ExecuteReader()
bei L4ONG.DAL.AWARDS.AwardsDatabase.LoadAwards(Boolean dje_zSC82UTP8UFUT9ZQ_ejd, Boolean dje_zMSBFZA95_ejd)
2023-09-16 12:03:09.6622 INFO: [SplashScreen] : Loading bands...
*******************************************************




**********************************************************
13:28:10.055 Info: * [dje_z7UKVGZUFXWYWD6V4PYWHTEJPBNKQ_ejd][26953 ms] : Updating awards from web
13:28:10.116 Info: [dje_z7UKVGZUFXWYWD6V4PYWHTEJPBNKQ_ejd] : New award found: award_160MMI.xml
13:28:10.17 Error: [AwardsDatabase][dje_zK36U59HNS6Y84NFJ5T2XHQXRPS7Q_ejd] : [EXCEPTION] SQL logic error
no such table: Awards
13:28:10.182 Error: [AwardsDatabase][SaveAward] : SQLITE SaveAward exception while removing QSO Activation Program 160MMI
[EXCEPTION] SQL logic error
no such table: Awards
13:28:10.182 Error: [AwardsDatabase][SaveAward] : [EXCEPTION] SQL logic error
no such table: Awards
13:28:10.182 Error: [AwardsDatabase][SaveAward] : [EXCEPTION] SQL logic error
no such table: Awards
13:28:10.196 Info: [dje_z7UKVGZUFXWYWD6V4PYWHTEJPBNKQ_ejd] : New award found: award_AA.xml
13:28:10.258 Error: [AwardsDatabase][dje_zK36U59HNS6Y84NFJ5T2XHQXRPS7Q_ejd] : [EXCEPTION] SQL logic error
no such table: Awards
....
**********************************************************

Where/how are you updating?

GE Terry,

in the first steps of starting log4om, the logging monitors the error: "SQL logic error
no such table:"

When log4om is started I tried: Utilities --> award manager --> Update --> update awards.
Same error.

TU, 73 de Stephan

Did you try update resources/ log4om awards in the utilities menu?

Settings -->updates ressources --> log4om awards

Yes, same error logs:
.....
17:45:06.688 Info: [dje_z7UKVGZUFXWYWD6V4PYWHTEJPBNKQ_ejd] : New award found: award_ZWP.xml
17:45:06.83 Error: [AwardsDatabase][dje_zK36U59HNS6Y84NFJ5T2XHQXRPS7Q_ejd] : [EXCEPTION] SQL logic error
no such table: Awards
17:45:06.925 Error: [AwardsDatabase][SaveAward] : SQLITE SaveAward exception while removing QSO Activation Program ZWP
[EXCEPTION] SQL logic error
no such table: Awards
17:45:06.961 Error: [AwardsDatabase][SaveAward] : [EXCEPTION] SQL logic error
no such table: Awards
17:45:07.02 Error: [AwardsDatabase][SaveAward] : [EXCEPTION] SQL logic error
no such table: Awards
17:45:07.083 Info: [AwardsDatabase] : Loading Awards list from database
17:45:07.13 Error: * [AwardsDatabase][LoadAwards][47 ms] : [EXCEPTION] SQL logic error
no such table: Awards
17:45:07.193 Info: [dje_z7UKVGZUFXWYWD6V4PYWHTEJPBNKQ_ejd] : Award update complete

Try a fresh install

DR Terry.

New installation. Same behaviour, no awards. Strange.

W11. Normal user.
Microsoft .NET Runtime - 6.0.14 (x64)
Log4OM V2 version: 2.29.0.0
Application is running in INSTALLED mode
You're running Log4OM without ADMIN privileges
Your program settings are OK. User is initialized

The start log reports the error:
" ....
2023-09-17 07:48:57.2906 INFO: [SplashScreen] : Loading Awards...
2023-09-17 07:48:57.2906 INFO: [dje_zNQWCKGR3E9QG3Z424X899KHW4LAWH4VSMZ_ejd] : [COUNTRY] Loading countries...
2023-09-17 07:48:57.2906 INFO: [AwardsDatabase] : Loading Awards list from database
2023-09-17 07:48:57.3850 INFO: [dje_zNQWCKGR3E9QG3Z424X899KHW4LAWH4VSMZ_ejd] : [COUNTRY] Found 402 last updated 11.05.2023 09:05:37
2023-09-17 07:48:57.3850 ERROR: * [AwardsDatabase][LoadAwards][94 ms] : [EXCEPTION] SQL logic error
no such table: Awards code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error
no such table: Awards
bei System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
bei System.Data.SQLite.SQLiteCommand.BuildNextCommand()
bei System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
bei System.Data.SQLite.SQLiteDataReader.NextResult()
bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
bei System.Data.SQLite.SQLiteCommand.ExecuteReader()
bei L4ONG.DAL.AWARDS.AwardsDatabase.LoadAwards(Boolean dje_zL755KPMKZ2NEFAQ_ejd, Boolean dje_zA47B42XK_ejd)
2023-09-17 07:48:57.4007 INFO: [SplashScreen] : Loading bands...
2023-09-17 07:48:57.4007 INFO: [ConfigurationLogic] : Loading bands from fil
... "

73 de Stephan, DD6DO

Hello Stephan,

the folder where the awards are in is normally a hidden folder. If you not have "unhide" it in Windows this folder need
ADMIN privileges. Please try to run Log4OM as Administrator and check again.

Thanks Terry, thanks Juergen,

I deleted folder Log4om2 ("C:\Users\Stephan\AppData\Roaming\Log4OM2") and used a complete new folder from the installation.
Still working as normal user.
No errors anymore. All the awards are now available.

CUAGN, TU. 73. Stephan, DD6DO