<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content=text/html;charset=iso-8859-1>
<META content="MSHTML 6.00.6000.16809" name=GENERATOR></HEAD>
<BODY id=MailContainerBody
style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"
bgColor=#ffffff leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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'.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>John</FONT></DIV>
<DIV style="FONT: 10pt Tahoma">
<DIV><BR></DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=johnmessingham@hotmail.com
href="mailto:johnmessingham@hotmail.com">John Messingham</A> </DIV>
<DIV><B>Sent:</B> Wednesday, February 25, 2009 1:26 PM</DIV>
<DIV><B>To:</B> <A title=vtigercrm-developers@lists.vtigercrm.com
href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</A>
</DIV>
<DIV><B>Subject:</B> Re: [Vtigercrm-developers] Connecting to
vtiger</DIV></DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have installed the validation 1 version of vtiger
and still have the same problem with the web services.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am able to view the return from the doListTypes()
command.</FONT></DIV>
<DIV><FONT face=Arial size=2>I am able to add a new lead using the doCreate()
command.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>But still get the same error when I try to
use the doQuery command.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>John</FONT></DIV>
<DIV style="FONT: 10pt Tahoma">
<DIV><BR></DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A
title="mailto:johnmessingham@hotmail.com CTRL + Click to follow link"
href="mailto:johnmessingham@hotmail.com">John Messingham</A> </DIV>
<DIV><B>Sent:</B> Monday, February 23, 2009 11:43 AM</DIV>
<DIV><B>To:</B> <A
title="mailto:vtigercrm-developers@lists.vtigercrm.com CTRL + Click to follow link"
href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</A>
</DIV>
<DIV><B>Subject:</B> Re: [Vtigercrm-developers] Connecting to
vtiger</DIV></DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have added a simple print_r() statement just
before the return in the WXClient.php file doQuery funtion. This
displays:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Array ( [success] => [error] => Array (
[code] => ACCESS_DENIED [message] => Permission to perform the operation
is denied for query ) )</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>at that point.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I get the same result if I uise my own code or the
vtclient demo.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>John</FONT></DIV>
<DIV style="FONT: 10pt Tahoma">
<DIV><FONT face=Arial></FONT><BR></DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A
title="mailto:musavir@vtiger.com CTRL + Click to follow link"
href="mailto:musavir@vtiger.com">Musavir Khan</A> </DIV>
<DIV><B>Sent:</B> Sunday, February 22, 2009 6:58 PM</DIV>
<DIV><B>To:</B> <A
title="mailto:vtigercrm-developers@lists.vtigercrm.com CTRL + Click to follow link"
href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</A>
</DIV>
<DIV><B>Subject:</B> Re: [Vtigercrm-developers] Connecting to
vtiger</DIV></DIV></DIV>
<DIV><BR></DIV><BR>Hi John,
<DIV><BR></DIV>
<DIV>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.<BR></DIV>
<DIV><BR></DIV>
<DIV>Thanks,</DIV>
<DIV>MAK.</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>Reach hundreds of
potential candidates - http://jobs.vtiger.com
<P>
<HR>
<P></P>_______________________________________________<BR>Reach hundreds of
potential candidates - http://jobs.vtiger.com
<P>
<HR>
<P></P>_______________________________________________<BR>Reach hundreds of
potential candidates - http://jobs.vtiger.com</BODY></HTML>