Subject | Re: [firebird-support] Invalid BLOB ID |
---|---|
Author | Sergio H. Gonzalez |
Post date | 2008-08-05T13:07:14Z |
Hi again Vlad! I had a table in my database with just one record and all fields
set to null (also the PK) but one set to a string. I couldn't delete that
record, because when I commit the transaction, the record re-appear. That table
wouldn't let me backup and restore the database. So I drop that table, made a
backup of the database and then a restore and now I can update fields without
getting the "invalid blob id" message!
Probably I was not clear in my previous message when I say that "I recover the
database from a backup". I meant that I deleted the original DB and copied the
DB file from another folder (a backup folder) to my app folder.
I'm curious about all this... was my DB corrupted? How can I corrupt my DB? I'd
like to know that because I want to know if it was my fault. Probably I'm doing
something wrong...
By the way: I use IBX for my project, because I started it with IB6.5 and then
migrated to FB. Can IBX damage the DB ? The project is huge... If I must to
change the components I use, what would you suggest? Is there any tool to change
all the IBX for the new one? Or should I make this task "by hand"
Thanks again for all your help!
-sergio
set to null (also the PK) but one set to a string. I couldn't delete that
record, because when I commit the transaction, the record re-appear. That table
wouldn't let me backup and restore the database. So I drop that table, made a
backup of the database and then a restore and now I can update fields without
getting the "invalid blob id" message!
Probably I was not clear in my previous message when I say that "I recover the
database from a backup". I meant that I deleted the original DB and copied the
DB file from another folder (a backup folder) to my app folder.
I'm curious about all this... was my DB corrupted? How can I corrupt my DB? I'd
like to know that because I want to know if it was my fault. Probably I'm doing
something wrong...
By the way: I use IBX for my project, because I started it with IB6.5 and then
migrated to FB. Can IBX damage the DB ? The project is huge... If I must to
change the components I use, what would you suggest? Is there any tool to change
all the IBX for the new one? Or should I make this task "by hand"
Thanks again for all your help!
-sergio