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
....
**********************************************************
No awards, Updating awards from web causes SQLlogic error "no such table: Awards"
Moderator: OE6CLD
- G4POP
- Log4OM Alpha Team
- Posts: 11225
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"
Where/how are you updating?
73 Terry G4POP
Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"
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
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
- G4POP
- Log4OM Alpha Team
- Posts: 11225
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"
Did you try update resources/ log4om awards in the utilities menu?
73 Terry G4POP
Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"
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
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
- G4POP
- Log4OM Alpha Team
- Posts: 11225
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"
Try a fresh install
73 Terry G4POP
Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"
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
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
- DF5WW
- Log4OM Alpha Team
- Posts: 2035
- Joined: 02 May 2013, 09:49
- Location: Kraam, Rhineland Palatinate, Germany
- Contact:
Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"
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.
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.
73´s .. Juergen ... ALT-512 SDR (10W) , 50 m random wire at SG-211 autotuner, 2 x Xiegu G90 (20W HF TRX) one as portable Radio. Also TS-790E (40 W) for VHF/UHF with X-50 vertical and Duoband 4-Element LPDA.
Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"
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
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
- DF5WW
- Log4OM Alpha Team
- Posts: 2035
- Joined: 02 May 2013, 09:49
- Location: Kraam, Rhineland Palatinate, Germany
- Contact:
Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"
73´s .. Juergen ... ALT-512 SDR (10W) , 50 m random wire at SG-211 autotuner, 2 x Xiegu G90 (20W HF TRX) one as portable Radio. Also TS-790E (40 W) for VHF/UHF with X-50 vertical and Duoband 4-Element LPDA.