No awards, Updating awards from web causes SQLlogic error "no such table: Awards"

Update and distribution of news relating to awards

Moderator: OE6CLD

Post Reply
DD6DO
Novice Class
Posts: 5
Joined: 30 Jan 2016, 12:39

No awards, Updating awards from web causes SQLlogic error "no such table: Awards"

Post by DD6DO »

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
....
**********************************************************
User avatar
G4POP
Log4OM Alpha Team
Posts: 10926
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"

Post by G4POP »

Where/how are you updating?
73 Terry G4POP
DD6DO
Novice Class
Posts: 5
Joined: 30 Jan 2016, 12:39

Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"

Post by DD6DO »

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
User avatar
G4POP
Log4OM Alpha Team
Posts: 10926
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"

Post by G4POP »

Did you try update resources/ log4om awards in the utilities menu?
73 Terry G4POP
DD6DO
Novice Class
Posts: 5
Joined: 30 Jan 2016, 12:39

Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"

Post by DD6DO »

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
User avatar
G4POP
Log4OM Alpha Team
Posts: 10926
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"

Post by G4POP »

Try a fresh install
73 Terry G4POP
DD6DO
Novice Class
Posts: 5
Joined: 30 Jan 2016, 12:39

Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"

Post by DD6DO »

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
User avatar
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"

Post by DF5WW »

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.
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.
DD6DO
Novice Class
Posts: 5
Joined: 30 Jan 2016, 12:39

Re: No awards, Updating awards from web causes SQLlogic error "no such table: Awards"

Post by DD6DO »

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
User avatar
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"

Post by DF5WW »

😉😉👍👍
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.
Post Reply