[FX.php List] Trouble with fx.php and update from FMSA11 to FMS13

Dale Bengston dale.bengston at gmail.com
Wed Mar 19 13:53:59 MDT 2014

Previous message: [FX.php List] Trouble with fx.php and update from FMSA11 to FMS13
Next message: [FX.php List] Trouble with fx.php and update from FMSA11 to FMS13
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

RetrieveFM5Data? 


On Mar 19, 2014, at 2:37 PM, Ness, David <dness at bondedbuilders.com> wrote:

> This is the result of the print_r($queryResult);
>  
> FX_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => 100 [message] => FX: ExecuteQuery XML error: Not well-formed (invalid token) at line 1 [userinfo] => [backtrace] => Array ( [0] => Array ( [file] => D:\websites\dev.MyBBWG\FX\datasource_classes\RetrieveFM5Data.class.php [line] => 165 [function] => FX_Error [class] => FX_Error [object] => FX_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => ExecuteQuery XML error: Not well-formed (invalid token) at line 1 ) ) [1] => Array ( [file] => D:\websites\dev.MyBBWG\FX\FX.php [line] => 309 [function] => doQuery [class] => RetrieveFM5Data [object] => RetrieveFM5Data Object ( [currentFlag] => [currentValueList] => [currentValueListElement] => [currentRecord] => [currentSubrecordIndex] => [currentField] => [currentFieldIndex] => [columnCounter] => -1 [dataURL] =>http://php_system:m0t10n@10.30.8.173:80/FMPro?-db=Online+Enrollments&-lay=oe_systemwide_preferences&-format=-fmp_xml&-max=1&-op=eq&constant=1&-find [dataURLParams] => -db=Online+Enrollments&-lay=oe_systemwide_preferences&-format=-fmp_xml&-max=1&-op=eq&constant=1&-find [invalidXMLChars] => Array ( [0] => [1] =>  [2] =>  ) [UTF8SpecialChars] => Array ( [0] => |([Â-ß])([€-¿])|e [1] => |(à)([ -¿])([€-¿])|e [2] => |([á-ï])([€-¿])([€-¿])|e [3] => |(ð)([-¿])([€-¿])([€-¿])|e [4] => |([ñ-ó])([€-¿])([€-¿])([€-¿])|e [5] => |(ô)([€-])([€-¿])([€-¿])|e ) [UTF8HTMLEntities] => Array ( [0] => $this->FX->BuildExtendedChar('\1','\2') [1] => $this->FX->BuildExtendedChar('\1','\2','\3') [2] => $this->FX->BuildExtendedChar('\1','\2','\3') [3] => $this->FX->BuildExtendedChar('\1','\2','\3','\4') [4] => $this->FX->BuildExtendedChar('\1','\2','\3','\4') [5] => $this->FX->BuildExtendedChar('\1','\2','\3','\4') ) [FX] => FX Object ( [dataServer] => 10.30.8.173 [dataServerType] => fmpro [dataServerVersion] => 0 [dataPort] => 80 [dataPortSuffix] => :80 [urlScheme] => http [useSSLProtocol] => [verifyPeer] => 1 [database] => Online Enrollments [layout] => oe_systemwide_preferences [responseLayout] => [groupSize] => 1 [currentSkip] => 0 [defaultOperator] => bw [findquerynumber] => 1 [findquerystring] => [dataParams] => Array ( [0] => Array ( [name] => constant [value] => 1 [op] => eq ) ) [sortParams] => Array ( ) [actionArray] => Array ( [-delete] => -delete [-dup] => -dup [-edit] => -edit [-find] => -find [-findall] => -findall [-findany] => -findany [-findquery] => -findquery [-new] => -new [-view] => -view [-dbnames] => -dbnames [-layoutnames] => -layoutnames [-scriptnames] => -scriptnames [-sqlquery] => -sqlquery [delete] => -delete [duplicate] => -dup [update] => -edit [perform_find] => -find [show_all] => -findall [show_any] => -findany [new] => -new [view_layout_objects] => -view [view_database_names] => -dbnames [view_layout_names] => -layoutnames [view_script_names] => -scriptnames ) [primaryKeyField] => [modifyDateField] => [dataKeySeparator] => [fuzzyKeyLogic] => [genericKeys] => [selectColsSet] => [selectColumns] => [fieldInfo] => Array ( ) [currentData] => Array ( ) [valueLists] => Array ( ) [totalRecordCount] => -1 [foundCount] => -1 [dateFormat] => [timeFormat] => [dataQuery] => [charSet] => [dataParamsEncoding] => [remainNames] => Array ( ) [remainNamesReverse] => Array ( ) [portalAsRecord] => [usePortalIDs] => [fieldCount] => 0 [fxError] => No Action Taken [errorTracking] => 0 [useInnerArray] => 1 [useComma2Period] => [DBUser] => php_system [DBPassword] => m0t10n [userPass] => php_system:m0t10n@ [defaultPostPolicy] => 1 [isPostQuery] => 1 [defaultFOpenPolicy] => [isFOpenQuery] => [useCURL] => 1 [customPrimaryKey] => [lastLinkPrevious] => [lastLinkNext] => [lastFoundCount] => -2 [lastFields] => Array ( ) [lastURL] => [lastQuery] => [lastQueryParams] => Array ( ) [lastErrorCode] => -2 [lastValueLists] => Array ( ) [lastDebugMessage] =>
> Instantiating FX.php.
> Configuring database connection...
> Setting user name and password...
> Unable to parse FileMaker XML. Use the DEBUG constant and try connecting with the resulting URL manually.
> You should also double check the user name and password used, the server address and port, and Web Companion configuration.
> Finally, be sure that you have specified the correct data type (e.g. FileMaker 5 or 6 versus 7 or 8.)
> [fuzzyFXPass] => [columnCount] => -1 ) ) [type] => -> [args] => Array ( [0] => -find ) ) [2] => Array ( [file] => D:\websites\dev.MyBBWG\FX\FX.php [line] => 464 [function] => ExecuteQuery [class] => FX [object] => FX Object ( [dataServer] => 10.30.8.173 [dataServerType] => fmpro [dataServerVersion] => 0 [dataPort] => 80 [dataPortSuffix] => :80 [urlScheme] => http [useSSLProtocol] => [verifyPeer] => 1 [database] => Online Enrollments [layout] => oe_systemwide_preferences [responseLayout] => [groupSize] => 1 [currentSkip] => 0 [defaultOperator] => bw [findquerynumber] => 1 [findquerystring] => [dataParams] => Array ( [0] => Array ( [name] => constant [value] => 1 [op] => eq ) ) [sortParams] => Array ( ) [actionArray] => Array ( [-delete] => -delete [-dup] => -dup [-edit] => -edit [-find] => -find [-findall] => -findall [-findany] => -findany [-findquery] => -findquery [-new] => -new [-view] => -view [-dbnames] => -dbnames [-layoutnames] => -layoutnames [-scriptnames] => -scriptnames [-sqlquery] => -sqlquery [delete] => -delete [duplicate] => -dup [update] => -edit [perform_find] => -find [show_all] => -findall [show_any] => -findany [new] => -new [view_layout_objects] => -view [view_database_names] => -dbnames [view_layout_names] => -layoutnames [view_script_names] => -scriptnames ) [primaryKeyField] => [modifyDateField] => [dataKeySeparator] => [fuzzyKeyLogic] => [genericKeys] => [selectColsSet] => [selectColumns] => [fieldInfo] => Array ( ) [currentData] => Array ( ) [valueLists] => Array ( ) [totalRecordCount] => -1 [foundCount] => -1 [dateFormat] => [timeFormat] => [dataQuery] => [charSet] => [dataParamsEncoding] => [remainNames] => Array ( ) [remainNamesReverse] => Array ( ) [portalAsRecord] => [usePortalIDs] => [fieldCount] => 0 [fxError] => No Action Taken [errorTracking] => 0 [useInnerArray] => 1 [useComma2Period] => [DBUser] => php_system [DBPassword] => m0t10n [userPass] => php_system:m0t10n@ [defaultPostPolicy] => 1 [isPostQuery] => 1 [defaultFOpenPolicy] => [isFOpenQuery] => [useCURL] => 1 [customPrimaryKey] => [lastLinkPrevious] => [lastLinkNext] => [lastFoundCount] => -2 [lastFields] => Array ( ) [lastURL] => [lastQuery] => [lastQueryParams] => Array ( ) [lastErrorCode] => -2 [lastValueLists] => Array ( ) [lastDebugMessage] =>
> Instantiating FX.php.
> Configuring database connection...
> Setting user name and password...
> Unable to parse FileMaker XML. Use the DEBUG constant and try connecting with the resulting URL manually.
> You should also double check the user name and password used, the server address and port, and Web Companion configuration.
> Finally, be sure that you have specified the correct data type (e.g. FileMaker 5 or 6 versus 7 or 8.)
> [fuzzyFXPass] => [columnCount] => -1 ) [type] => -> [args] => Array ( [0] => -find ) ) [3] => Array ( [file] => D:\websites\dev.MyBBWG\FX\FX.php [line] => 879 [function] => FMAction [class] => FX [object] => FX Object ( [dataServer] => 10.30.8.173 [dataServerType] => fmpro [dataServerVersion] => 0 [dataPort] => 80 [dataPortSuffix] => :80 [urlScheme] => http [useSSLProtocol] => [verifyPeer] => 1 [database] => Online Enrollments [layout] => oe_systemwide_preferences [responseLayout] => [groupSize] => 1 [currentSkip] => 0 [defaultOperator] => bw [findquerynumber] => 1 [findquerystring] => [dataParams] => Array ( [0] => Array ( [name] => constant [value] => 1 [op] => eq ) ) [sortParams] => Array ( ) [actionArray] => Array ( [-delete] => -delete [-dup] => -dup [-edit] => -edit [-find] => -find [-findall] => -findall [-findany] => -findany [-findquery] => -findquery [-new] => -new [-view] => -view [-dbnames] => -dbnames [-layoutnames] => -layoutnames [-scriptnames] => -scriptnames [-sqlquery] => -sqlquery [delete] => -delete [duplicate] => -dup [update] => -edit [perform_find] => -find [show_all] => -findall [show_any] => -findany [new] => -new [view_layout_objects] => -view [view_database_names] => -dbnames [view_layout_names] => -layoutnames [view_script_names] => -scriptnames ) [primaryKeyField] => [modifyDateField] => [dataKeySeparator] => [fuzzyKeyLogic] => [genericKeys] => [selectColsSet] => [selectColumns] => [fieldInfo] => Array ( ) [currentData] => Array ( ) [valueLists] => Array ( ) [totalRecordCount] => -1 [foundCount] => -1 [dateFormat] => [timeFormat] => [dataQuery] => [charSet] => [dataParamsEncoding] => [remainNames] => Array ( ) [remainNamesReverse] => Array ( ) [portalAsRecord] => [usePortalIDs] => [fieldCount] => 0 [fxError] => No Action Taken [errorTracking] => 0 [useInnerArray] => 1 [useComma2Period] => [DBUser] => php_system [DBPassword] => m0t10n [userPass] => php_system:m0t10n@ [defaultPostPolicy] => 1 [isPostQuery] => 1 [defaultFOpenPolicy] => [isFOpenQuery] => [useCURL] => 1 [customPrimaryKey] => [lastLinkPrevious] => [lastLinkNext] => [lastFoundCount] => -2 [lastFields] => Array ( ) [lastURL] => [lastQuery] => [lastQueryParams] => Array ( ) [lastErrorCode] => -2 [lastValueLists] => Array ( ) [lastDebugMessage] =>
> Instantiating FX.php.
> Configuring database connection...
> Setting user name and password...
> Unable to parse FileMaker XML. Use the DEBUG constant and try connecting with the resulting URL manually.
> You should also double check the user name and password used, the server address and port, and Web Companion configuration.
> Finally, be sure that you have specified the correct data type (e.g. FileMaker 5 or 6 versus 7 or 8.)
> [fuzzyFXPass] => [columnCount] => -1 ) [type] => -> [args] => Array ( [0] => -find [1] => 1 [2] => full [3] => 1 ) ) [4] => Array ( [file] => D:\websites\dev.MyBBWG\index.php [line] => 330 [function] => FMFind [class] => FX [object] => FX Object ( [dataServer] => 10.30.8.173 [dataServerType] => fmpro [dataServerVersion] => 0 [dataPort] => 80 [dataPortSuffix] => :80 [urlScheme] => http [useSSLProtocol] => [verifyPeer] => 1 [database] => Online Enrollments [layout] => oe_systemwide_preferences [responseLayout] => [groupSize] => 1 [currentSkip] => 0 [defaultOperator] => bw [findquerynumber] => 1 [findquerystring] => [dataParams] => Array ( [0] => Array ( [name] => constant [value] => 1 [op] => eq ) ) [sortParams] => Array ( ) [actionArray] => Array ( [-delete] => -delete [-dup] => -dup [-edit] => -edit [-find] => -find [-findall] => -findall [-findany] => -findany [-findquery] => -findquery [-new] => -new [-view] => -view [-dbnames] => -dbnames [-layoutnames] => -layoutnames [-scriptnames] => -scriptnames [-sqlquery] => -sqlquery [delete] => -delete [duplicate] => -dup [update] => -edit [perform_find] => -find [show_all] => -findall [show_any] => -findany [new] => -new [view_layout_objects] => -view [view_database_names] => -dbnames [view_layout_names] => -layoutnames [view_script_names] => -scriptnames ) [primaryKeyField] => [modifyDateField] => [dataKeySeparator] => [fuzzyKeyLogic] => [genericKeys] => [selectColsSet] => [selectColumns] => [fieldInfo] => Array ( ) [currentData] => Array ( ) [valueLists] => Array ( ) [totalRecordCount] => -1 [foundCount] => -1 [dateFormat] => [timeFormat] => [dataQuery] => [charSet] => [dataParamsEncoding] => [remainNames] => Array ( ) [remainNamesReverse] => Array ( ) [portalAsRecord] => [usePortalIDs] => [fieldCount] => 0 [fxError] => No Action Taken [errorTracking] => 0 [useInnerArray] => 1 [useComma2Period] => [DBUser] => php_system [DBPassword] => m0t10n [userPass] => php_system:m0t10n@ [defaultPostPolicy] => 1 [isPostQuery] => 1 [defaultFOpenPolicy] => [isFOpenQuery] => [useCURL] => 1 [customPrimaryKey] => [lastLinkPrevious] => [lastLinkNext] => [lastFoundCount] => -2 [lastFields] => Array ( ) [lastURL] => [lastQuery] => [lastQueryParams] => Array ( ) [lastErrorCode] => -2 [lastValueLists] => Array ( ) [lastDebugMessage] =>
> Instantiating FX.php.
> Configuring database connection...
> Setting user name and password...
> Unable to parse FileMaker XML. Use the DEBUG constant and try connecting with the resulting URL manually.
> You should also double check the user name and password used, the server address and port, and Web Companion configuration.
> Finally, be sure that you have specified the correct data type (e.g. FileMaker 5 or 6 versus 7 or 8.)
> [fuzzyFXPass] => [columnCount] => -1 ) [type] => -> [args] => Array ( ) ) ) [callback] => )
>  
>  
> David Ness
> FileMaker & Web Applications Developer
>  
> Bonded Builders Warranty Group
> 800-749-0381 x3123
>  
> From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dale Bengston
> Sent: Wednesday, March 19, 2014 3:20 PM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Trouble with fx.php and update from FMSA11 to FMS13
>  
> Hi David,
>  
> Your foreach loop is addressing $queryResult as an array, but in the case of an error from FX.php, $queryResult is an object. Try doing print_r($queryResult) at that point to see what the error object contains.
>  
> Dale
>  
>  
> On Mar 19, 2014, at 1:59 PM, Ness, David <dness at bondedbuilders.com> wrote:
> 
> 
> I, also, need some help.
>  
> I have a working FMSA v11/fx.php v4.5.1 solution that’s been running great for years.
>  
> It’s time I tackle the update to FMS v13.
>  
> Updating FileMaker server to 13 resulted in fx.php failure. I downloaded and swapped fx.php v4.5.1 for FX.php v6.0
> This is a new server. Port 80 is open between web server and FMSv13 machine.
>  
> No joy.
>  
> The php error log has this entry:
> [19-Mar-2014 18:51:11 UTC] PHP Fatal error:  Cannot use object of type FX_Error as array in D:\websites\dev.MyBBWG\index.php on line 331
>  
> Line 331 of my code is:
> foreach ($queryResult['data'] as $key => $message_data) {
> …
>  
> The FMS13 Log (Web Publishing Core) has this entry:
> Type = Error, Event = 0, Description = 10.30.8.173 168.50.115:55019 php_system XML 4 497 “fmi/xml/FMPXMLRESULT.xml”
>  
>  
>  
> I have no clue how to proceed.
> Any help is great appreciated.
>  
> Probably nothing; what’s the port 55019 indicate in the log error?
>  
>  
>  
> David Ness
> FileMaker & Web Applications Developer
>  
> Bonded Builders Warranty Group
> 800-749-0381 x3123
>  
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>  
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20140319/527153af/attachment-0001.html

Previous message: [FX.php List] Trouble with fx.php and update from FMSA11 to FMS13
Next message: [FX.php List] Trouble with fx.php and update from FMSA11 to FMS13
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the FX.php_List mailing list