Issue - created a opportunity

[rslemer]

When I try created a new opportunity and related a new contact, system show a error

Fatal error: Uncaught exception 'Exception' with message 'result is not an object' in /usr/share/coreBOS/corebos-master/include/database/PearDatabase.php:826 Stack trace: #0 /usr/share/coreBOS/corebos-master/Popup.php(70): PearDatabase->query_result(false, 0, 0) #1 /usr/share/coreBOS/corebos-master/modules/Contacts/Popup.php(10): require_once('/usr/share/core...') #2 /usr/share/coreBOS/corebos-master/index.php(504): include_once('/usr/share/core...') #3 {main} thrown in /usr/share/coreBOS/corebos-master/include/database/PearDatabase.php on line 826

2018-02-20T14:33:09+00:00 INFO  VT PearDatabase ->ADODB error  Query Failed:insert into vtiger_contpotentialrel values(?,?)::->[1062]Duplicate entry '354-31179' for key 'PRIMARY'
2018-02-20T14:33:09+00:00 DEBUG index Prepared sql query being executed : UPDATE vtiger_crmentity SET modifiedtime = ?, modifiedby = ? WHERE crmid = ?
2018-02-20T14:33:09+00:00 DEBUG index Prepared sql query parameters : [2018-02-20 14:33:09,1,354]

[joebordes]

I cannot reproduce this and I don't understand how it could happen. I suppose it is some combination of workflow or custom change. In any case, I added a check so the application does not try to add an already existing relation.

https://github.com/tsolucio/corebos/commit/afdd4619ae736cd7acbf828be6a1f8f33b3459d5

[rslemer]

Not solve, yet



If I create first a contact works, and after that created a opportunity - OK
If I create a opportunity and select a contact, in creation time of opportunity - OK
Only not work, if I try created a new contact when I created a opportunity

[joebordes]

How do you "created a new contact when I created a opportunity"?

[rslemer]

I can erase all lines in vtiger_contpotentialrel and redo with a relation?

Thats really strange

contactid potentialid
313 24767
347 24767
354 24767
16573 24767
313 24768
313 24788
347 24788
16573 24862
24956 24959
313 24977
25619 25620
24677 26141
22518 26151
22507 26154
22322 26160
26745 27275
354 31179

[joebordes]

if you erase all lines in that table you will lose all relations between contacts and potentials

[rslemer]

But now, when I click on contacts - related list - opportunity system show various opportunity not real related with this contact.

When I click on opportunity and click in contact system not show any contact ( even with a field relation assigned correctly )

[rslemer]

(02-20-2018, 10:25 PM)joebordes Wrote: How do you "created a new contact when I created a opportunity"?

 Ops, create a contact and after that create a opportunity ..  works ...