[FX.php List] First try with WPE and FM Server 13... fail...

[Nick]

I imagine you just need to use fmalt instead of FMPro7 and also make sure
you have the latest FX from github.


On Mon, Mar 17, 2014 at 10:35 PM, Bob Patin <bob at patin.com> wrote:

> Hey Dale,
>
> I've always left the extension on database filenames, and I know they're
> not necessary, but it's an old habit... it didn't fix the issue,
> unfortunately.
>
> print_r returns a lot though; when I try the URL
>
> http://bob
> patin:password at 208.52.164.176:80/fmi/xml/FMPXMLRESULT.xml?-db=wpe_test&-lay=data&-max=50&-findall
>
> I do get results though...
>
> Here's what print_r returns (there's more, but...)
>
> I'd love to get this working... :)
>
> Thanks,
>
> Bob
>
>
> FX_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024
> [code] => 100 [message] => FX: cURL could not retrieve Post data in
> RetrieveFM7Data(). A bad URL is the most likely reason. [userinfo] =>
> [backtrace] => Array ( [0] => Array ( [file] =>
> /Library/WebServer/Documents/longterm/FX/FX.php [line] => 649 [function] =>
> FX_Error [class] => FX_Error [object] => FX_Error Object *RECURSION* [type]
> => -> [args] => Array ( [0] => cURL could not retrieve Post data in
> RetrieveFM7Data(). A bad URL is the most likely reason. ) ) [1] => Array (
> [file] => /Library/WebServer/Documents/longterm/FX/FX.php [line] => 1455
> [function] => RetrieveFM7Data [class] => FX [object] => FX Object (
> [dataServer] => 208.52.164.176 [dataServerType] => FMPro7 [dataPort] => 80
> [dataPortSuffix] => :80 [urlScheme] => http [useSSLProtocol] => [database]
> => wpe_test [layout] => data [responseLayout] => [groupSize] => 3
> [currentSkip] => 0 [defaultOperator] => bw [dataParams] => Array ( )
> [sortParams] => Array ( ) [actionArray] => Array ( [-delete] => -delete
> [-dup] => -dup [-edit] => -edit [-find] => -find [-findall] => -findall
> [-findany] => -findany [-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] => [dataURL] => http://bob
> patin:password at 208.52.164.176:80/fmi/xml/FMPXMLRESULT.xml?-db=wpe_test&-lay=data&-max=3&-findall[dataURLParams] => -db=wpe_test&-lay=data&-max=3&-findall [dataQuery] =>
> [charSet] => [dataParamsEncoding] => [currentFlag] => [currentRecord] =>
> [currentField] => [currentValueList] => [fieldCount] => 0 [columnCount] =>
> -1 [fxError] => No Action Taken [errorTracking] => 0 [useInnerArray] => 1
> [DBUser] => bob patin [DBPassword] => password [userPass] => bob
> patin:password@ [defaultPostPolicy] => 1 [isPostQuery] => 1 [useCURL] =>
> 1 [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 connect to FileMaker. 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 WPE configuration.
>
>
>
> On Mar 17, 2014, at 10:18 PM, Dale Bengston <dale.bengston at gmail.com>
> wrote:
>
> Hi Bob,
>
> You could try removing the extension from the database name. It's not
> needed. Also, try
>
> print_r($qResult);
>
> ... and see what the full error object tells you.
>
> Dale
>
> On Mar 17, 2014, at 10:14 PM, Bob Patin <bob at patin.com> wrote:
>
> I had no trouble when I moved web apps to FMSA 12, but with FMS 13 I've
> hit a brick wall.
>
> Here's my test query:
>
> <?php
>
> include_once('FX/FX.php');
>
> // perform query
> $q =new FX('xxx.xxx.xxx.xxx','80', 'FMPro7', 'http');
> $q->SetDBData('wpe_test.fmp12','data' );
> $q->SetDBPassword('password','bob patin');
> $qResult = $q->FMFindAll();
>
> echo 'Error: '.$qResult['errorCode'];
>
> ?>
>
> Anyone see a reason why this shouldn't work, assuming that
>
> a) database exists, is online, and has XML enabled in priv. set;
> b) web pub. engine is working and tests fine on FMS 13
> c) username/password are valid
>
> ?
>
> Thanks,
>
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> FileMaker 9, 10, 11 & 12 Certified Developer
> http://www.longtermsolutions.com
> -
> iChat: bobpatin at me.com
> Twitter: bobpatin
> --
> FileMaker Consulting
> FileMaker Hosting for all versions of FileMaker
> PHP * Full email services * Free DNS hosting * Colocation * Consulting
>
>
> _______________________________________________
> 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
>
>
>
> _______________________________________________
> 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/20140317/87c06db7/attachment-0001.html