[FX.php List] FMS 10 setting up XML returns sometimes empty record sets, and sometimes fields and data working

[Leo R. Lundgren]

Well, the times I've had these problems, it's been with FM PHP API, so  
I don't think it's a problem with the PHP part.

I recall checking the XML output from a problematic search, and indeed  
the actual data stream said that there were no record. This means the  
problem is upstreams and not on the PHP side of the solution.


19 okt 2009 kl. 15.56 skrev Gjermund Gusland Thorsen:

> The sad thing though... is that fmphp works :-(...
>
> ggt
>
> 2009/10/19 Gjermund Gusland Thorsen <ggt667 at gmail.com>:
>> Yes, they are in FM, on the web I even try to use FMFindAny, in FX  
>> and
>> -findany using curl on commandline.
>>
>> This time around saving privs did not make a difference :-(
>>
>> ggt
>>
>> 2009/10/19 Leo R. Lundgren <leo at finalresort.org>:
>>> Have you looked in the database using the normal FM GUI, and seen  
>>> whether
>>> the records that you cannot find via XML are visible in the  
>>> database like
>>> they should?
>>>
>>> 19 okt 2009 kl. 15.51 skrev Gjermund Gusland Thorsen:
>>>
>>>> My experience with this on this one server is that it works for  
>>>> about
>>>> 50 queries then starts serving _ONE_ blank record.
>>>>
>>>> And it does not matter whether you set privs again or relaunching  
>>>> WPE...
>>>>
>>>> ggt
>>>>
>>>> 19 okt 2009 kl. 15.44 skrev Leo R. Lundgren:
>>>>
>>>>> Do you mean that relaunching WPE (by disabling IWP for that  
>>>>> database in
>>>>> the databases pane in FM Admin?) gives the same effect as  
>>>>> "touching" the
>>>>> permissions, i.e that the records start being visible again, but  
>>>>> only for a
>>>>> little while?
>>>>>
>>>>> The last time this happened for me was a while ago and before  
>>>>> that it was
>>>>> a while ago as well. It doesn't happen very often, it's measured  
>>>>> in a number
>>>>> of months between times. Overall I think it's happened only two  
>>>>> times for
>>>>> something that's been running for a couple of years.
>>>>>
>>>>> That being said, it might still have happened at times when  
>>>>> neither I nor
>>>>> the client was looking. But considering that I haven't been able  
>>>>> to get rid
>>>>> of the problem without taking action, after a few hours of  
>>>>> almost fruitless
>>>>> debugging, it feels more likely that it hasn't happened without  
>>>>> us noticing
>>>>> it.
>>>>>
>>>>> 19 okt 2009 kl. 15.33 skrev Gjermund Gusland Thorsen:
>>>>>
>>>>>> You are right, this works.
>>>>>>
>>>>>> I will give you feed back on whether or not it stays like this,  
>>>>>> I mean
>>>>>> relaunching WPE gives the same effect for a while.
>>>>>>
>>>>>> tia,
>>>>>> ggt
>>>>>>
>>>>>> 2009/10/19 Leo R. Lundgren <leo at finalresort.org>:
>>>>>>>
>>>>>>> 19 okt 2009 kl. 14.56 skrev Gjermund Gusland Thorsen:
>>>>>>>
>>>>>>>> Anyone experienced this?
>>>>>>>>
>>>>>>>> http://pastebin.com/f7d504cc4
>>>>>>>>
>>>>>>>> foundCount = 0
>>>>>>>> ErrorCode = 0 and not 401...
>>>>>>>>
>>>>>>>> all fields are supposedly empty.
>>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> Before I delve into explaining my similar experiences, do you  
>>>>>>> still
>>>>>>> have the
>>>>>>> same problem? If so, does it help if you go into the  
>>>>>>> permissions for
>>>>>>> the
>>>>>>> user/group that the user belongs to, and change something, so  
>>>>>>> that the
>>>>>>> privileges are updated. Note that I don't mean you must change
>>>>>>> something
>>>>>>> that actually matters, do whatever little change is needed to  
>>>>>>> be able
>>>>>>> to
>>>>>>> "OK" and save the new permissions, then change it back to what  
>>>>>>> it
>>>>>>> originally
>>>>>>> was. Just to see if the problem goes away when the permissions  
>>>>>>> are
>>>>>>> definately updated at least once.
>>>
>>>
>>> -|
>>>
>>> _______________________________________________
>>> 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



-|