Page 1 of 4

[Solved] Database unable to open

PostPosted: Mon Jul 14, 2014 3:27 pm
by Karena
Hi,

I've been working for the last few weeks on an ODB file. I saved (yes!) and went to open something else and Open Office crashed. I tried to reopen the file and I got a "Filter Selection" window.

I don't know what happened! Is there anything I can do to try to fix it?? I've tried the zip trick and creating a new user profile, and it's still not working.

Thank you so much! I really appreciate the help, it's a very important file.

Re: Database unable to open and asking for "Filter Selection

PostPosted: Mon Jul 14, 2014 3:47 pm
by Sliderule
I just sent you a PM ( Private Message ).

Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.

Re: [Solved] Database unable to open

PostPosted: Wed Jul 16, 2014 9:07 pm
by Pastor Bob
I have this same problem on my .odb file. Worked fine for a year. Now I get that Filter Selection window. Solution? Many thanks!

Re: [Solved] Database unable to open

PostPosted: Wed Jul 16, 2014 10:25 pm
by Sliderule
Pastor Bob:

I just sent you a PM ( Private Message ).

Sliderule

Re: [Solved] Database unable to open

PostPosted: Thu Jul 17, 2014 5:00 pm
by Pastor Bob
Thanks Sliderule! You fixed my corrupted .odb file! I set the backup function to help prevent this. Unfortunately, I had been using my dropbox account as a backup, and it just saved my corrupt file with the same name, and was no use as a backup. I know better now.

Re: [Solved] Database unable to open

PostPosted: Tue Jan 06, 2015 7:49 pm
by OPE1rginla
I am having the same problem. Can anyone help? Pastor Bob or Sliderule? Thanks,

Re: [Solved] Database unable to open

PostPosted: Tue Jan 06, 2015 8:25 pm
by Sliderule
OPE1rginla:

I just sent you a PM ( Private Message ).

Sliderule

Re: [Solved] Database unable to open

PostPosted: Thu Jan 15, 2015 11:06 pm
by macstibs
Same problem here.

Accessed an ODB that I saved to Dropbox using OpenOfficeAndroid and then got a corrupt DB error back on the desktop.

Tried to copy the data over to a new ODB and then rezip but I'm getting the Filter screen instead of it opening properly.

Thanks.

Re: [Solved] Database unable to open

PostPosted: Thu Jan 15, 2015 11:56 pm
by Sliderule
macstibs wrote:Same problem here.

Accessed an ODB that I saved to Dropbox using OpenOfficeAndroid and then got a corrupt DB error back on the desktop.

Tried to copy the data over to a new ODB and then rezip but I'm getting the Filter screen instead of it opening properly.

Thanks.

I will momentarily send you a PM ( Private Message ).

Sliderule

Re: [Solved] Database unable to open

PostPosted: Sat Jan 17, 2015 9:51 am
by JJJoseph
Sliderule, why are you sending private messages? That means each one of us has to request your answer individually. If you post your reply here, we can all get to work with needing to bother you repeatedly, until the end of time.

Re: [Solved] Database unable to open

PostPosted: Sat Jan 17, 2015 1:34 pm
by DACM
JJJoseph wrote:Sliderule, why are you sending private messages? That means each one of us has to request your answer individually. If you post your reply here, we can all get to work with needing to bother you repeatedly, until the end of time.

JJJoseph,

Please be respectful of Sliderule's skills and dedication involved with .odb file repair. The steps are often beyond a simple tutorial. The process requires advanced ZIP archive repair tools, significant knowledge and experience with .odb file specifications (such as embedded query, form, report and database-file storage), expertise with HSQLDB configurations and recovery mechanisms, as well as, tedious manual HSQL 'script' file repair on a case-by-case basis. The results must then be repackaged and tested. Private Messaging is likely used to eliminate the possibility that a desperate user might unwittingly post confidential database data in a public forum. Lets just tip our hats to Sliderule for this invaluable service and dedication to the Base user-community.

We can generally avoid the need for .odb file recovery by storing our files in a cloud-sync'ed folder featuring file-versioning services (Dropbox, Google Drive, etc.).

