execute block my php script

[tatoosa]

hello,

i'm a beginner, i have problem with a php script, i run it (1/2  minutes), reaches the command execute() and then it stop with no error message.

this is the script:

 

$fm_a = new FileMaker($file, $host, $username, $password);
$a_table = $fm_a ->newFindCommand('layout_name');

$a_table->addFindCriterion('online', '1');
$a_result = $a_table->execute();
if (FileMaker::isError($iconografia_result)) {

.......

where i'm a wrong? 

thanx for your time and collaboration

Simone

 

[ggt667]

How do you know that the script reaches execute()?

I would have to do a print_r( $a_result ); on a new line immediately after the line that ends with execute();

[tatoosa]

 

thanx for your collaboration !

I put the echo to figure out where it stops.

I think about a FM timeout but  I did extend the time.

the problem continue

[ggt667]

To check that you have connection just paste this in your browser: http://<<username>>:<<password>>@<<IP-address-of-your WPE>>/fmi/xml/FMPXMLRESULT.xml?-dbnames

Example:  http://wpeuser:[email protected]/fmi/xml/FMPXMLRESULT.xml?-dbnames

Edited April 9, 2016 by ggt667

[tatoosa]

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">

<ERRORCODE>4</ERRORCODE>

<PRODUCT BUILD="11/02/2015" NAME="FileMaker Web Publishing Engine" VERSION="14.0.4.412"/>

<DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT=""/>

<METADATA/>

<RESULTSET FOUND=""/>

</FMPXMLRESULT>

 

 

 

Quote

 

[ggt667]

WPE is on, as you receive a message like this ERRORCODE 4 is returned.

Which URL did you use?

Edited April 11, 2016 by ggt667

[tatoosa]

http://wpeuser:[email protected]/fmi/xml/FMPXMLRESULT.xml?-dbnames

with the correct data

sorry the upper case

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<fmresultset xmlns="http://www.filemaker.com/xml/fmresultset" version="1.0">

<error code="954"/>

<product build="11/02/2015" name="FileMaker Web Publishing Engine" version="14.0.4.412"/>

<datasource database="" date-format="" layout="" table="" time-format="" timestamp-format="" total-count=""/>

<metadata/>

<resultset count="" fetch-size=""/>

</fmresultset>

[ggt667]

The one above from: https://fmhelp.filemaker.com/docs/14/en/fms14_cwp_guide.pdf page 46

You can also try this one: http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-layoutnames remember to change to a database you know is there.

Did you create a new account, for example web with a custom privilege set that has the checkbox fmxml and/or fmphp checked?

Edited April 11, 2016 by ggt667

[tatoosa]

ok with no pass and user?

[tatoosa]

ok

now it works... but i think that fm goes in timeout..... can you advise a config for the fm .... i export about 20000 records with 40 field each

thanx for your collaboration

 

[ggt667]

6 hours ago, tatoosa said:

now it works... but i think that fm goes in timeout..... can you advise a config for the fm .... i export about 20000 records with 40 field each

Each month? pr minute?

 

Make sure you create a new layout with only the fields you need for that one query: make sure you have no calculation or summary fields on the query layout.

Edited April 11, 2016 by ggt667

[tatoosa]

i'll check thanx

 

do you think, thet there's a way to put on fm layout only records that have that condition online = 1 ?

thanx!

[ggt667]

Narrowing down the amount of data you work with is always good; but the part you are writing about is in the query, not in the layout.