[FX.php List] FINDALL failure

[Bob Patin]

Well, here's some more strangeness:

There are actually 3 queries on that page; the first one is an EDIT,  
and it works fine. The 2nd and 3rd are just FINDALLs that find all the  
records from  different tables (543 in the 1st table, 25 in the 2nd).

I created a new table for the 1st query, tested it, seemed to work fine.

However, I then tried the actual web app page and it failed.

I then turned off indexing on all fields in the table in question,  
saved the field changes, then went back in and turned them back on.

No change.

I'm stumped; I think Dale may be right that there's a bad record...

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
Member of FileMaker Business Alliance and FileMaker TechNet

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: tech at longtermsolutions.com
      ICQ: 159333060

--------------------------
Contact us for FileMaker hosting and programming for all versions of  
FileMaker
PHP • CDML • Full email services • Free DNS hosting • Colocation •  
Consulting

On Feb 25, 2008, at 8:23 PM, David Ness wrote:

> On 2/25/08 9:00 PM, "Bob Patin" <bob at patin.com> wrote:
>
>> Same thing... I tried everything that I could think of.
>
> Corrupted field indexes?
>
> With FMS v9, I was having a LOT of problems with indexed fields  
> going wonky
> with corrupted indexes. No obvious indication of a problem, just  
> data not
> being returned as expected from finds: Go to all of the referenced  
> indexed
> fields, turn indexing off, exit Manage Database (fields) entirely,  
> then go
> right back in and turn indexing back on for those fields. This will  
> rebuild
> the indexes for those fields.
>
> I had to do this several dozed times (yikes!), but now with FMS  
> 9.0v3 the
> problem appears to be resolved, but it's too early to know  
> definitively.
>
>
> -- 
> David Ness,
> FileMaker Systems Specialist
>
> email: David at David-Ness.com
> Web  : http://www.David-Ness.com
> Ph   : 941.914.4041
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list