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

[Dale Bengston]

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