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="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">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>