[FX.php List] What can possibly be wrong?

[Bob Patin]

Well, I did change

define("DEBUG",true) to

define("DEBUG",'true')

and it returned a proper URL, all of which looks good.

I have 2 full-access accounts, and XML is enabled as it should be.  
This is an old FM6 file that I converted to FM8 so that I can move  
this client from 6 to 8 on my servers. This should've taken 15  
minutes, and i've now been on this for an hour. Very frustrating...

I removed all of the POST arguments, so that all I have is this:

<?php
include_once('FX/FX.php');
include_once('FX/server_data.php');

$firstname='Bob Patin';

$create=new FX($serverIP,$webCompanionPort);
$create->SetDBData('<deleted>','<deleted>');
$create->SetDBPassword('<deleted>','<deleted>');

$create->AddDBParam('firstname',$firstname);
$createResult=$create->FMNew();

echo $createResult['errorCode'];
print_r($createResult);
?>

Still nothing. So strange...

I know that with IWP I was cautioned not to IWP-enable more than one  
username, but that doesn't matter in XML, does it? Shouldn't I be  
able to have more than one full-access username (which is the  
privilege set that has XML enabled)?

My next step is to create a db from scratch, but that's such a  
pain... I'm beginning to wonder if perhaps it's something to do with  
having converted this from FM6. I know that sounds absurd, but I'm  
running out of theories.

Any thoughts? Thanks for your help, guys, this one is making me pull  
out what little hair I have...

Bob



On Jul 27, 2006, at 11:29 AM, Dale Bengston wrote:

> Doesn't code => 100 mean it can't access the file for some reason?  
> Are the web accounts set correctly on the hosted file?
>
> Dale
>
> On Jul 27, 2006, at 11:19 AM, Chris Hansen wrote:
>
>> Bob,
>>
>> Nope, this isn't a traditional user name error.  Any time that you  
>> see an XML error within the error object, it means that the data  
>> returned was not valid.  This could be caused by a number of  
>> things (the infamous related field without related records being  
>> one possibility...)  The best was to troubleshoot an XML error is  
>> to use the debug capability built into FX by adding a line like  
>> this near the top of your page:
>>
>> define("DEBUG", true);
>>
>> Then, use the URL returned to directly access the XML.  Some  
>> things to watch for:
>>
>> 1) Are the username and password in the URL correct?
>>
>> 2) Is XML returned when the URL is accessed?
>>
>> 3) Are all XML tags closed properly, or does the XML appear  
>> truncated?
>>
>> That should give you a start.  HTH
>>
>> --Chris Hansen
>>   FileMaker 7 Certified Developer
>>   Creator of FX.php
>>   "The best way from FileMaker to the Web."
>>   www.iViking.org
>>
>>
>> On Jul 27, 2006, at 10:11 AM, Bob Patin wrote:
>>
>>> Dale,
>>>
>>> Thanks for the reply; I keep forgetting about that. I get this:
>>>
>>> fx_error Object ( [error_message_prefix] => [mode] => 1 [level]  
>>> => 1024 [code] => 100 [message] => FX: ExecuteQuery XML error:  
>>> syntax error at line 1 [userinfo] => [backtrace] => Array ( [0]  
>>> => Array ( [file] => /Library/WebServer/Documents/newvisions/FX/ 
>>> FX.php [line] => 879 [function] => fx_error [class] => fx_error  
>>> [type] => -> [args] => Array ( [0] => ExecuteQuery XML error:  
>>> syntax error at line 1 ) ) [1] => Array ( [file] => /Library/ 
>>> WebServer/Documents/newvisions/FX/FX.php [line] => 1041  
>>> [function] => executequery [class] => fx [type] => -> [args] =>  
>>> Array ( [0] => -new ) ) [2] => Array ( [file] => /Library/ 
>>> WebServer/Documents/newvisions/FX/FX.php [line] => 1106  
>>> [function] => fmaction [class] => fx [type] => -> [args] => Array  
>>> ( [0] => -new [1] => 1 [2] => full ) ) [3] => Array ( [file] => / 
>>> Library/WebServer/Documents/newvisions/request_process.php [line]  
>>> => 17 [function] => fmnew [class] => fx [type] => -> [args] =>  
>>> Array ( ) ) ) [callback] => )
>>>
>>> Does the first part of this mean that i have a username error?  
>>> That's so odd, since it's my name and normal password that I use  
>>> for web apps.
>>>
>>>
>>> _______________________________________________
>>> 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