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

Leo R. Lundgren leo at finalresort.org
Mon Oct 19 07:54:17 MDT 2009


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.


-|



More information about the FX.php_List mailing list