refresh NEW ONE status after import a DB

iz0tws
Novice Class
Posts: 13
Joined: 03 Apr 2016, 11:23

refresh NEW ONE status after import a DB

Post by iz0tws »

I just migrated to SQL database importing a full ADI backup of the previuos contact.
It seems that after this operation, the worked country memory was reset in such a way.
Any QSO is now considered a NEW ONE until that country is worked again (very easy to check in the Country column of the cluster function).
Any way to update correctly the worked country from the database
User avatar
G4POP
Log4OM Alpha Team
Posts: 11592
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: refresh NEW ONE status after import a DB

Post by G4POP »

Where did the ADIF file come from that you imported?

Guess you select not to carry out quality checks during import otherwise the countries would have been verified
73 Terry G4POP
iz0tws
Novice Class
Posts: 13
Joined: 03 Apr 2016, 11:23

Re: refresh NEW ONE status after import a DB

Post by iz0tws »

The ADIF was the full export of the previous log4om2 sqlite.
And for re importing i left everything by default so the option 1. Apply quality check correction.
Does it reset the country "new one" reference?
iz0tws
Novice Class
Posts: 13
Joined: 03 Apr 2016, 11:23

Re: refresh NEW ONE status after import a DB

Post by iz0tws »

I made some other trial.
If i create a QSO entry for a country this country is not anymore RED (the default color for new one) in the country column in the cluster list. Also the statistic doesn't report new one flag.
But if i restart the program, any new one is reset and again all the country are in new one state.
It seems more some bug and it is reproducible

version: 2.9.0.0
User avatar
G4POP
Log4OM Alpha Team
Posts: 11592
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: refresh NEW ONE status after import a DB

Post by G4POP »

where is the sqlite file stored, what folder?
73 Terry G4POP
iz0tws
Novice Class
Posts: 13
Joined: 03 Apr 2016, 11:23

Re: refresh NEW ONE status after import a DB

Post by iz0tws »

I'm logging on mysql not using sqlite anymore. I'm not sure that with sqlite was working either. I do not see new ones so often.
iz0tws
Novice Class
Posts: 13
Joined: 03 Apr 2016, 11:23

Re: refresh NEW ONE status after import a DB

Post by iz0tws »

The sqlite folder was located in a shared dropbox folder.
The mysql is an external server.
User avatar
G4POP
Log4OM Alpha Team
Posts: 11592
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: refresh NEW ONE status after import a DB

Post by G4POP »

Are you sure that you have permissions to use the external server because the only time I see this issue its usually because the user located the database in the Program files x86 directory and windows security does not like that
73 Terry G4POP
iz0tws
Novice Class
Posts: 13
Joined: 03 Apr 2016, 11:23

Re: refresh NEW ONE status after import a DB

Post by iz0tws »

The user , the db and its permission are created by the script that log4om generates in this kind of configuration.
The connection and the db access seems normal.
User avatar
G4POP
Log4OM Alpha Team
Posts: 11592
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: refresh NEW ONE status after import a DB

Post by G4POP »

I will ask Lele to contact you about this as it's probably easier for him to troubleshoot the problem.
73 Terry G4POP
Post Reply