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

[Ness, David]

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<mailto: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<mailto: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/a5b6ad5f/attachment-0001.html