I should also mention:

Re: [Solved] Database unable to open

PostPosted: Sat Jan 17, 2015 5:47 pm
by Sliderule
JJJoseph wrote:Sliderule, why are you sending private messages? That means each one of us has to request your answer individually. If you post your reply here, we can all get to work with needing to bother you repeatedly, until the end of time.

I send a private message, to inform the user of MY REQUIREMENTS, if I am to help a user. If/when the user meets those requirements, I will attempt to repair the file. Sometimes, a user elects not to reply or even acknowledge or read the PM.

No, it is NOT a list of things to do to repair a corrupt .odb file, since what must be done, or even, if it can be done ( repaired ), depends on the 'condition/contents' of the individual file. Some of the tools are also, operating system specific.

Sliderule

Re: [Solved] Database unable to open

PostPosted: Sun Jan 18, 2015 9:30 am
by JJJoseph
Sliderule wrote:I send a private message, to inform the user of MY REQUIREMENTS


Then you should do that somewhere else other than this forum. You're wasting everybody's time & space conducting private conversations on a "Help Forum", and you're not helping any other users. It's bad manners. Please take your PMs somewhere else.

Re: [Solved] Database unable to open

PostPosted: Sun Jan 18, 2015 5:27 pm
by Sliderule
JJJoseph wrote:
Sliderule wrote:I send a private message, to inform the user of MY REQUIREMENTS


Then you should do that somewhere else other than this forum. You're wasting everybody's time & space conducting private conversations on a "Help Forum", and you're not helping any other users. It's bad manners. Please take your PMs somewhere else.

JJJoseph:

Thank you for telling me what I should or not do.

I have now learned, you are expert in "bad manners".

To the over 75 users, over the years, where, I was able to 'recover' a Base file ( *.odb ) . . . I apologise . . . per user JJJoseph . . for wasting forum bandwidth with one private message.

Thank you very much in teaching me something today.

Sliderule

Re: [Solved] Database unable to open

PostPosted: Fri Jan 30, 2015 7:16 am
by jimmpa25
Can i please have some help with this to, when i try to open my work i get the filter selection window and i cant choose anything there, please help :)

Re: [Solved] Database unable to open

PostPosted: Fri Jan 30, 2015 5:46 pm
by Sliderule
jimmpa25:

Welcome to the OpenOffice / LibreOffice Base forum.

You said, wrote:

jimmpa25 wrote:Can i please have some help with this to, when i try to open my work i get the filter selection window and i cant choose anything there, please help :)

While I would like to help you . . . user JJJoseph has written:

JJJoseph wrote:
Sliderule wrote:I send a private message, to inform the user of MY REQUIREMENTS


Then you should do that somewhere else other than this forum. You're wasting everybody's time & space conducting private conversations on a "Help Forum", and you're not helping any other users. It's bad manners. Please take your PMs somewhere else.

Since, the forum moderators have not added anything to this forum post . . . I have learned that . . . no . . . I cannot help users with corrupt Base files.

However, I am confident . . . user . . . JJJoseph . . . will help you repair your file, and, do it without "wasting everybody's time & space" and with "good manners". :)

Sliderule

Re: [Solved] Database unable to open

PostPosted: Fri Jan 30, 2015 6:42 pm
by F3K Total
Hello,
IMPOV, everybody can help the way he/she likes.
I am able to repair broken databases, just by reading previous posts of Sliderule (thank you so much) and others here in the Forum.
So JJJoseph :evil: is just too lazy to search and learn it, all necessary informations are available.
He's the one, wasting everybody's time & space with his unfriendly comments and unnecessary discussions.
Sliderule, don't let him bother you!
R

Re: [Solved] Database unable to open

PostPosted: Fri Jan 30, 2015 6:49 pm
by Sliderule
F3K Total wrote:Hello,
IMPOV, everybody can help the way he/she likes.
I am able to repair broken databases, just by reading previous posts of Sliderule (thank you so much) and others here in the Forum.
So JJJoseph :evil: is just too lazy to search and learn it, all necessary informations are available.
He's the one, wasting everybody's time & space with his unfriendly comments and unnecessary discussions.
Sliderule, don't let him bother you!
R

