Thunderstone Support Forums

When trying to do an update I get these errors. Are they repairable.

05 Bad size 0 for column USER_REC at offset 0xC0 in recid 0x0 of /db/tables/prod/books.tbl in the function fbuftofld
100 Error in data, file /db/tables/prod/books.tbl, offset 0x0
005 Bad size 0 for column USER_REC at offset 0xC0 in recid 0x0 of /db/tables/prod/books.tbl in the function fbuftofld
100 Error in data, file /db/tables/prod/books.tbl, offset 0x0
005 Bad size 0 for column USER_REC at offset 0xC0 in recid 0x0 of /db/tables/prod/books.tbl in the function fbuftofld
100 Error in data, file /db/tables/prod/books.tbl, offset 0x0

That suggests somehow you have a bad index on the field in your where clause, which is pointing to an invalid location in the table. If you rebuild that index you should be OK.

Hmm... my where clause consistst of "where PRICE = '0'" yet it says USER_REC. Should I do both columns?

No, just the PRICE one. The block of data the index pointed to looked invalid, which is where USER_REC came in.