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.

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.

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:[email protected]: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:[email protected]: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

(

)

)