Hallo maxi musterfrau, am Mittwoch, 18. Januar 2006 17:15 schriebst du:
> Hi Jan,
>
Ah, thanks for your answer. I already thought I was misbehaving as anybody
else ignored my question.
> i had a similar problem. After a long debug session i found out that the
> error cames from btree.c (+- line 1000) after the call get2bytes (if res >
> ...) return ... . so in my database i saw that there are a lot of FFŽs -
> anyway.
>
> here are the code snippet.
>
> btree.c
> --------------------------------
> top = get2byte(&data[hdr+5]);
> pPage->nCell = get2byte(&data[hdr+3]);
> if( pPage->nCell>MX_CELL(pBt) ){
> /* To many cells for a single page. The page must be corrupt */
> //return SQLITE_OK; /*temporarily!!!!!!!!!!!!!!!!!! uncomment this*/
> return SQLITE_CORRUPT_BKPT;
> }
> --------------------------------
>
> my solution was to temporarily return SQLITE_OK during a comlete
> reorganisation of my db file.
>
> so i have a function copy_table_content.
>
Thanks for this solution. That's more I've hoped to get.
I the meantime, I tried to "SELECT" distinct records (by an ID field the table
template had) instead of "*", and that worked even with the broken database.
I was able to restore the missing records.
Kind regards
Jan
