Jump to content
Sign in to follow this  
brainonastick

FX.php error message

Recommended Posts

We are having trouble getting our databases to accept data from web forms using using FX.PHP.

We get a message about scalar values not being useable in an array and the "current" function is not recognised.

The error code is as follows:

fx_error Object

(

[error_message_prefix] =>

[mode] => 1

[level] => 1024

Code:

=> 100

[message] => FX: ExecuteQuery XML error: mismatched tag at line 6

[userinfo] =>

[backtrace] => Array

(

[0] => Array

(

[file] => /Library/WebServer/Documents/ACWA CCWT Web Site/web-content/FX/FX.php

[line] => 1362

[function] => fx_error

[class] => fx_error

[type] => ->

[args] => Array

(

[0] => ExecuteQuery XML error: mismatched tag at line 6

)

)

[1] => Array

(

[file] => /Library/WebServer/Documents/ACWA CCWT Web Site/web-content/FX/FX.php

[line] => 1529

[function] => executequery

[class] => fx

[type] => ->

[args] => Array

(

[0] => -new

)

)

[2] => Array

(

[file] => /Library/WebServer/Documents/ACWA CCWT Web Site/web-content/FX/FX.php

[line] => 1768

[function] => fmaction

[class] => fx

[type] => ->

[args] => Array

(

[0] => -new

[1] => 1

[2] => full

[3] => 1

)

)

[3] => Array

(

[file] => /Library/WebServer/Documents/ACWA CCWT Web Site/web-content/new_community_event.php

[line] => 8

[function] => fmnew

[class] => fx

[type] => ->

[args] => Array

(

)

)

)

[callback] =>

)

Please advise as how to solve this FX.php bug.

Share this post


Link to post
Share on other sites

Which version of FX are you using?

This error message is usually a permissions error.

Do you have the fmxml privilege set active for the account you are using?

Try adding;

define("DEBUG", true);

