<!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.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=836411321-13032006><FONT face=Arial
color=#0000ff size=2>Try the patch with <A
href="http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/51">http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/51</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=836411321-13032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=836411321-13032006><FONT face=Arial
color=#0000ff 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/">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 dir=ltr align=left><SPAN class=836411321-13032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=836411321-13032006><FONT face=Arial
color=#0000ff 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 class=836411321-13032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=836411321-13032006><FONT face=Arial
color=#0000ff 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 dir=ltr align=left><SPAN class=836411321-13032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=836411321-13032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=836411321-13032006><FONT face=Arial
color=#0000ff size=2>Andy Rodes</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=836411321-13032006><FONT face=Arial
color=#0000ff size=2>Onweald</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
vtigercrm-developers-bounces@lists.vtigercrm.com
[mailto:vtigercrm-developers-bounces@lists.vtigercrm.com] <B>On Behalf Of
</B>Joao Oliveira<BR><B>Sent:</B> Monday, March 13, 2006 1:50 PM<BR><B>To:</B>
vtigercrm-developers@lists.vtigercrm.com<BR><B>Subject:</B> Re:
[Vtigercrm-developers] HELPME<BR></FONT><BR></DIV>
<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">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">mfedyk@mikefedyk.com</A>>
wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Does
this patch fix the problem?<BR><BR><A
href="http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/48">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">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">http://zohoplanner.com/?vt</A><BR>><BR>><BR>><BR>_______________________________________________<BR>This
<A href="http://vtiger.com">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">http://zohoplanner.com/?vt</A><BR></BLOCKQUOTE></DIV><BR></BODY></HTML>