Record not show

[HS3LSE]

Dear all
I am an old user in Win 7
The last used v. Log4OM_1115 and all OK I have 4179 QSO in my database SQLlite "DX.SQLlite"
Now I try to install Log4OM_1150 (stable vertion) the first config is OK and finish.
I start to open my database "DX.SQLlite" but it not show the record in Recent QSO window but at the buttom is show QSO:4179 Recor found 0
So I try to Uninstall and install the old vertion but it's also not show my record.
and I try install the new Log4OM_1150 again but not show record.. I try to create new database for test and add new one yes is work but try to change to open my old database it's not show

I found the log of Log4OM report is.....
2013-10-24 21:38:24.9512 INFO: BL.FileManagement: VIEW CONFIGURATION load completed
2013-10-24 21:38:29.7095 INFO: Log4OMMainWindow: OPEN DATABASE by menu initiated
2013-10-24 21:38:33.2207 INFO: Log4OMMainWindow: OPEN DATABASE: K:\ALL_HAM\DXLOG\DX2.SQLite
2013-10-24 21:38:33.2207 INFO: BL.DatabaseManagement: *** Connecting to Database SqlLite ***
2013-10-24 21:38:33.2227 INFO: BL.DatabaseManagement: SQLITE Begin Connection Validation
2013-10-24 21:38:33.5067 INFO: BL.DatabaseManagement: SQLITE Connection Valid
2013-10-24 21:38:33.5067 INFO: BL.DatabaseManagement: *** Connected to database K:\ALL_HAM\DXLOG\DX2.SQLite ***
2013-10-24 21:38:50.2707 INFO: Log4OMMainWindow: OPEN DATABASE by menu initiated
2013-10-24 21:38:52.6558 INFO: Log4OMMainWindow: OPEN DATABASE: K:\ALL_HAM\DXLOG\DX.SQLite
2013-10-24 21:38:52.6588 INFO: BL.DatabaseManagement: *** Connecting to Database SqlLite ***
2013-10-24 21:38:52.6608 INFO: BL.DatabaseManagement: SQLITE Begin Connection Validation
2013-10-24 21:38:52.6888 INFO: BL.DatabaseManagement: SQLITE Connection Valid
2013-10-24 21:38:52.6888 INFO: BL.DatabaseManagement: *** Connected to database K:\ALL_HAM\DXLOG\DX.SQLite ***
2013-10-24 21:38:52.7978 ERROR: *** BL.SQLiteDatabaseManagement: SQLITE Recalculate statistics exception ******* [Function: RecalculateCountryStatistics] System.InvalidCastException: Specified cast is not valid.
at System.Data.SQLite.SQLiteDataReader.VerifyType(Int32 i, DbType typ)
at System.Data.SQLite.SQLiteDataReader.GetString(Int32 i)
at LogOM.BL.SQLiteDatabaseManagement.RecalculateCountryStatistics()
2013-10-24 21:38:52.8668 ERROR: *** BL.SQLiteDatabaseManagement: SQLITE Recalculate statistics exception ******* [Function: RecalculateCountryStatistics] System.InvalidCastException: Specified cast is not valid.
at System.Data.SQLite.SQLiteDataReader.VerifyType(Int32 i, DbType typ)
at System.Data.SQLite.SQLiteDataReader.GetString(Int32 i)
at LogOM.BL.SQLiteDatabaseManagement.RecalculateCountryStatistics()
2013-10-24 21:38:53.0798 ERROR: *** BL.SQLiteDatabaseManagement: SQLITE GetLog exception ******* [Function: GetLog] System.InvalidCastException: Specified cast is not valid.
at System.Data.SQLite.SQLiteDataReader.VerifyType(Int32 i, DbType typ)
at System.Data.SQLite.SQLiteDataReader.GetString(Int32 i)
at LogOM.BL.SQLiteDatabaseManagement.ParseLog(SQLiteDataReader reader)
at LogOM.BL.SQLiteDatabaseManagement.GetLog(QueryParameters parameters, Int32 items, SortParameters sortParameters)

PS. I used the SQLlite browser is "SQLite Database Browser 2.0 b1" for check my file "DX.SQLlite" is OK seen the all record in my LOG!!!! but not show in LOG4OM

DX2.SQLlite is for test 1 record is OK
DX.SQLlite is my old database is not work.
Help me please now I miss my LOG

[HS3LSE]

Just now
I try to install old v. Log4OM_1106 is can show my record
but the last v. still not show

[G4POP]

Dear ?
Please make a backup of your logbook

Uninstall Log4OM

Download the latest version again

Install the latest version 1.15

Create a new logbook with a different name (File/New database)

Import your backup ADIF into this new logbook (File/Import ADIF)

PLEASE ENSURE THAT YOU UNINSTALL LOG4OM BEFORE INTALLING THE NEW DOWNLOAD

Please notify me ot the result

[HS3LSE]

OK
I followed this
1. Backup for my old database in the old vertion 1.10.6 as DX.QSLlite to Export ADIF "DXADIF" . (uncheck export only standard ADIF filed)
2. Uninstall the old v.1.10.6
3. redownload new v. 1.15 and install
4. run v.1.15 and create new database to DXLOG.SQLlite
5. import ADIF "DXADIF" in to new database (check update contries in ADIF)

Result:
1. record show and working
2. Tab country in record is empty
3. I think may be some field is missing but not important (export ADIF) suchs as I worked on satellite and add the info of nameSAT freq but the new database in the field is not found.

OK it's work but 100% of field info unlike the original database.....
if you have the way to direct use the original database please help me.
Thanks very much.

[G4POP]

Dear ?
Please email me your original DX.SQLite file (The original database file)

You can find my email on QRZ

[HS3LSE]

Tnx Terry.
I will send to you.

[IW3HMH]

It's probably something bad in a field you have set, or log4om has saved somewhere.
the invalid cast is something that log4om tries to cast as number, but it's not a number.

This error should be intercepted before happens, so the log will be of interest to me too.
Pse Terry forward it to me as soon as you have it

Thanks
Daniele

[IW3HMH]

Error found. There are some NULL values in your DB (strange indeed)

to fix:

open QSO ARCHIVE -> ARCHIVE MANAGEMENT screen
open FIELD UPDATE top menu. Press OK in the error message
in the TOP RIGHT part of the window (execute custom update query) type:

Code: Select all

update log set submissionstatus = '' where submissionstatus is null

flag all warning fields and press EXECUTE

This should fix your log.
If not, i will send your log fixed via mail

[G4POP]

I have fixed your log as well Chan but I notice there are many missing country names and DXCC numbers so I will do all of the updates and email it to you later.

What logging software did you use before Log4OM?

[G4POP]

For the record Chan has acknowledged by email that the repaired database is working OK