Hi John,<br><br>Thanks for the catch ... will fix the issue soon.<br><br>Refer: <a href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/5480">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/5480</a><br><br>Keep testing and update us.<br>
<br>Regards,<br>Prasadt<br><br><div><span class="gmail_quote">On 2/25/09, <b class="gmail_sendername">John Messingham</b> <<a href="mailto:johnmessingham@hotmail.com">johnmessingham@hotmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="padding-right: 10px; padding-left: 10px; padding-top: 15px;" bgcolor="#ffffff" 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-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">
<div><br></div>
<div style="background: rgb(245, 245, 245) none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
<div><b>From:</b> <a title="johnmessingham@hotmail.com" href="mailto:johnmessingham@hotmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">
<div><br></div>
<div style="background: rgb(245, 245, 245) none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
<div><b>From:</b> <a title="mailto:johnmessingham@hotmail.com
CTRL + Click to follow link" href="mailto:johnmessingham@hotmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">
<div><font face="Arial"></font><br></div>
<div style="background: rgb(245, 245, 245) none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">
<div><b>From:</b> <a title="mailto:musavir@vtiger.com
CTRL + Click to follow link" href="mailto:musavir@vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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>
</p><hr>
<p></p>_______________________________________________<br>Reach hundreds of
potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a>
<p>
</p><hr>
<p></p>_______________________________________________<br>Reach hundreds of
potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a>
<p>
</p><hr>
<p></p>_______________________________________________<br>Reach hundreds of
potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a><p></p><p></p><p></p></div>
<br>_______________________________________________<br>
Reach hundreds of potential candidates - <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a> <br></blockquote></div><br>