[Vtigercrm-developers] Error when adding ToDo from SO/Inv/PO

[Asha]

Hi John,

Thanks for reporting the issue and for your effort in looking deeper into
the issue.

We had also discovered the same issue recently, and have fixed it
internally.

The issue here is, whenever you try to add an Event or a Todo to any
entities other than Accounts and Contacts, and check 'Send Notification', it
will fail.

Following is the trac ticket for the same:
http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7164

Fix will be available in our upcoming release 5.3.0.

On Mon, Oct 17, 2011 at 9:53 PM, John Crisp <john at reetspetit.net> wrote:

> On 17/10/11 17:52, John Crisp wrote:
> > I have had an odd situation that I cannot resolve. I have tested this on
> > the demo server and it works but not on my installation. I can only
> > assume a mod somewhere has upset things but cannot see what.
> >
> > When adding a ToDo to a SO/Inv/PO I was getting a stop as follows (it
> > worked fine from Accounts or Contacts)
>
>
> Further to this, I realised I should have said that it was stopping on
> ToDos from Accounts and Contacts which were being related to Sales Orders
>
> Any comments appreciated. I will go back and check exactly when it is
> failing as I may have got myself in a knot !
>
> However I think the error still stands in the ComonUtils.php file
>
> I have amended it as follows adding an extra 'else' line :
>
> function getParentName($parent_id)
> {
>        global $adb;
>        if ($parent_id == 0)
>                return "";
>        $sql="select setype from vtiger_crmentity where crmid=?";
>        $result=$adb->pquery($sql,array($parent_id));
>        //For now i have conditions only for accounts and contacts, if
> needed
> can add more
>        if($adb->query_result($result,'setype') == 'Accounts')
>                $sql1="select accountname name from vtiger_account where
> accountid=?";
>        else if($adb->query_result($result,'setype') == 'Contacts')
>                $sql1="select concat( firstname, ' ', lastname ) name from
> vtiger_contactdetails where contactid=?";
>         else $sql1="select setype from vtiger_crmentity where crmid=?";
>                 $result1=$adb->pquery($sql1,array($parent_id));
>        $asd=$adb->query_result($result1,'name');
>        return $asd;
> }
>
>
>
> Not sure if this is right but IWFM
>
> B. Rgds
> John
> _______________________________________________
> http://www.vtiger.com/
>



-- 
Regards,
Asha
vtiger Team

*Connect with us on: *Twitter <http://twitter.com/#%21/vtigercrm> *I*
Facebook <http://www.facebook.com/pages/vtiger/226866697333578?sk=wall> *I*
Blog <http://blog.vtiger.com/>* I*
Wiki<http://wiki.vtiger.com/index.php/Main_Page>
 *I *Forums  <http://forums.vtiger.com/>*I* Website <http://vtiger.com/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20111018/432a0868/attachment-0002.html