[Vtigercrm-developers] Connecting to vtiger - Solved

[John Messingham]

Hi,

I just spent some time following this through the actual web services code. It appears that the web services code does not like 'FROM' in the sql statements it prefers 'from'.

John


From: John Messingham 
Sent: Wednesday, February 25, 2009 1:26 PM
To: vtigercrm-developers at lists.vtigercrm.com 
Subject: Re: [Vtigercrm-developers] Connecting to vtiger


Hi,

I have installed the validation 1 version of vtiger and still have the same problem with the web services.

I am able to view the return from the doListTypes() command.
I am able to add a new lead using the doCreate() command.

But still get the same error  when I try to use the doQuery command.

John


From: John Messingham 
Sent: Monday, February 23, 2009 11:43 AM
To: vtigercrm-developers at lists.vtigercrm.com 
Subject: Re: [Vtigercrm-developers] Connecting to vtiger


Hi,

I have added a simple print_r() statement just before the return in the WXClient.php file doQuery funtion. This displays:

Array ( [success] => [error] => Array ( [code] => ACCESS_DENIED [message] => Permission to perform the operation is denied for query ) )

at that point.

I get the same result if I uise my own code or the vtclient demo.

I hope this helps. If you are not getting the same problem then I will check my installation again in case something has gone wrong but it looks ok at this point.

John


From: Musavir Khan 
Sent: Sunday, February 22, 2009 6:58 PM
To: vtigercrm-developers at lists.vtigercrm.com 
Subject: Re: [Vtigercrm-developers] Connecting to vtiger



Hi John, 


can you be little more specific with error you are getting and share the error message you are getting. one thing i recommend is making sure you have access to the module you are running a query on, this can be achieved by doing check whether that particular module is part of doListType operation.



Thanks,
MAK.






--------------------------------------------------------------------------------


_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com 


--------------------------------------------------------------------------------


_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com 


--------------------------------------------------------------------------------


_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090225/949cb2e6/attachment-0003.html