[FX.php List] Workked on a Mac but not on a PC

John Funk jfunk at criticalsolution.com
Sun Feb 22 14:28:19 MST 2009 

An update on my problem of a few days ago...
The update to 8.0v4r2 did the trick.
Thanks gtt.

John Funk


On 2/19/09 10:26 AM, "John Funk" <jfunk at criticalsolution.com> wrote:

> OK this makes sense. I bet the copy of server was not updated.
>  I will try this first and post my result.
> thanks
> 
> 
> On 2/19/09 10:16 AM, "Gjermund Gusland Thorsen" <ggt667 at gmail.com> wrote:
> 
>> Make sure you have FileMaker Server Advance 8.0v4r2 or whatever is
>> latest FMSA version for 8
>> 
>> ggt
>> 
>> 2009/2/19, Gjermund Gusland Thorsen <ggt667 at gmail.com>:
>>> http://pastebin.com/m33ae3e5f
>>> 
>>> 
>>>  2009/2/19, Gjermund Gusland Thorsen <ggt667 at gmail.com>:
>>>> Hmm your output lacks som closing tags
>>>> 
>>>> 
>>>>  ggt
>>>> 
>>>>  2009/2/19, Gjermund Gusland Thorsen <ggt667 at gmail.com>:
>>>>> 1496 is the last character I would search for ugly chars
>>>>> 
>>>>>  ggt
>>>>> 
>>>>>  2009/2/19, Gjermund Gusland Thorsen <ggt667 at gmail.com>:
>>>>> 
>>>>>> Thanks Steve, now I didn't have to :-p
>>>>>> 
>>>>>>  Where is character 1496 in that string?
>>>>>> 
>>>>>>  It would be easier to do %s/></>^M<
>>>>>> 
>>>>>>  and reevaluate the XML document
>>>>>> 
>>>>>>  ggt
>>>>>> 
>>>>>>  2009/2/19, Steve Winter <steve at bluecrocodile.co.nz>:
>>>>>> 
>>>>>>> and as ggt will no doubt pop up to say, make sure everything is utf8
>>>>>>> encoded
>>>>>>> ;-)
>>>>>>> 
>>>>>>> Cheers
>>>>>>> Steve
>>>>>>> 
>>>>>>> 
>>>>>>> On 19 Feb 2009, at 15:53, Chris Hansen wrote:
>>>>>>> 
>>>>>>> John,
>>>>>>> 
>>>>>>> Is that the entirety of the XML that you get?  If so, there's the
>>>>>>> problem
>>>>>>> --
>>>>>>> the XML isn't closed properly.  My guess is that there's a character
>>>>>>> (possibly invisible) in there that is forbidden by XML.  FileMaker has
>>>>>>> gotten increasingly good about handling this as versions have
>>>>>>> progressed,
>>>>>>> so
>>>>>>> it doesn't surprise me that an XML problem would crop up when you went
>>>>>>> backwards.  Also, Windows tends to be worse about invisible characters,
>>>>>>> in
>>>>>>> my experience, so there's something of a double whammy here.
>>>>>>> 
>>>>>>> So... the fix... you know in which record the problem is -- Record ID
>>>>>>> 102
>>>>>>> --
>>>>>>> and you know in which field (most likely) the problem lies since output
>>>>>>> died
>>>>>>> before it -- Skaters_Sessions::Testdata.  Have a look in there and see
>>>>>>> what
>>>>>>> you find.
>>>>>>> 
>>>>>>> HTH
>>>>>>> 
>>>>>>> --Chris
>>>>>>> 
>>>>>>> On Feb 19, 2009, at 8:30 AM, John Funk wrote:
>>>>>>> 
>>>>>>> I have a very simple html login page that asks for a member number and a
>>>>>>> php
>>>>>>> file that finds the entered member and displays the member info.
>>>>>>> The problem is, this worked on a Mac/ FileMaker Server Advance 9 test
>>>>>>> system
>>>>>>> and now I moved it to a PC (XP) FileMaker Server Advance 8 system (with
>>>>>>> iis)
>>>>>>> and the result does not work. But IWP does work so the config is good.
>>>>>>> 
>>>>>>> This is the xml error I get:
>>>>>>> 
>>>>>>> XML Parsing Error: no element found
>>>>>>> Location:
>>>>>>> 
http://webuser:webpass@192.168.1.3/fmi/xml/FMPXMLRESULT.xml?-db=RFSC+Ses>>>>>>>
s
>>>>>>> ions.fp7&-lay=WEB_Skaters&-max=1&SkaterNumber=%3D%3D1010&-find
>>>>>>> Line Number 1, Column 1496:
>>>>>>> 
>>>>>>> 
>>>>>>> This is the XML result from the debug url:
>>>>>>> 
>>>>>>> <?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE
>>>>>>> FMPXMLRESULT
>>>>>>> PUBLIC "-//FMI//DTD FMPXMLRESULT//EN"
>>>>>>> "/fmi/xml/FMPXMLRESULT.dtd"><FMPXMLRESULT
>>>>>>> 
xmlns="http://www.filemaker.com/fmpxmlresult"><ERRORCODE>0</ERRORCODE><P>>>>>>>
R
>>>>>>> ODUCT
>>>>>>> BUILD="11/14/2005" NAME="FileMaker Web Publishing Engine"
>>>>>>> VERSION="8.0.2.65"/><DATABASE DATEFORMAT="MM/dd/yyyy"
>>>>>>> LAYOUT="WEB_Skaters"
>>>>>>> NAME="RFSC Sessions.fp7" RECORDS="77"
>>>>>>> TIMEFORMAT="HH:mm:ss"/><METADATA><FIELD EMPTYOK="YES"
>>>>>>> MAXREPEAT="1" NAME="SkaterNumber" TYPE="TEXT"/><FIELD EMPTYOK="YES"
>>>>>>> MAXREPEAT="1" NAME="First" TYPE="TEXT"/><FIELD EMPTYOK="YES"
>>>>>>> MAXREPEAT="1"
>>>>>>> NAME="MI" TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Last"
>>>>>>> TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Sessions"
>>>>>>> TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Season"
>>>>>>> TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Year"
>>>>>>> TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1"
>>>>>>> NAME="Skaters_Sessions::Season" TYPE="TEXT"/><FIELD
>>>>>>> EMPTYOK="YES" MAXREPEAT="1"
>>>>>>> NAME="Skaters_Sessions::SkaterNumber" TYPE="TEXT"/><FIELD
>>>>>>> EMPTYOK="YES" MAXREPEAT="1"
>>>>>>> NAME="Skaters_Sessions::SessionNumber" TYPE="TEXT"/><FIELD
>>>>>>> EMPTYOK="YES" MAXREPEAT="1"
>>>>>>> NAME="Skaters_Sessions::Testdata"
>>>>>>> TYPE="TEXT"/></METADATA><RESULTSET FOUND="1"><ROW
>>>>>>> MODID="25"
>>>>>>> 
RECORDID="102"><COL><DATA>1010</DATA></COL><COL><DATA>Emma</DATA></COL><>>>>>>>
C
>>>>>>> 
OL><DATA></DATA></COL><COL><DATA>Erler</DATA></COL><COL><DATA></DATA></C>>>>>>>
O
>>>>>>> 
L><COL><DATA>Winter</DATA></COL><COL><DATA>2008</DATA></COL><COL></COL><>>>>>>>
C
>>>>>>> OL></COL><COL></COL>
>>>>>>> 
>>>>>>> Is this an iis problem? Where do I start?
>>>>>>> I can send the php if required.
>>>>>>> 
>>>>>>> 
>>>>>>> Thanks
>>>>>>> John Funk
>>>>>>> _______________________________________________
>>>>>>> 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
>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>>>> Steve Winter
>>>>>>> steve at bluecrocodile.co.nz
>>>>>>> m: +44 77 7852 4776
>>>>>>> 3 Calshot Court, Channel Way
>>>>>>> Ocean Village, Southampton SO14 3GR
>>>>>>> 
>>>>>>> _______________________________________________
>>>>>>>  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
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

More information about the FX.php_List mailing list