F3K Total:

I am certainly not letting user JJJoseph "bother me". The exact opposite . . . as I have posted above . . . I have learned from user JJJoseph . I am just, following the wise recommendations posted by said user. :super:

Sliderule

Re: [Solved] Database unable to open

PostPosted: Wed Feb 18, 2015 3:02 am
by acknak
May I state clearly, for the record, that there is no forum policy against using PMs to help users privately. Volunteers offer their valuable expertise here pro bono and each is entitled to choose the approach that they feel is most appropriate.

While we encourage people to resolve issues publicly so others can benefit from the discussion, there is no forum policy regarding this and it is not, from the standpoint of the community forum, considered improper in any way for someone to choose to use a private channel. Sliderule has done nothing improper in using the private channel to resolve the problem.

If you dislike using a private channel, that is your choice, clearly. But we ask everyone to respect each other's choices and refrain from making personal character attacks.

A personal note: I sometimes help with damaged document files (Base problems are beyond my skills) and I've considered trying to write down the steps: aside from some general strategies (which are already written down, and apply to Base documents as well), there is no recipe for recovering a damaged file. Every one is a little different and it often takes some knowledge of xml and a bit of intuition to fix the problem. Writing that down for someone else to follow would end up as a book. About half the time, I end up using a private channel to solve the problem.

Any comment or discussion on this issue should be made on the Site Feedback area of the forum: https://forum.openoffice.org/en/forum/v ... m.php?f=50

Re: [Solved] Database unable to open

PostPosted: Wed Apr 01, 2015 3:32 pm
by lennonenglish
i'm having thesame problem. can someone please post the solution? thanks!

Re: [Solved] Database unable to open

PostPosted: Wed Apr 01, 2015 4:06 pm
by Sliderule
lennonenglish:

I just sent you a PM ( Private Message ).

Sliderule

Re: [Solved] Database unable to open

PostPosted: Thu Apr 30, 2015 6:20 pm
by jslcpd157
I am having this same issue. I am working on OpenOffice 4.1.1, on Windows 7.

Re: [Solved] Database unable to open

PostPosted: Thu Apr 30, 2015 7:48 pm
by Sliderule
jslcpd157:

I just sent you a PM ( Private Message ).

Sliderule

Re: [Solved] Database unable to open

PostPosted: Fri May 01, 2015 5:37 pm
by thatchristianguy
I am getting a corrupt .odb file that I was in several minutes ago. Is there a solution I can pointed to? Thank you for you help with this.

Re: [Solved] Database unable to open

PostPosted: Fri May 01, 2015 6:21 pm
by F3K Total
How do you see, that it's corrupt?
R

Re: [Solved] Database unable to open

PostPosted: Fri May 01, 2015 7:24 pm
by thatchristianguy
When I go to open the .odb the FIlter Selection window opens and there is no option that will allow the database to open regularly.

Re: [Solved] Database unable to open

PostPosted: Fri May 01, 2015 8:27 pm
by Villeroy
thatchristianguy wrote:When I go to open the .odb the FIlter Selection window opens and there is no option that will allow the database to open regularly.

... and you are running Windws without any backup facility so you do not have any working version of that file?
Well, that database might be lost.
[Tutorial] Avoiding data loss with built in HSQLDB

Re: [Solved] Database unable to open

PostPosted: Thu May 07, 2015 11:44 am
by deadline13
Please help. My database crashed a while ago and cant be opened. Same issue.
Please help I need the database back. Been working on it for quite a while :crazy:

Re: [Solved] Database unable to open

PostPosted: Thu May 07, 2015 3:07 pm
by Sliderule
deadline13:

I just sent you a PM ( Private Message ).

Sliderule

Re: [Solved] Database unable to open

PostPosted: Tue Jul 07, 2015 1:13 pm
by jtbernier
Same issue... hoping for a PM from Sliderule