Can't Display Contracts Subpanel in Opportunities Detail View

[katherinem]

Sugar Professional 6.0
PHP Version: 5.2.11
Database Version: MySQL 5.1
Deployment Option: on premise
Web Server: Apache 2.2

How do I display the Contracts subpanel in the Opportunities Detail View? The relationship is predefined so I cannot edit it in Studio. I have access to the code. I have not found anything in the forums that comprehensively explains how to do this for core modules.

[davidboris]

Hello,

Sugar does provide the "Contracts" subpanel in Opportunities detail view. I wonder why it is not appearing for you. Check custom/modules/Opportunities/Ext/Layoutdefs/layoutdefs.ext.php and see if you have overwrite the "Contract" subpanel there?

[mjunior]

I´m stuck into similar problem here with 4.5.1 version..
I did the installation smootly but then nothing happened...
I followed the instructions below figuring it might had some declaration missing since I could see the extra module instaled when I click admin/studio (despite the new module listed had no name (blank))
http://sugarcrm.openapp.org/2006/02/...-sugarcrm-401/
Nothing happened again...

My custom/modules/Opportunities/Ext/Layoutdefs/layoutdefs.ext.php shows:
$layout_defs['Accounts']['subpanel_setup']['contracts'] = array(
'order' => 330,
'module' => 'Contracts',
'subpanel_name' => 'ForAccounts',
'override_subpanel_name' => 'contracts',
'get_subpanel_data' => 'contracts',
'add_subpanel_data' => 'contract_id',
'title_key' => 'LBL_CONTRACTS_SUBPANEL_TITLE',
'top_buttons' => array(
array('widget_class' => 'SubPanelTopCreateButton')
)
);

I´d like to have contract listed only inside accounts, If possible...

[andopes]

I´m stuck into similar problem here with 4.5.1 version..
I did the installation smootly but then nothing happened...
I followed the instructions below figuring it might had some declaration missing since I could see the extra module instaled when I click admin/studio (despite the new module listed had no name (blank))
http://sugarcrm.openapp.org/2006/02/...-sugarcrm-401/
Nothing happened again...

My custom/modules/Opportunities/Ext/Layoutdefs/layoutdefs.ext.php shows:
$layout_defs['Accounts']['subpanel_setup']['contracts'] = array(
'order' => 330,
'module' => 'Contracts',
'subpanel_name' => 'ForAccounts',
'override_subpanel_name' => 'contracts',
'get_subpanel_data' => 'contracts',
'add_subpanel_data' => 'contract_id',
'title_key' => 'LBL_CONTRACTS_SUBPANEL_TITLE',
'top_buttons' => array(
array('widget_class' => 'SubPanelTopCreateButton')
)
);

I´d like to have contract listed only inside accounts, If possible...

You have to edit a file inside custom/Extension/modules/Opportunities/Ext/Layoutdefs/, remove the entry regarding $layout_defs['Accounts']['subpanel_setup']['contracts'] and add the code:

unset($layout_defs['Accounts']['subpanel_setup']['contracts']);

Then go to Admin -> Repair -> Quick Repair and Rebuild

Cheers

[mjunior]

in the given path, within contracts.php, I did remove the entry :
$layout_defs['Opportunities']['subpanel_setup']['contracts'] = array(
'order' => 320,
'module' => 'Contracts',
'subpanel_name' => 'ForAccounts',
'override_subpanel_name' => 'contracts',
'get_subpanel_data' => 'contracts',
'add_subpanel_data' => 'contract_id',
'title_key' => 'LBL_CONTRACTS_SUBPANEL_TITLE'
);

and placed yours

While rebuilding via admin panel, I got the following error:
Reparar Base de Dados:display Imprimir Ajuda
Error dropping table : Query Failed:drop table if exists repair_table::MySQL error 1142

[andopes]

It happens because the Mysql User has no right to either drop or create table.
Go to phpMyAdim and grant these privileges to such user.

Cheers

[mjunior]

Regarding the error mentioned, current db user permissions are:
SELECT, INSERT, UPDATE, DELETE, CREATE, FILE, INDEX, ALTER, SHOW VIEW

[andopes]

As per error, SugarCRM is trying to drop a temporary table, and this is the big deal.
Your MySQL user is able to create table but not drop table.

Cheers

[mjunior]

Even after flush into mysql, the error continue..
Current permissiona are:
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER, SHOW VIEW

[mjunior]

Rebuilded, but nothing changes neither in main tabs view nor within opportunities or accounts...I can´t see contracts even within admin/studio...

