Page 1 of 1

SQLlite corrupted

Posted: 25 May 2015, 13:09
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

Re: SQLlite corrupted

Posted: 25 May 2015, 13:27
by G4POP
Please email me the ******.sqlite database file

Re: SQLlite corrupted

Posted: 25 May 2015, 17:32
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

Re: SQLlite corrupted

Posted: 25 May 2015, 17:35
by i2lqf
...or do you mean "attach the file here, in a forum reply" ?
I2LQF

Re: SQLlite corrupted

Posted: 25 May 2015, 17:44
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

Re: SQLlite corrupted

Posted: 25 May 2015, 18:09
by IW3HMH
Check in the config folder for a folder called backup...

Re: SQLlite corrupted

Posted: 25 May 2015, 20:03
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

Re: SQLlite corrupted

Posted: 25 May 2015, 20:24
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

Re: SQLlite corrupted

Posted: 25 May 2015, 21:05
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

Re: SQLlite corrupted

Posted: 25 May 2015, 21:08
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