[FX.php List] RE: Form not seeing database (XPOST)

[VanBuskirk, Patricia]

Thanks Dale for responding!  What is strange is that these forms have been working as they are for years.  This happened the first time I set up the new server, but I cannot remember what we had to do to fix it … I am thinking I changed the find for the dropdown to look at the other database, instead of a layout  through a external relationship/TO in the orders database.

I set debug to true in the server data file, and the following line showed up in the dropdown list:
“Notice: Undefined index: ListForWeb in …” it goes on to list the file name.

I haven’t tried submitting it again yet.  Do you know of a simple way to test the database connection?  For the life of me, I can’t remember the simplest of tasks.  :-\  Could be that I’ve trained and learned two other systems for my job and FM is now just in limbo until they convert it to another database program.

~ Trish

From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dale Bengston
Sent: Saturday, June 23, 2012 4:24 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] RE: Form not seeing database (XPOST)

Hi Trish,

Second error first - your code is expecting an array and it's getting a php error object: FX_Error. Do a print_r on the variable in line 106 that's supposed to be your fx data array. You should then get better feedback about what's happening.

First error second. If your popup menu is truncating in the middle and breaking the page, it may have an element that contains corrupt data or characters being interpreted as an HTML entity. Try viewing source on the page to see if thempage code continues past where it stops drawing on the screen. With luck, it'll show you exactly which value is causing the fail.

Hope that helped,
Dale


On Jun 23, 2012, at 7:36 PM, "VanBuskirk, Patricia" <pvanbuskirk at fsu.edu<mailto:pvanbuskirk at fsu.edu>> wrote:
I took out all the dropdown php info and tried to submit the form without it.  Got this error back:
Catchable fatal error: Object of class FX_Error could not be converted to string in E:\Inetpub\wwwroot\Forms\Repair\repairconfirm.php on line 106

~ Trish

From: fx.php_list-bounces at mail.iviking.org<mailto:fx.php_list-bounces at mail.iviking.org> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of VanBuskirk, Patricia
Sent: Saturday, June 23, 2012 1:10 PM
To: FX.php Discussion List
Subject: [FX.php List] Form not seeing database (XPOST)

I have had to re-setup our web server and FM server.   The databases are hosted and open, and have all the correct web settings and were previously working fine (just copied to a backup folder prior to the maintenance work and copied back when completed).

The forms contain dropdown lists that pull in from the database(s) that will not work now.  Does anyone have an idea for why this stopped working?

Here’s an example of the code in the form.  The form stops at that point … doesn’t show the dropdown info, and also doesn’t show any more of the form.  I tried replacing the line that requires the server_data.php file with the actual lines from that file, but that didn’t work either.

<?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('Dept_Directory', 'SG_SectionsLIST', 'all');
//$ordersQuery->SetDBData('WEB_Forms', 'SG_Sections', '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);
    echo "                <option>Student Request\n";
            foreach ($orders as $contact) {
    echo "                <option>{$contact['ListForWeb']}\n";

}
?>


Trish Van Buskirk
Technology Specialist
Information Technology Services
Florida State University
2035 E. Paul Dirac Dr / Tallahassee, FL 32310
Phone: (850) 645-8063
http://www.its.fsu.edu

_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org<mailto:FX.php_List at mail.iviking.org>
http://www.iviking.org/mailman/listinfo/fx.php_list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20120623/6b132190/attachment-0001.html