It looks like you're new here. If you want to get involved, click one of these buttons!
09/30/05 16:18:13,388 [696] DEBUG VT - Message ->query being executed : select * from inventorynotification where notificationname='QuoteNotification'
09/30/05 16:18:13,390 [696] INFO VT - Message ->checkconnect using old connection
09/30/05 16:18:13,396 [696] DEBUG VT - Message ->Inside SendMailToCustomer function.
09/30/05 16:18:13,816 [696] DEBUG VT - Message ->query being executed : select * from users where id= 1
09/30/05 16:18:13,819 [696] INFO VT - Message ->checkconnect using old connection
09/30/05 16:18:13,827 [696] DEBUG VT - Message ->query being executed : select * from systems where server_type='email'
09/30/05 16:18:13,830 [696] INFO VT - Message ->checkconnect using old connection
09/30/05 16:18:24,182 [696] DEBUG VT - Message ->query being executed : insert into quotesproductrel values(10,6,1,15.00)
09/30/05 16:18:24,185 [696] INFO VT - Message ->checkconnect using old connection
09/30/05 16:18:24,190 [696] FATAL VT - PearDatabase ->ADODB error Query Failed:insert into quotesproductrel values(10,6,1,15.00)::->[1216]Cannot add or update a child row: a foreign key constraint fails
09/30/05 16:18:24,193 [696] DEBUG VT - Message ->Inside Quote updateStk function.
09/30/05 16:18:24,196 [696] DEBUG VT - Message ->Product Id is6
09/30/05 16:18:24,198 [696] DEBUG VT - Message ->Qty is1
09/30/05 16:18:24,201 [696] INFO VT - Message ->in getproductname 6
09/30/05 16:18:24,204 [696] DEBUG VT - Message ->query being executed : select productname from products where productid=6
09/30/05 16:18:24,206 [696] INFO VT - Message ->checkconnect using old connection
09/30/05 16:18:24,230 [696] DEBUG VT - Message ->query being executed : select qtyinstock from products where productid=6
09/30/05 16:18:24,233 [696] INFO VT - Message ->checkconnect using old connection
09/30/05 16:18:24,238 [696] DEBUG VT - Message ->Prd Qty in Stock 100
09/30/05 16:18:24,241 [696] DEBUG VT - Message ->query being executed : select reorderlevel from products where productid=6
09/30/05 16:18:24,243 [696] INFO VT - Message ->checkconnect using old connection
09/30/05 16:18:24,248 [696] DEBUG VT - Message ->Prd reorder level 10
09/30/05 16:18:24,250 [696] DEBUG index - Saved record with id of 10
Comments
when the system is trying to create the quote, it uses one foreign key for contact id, and other to potential id...
the problem happen cause i´m using the mysql 4.1 and when happen an insert of a value to a foreign key, it does not accept '', in its place place null, well, to solve this... place this lines of code in the "modules/quotes/save.php"
sorry by the bad english,
hope have helped.
léo willian kölln
yesterday night i began to look for solution for the bug which you posted.but i did not find any solution until i reviewed the bug again.
there is nothing about the bug in the mysql manual.
best regards
dfar
<!-- m --><a class="postlink" href="http://www.c3crm.com">http://www.c3crm.com</a><!-- m -->
because of the correction, other issue happen, when you try to list the quotes what you have created, you get an error like this...
this happen cause the system try to find a null id of potential... and we don´t have a potential...
to solve this open the file "include/utils.php" and edit
[at line 3127 (or something around this)]
in place of:
put:
this solved the problem for me, hope for you too... please post here if something like this happen... or more...
for the vtiger developers:
i think this type of problem is everywere in the system, please take a look on those problems, of if some one read this, please post here.
thanks,
léo willian kölln
<!-- m --><a class="postlink" href="http://forums.vtiger.com/viewtopic.php?p=12987#12987">http://forums.vtiger.com/viewtopic.php?p=12987#12987</a><!-- m -->
any thought?
somebody, please, get this merged in cvs.
thanks,
ken
yes confirmed in my 4.2.4, the bug is caused because potential is not a required field when creating a quote. if you create a quote without potential the fatal error occurs.