InfoQube IM - Community

Submitted by Armando on 2009/12/06 22:39

Anybody else ?

(This is since last release)

Comments

Can you provide detailed steps? , as it works fine when I try it here...

OK... It works ok with an empty DB. So, unfortunately, my DB seems to have a problem. Oh no... :(

I've tried a repair. Still doesn't work.

Now it crashes even when I try modifying pop parameters, etc. and win-n doesn't work anymore (just writes "n" wherever the focus is...)

Will try to figure what's happening.

When I erase the SMTP port (Options sialog) and press OK, IQ crashes...

Does it happen with your DB ?

Yes it does... thanks for reporting. This is now fixed.

(The port number is stored as an integer and I was not testing for blank or other invalid characters)

Ok... now I just had a blue screen. The firs one in s long long while. I hate these as they are almost always cryptic.

I any case, it happened when retrieving something from the recycle bin. But this has nothing to do with IQ.

I'm going to try to revert to the previous version and see if I can add items using the add item dialog.

Nope... Still can't add anything to my DB. I think I'm going to empty it and send it to you.

Wow. Interresting.

I've emptied the DB and now that it's empty (but still same fields etc.) I can successfully add items to it.

????

==========

Edit 2009 12 07

I tried looking at my normal DB and I saw about 95 items which didn't even had an item creation date. Strange they were like empty items. I suspect they were "imported" from outlook yesterday when I tried importing stuff from there.

Now, I really don't know what to do next.

My DB is like 165mb so I definitely won't send it over.... Plus, there is some confidential stuff in there...

You can try the following:

Make a backup of your IQBase
File>>Properties: note the number of items and field values
File>>close
Tools>>Database management>>Compact
Select your file. JET will perform its own repair. [edit] 9 times out of 10 (*), JET can repair without any data loss. [/edit]
File>>Open. Open your file
Tools>>Database management>>Repair. IQ will do its own housekeeping
File>>Properties again: note the number of items and field values.
- Compare with step 2 above.
- If they differ, this means that JET had internal corruption and restored what it could. Keep your backup (step 1)in a safe place, it could be helpful in eventually retrieving lost items. Daily backups and Dropbox ones could also be useful
Is the problem solved ?

(*) I've seen very few data corruption when using IQ. The database stucture is relatively simple and this does not cause any significant stress on JET. In my 16+ years of working with JET (mostly MS Access apps), corruption does occur at times, generally due to PC or network problems. sometimes, due to overly complex relational data. A few times, it could not be traced to anything other than a JET issue. I recall only 1 case which actually caused data loss.

thanks. I'll try that later.

I discovered that the backup I made on Friday was ok. So I'll 1st try reverting to a previous version in which copying works and, 2nd, copy the items from the corrupt DB to the one that works.

Then if that works, I'll try to see if it was JET corruption or what.

Wow... This is more complicated than I thought as all my toolbars are completely screwed up when I revert to H5... HTML pane is unreadable, etc.

Do you think it'd be possible to have a newer version with a working XML Copy/paste ?

Yes, 0.9.25 uses a more recent version of controls. You can have different versions in separate folder and everything will work fine, as the database format has not changed, but trying to use the same folder will not work.

I'll look at the XML copy/paste first thing in the morning.

One important note however if using a previous version: Do not create calendar events in any previous versions.

[quote=Pierre_Admin]

You can have different versions in separate folder and everything will work fine, as the database format has not changed, but trying to use the same folder will not work.

[/quote]

Yup, that's what I did the whole week... But somehow something went really wrong in the last few hours. Maybe I just need some sleep.

[quote=Pierre_Admin]

I'll look at the XML copy/paste first thing in the morning.

One important note however if using a previous version: Do not create calendar events in any previous versions.

[/quote]

OK...

I think I'll wait for proper XML copy paste before doing anything else. All other options seem potentially time consuming judging from the progress I made in the last 3 hours...

BTW : tried your steps above and it didn't work...

Here's the error when I IQ crashes... Doesn't seem to say much

AppName: infoqube.exe AppVer: 0.9.0.25 ModName: msvbvm60.dll
ModVer: 6.0.97.82 Offset: 0008c6ba

One last before going to bed.

The last item I entered in my DB has the Iditem 96 assigned to it ! This is weird... Unless IQ now starts assigning "unoccupied" values (assigned to now deleted items).

And when I manually create new ones they have values like 123, 124... And I'm normally up to 53807...

>And when I manually create new ones they have values like 123, 124... And I'm normally up to 53807

This is definitely a sign of DB Corruption.

OK... So that's one thing that's out of the way... ;)

Just wanted to "semi close" this thread properly :

- Used a backup and copied items from the corrupt DB to the backup. That's pretty much it...

Now, how did this corruption happen ? Don't know... Will look at my corrupt DB with Pierre later this week.

Adding items using the "Add item" dialog crashes IQ

Comments