Hello Andrew,<br>
<br>
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:<br>
<br>
<b>Fatal error</b>: Call to a member function on a non-object in <b>c:\inetpub\wwwroot\vtiger42\include\database\PearDatabase.php</b> on line <b>440<br>
<br>
<br>
<span style="font-weight: bold;"></span></b>The error happens in line 3146 of include/utils.php:<br>
<br>
----<br>
elseif($module == 'Quotes' && $name == 'Potential Name')<br>
{<br>
$potential_id
= $adb->query_result($list_result,$i-1,"potentialid");<br>
$potential_name = getPotentialName($potential_id);<br>
$value =
'<a
href="index.php?module=Potentials&action=DetailView&record='.$potential_id.'">'.$potential_name.'</a>';<br>
}<br>
----<br>
When vtiger try to call getPotentialName() and potentialid passed is null.<br>
<br>
This kind of troubles start to came up when we pass from '' to null...<br>
<br>
Best Regards<br>
João Oliveira.<br>
<br>
<br>
<div><span class="gmail_quote">On 3/13/06, <b class="gmail_sendername">Andrew Rodes</b> <<a href="mailto:arodes@onweald.com">arodes@onweald.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="direction: ltr;">
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2">Try the patch with <a href="http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/51" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/51</a></font></span></div>
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2">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 <a href="http://vtiger.fosslabs.com/svn/vtiger/vtigercrm/branches/4.2/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://vtiger.fosslabs.com/svn/vtiger/vtigercrm/branches/4.2/
</a>,
but im not totally sure where the current release candidate code
is.</font></span></div>
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2">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.</font></span><span><font color="#0000ff" face="Arial" size="2"></font></span></div>
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2">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.</font></span></div>
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2">Andy Rodes</font></span></div>
<div align="left" dir="ltr"><span><font color="#0000ff" face="Arial" size="2">Onweald</font></span></div><br>
<div align="left" dir="ltr" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b>
<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">vtigercrm-developers-bounces@lists.vtigercrm.com</a>
[mailto:<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">vtigercrm-developers-bounces@lists.vtigercrm.com</a>] <b>On Behalf Of
</b>Joao Oliveira<br><b>Sent:</b> Monday, March 13, 2006 1:50 PM<br><b>To:</b>
<a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">vtigercrm-developers@lists.vtigercrm.com</a><br><b>Subject:</b> Re:
[Vtigercrm-developers] HELPME<br></font><br></div></div><div style="direction: ltr;"><span class="e" id="q_109f579cf5346207_1">
<div></div>Hello,<br><br>I've doing some tests today in vtiger, and quotes still
doesn't work.<br><br>The problem is here, and only occurs with mysql 4.1 or
greater:<br><br>insert into quotes (quoteid, subject, potentialid, quotestage,
validtill, team, contactid, carrier, subtotal, shipping, inventorymanager, tax,
adjustment, total, accountid, terms_conditions) <br>values(129, 'rtyuy', '',
'Created', '2006-03-13', '', '', 'FedEx', '', '', 1, 0, 0, '', 1,
'')<br><br>when we want to create a quote without potentialid and/or contactid,
the generated SQL inputs '' as value for this fields.<br><br>It seems that this
issue was fixed in vtiger5 by deleting those relationships from
database.<br>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<br><a href="http://forums.vtiger.com/viewtopic.php?t=3185" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://forums.vtiger.com/viewtopic.php?t=3185
</a>
(But with that patch, some other issues came up...).<br><br>Note that orders
have the same problem, and is possible that also other modules are affected
too...<br><br>Best Regards <br>João Oliveira<br><br>
<div><span class="gmail_quote">On 3/8/06, <b class="gmail_sendername">Mike Fedyk</b>
<<a href="mailto:mfedyk@mikefedyk.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mfedyk@mikefedyk.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;">Does
this patch fix the problem?<br><br><a href="http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/48" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/48
</a><br><br>Luis
Alberto Arenas Salinas wrote:<br><br>>Some body knows if there is a bug in
quotes modules. <br>><br>>That happen is, when i save my queote, in the
next window dont appers<br>>nothing.<br>><br>>Help
please.<br>>_______________________________________________<br>>This <a href="http://vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">vtiger.com</a> 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! <a href="http://zohoplanner.com/?vt" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://zohoplanner.com/?vt</a><br>><br>><br>><br>_______________________________________________
<br>This
<a href="http://vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">vtiger.com</a> 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! <a href="http://zohoplanner.com/?vt" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://zohoplanner.com/?vt</a><br></blockquote></div><br>
</span></div><br>_______________________________________________<br>This <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://vtiger.com" target="_blank">vtiger.com</a>
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! <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://zohoplanner.com/?vt" target="_blank">http://zohoplanner.com/?vt</a><br><br></blockquote></div>
<br>