[FX.php List] FINDALL failure

[Chris Hansen]

Bob,

I agree with Dale too.  I've seen odd things happen when control  
characters, etc. somehow get into the data.  For example, I've seen  
XML data from FileMaker truncated as the result of a bad character.   
Have you tried turning on debug and grabbing the XML directly?  If  
nothing comes back, use debug to get the URL for another query, then  
modify that URL to perform the problem query.  (If you want help with  
this, email me back channel...)  Best,

--Chris Hansen
   FileMaker 8 Certified Developer
   FileMaker 7 Certified Developer
   Creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org

On Feb 25, 2008, at 8:34 PM, Bob Patin wrote:

> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>