Corrupted table

Post Reply
jai.thomas
Posts: 54
Joined: Tue Dec 11, 2001 6:20 pm

Corrupted table

Post by jai.thomas »

While inserting a record into a table, I got "More Values Than Fields in the function Insert" error due to an obvious problem in the SQL.
From that point on I am getting the following error on any operation (including simple select) on the table.
Bad size 1815049317 for column TITLE at offset 0x4A in recid 0x2F4C17 of d:\morph3\texis\lyceumdb\SRCH_PAGE.tbl in the function fbuftofld
Error in data, file d:\morph3\texis\lyceumdb\SRCH_PAGE.tbl, offset 0x2F4C17

Looks like I cannot do anything with the table now. Why is this happening and how do I fix the table?

Thanks
Jai
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Corrupted table

Post by John »

The error you mentioned would not have caused the problem, as the table is not touched in that case.
What is the table definition? You can fix the table with kdbfchk, e.g.

kdbfchk -O -d 0x2F4C17 d:\morph3\texis\lyceumdb\SRCH_PAGE.tbl
John Turnbull
Thunderstone Software
Post Reply