Sign Up ›
  • Rmcnulty
  • NEWBIE
  • 0 Points
  • Member since 2007
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 8
    Replies
SOLVED
9 replies

Relationship Query

Hi,
 
I'm having trouble joining 2 tables. I want to get the Account details from the opportunity.
 
My Query:
 
$query = "SELECT Opportunity.Id, Opportunity.Name FROM Opportunity, Account WHERE Opportunity.AccountId = Account.Id";
 
Result:
MALFORMED_QUERY: WHERE Opportunity.AccountId = Account.Id ^ ERROR at Row:1:Column:96 unexpected token: Account.Id
6 replies

INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session

Hi,

I've got a ASP.NET 2.0 application which acquires a session that is passed to it from SF.

I just started getting this message, and am not sure where to go with it.  The code that is running with it has been functioning for a while without any issues, and it still works some of the time.  Also, even though the API calls are server-side, I've only seen this problem when running IE; Firefox hasn't been a problem so far.  I don't have a setting for "lock sessions to originating IP" - this is the developer version.  Does anybody have any suggestions?

Thanks, Jim
21 replies

Fatal error: Uncaught SoapFault exception: [HTTP] Could not connect to host

Hi,

My problem is
Fatal error: Uncaught SoapFault exception: [HTTP] Could not connect to host in /***/soapclient/SforceBaseClient.php:113
Stack trace:
#0 [internal function]: SoapClient->__doRequest('<?xml version="...', 'https://www.sal...', '', 1, 0)
#1 [internal function]: SoapClient->__call('login', Array)
#2 /***/soapclient/SforceBaseClient.php(113): SoapClient->login(Array)
#3 /***/test.php(7): SforceBaseClient->login('username@domain...', 'mypassword')
#4 {main} thrown in /***/soapclient/SforceBaseClient.php on line 113

Settings:
Apache/1.3.37 (Unix)
PHP 5.2.1

curl
cURL support  enabled 
cURL Information  libcurl/7.16.1 OpenSSL/0.9.7e zlib/1.2.3 

openssl
OpenSSL support  enabled 
OpenSSL Version  OpenSSL 0.9.7e-p1 25 Oct 2004 

soap
Soap Client  enabled 
Soap Server  enabled 
Directives
soap.wsdl_cache 1
soap.wsdl_cache_dir /tmp
soap.wsdl_cache_enabled 1
soap.wsdl_cache_limit 5
soap.wsdl_cache_ttl 86400

php.ini
allow_url_fopen = On

Same script is working from my local computer (apache 2.2, php 5.2.3 on windows) with exactly same settings.
I don't see any requirement about Apache version as long as PHP 5 works but it is the only difference beside windows - unix?

Thanks for helping!

Suat

SOLVED
9 replies

Relationship Query

Hi,
 
I'm having trouble joining 2 tables. I want to get the Account details from the opportunity.
 
My Query:
 
$query = "SELECT Opportunity.Id, Opportunity.Name FROM Opportunity, Account WHERE Opportunity.AccountId = Account.Id";
 
Result:
MALFORMED_QUERY: WHERE Opportunity.AccountId = Account.Id ^ ERROR at Row:1:Column:96 unexpected token: Account.Id
26 replies

Fatal Error Connecting Via API

Yesterday evening, connecting via PHP 5.1 was working properly as it has been for some time now. This morning, we're receiving a fatal error. Nothing has changed in our code overnight, and I was wondering if something has changed on the Salesforce side concerning connection.
 
Here's the error:
 
Fatal error: Uncaught SoapFault exception: [soapenv:Client] Element {)item invalid at this location in /path-to/SforceBaseClient.php:79 Stack trace: #0 [internal function]: SoapClient->__call('login', Array) #1 /path-to/SforceBaseClient.php(79): SoapClient->login(Array) #2 /another-path-to/connect.php(13): SforceBaseClient->login('my username is here', 'my password is here') #3 /another-path-to/index.php(228): include_once('/some-path/h...') #4 {main} thrown in /path-to/SforceBaseClient.php on line 79