Jump to content

can't add XML/XSLT records in FMSA9, worked in FMSA8


This topic is 6157 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Today I moved our database files to the new server running FMSA 9, our files were previously on a FMSA 8 system.

We have a few scripts in a few places that create records in the database via XML/XSLT/Custom Web Publishing/Whatever and they don't seem to work.

Here's an example:

http://OLD.IPA.DDR.ESS/fmi/xml/fmresultset.xml?-db=CartSales&-lay=Orders&BillingFirstName=Wes&BillingLastName=Plate&BillingCompany=Duck&BillingAddress1=TEST&BillingAddress2=TEST&BillingCity=TEST&BillingState=TEST&BillingZip=TEST&BillingCountry=TEST&BillingPhone=TEST&BillingEmail=TEST&ShippingFirstName=TEST&ShippingLastName=TEST&ShippingCompany=TEST&ShippingAddress1=TEST&ShippingAddress2=TEST&ShippingCity=TEST&ShippingState=TEST&ShippingZip=TEST&ShippingCountry=TEST&ShippingPhone=TEST&ShippingCharge=TEST&CreditCard=TEST&CCExpire=TEST&Comments=TEST&CartOrderID=TEST&-new





This does not work...


http://NEW.IPA.DDR.ESS/fmi/xml/fmresultset.xml?-db=CartSales&-lay=Orders&BillingFirstName=Wes&BillingLastName=Plate&BillingCompany=Duck&BillingAddress1=TEST&BillingAddress2=TEST&BillingCity=TEST&BillingState=TEST&BillingZip=TEST&BillingCountry=TEST&BillingPhone=TEST&BillingEmail=TEST&ShippingFirstName=TEST&ShippingLastName=TEST&ShippingCompany=TEST&ShippingAddress1=TEST&ShippingAddress2=TEST&ShippingCity=TEST&ShippingState=TEST&ShippingZip=TEST&ShippingCountry=TEST&ShippingPhone=TEST&ShippingCharge=TEST&CreditCard=TEST&CCExpire=TEST&Comments=TEST&CartOrderID=TEST&-new

The only difference is the IP address.

Safari gives this error...

safarifilemaker.jpg

And Firefox this error...

firefoxfilemaker.jpg

I'm not sure what I need to do on the new server side, the system is essentially in its default setup, everything is enabled.

Help! :(-)

Link to comment
Share on other sites

Unfortunately calling FileMaker did no good. I guess once you start down the road of Custom Web Publishing, you're officially unsupported.

"But can you tell me why something that worked in FMSA8 doesn't in FMSA9?"

"Sorry, No."

Sorry, I'm venting. I hope someone here can help me.

Link to comment
Share on other sites

Could it be that FMSA9 is now limiting the number of characters in the URL?

This URL works, it is 503 characters

http://XXX.XXX.XXX.XXX/fmi/xml/fmresultset.xml?-db=CartSales&-lay=Orders&BillingFirstName=44555555555511111111112222222222333333333344444444445555555555111111111122222222223333333333444444444455555555551111111111222222222233333333334444444444555555555511111111112222222222333333333344444444445555555555111111111122222222223333333333444444444455555555551111111111222222222233333333334444444444555555555511111111112222222222333333333344444444445555555555111111111122222222223333333333444444444455555555&-new




But if I add one more character to the URL and make it 504 characters, I get XML Parsing Error: no element found


http://XXX.XXX.XXX.XXX/fmi/xml/fmresultset.xml?-db=CartSales&-lay=Orders&BillingFirstName=445555555555111111111122222222223333333333444444444455555555551111111111222222222233333333334444444444555555555511111111112222222222333333333344444444445555555555111111111122222222223333333333444444444455555555551111111111222222222233333333334444444444555555555511111111112222222222333333333344444444445555555555111111111122222222223333333333444444444455555555551111111111222222222233333333334444444444555555555&-new

Does this make sense to anyone?

Link to comment
Share on other sites

SUCCESS!

I called FileMaker back. This new support guy was a bit more helpful. He asked if I'd turned off Performance Cache in the web server. No I'd not. See page 88 of the Getting Started Guide...

Ok, so I disabled it, uninstalled FMSA then reinstalled, now I'm happy. HOORAY!

Link to comment
Share on other sites

This topic is 6157 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.