+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: Issue - created a opportunity (/showthread.php?tid=903)
Issue - created a opportunity - rslemer - 02-20-2018
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]
RE: Issue - created a opportunity - joebordes - 02-20-2018
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
RE: Issue - created a opportunity - rslemer - 02-20-2018
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
RE: Issue - created a opportunity - joebordes - 02-20-2018
How do you "created a new contact when I created a opportunity"?
RE: Issue - created a opportunity - rslemer - 02-20-2018
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
RE: Issue - created a opportunity - joebordes - 02-20-2018
if you erase all lines in that table you will lose all relations between contacts and potentials
RE: Issue - created a opportunity - rslemer - 02-20-2018
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 )
RE: Issue - created a opportunity - rslemer - 02-21-2018
(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 ...