to the top of your page (this will allow you to see the URL being passed and let you click directly into that to see if you can actually hit the database that way.

Share this post


Link to post
Share on other sites

Which version of FX are you using?

This error message is usually a permissions error.

Do you have the fmxml privilege set active for the account you are using?

Try adding;

define("DEBUG", true);

to the top of your page (this will allow you to see the URL being passed and let you click directly into that to see if you can actually hit the database that way.

Thanks Andy,

fmxml is checked in extended priveleges for the Admin and fmsadmin access accounts.

We are using FX.php version 4.2.

We have a Mac OSX operating system.

Does the order of the access accounts matter? I have an Admin account listed first and then the fmsadmin account below that.

the serverdata.php file has the UN set o fmsadmin and the PW is currently the same.

Here's what I get when I add your debug code:

Accessing FileMaker Pro 7 data.

Using FileMaker URL: http://fmsadmin:fmsadmin@192.168.100.9:80/fmi/xml/FMPXMLRESULT.xml?-db=Community_Events.fp7&-lay=Community_Events&-max=50&Type_of_Event=test12&Event_Name=&Event_Theme=&Event_Cost=&Event_Description=&Duration=&Event_Starting_Date=&Event_Finishing_Date=&All_Dates=&Venue_Name=&Venue_Street_1=&Venue_Street_2=&Venue_Suburb_Town=&Venue_City=&Venue_State=&Venue_Post_Code=&Venue_Country=&Host_Organisation=&Host_Contact_Phone=&Host_Contact_Fax=&Host_Contact_Email=&Host_Contact_URL=&Organisers_Name=&Organisers_Phone=&Organisers_Fax=&Organisers_Email=&-new

0Array ( [40.0] => Array ( [Event_Name] => Array ( [0] => ) [Event_Theme] => Array ( [0] => ) [Host_Organisation] => Array ( [0] => ) [Event_Description] => Array ( [0] => ) [Event_Cost] => Array ( [0] => ) [Event_Starting_Date] => Array ( [0] => ) [Duration] => Array ( [0] => ) [Event_Finishing_Date] => Array ( [0] => ) [All_Dates] => Array ( [0] => ) [Venue_Name] => Array ( [0] => ) [Venue_Street_1] => Array ( [0] => ) [Venue_Street_2] => Array ( [0] => ) [Venue_State] => Array ( [0] => ) [Venue_Country] => Array ( [0] => ) [Organisers_Contact_Name] => Array ( [0] => ) [Host_Contact_Phone] => Array ( [0] => ) [Host_Contact_Fax] => Array ( [0] => ) [Host_Contact_Email] => Array ( [0] => ) [Host_Contact_URL] => Array ( [0] => ) [Organisers_Phone] => Array ( [0] => ) [Organisers_Fax] => Array ( [0] => ) [Organisers_Email] => Array ( [0] => ) [Venue_Suburb_Town] => Array ( [0] => ) [Venue_Post_Code] => Array ( [0] => ) [Venue_Phone] => Array ( [0] => ) [Venue_Fax] => Array ( [0] => ) [Venue_Email] => Array ( [0] => ) [Venue_URL] => Array ( [0] => ) [Venue_Contact_Person] => Array ( [0] => ) [Host_Street_1] => Array ( [0] => ) [Host_Street_2] => Array ( [0] => ) [Host_Suburb_Town] => Array ( [0] => ) [Host_State] => Array ( [0] => ) [Host_Country] => Array ( [0] => ) [Event_Logo] => Array ( [0] => ) [Host_Post_Code] => Array ( [0] => ) [Record_Created] => Array ( [0] => 04/20/2007 10:12:59 ) [Record_Created_By] => Array ( [0] => fmsadmin ) [Record_Modified_By] => Array ( [0] => fmsadmin ) [Record_Modified] => Array ( [0] => 04/20/2007 10:12:59 ) [Event_Status] => Array ( [0] => ) [Type_of_Event] => Array ( [0] => test12 ) [Venue_City] => Array ( [0] => ) [Download_Flyer] => Array ( [0] => ) [Organisers_Name] => Array ( [0] => ) [Hosts] => Array ( [0] => ) [Month_and_Year] => Array ( [0] => ) ) )

Array

(

[data] => Array

(

[40.0] => Array

(

[Event_Name] => Array

(

[0] =>

)

[Event_Theme] => Array

(

[0] =>

)

[Host_Organisation] => Array

(

[0] =>

)

[Event_Description] => Array

(

[0] =>

)

[Event_Cost] => Array

(

[0] =>

)

[Event_Starting_Date] => Array

(

[0] =>

)

[Duration] => Array

(

[0] =>

)

[Event_Finishing_Date] => Array

(

[0] =>

)

[All_Dates] => Array

(

[0] =>

)

[Venue_Name] => Array

(

[0] =>

)

[Venue_Street_1] => Array

(

[0] =>

)

[Venue_Street_2] => Array

(

[0] =>

)

[Venue_State] => Array

(

[0] =>

)

[Venue_Country] => Array

(

[0] =>

)

[Organisers_Contact_Name] => Array

(

[0] =>

)

[Host_Contact_Phone] => Array

(

[0] =>

)

[Host_Contact_Fax] => Array

(

[0] =>

)

[Host_Contact_Email] => Array

(

[0] =>

)

[Host_Contact_URL] => Array

(

[0] =>

)

[Organisers_Phone] => Array

(

[0] =>

)

[Organisers_Fax] => Array

(

[0] =>

)

[Organisers_Email] => Array

(

[0] =>

)

[Venue_Suburb_Town] => Array

(

[0] =>

)

[Venue_Post_Code] => Array

(

[0] =>

)

[Venue_Phone] => Array

(

[0] =>

)

[Venue_Fax] => Array

(

[0] =>

)

[Venue_Email] => Array

(

[0] =>

)

[Venue_URL] => Array

(

[0] =>

)

[Venue_Contact_Person] => Array

(

[0] =>

)

[Host_Street_1] => Array

(

[0] =>

)

[Host_Street_2] => Array

(

[0] =>

)

[Host_Suburb_Town] => Array

(

[0] =>

)

[Host_State] => Array

(

[0] =>

)

[Host_Country] => Array

(

[0] =>

)

[Event_Logo] => Array

(

[0] =>

)

[Host_Post_Code] => Array

(

[0] =>

)

[Record_Created] => Array

(

[0] => 04/20/2007 10:12:59

)

[Record_Created_By] => Array

(

[0] => fmsadmin

)

[Record_Modified_By] => Array

(

[0] => fmsadmin

)

[Record_Modified] => Array

(

[0] => 04/20/2007 10:12:59

)

[Event_Status] => Array

(

[0] =>

)

[Type_of_Event] => Array

(

[0] => test12

)

[Venue_City] => Array

(

[0] =>

)

[Download_Flyer] => Array

(

[0] =>

)

[Organisers_Name] => Array

(

[0] =>

)

[Hosts] => Array

(

[0] =>

)

[Month_and_Year] => Array

(

[0] =>

)

)

)

[linkNext] =>

[linkPrevious] =>

[foundCount] => 1

[fields] => Array

(

[0] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Event_Name

[type] => TEXT

[extra] =>

)

[1] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Event_Theme

[type] => TEXT

[extra] =>

)

[2] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Host_Organisation

[type] => TEXT

[extra] =>

)

[3] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Event_Description

[type] => TEXT

[extra] =>

)

