Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Issue - created a opportunity
#1
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]


Attached Files Image(s)
       
Ranieri
eCRM Web
Reply
#2
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
Joe
TSolucio
Reply
#3
Not solve, yet

Sad

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
Ranieri
eCRM Web
Reply
#4
How do you "created a new contact when I created a opportunity"?
Joe
TSolucio
Reply
#5
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
Ranieri
eCRM Web
Reply
#6
if you erase all lines in that table you will lose all relations between contacts and potentials
Joe
TSolucio
Reply
#7
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 )

Sad
Ranieri
eCRM Web
Reply
#8
(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 ...
Ranieri
eCRM Web
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)