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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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