[4] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Event_Cost

[type] => TEXT

[extra] =>

)

[5] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Event_Starting_Date

[type] => DATE

[extra] =>

)

[6] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Duration

[type] => TEXT

[extra] =>

)

[7] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Event_Finishing_Date

[type] => DATE

[extra] =>

)

[8] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => All_Dates

[type] => TEXT

[extra] =>

)

[9] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_Name

[type] => TEXT

[extra] =>

)

[10] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_Street_1

[type] => TEXT

[extra] =>

)

[11] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_Street_2

[type] => TEXT

[extra] =>

)

[12] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_State

[type] => TEXT

[extra] =>

)

[13] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_Country

[type] => TEXT

[extra] =>

)

[14] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Organisers_Contact_Name

[type] => TEXT

[extra] =>

)

[15] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Host_Contact_Phone

[type] => TEXT

[extra] =>

)

[16] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Host_Contact_Fax

[type] => TEXT

[extra] =>

)

[17] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Host_Contact_Email

[type] => TEXT

[extra] =>

)

[18] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Host_Contact_URL

[type] => TEXT

[extra] =>

)

[19] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Organisers_Phone

[type] => TEXT

[extra] =>

)

[20] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Organisers_Fax

[type] => TEXT

[extra] =>

)

[21] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Organisers_Email

[type] => TEXT

[extra] =>

)

[22] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_Suburb_Town

[type] => TEXT

[extra] =>

)

[23] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_Post_Code

[type] => TEXT

[extra] =>

)

[24] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_Phone

[type] => TEXT

[extra] =>

)

[25] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_Fax

[type] => TEXT

[extra] =>

)

[26] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_Email

[type] => TEXT

[extra] =>

)

[27] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_URL

[type] => TEXT

[extra] =>

)

[28] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_Contact_Person

[type] => TEXT

[extra] =>

)

[29] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Host_Street_1

[type] => TEXT

[extra] =>

)

[30] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Host_Street_2

[type] => TEXT

[extra] =>

)

[31] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Host_Suburb_Town

[type] => TEXT

[extra] =>

)

[32] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Host_State

[type] => TEXT

[extra] =>

)

[33] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Host_Country

[type] => TEXT

[extra] =>

)

[34] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Event_Logo

[type] => CONTAINER

[extra] =>

)

[35] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Host_Post_Code

[type] => TEXT

[extra] =>

)

[36] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Record_Created

[type] => TIMESTAMP

[extra] =>

)

[37] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Record_Created_By

[type] => TEXT

[extra] =>

)

[38] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Record_Modified_By

[type] => TEXT

[extra] =>

)

[39] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Record_Modified

[type] => TIMESTAMP

[extra] =>

)

[40] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Event_Status

[type] => TEXT

[extra] =>

)

[41] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Type_of_Event

[type] => TEXT

[extra] =>

)

[42] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Venue_City

[type] => TEXT

[extra] =>

)

[43] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Download_Flyer

[type] => TEXT

[extra] =>

)

[44] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Organisers_Name

[type] => TEXT

[extra] =>

)

[45] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Hosts

[type] => TEXT

[extra] =>

)

[46] => Array

(

[emptyok] => YES

[maxrepeat] => 1

[name] => Month_and_Year

[type] => NUMBER

[extra] =>

)

)

=> http://fmsadmin:fmsadmin@192.168.100.9:80/fmi/xml/FMPXMLRESULT.xml?-db=Community_Events.fp7&-lay=Community_Events&-max=50&Type_of_Event=test12&Event_Name=&Event_Theme=&Event_Cost=&Event_Description=&Duration=&Event_Starting_Date=&Event_Finishing_Date=&All_Dates=&Venue_Name=&Venue_Street_1=&Venue_Street_2=&Venue_Suburb_Town=&Venue_City=&Venue_State=&Venue_Post_Code=&Venue_Country=&Host_Organisation=&Host_Contact_Phone=&Host_Contact_Fax=&Host_Contact_Email=&Host_Contact_URL=&Organisers_Name=&Organisers_Phone=&Organisers_Fax=&Organisers_Email=&-new

[query] =>

[errorCode] => 0

[valueLists] => Array

(

)

)

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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