Error when editing Opportunity Contact Relationship

[rvergara]

I am using 4.2.0a. Long time user of Sugar (as long as it was originally released).

I am facing an issue when creating a relationship Opportunity Contact.

1. I go to the Opportunity tab, select the opportunity from the list view
2. Go to the Contact subpanel and click on the select button
3. I select the appropriate contact from the pop up window
4. I get the following messages in the Opportunity- Contact subpanel:

Warning: mysql_data_seek(): supplied argument is not a valid MySQL result resource in /home/hosting/bdi.web/crm/include/database/PearDatabase.php on line 494

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/hosting/bdi.web/crm/include/database/PearDatabase.php on line 498

5. The contact is displayed in the subpanel so I click edit in the contact line to change his/her role for the opportunity, however the Opportunity Contact window screen is open without an opportunity nor a contact name selected

Please help, this is critical for my implementation.

Thanks in advance

Ramiro

[rvergara]

Forgot to mention that I have PHP 5.1.4 .

I saw in the release notes that only 5.1.2 is supported. I wonder that this may be the source of this problem. Strange though since all the rest of the functionality is apparently working fine.

Comments anybody?

Ramiro

[rvergara]

Forgot to mention that I have PHP 5.1.4 .

I saw in the release notes that only 5.1.2 is supported. I wonder that this may be the source of this problem. Strange though since all the rest of the functionality is apparently working fine.

Comments anybody?

Ramiro

I installed 5.1.2 and the problem persists.

I guess this is a bug since PHP 5.1.2 is specifically listed as a supported version.

Anybody else facing a similar problem?

Regards

Ramiro

[rvergara]

After spending time reviewing the problem I found a workaround to continue working. However no editing of the subpaneal is feasible in SugarCRM 4.2.0d. I have raised a bug:

http://www.sugarcrm.com/crm/?option=...e-449f165c530e

I hope Clint or anybody in the sugar team visits this forum and/or the bug. I have noticed that now that SugarCRM is so successful they are kind of forgetting the community. I t was the community that made this project so successful.

Regards

Ramiro

[rvergara]

Sugar CRM team,

1. I reported this issue with all the relevant info to address
2. Since did not receive any answer, I found a workaround
3. I raised the issue as a bug
4. Nobody from the Sugar CRM team has entered any comment

Has the Sugar team forgotten the community???

Was the community important until success in the market???

Ramiro

[ruchida]

rvergara,

I have PHP 4.4.2 and 5.0.4 but can not reproduce this issue. It may be related to the PHP version you have. Are you unable to "downgrade" the PHP version to test it again?

[ruchida]

I've just tried it with PHP 5.1.4 and have not had any problem. So it may not be a PHP issue. What version of Apahce and MySQL are you running?

[rvergara]

Riuhei,

Can you please post details on how you are trying to reproduce?

What I do is:

1. Go to admin and click on Field Layout link of the Studio section
2. Select the Opportunities/contacts subpanel
3. Click on the edit columns link
4. Click on an add sign to add a new column and select a field to add. Any field would do but I was trying to add a dropdown table
5. Save the layout
6. Go to the opportunioty list view and select an opportunity that has already contacts added
7. Goto the opportunity contacts subpanel and you will see the error message

My last set of test was with the following software versions

PHP 5.04, 5.10 and 5.12
Apache 2.0.54
MySQL 4.0.24

Regards

Ramiro

[ruchida]

I did not know you changed the layout of the Opportunity subpanel.

Yes, I could duplicate the issue. This is apparently a bug.

I turned on debugging and found it was causing a MySQL error, which led to the warning messages.

 06/29/06 10:28:04,641 [368] INFO SugarCRM - Query: SELECT contacts.id ref_id   , jt0.assigned_user_id opportunity_role_fields_owner, 'Opportunities' opportunity_role_fields_mod, opportunities_contacts.opportunity_id opportunity_id, opportunities_contacts.id opportunity_role_id, opportunities_contacts.contact_role opportunity_role , jt1.name account_name, jtl1.account_id account_id FROM contacts   LEFT JOIN  accounts_contacts jtl1 ON contacts.id=jtl1.contact_id  AND jtl1.deleted=0
 LEFT JOIN  accounts jt1 ON jt1.id=jtl1.account_id AND jt1.deleted=0
 AND jt1.deleted=0 INNER JOIN opportunities_contacts ON (contacts.id=opportunities_contacts.contact_id AND opportunities_contacts.opportunity_id='85bc01c7-83cc-ae05-74b4-44a3260e4f7e') where (  opportunities_contacts.deleted=0 AND contacts.deleted=0) AND contacts.deleted=0
06/29/06 10:28:04,641 [368] INFO SugarCRM - Query Execution Time:0.000318
06/29/06 10:28:04,642 [368] ERROR SugarCRM - MySQL error 1109: Unknown table 'jt0' in field list 
  

It seems the query gets wrong where the join table prefix has "jt0" instead of "jt1".

[EdSawyer]

I had this same trouble and wrote a fix for it. It's due to some lame-ass coding by the sugar people, executing a mysql function without any error checking. I posted the fix to your bug

http://www.sugarcrm.com/crm/?option=...e-449f165c530e

good luck

-Ed