brainonastick Posted April 19, 2007 Share Posted April 19, 2007 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. Link to comment Share on other sites More sharing options...
andygaunt Posted April 19, 2007 Share Posted April 19, 2007 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. Link to comment Share on other sites More sharing options...
brainonastick Posted April 20, 2007 Author Share Posted April 20, 2007 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 ( ) ) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6210 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 accountSign in
Already have an account? Sign in here.
Sign In Now