As a suggestion... a clearer error message might be in order... something like:
Hey stupid! you forgot to index your unique field(s) <field name(s)>. Can not save the record until either there is an index, or the unique property has been removed. Alternatively (and maybe v15 does this) if the unique property is set, an index is automatically added. Chip On Wed, 17 Aug 2016 18:51:33 +0200, Timothy Penner wrote: > Hi Chip, > > Starting with v13.5: > You need to make sure that all unique fields have an index. > > Please see the big red note at the top of the bug fix list for v13.5: > ftp://ftp.4d.com/ACI_PRODUCT_REFERENCE_LIBRARY/Bug_Fix_Lists/Version_13/v13.5/Fixed_bugs_4D_v13.5.pdf > > See also: > http://kb.4d.com/assetid=77065 > > -Tim > > > > > > -----Original Message----- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip > Scheide > Sent: Wednesday, August 17, 2016 9:13 AM > To: 4D iNug Technical > Subject: Re: v13 - Can not add record & Maintenance issues > > I have: > installed a stand alone copy of 4D v13 > pulled a copy of the datafile from a backup. > It had the same problem (orphaned blob) > I ran repair, and compact - no issues (supposedly) > > I restarted the server with the repaired & compacted data file > > run the code to create a new record, this is NOT the table > (Department) with the orphaned blob, and am getting the same errors. > 1248 - Connot save new record in table calendar of database > 1247 - cannot update new record in table calendar of database > 1088 - Index is invalid or missing > > I have removed all indexes, and all relations. > > 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 > ********************************************************************** ********************************************************************** 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 **********************************************************************
