[FX.php List] Cannot get FX to connect to FMP

[Gjermund Gusland Thorsen]

There are bugs in some of the 8 releases make sure you have FMSA 8.0v4r2

If you run FileMaker Server 8 of any kind.

ggt

2008/7/23 Bob Patin/Longterm Solutions <bob at patin.com>:
> I wonder if it's a server issue; have you tried restarting the web server?
>
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> iChat: bobpatin
> AIM: longterm1954
> FileMaker 9 Certified Developer
> Member of FileMaker Business Alliance and FileMaker TechNet
> --------------------------
> FileMaker hosting and consulting for all versions of FileMaker
> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>
> On Jul 23, 2008, at 10:12 AM, VanBuskirk, Patricia wrote:
>
>> I am having major problems all of a sudden.  Our online forms are in php
>> on a designated server (Win Server 2003), using FX.php.  They started
>> acting up Friday (the form just stopped when it got to the dropdown
>> list, we got them working .. then again last night, we got them working,
>> then again this morning and I cannot get them working again.  They now
>> show the entire form, but will not show the drop-down list (which pull
>> from a field in FMP) and when submitted will not go to the confirm.php
>> page (the physical file shows in the directory, but goes to a page not
>> found error). And it does not make a record in FMP.
>>
>> We ran the included FM tests and all the web publishing tests come back
>> ok.  I have a test page that prints out the php settings, then lists all
>> the hosted databases available to the web (<?php print_r($databaseList);
>> ?>).  That works.
>>
>> When it gets to the following point in the form, it will not show the
>> list:
>>
>> <select name="Contact_Bldg" tabindex="5">
>>  <option selected>NOT LISTED - Type in Below</option>
>>  <?php
>>
>> require_once('FX.php');
>> require_once('server_data.php');
>>
>> // configure a connection to FileMaker Server Advanced
>> $ordersQuery = new FX(FM_IP, FM_PORT, FM_VERSION);
>> // set database and layout information
>> $ordersQuery->SetDBData('WEB_Forms', 'Ref_FSU_Buildings', 'all');
>> // set database username and password
>> $ordersQuery->SetDBUserPass(FM_USERNAME, FM_PASSWORD);
>> // retrieve all records in this database available to the current user
>> $ordersQuery->AddSortParam('ListForWeb', 'ascend');
>> $orders = $ordersQuery->DoFXAction(FX_ACTION_FINDALL);
>>        foreach ($orders as $contact) {
>>   echo "                <option>{$contact['ListForWeb']}\n";
>>
>> }
>> ?>
>> </select>
>>
>> This makes me think it has something to do with FX.  I re-downloaded
>> fx.php, made sure the includes folder is where it is supposed to be,
>> re-verified the php.ini is pointing to that folder, made sure all the
>> includes are in there ... I am out of ideas and about to pull my hair
>> out!!  Anyone have any suggestions??
>>
>> Trish
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>
>> _______________________________________________
>> 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
>