[FX.php List] FMFindAll (or not!)

[Roger Price]

Thank you Dale and Michael

After I posted this plea for help I went onto work on some other pages that 
used the same database/layout. These exhibited wierd behaviour although 
different from the 'FindAll' problem. I recreated the layout and all seems 
to be well now.

kindest regards

Roger


----- Original Message ----- 
From: "Dale Bengston" <dbengston at preservationstudio.com>
To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
Sent: Tuesday, May 08, 2007 2:59 PM
Subject: Re: [FX.php List] FMFindAll (or not!)


> Here are some other things to check. Error 100 is "file is missing," 
> which means FX can't communicate with a database file with that name. 
> Moving upstream from your code to the server, it could be one of  these...
>
> 1. You are feeding the wrong file name to FX.
> 2. Your serverdata.php file is pointing at the wrong IP/port for FMSA.
> 3. Your WPE is not running,  or not connecting to FMSA.
> 4. Your database file does not have the proper extended privilege set  for 
> FX (fmxml with full access).
> 5. FMSA is not running.
>
> I hope this helps,
>
> Dale
>
> On May 8, 2007, at 7:52 AM, Michael Layne wrote:
>
>> Roger,
>>
>> I'm pretty sure every time I've ever seem this message(error), it's 
>> about permissions.... either within FM or the database file itself.  Are 
>> you sure you have the user "fmxml" (or something like that)  configured?
>>
>> Anyway, I'd start looking there...
>>
>> HTH,
>>
>> Michael
>>
>> Sorry for the less than thorough response.  I can dig more if  necessary.
>>
>> On May 8, 2007, at 7:34 AM, Roger Price wrote:
>>
>>> I have the following FX.php request in a web page:
>>>
>>> $dbArchiveEvents = 'events.fp7';
>>> $layArchiveEvents = 'web';
>>> $ArchiveEventsQuery = new FX($serverIP, $webCompanionPort, 
>>> $dataSourceType);$ArchiveEventsQuery->SetDBData($dbArchiveEvents, 
>>> $layArchiveEvents);
>>> $ArchiveEventsQuery->setDBUserPass($webUN);
>>> $ArchiveEventsData = $ArchiveEventsQuery->FMFindAll();
>>>
>>> it returns the following when I do:
>>> 'print_r($ArchiveEventsData);
>>>
>>>
>>> fx_error Object ( [error_message_prefix] => [mode] => 1 [level] =>  1024 
>>> [code] => 100 [message] => FX: ExecuteQuery XML error: no  element found 
>>> at line 3 [userinfo] => [backtrace] => Array ( [0]  => Array ( [file] => 
>>> /var/htdocs/FX/FX.php [line] => 1362  [function] => fx_error [class] => 
>>> fx_error [type] => -> [args] =>  Array ( [0] => ExecuteQuery XML error: 
>>> no element found at line  3 ) ) [1] => Array ( [file] => 
>>> /var/htdocs/FX/FX.php [line] =>  1529 [function] => executequery [class] 
>>> => fx [type] => -> [args]  => Array ( [0] => -findall ) ) [2] => Array 
>>> ( [file] => /var/ htdocs/FX/FX.php [line] => 1758 [function] => fmaction 
>>> [class] =>  fx [type] => -> [args] => Array ( [0] => -findall [1] => 1 
>>> [2] =>  full [3] => 1 ) ) [3] => Array ( [file] => /var/htdocs/events/ 
>>> archive/results/index.html [line] => 59 [function] => fmfindall  [class] 
>>> => fx [type] => -> [args] => Array ( ) ) ) [callback] => )
>>>
>>> It suggests a missing element at line 3, but line 3 of what?  However If 
>>> I execute a find using a specific field name and value  then the record 
>>> is returned.
>>>
>>> I've tried 'fooling' it by searching for a numeric field value >=0  but 
>>> returns the same as 'FMFindAll'
>>>
>>> Any suggestions would be appreciated.
>>>
>>> Roger
>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>>
>> Michael Layne  |  9 degrees development  |  www.9degrees.com  | 
>> 404.226.7835 [m]  |   Skype: LayneBay
>>
>>
>> _______________________________________________
>> 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
>