Problems converting Custom Web Publishing scripts from12 to 15

[Tony Morosco]

Hello,

I am trying to convert a custom web publishing site in php, from FM Server 12 to FM Server 15.    We've updated the Windows machine that hosts it (to a shared server on the recommendation of IT) and installed FM Server 15.  

Direct opening of the existing scripts always yields 0 results, though the database hasn't changed.  

Is there some setting, somewhere, that I am oblivious to?   I've consulted user's manuals, IIS settings, web postings, ...

Attached is a copy of the website I am running.

I can point you to the existing website, though I doubt it would be useful.  The beginning part of this website are script tracking errors.  I've been inserting them, trying to track down where this error is creeping up.  So please ignore.

Please ask any additional questions, I am sure there are many.

Cheers,

Tony

 

 

PublicPortal.zip

[jbschwartz]

A number of things come to mind:

1) Updating the machine (probably) involves updating to a new php versions and IIS, either of which could be playing  a part in the failure.  Come back to that later after #2.

2) I would want to know what $result FMP Server is reporting after any query.  Try adding print_r($result); exit; after the query to see how FMP is responding..

 

Hope that helps.

Jonathan

[Tony Morosco]

Hi Jonathan,

Early on, I did end up reverting the php back to the FileMaker supplied files, and removed the extraneous php version that IT  had installed.  However I seem to be running into the same issue, so the versioning does not seem to be an issue.  I'm now running under php 5.6.24, and Microsoft Windows 2012 R2 Standard.

For the second question, I've inserted this directly after the database call.  Here is what it produces: 

FileMaker_Result Object
(
    [_impl] => FileMaker_Result_Implementation Object
        (
            [_fm] => FileMaker_Implementation Object
                (
                    [V73ee434e] => Array
                        (
                            [charset] => UTF-8
                            [locale] => en
                            [logLevel] => 3
                            [hostspec] => http://127.0.0.1
                            [recordClass] => FileMaker_Record
                            [prevalidate] =>
                            [database] => location
                            [username] =>
                            [password] =>
                        )

                    [Vea4b3413] =>
                    [V9a3dcbce] =>
                )

            [_layout] =>
            [_records] =>
            [_tableCount] =>
            [_foundSetCount] =>
            [_fetchCount] =>
        )

 

 

[jbschwartz]

Tony,

Looks like you received a valid result from the query. I assume that there was more to the result other than what you posted. 

Moving forward,  what happens after this?

[Tony Morosco]

19 hours ago, jbschwartz said:

Tony,

Looks like you received a valid result from the query. I assume that there was more to the result other than what you posted. 

Moving forward,  what happens after this?

If I follow up the print_r($result); with the following, 

     $statusLinks = getStatusLinks("recordlist.php", $result, $skip, $max);
     $records = $result->getRecords();   
     echo "\n<P>Records: ";
     echo $statusLinks['records']['rangestart'];
     echo " - "; 
     echo $statusLinks['records']['rangeend'];
     echo " of "; 
     echo $statusLinks['records']['foundcount'];
     echo ". <P>\n";
     exit;

I still get the following:

Records: 0 - 0 of 0.

I know this script ran for many years under a previous version of FileMaker, so very frustrating for me to update!  :-P  I did the initial design, but had a little thing called an AVM since then (a stroke.)

[jbschwartz]

Tony,

This looks like code generated by SiteAssistant...which was a flawed concept from the start.  But we won't go there.

Going back to the $result you posted, I realized that it's not returning any results. Everything up to the last 5 lines is normal. but the last 5 lines represent arrays (layout, records, etc) and is supposed to be populated with literally hundreds/thousands lines of data.  Can't expect the record link functions to work without having data to work with.

Is this system online? I can try and resolve from here.

[Tony Morosco]

Hi Jonathan ,

Yes, this site was originally generated in SiteAssistant back in 2010 or so.   It's only recently updated to FileMaker Server 15 this year, thus the problems.  

Yes, I know it isn't returning any results, which is what I was looking for.  I probably didn't phrase it very well.

The online website is at http://cornucopia.sfbg.org/PublicPortal/home.php
and called PlantFinder.   (Obviously it looks for specimens at a botanical garden for the public.)

But I presume you need to get into the computer.   Will have to see if I can swing that. 

Why don't you contact me and I'll see what I can do!  [email protected]

 

Many thanks!  I'll post any follow-up results here, once we get this solved.

Cheers,

Tony

[Tony Morosco]

Hi all,

We ended up re-creating the site in FM WebDirect. 

It was much simpler, than trying to suss out the problems with the older pHp custom web publishing scripts.

So I am sure this thread won't be of much help for future researchers.

Cheers,

Tony