SQLlite corrupted

Need help? - Post here and we will find a solution for you.
Locked
i2lqf
Novice Class
Posts: 5
Joined: 25 May 2015, 12:47

SQLlite corrupted

Post by i2lqf »

Hello,

I've used portable version of LOG4OM for a while, on a 2GB USB stick with W7 machine; suddenly, storing a QSO, I receive a "Disk I/O error" and log became inaccessible; the stick has yet 1.5GB free and seems errorfree to scanDisk. Unfortunately, I had exported only a CSV version of log, so I cannot reload data on a fresh DB; there is some tool to recover/repair the SQLlite DB, before typing everything again ?

Thanks, I2LQF Fabio
P.S. Log and DB File available on request
User avatar
G4POP
Log4OM Alpha Team
Posts: 11592
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: SQLlite corrupted

Post by G4POP »

Please email me the ******.sqlite database file
73 Terry G4POP
i2lqf
Novice Class
Posts: 5
Joined: 25 May 2015, 12:47

Re: SQLlite corrupted

Post by i2lqf »

Thanks for the fast reply, but the email page for your profile's contact does not allow attachments (at least to me :oops: )
I2LQF, Fabio
i2lqf
Novice Class
Posts: 5
Joined: 25 May 2015, 12:47

Re: SQLlite corrupted

Post by i2lqf »

...or do you mean "attach the file here, in a forum reply" ?
I2LQF
User avatar
G4POP
Log4OM Alpha Team
Posts: 11592
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: SQLlite corrupted

Post by G4POP »

i2lqf wrote:...or do you mean "attach the file here, in a forum reply" ?
I2LQF
No just email it to me g4pop (at) arrl.net
73 Terry G4POP
User avatar
IW3HMH
Site Admin
Posts: 2988
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: SQLlite corrupted

Post by IW3HMH »

Check in the config folder for a folder called backup...
Daniele Pistollato - IW3HMH
i2lqf
Novice Class
Posts: 5
Joined: 25 May 2015, 12:47

Re: SQLlite corrupted

Post by i2lqf »

Hello,

@G4POP: file sent to your address, thanks.

@IW3HMH: the folder "Backup" contains a bunch of ".adi" and ".xml" files, aligned, I think, with times of my use of program; how can utilize them ? (P.S. I don't switch to italian language to respect other users/readers)

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

Re: SQLlite corrupted

Post by G4POP »

File/new database

This will creat a new empty database

Now file/import ADIF and select the adi file in the backup folder with the most recent date

With luck you will have all of your QSO's back
73 Terry G4POP
i2lqf
Novice Class
Posts: 5
Joined: 25 May 2015, 12:47

Re: SQLlite corrupted

Post by i2lqf »

Fine Business !

Acted as suggested by Terry, everything is OK.
Frankly, I missed the hint that .adi means ADIF File :oops: .

Thanks for the strong help, Daniele and Terry

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

Re: SQLlite corrupted

Post by G4POP »

i2lqf wrote:Fine Business !

Acted as suggested by Terry, everything is OK.
Frankly, I missed the hint that .adi means ADIF File :oops: .

Thanks for the strong help, Daniele and Terry

I2LQF, Fabio
Good news Fabio,

Perhaps you should also set a couple of backups in the options also?

Ciao
73 Terry G4POP
Locked