Reparar Base de Dados:display Imprimir Ajuda
/* Table : leads */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - first_name - ROW [Field] => 'first_name' [Type] => 'varchar(25)' [Null] => 'YES' [Key] => '' [Default] => '' [Extra] => '' */
/* VARDEF - first_name - ROW[Field] => 'first_name' [Type] => 'varchar(25)' [Null] => 'NO' [Key] => '' [Default] => '' [Extra] => '' */
alter table leads modify column first_name varchar(25) NOT NULL
/*INDEXES/*
/*INDEX MISMATCH WITH DATABASE - idx_lead_del_stat - ROW [Table] => 'leads' [Non_unique] => '1' [Key_name] => 'idx_lead_del_stat' [Seq_in_index] => '4' [Column_name] => 'first_name' [Collation] => 'A' [Cardinality] => '2150' [Sub_part] => '' [Packed] => '' [Null] => 'YES' [Index_type] => 'BTREE' [Comment] => '' */
/* VARDEF - idx_lead_del_stat - ROW[Table] => 'repair_table' [Non_unique] => '1' [Key_name] => 'idx_lead_del_stat' [Seq_in_index] => '4' [Column_name] => 'first_name' [Collation] => 'A' [Cardinality] => '' [Sub_part] => '' [Packed] => '' [Null] => '' [Index_type] => 'BTREE' [Comment] => '' */
ALTER TABLE leads DROP INDEX idx_lead_del_stat
ALTER TABLE leads ADD INDEX idx_lead_del_stat (last_name, status, deleted, first_name)
/* Table : contacts */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - first_name - ROW [Field] => 'first_name' [Type] => 'varchar(100)' [Null] => 'YES' [Key] => '' [Default] => '' [Extra] => '' */
/* VARDEF - first_name - ROW[Field] => 'first_name' [Type] => 'varchar(100)' [Null] => 'NO' [Key] => '' [Default] => '' [Extra] => '' */
alter table contacts modify column first_name varchar(100) NOT NULL
/*MISMATCH WITH DATABASE - last_name - ROW [Field] => 'last_name' [Type] => 'varchar(100)' [Null] => 'YES' [Key] => 'MUL' [Default] => '' [Extra] => '' */
/* VARDEF - last_name - ROW[Field] => 'last_name' [Type] => 'varchar(100)' [Null] => 'NO' [Key] => 'MUL' [Default] => '' [Extra] => '' */
alter table contacts modify column last_name varchar(100) NOT NULL
/*INDEXES/*
/*INDEX MISMATCH WITH DATABASE - idx_contacts_del_last - ROW [Table] => 'contacts' [Non_unique] => '1' [Key_name] => 'idx_contacts_del_last' [Seq_in_index] => '2' [Column_name] => 'last_name' [Collation] => 'A' [Cardinality] => '3608' [Sub_part] => '' [Packed] => '' [Null] => 'YES' [Index_type] => 'BTREE' [Comment] => '' */
/* VARDEF - idx_contacts_del_last - ROW[Table] => 'repair_table' [Non_unique] => '1' [Key_name] => 'idx_contacts_del_last' [Seq_in_index] => '2' [Column_name] => 'last_name' [Collation] => 'A' [Cardinality] => '' [Sub_part] => '' [Packed] => '' [Null] => '' [Index_type] => 'BTREE' [Comment] => '' */
ALTER TABLE contacts DROP INDEX idx_contacts_del_last
ALTER TABLE contacts ADD INDEX idx_contacts_del_last (deleted, last_name)
/*INDEX MISMATCH WITH DATABASE - idx_cont_del_reports - ROW [Table] => 'contacts' [Non_unique] => '1' [Key_name] => 'idx_cont_del_reports' [Seq_in_index] => '3' [Column_name] => 'last_name' [Collation] => 'A' [Cardinality] => '3608' [Sub_part] => '' [Packed] => '' [Null] => 'YES' [Index_type] => 'BTREE' [Comment] => '' */
/* VARDEF - idx_cont_del_reports - ROW[Table] => 'repair_table' [Non_unique] => '1' [Key_name] => 'idx_cont_del_reports' [Seq_in_index] => '3' [Column_name] => 'last_name' [Collation] => 'A' [Cardinality] => '' [Sub_part] => '' [Packed] => '' [Null] => '' [Index_type] => 'BTREE' [Comment] => '' */
ALTER TABLE contacts DROP INDEX idx_cont_del_reports
ALTER TABLE contacts ADD INDEX idx_cont_del_reports (deleted, reports_to_id, last_name)
/* Table : */
/* Table : files */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - id - ROW [Field] => 'id' [Type] => 'char(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
/* VARDEF - id - ROW[Field] => 'id' [Type] => 'varchar(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
alter table files modify column id varchar(36) NOT NULL
/*MISSING IN DATABASE - date_modified - ROW/*
alter table files add column date_modified datetime NULL
/*MISMATCH WITH DATABASE - assigned_user_id - ROW [Field] => 'assigned_user_id' [Type] => 'char(36)' [Null] => 'YES' [Key] => '' [Default] => '' [Extra] => '' */
/* VARDEF - assigned_user_id - ROW[Field] => 'assigned_user_id' [Type] => 'varchar(36)' [Null] => 'YES' [Key] => 'MUL' [Default] => '' [Extra] => '' */
alter table files modify column assigned_user_id varchar(36) NULL
/*INDEXES/*
/*MISSING INDEX IN DATABASE - idx_cont_owner_id_and_name -index ROW/*
ALTER TABLE files ADD INDEX idx_cont_owner_id_and_name (assigned_user_id, name, deleted)
/* Table : */
/* Table : */