Hi Chip, You can ignore an orphaned blob. It is just a saved-outside-the-record field that lost its parent. I don't think it causes any problem.
To fix an orphaned blob run Repair, twice. If you go into MSC and Repair it will say "Anomalies Detected". Repair again and it will be fixed. First, for your your Index error, try re-writing all records in the table with something like All Records Apply To Selection(field1:=field1) Does this help? > On Aug 17, 2016, at 6:52 AM, Chip Scheide <4d_o...@pghrepository.org> wrote: > > since this is development - it is not so much a problem as I can > replace the data file, however, I would like to understand what is > going on. > all of this is: > C/S v13.5 OS X 10.6.8 on client side, OS X 10.9.? server side. > > I attempted to add a record to a table, this is the first record in the > table (in other words the table is empty) > Create record([table]) > > set some values in the record, and save it. > Upon saving, I get an error (not exact message) > The record can be saved bad index. > > I go into the structure editor, remove the indexes on the table. > I then add them back. > try again to add a record - no joy, same error. > > I remove all the indexes completely. > I try adding a new record - STILL no joy. > *same* error - even though there is no longer an index on the table. > > Run maintenance, from client, 'verify' fails showing an orphaned blob > in a different table from the one I am having trouble with. > Go to server, run maintenance, 'Compact', it starts hits the table with > the orphaned blob - and crashes! > > Any ideas what is going on? > ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
