[Vtigercrm-developers] HELPME

[Joao Oliveira]

Hello Andrew,

With that patch I've successfully insert one quote in database. Thus, when i
go to Quotes ListView php came up with the following error:

*Fatal error*: Call to a member function on a non-object in *
c:\inetpub\wwwroot\vtiger42\include\database\PearDatabase.php* on line *440


*The error happens in line 3146 of include/utils.php:

----
          elseif($module == 'Quotes' && $name == 'Potential Name')
                    {
                        $potential_id =
$adb->query_result($list_result,$i-1,"potentialid");
                        $potential_name = getPotentialName($potential_id);
                        $value = '<a href="index.php
?module=Potentials&action=DetailView&record='.$potential_id.'">'.$potential_name.'</a>';
                    }
----
When vtiger try to call getPotentialName() and potentialid passed is null.

This kind of troubles start to came up when we pass from '' to null...

Best Regards
João Oliveira.


On 3/13/06, Andrew Rodes <arodes at onweald.com> wrote:
>
> Try the patch with http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/51
>
> I basically implemented the solution recommended a few weeks ago and
> submitted the patch with tic #51. I noticed that it appears this patch has
> not been rolled into the working branch at
> http://vtiger.fosslabs.com/svn/vtiger/vtigercrm/branches/4.2/, but im not
> totally sure where the current release candidate code is.
>
> anyway .. try this patch and let us know what you found. In my testing,
> Quotes appeared to start working. during my testing with that patch.
> Also, I submitted bug 48, which I think may have a similar root cause as
> 51, but i have not had time to implement a fix.
>
>
> Andy Rodes
> Onweald
>
>  ------------------------------
> *From:* vtigercrm-developers-bounces at lists.vtigercrm.com [mailto:
> vtigercrm-developers-bounces at lists.vtigercrm.com] *On Behalf Of *Joao
> Oliveira
> *Sent:* Monday, March 13, 2006 1:50 PM
> *To:* vtigercrm-developers at lists.vtigercrm.com
> *Subject:* Re: [Vtigercrm-developers] HELPME
>
> Hello,
>
> I've doing some tests today in vtiger, and quotes still doesn't work.
>
> The problem is here, and only occurs with mysql 4.1 or greater:
>
> insert into quotes (quoteid, subject, potentialid, quotestage, validtill,
> team, contactid, carrier, subtotal, shipping, inventorymanager, tax,
> adjustment, total, accountid, terms_conditions)
> values(129, 'rtyuy', '', 'Created', '2006-03-13', '', '', 'FedEx', '', '',
> 1, 0, 0, '', 1, '')
>
> when we want to create a quote without potentialid and/or contactid, the
> generated SQL inputs '' as value for this fields.
>
> It seems that this issue was fixed in vtiger5 by deleting those
> relationships from database.
> IMHO, this isn't the best way. The sql query should be changed in order to
> insert NULL values in those relationships, like Léo had post
> http://forums.vtiger.com/viewtopic.php?t=3185 (But with that patch, some
> other issues came up...).
>
> Note that orders have the same problem, and is possible that also other
> modules are affected too...
>
> Best Regards
> João Oliveira
>
> On 3/8/06, Mike Fedyk <mfedyk at mikefedyk.com> wrote:
> >
> > Does this patch fix the problem?
> >
> > http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/48
> >
> > Luis Alberto Arenas Salinas wrote:
> >
> > >Some body knows if there is a bug in quotes modules.
> > >
> > >That happen is, when i save my queote, in the next window dont appers
> > >nothing.
> > >
> > >Help please.
> > >_______________________________________________
> > >This vtiger.com email is sponsored by Zoho Planner. Still scribbling
> > down your To-Do's on bits of paper & palms of your hands? Try the AJAX
> > enabled, personal organizer online, Zoho Planner for FREE instead!
> > http://zohoplanner.com/?vt
> > >
> > >
> > >
> > _______________________________________________
> > This vtiger.com email is sponsored by Zoho Planner. Still scribbling
> > down your To-Do's on bits of paper & palms of your hands? Try the AJAX
> > enabled, personal organizer online, Zoho Planner for FREE instead!
> > http://zohoplanner.com/?vt
> >
>
>
> _______________________________________________
> This vtiger.com email is sponsored by Zoho Planner. Still scribbling down
> your To-Do's on bits of paper & palms of your hands? Try the AJAX enabled,
> personal organizer online, Zoho Planner for FREE instead!
> http://zohoplanner.com/?vt
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20060313/e42168f8/attachment-0003.html