Issue on New Module, making relation with second custom module.

[GrupImatica]

Hi, 've attached a log of error when deploying a custom module.

This module has a relation with other custom module installed on same suite server. suitecrm - copia.zip

I've attached also, the two custom modules, error is when i create a relationship between Reclamaciones as Many to One of the custom module previsiones.

project_S50_Enlace2016_10_21_175844.zip project_Reclamaciones2016_10_21_175836.zip

Thanks!

[shogunpol]

@GrupImatica , please provide step by step to reproduce, and environment information, if you did any customisation, please describe it in replication section. Thanks for your contribution.

[GrupImatica]

Hi, there are NO customization. Only Spanish translation, and the two modules installed.

Problem es when on personalized module 2 i create a relation with an account, and then i make a relation with module 1, the package not installs.

[shogunpol]

The translations for SuiteCRM are made by: https://crowdin.com/project/suitecrmtranslations and can be contributed back there and are unable to be updated in this project on github @horus68 may be able to help with this.

[GrupImatica]

But in English, problem persists.

[shogunpol]

@GrupImatica , did you add relationships in studio or module builder?

[GrupImatica]

on module builder

[GrupImatica]

hi, i've been tested to add relation with both personalized modules after installed in Studio, and i get error and cannot make a relation with the module Reclamaciones with modules previsiones.

I attach steps:

Error on server:

SUITELOG:

Tue Nov 1 13:59:04 2016 [8140][22a72c40-b540-0122-3686-58068e34e2c9][WARN] Image sidebar/modules\AOS_PDF_Templates.svg not found Tue Nov 1 13:59:05 2016 [8140][22a72c40-b540-0122-3686-58068e34e2c9][WARN] Image sub_panel\PhoneCalls.svg not found Tue Nov 1 14:00:43 2016 [8140][1][FATAL] Query Failed:INSERT into relationships (id,relationship_name,lhs_module,lhs_table,lhs_key,rhs_module,rhs_table,rhs_key,join_table,join_key_lhs,join_key_rhs,relationship_type) values (N'33bb4430-b1be-cccd-4639-581875c441a1',N'gis50_previsiones_girec_gi_reclamaciones_1',N'GIS50_Previsiones',N'gis50_previsiones',N'id',N'GiRec_GI_RECLAMACIONES',N'girec_gi_reclamaciones',N'id',N'gis50_previsiones_girec_gi_reclamaciones_1_c',N'gis50_previsiones_girec_gi_reclamaciones_1gis50_previsiones_ida',N'gis50_previsiones_girec_gi_reclamaciones_1girec_gi_reclamaciones_idb',N'many-to-many')::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Los datos de cadena o binarios se truncarían. [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Se terminó la instrucción. Tue Nov 1 14:00:43 2016 [8140][1][FATAL] Exception in Controller: Error de base de datos. Por favor, consulte SuiteCRM error .log para más detalles. Tue Nov 1 14:01:08 2016 [8140][22a72c40-b540-0122-3686-58068e34e2c9][ERROR] Field date_due expecting datetime format, but got value: Tue Nov 1 14:01:08 2016 [8140][22a72c40-b540-0122-3686-58068e34e2c9][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated

PHPLOG: [01-Nov-2016 13:59:04 Asia/Kuwait] PHP Notice: Undefined index: CampaignLog in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\include\SearchForm\SearchForm2.php on line 129 [01-Nov-2016 14:00:28 Asia/Kuwait] PHP Warning: Declaration of SugarWebServiceUtilv4::get_data_list($seed, $order_by = '', $where = '', $row_offset = 0, $limit = -1, $max = -1, $show_deleted = 0, $favorites = false) should be compatible with SugarWebServiceUtilv3_1::get_data_list($seed, $order_by = '', $where = '', $row_offset = 0, $limit = -1, $max = -1, $show_deleted = 0, $favorites = false, $singleSelect = false) in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\service\v4\SugarWebServiceUtilv4.php on line 555 [01-Nov-2016 14:00:28 Asia/Kuwait] PHP Warning: Declaration of SugarWebServiceImplv4::get_entries($session, $module_name, $ids, $select_fields, $link_name_to_fields_array) should be compatible with SugarWebServiceImplv3_1::get_entries($session, $module_name, $ids, $select_fields, $link_name_to_fields_array, $track_view = false) in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\service\v4\SugarWebServiceImplv4.php on line 49 [01-Nov-2016 14:00:28 Asia/Kuwait] PHP Warning: Missing argument 2 for SugarWebServiceImplv4::login(), called in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\service\core\REST\SugarRestJSON.php on line 91 and defined in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\service\v4\SugarWebServiceImplv4.php on line 70 [01-Nov-2016 14:00:28 Asia/Kuwait] PHP Notice: Undefined variable: application in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\service\v4\SugarWebServiceImplv4.php on line 71 [01-Nov-2016 14:00:28 Asia/Kuwait] PHP Notice: Undefined property: User::$default_team in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\service\v4\SugarWebServiceImplv4.php on line 171 [01-Nov-2016 14:00:28 Asia/Kuwait] PHP Notice: Undefined index: wl_list_max_entries_per_page in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\service\v4\SugarWebServiceImplv4.php on line 180 [01-Nov-2016 14:00:28 Asia/Kuwait] PHP Notice: Undefined index: wl_list_max_entries_per_subpanel in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\service\v4\SugarWebServiceImplv4.php on line 181 [01-Nov-2016 14:00:36 Asia/Kuwait] PHP Warning: Declaration of SugarWebServiceUtilv4::get_data_list($seed, $order_by = '', $where = '', $row_offset = 0, $limit = -1, $max = -1, $show_deleted = 0, $favorites = false) should be compatible with SugarWebServiceUtilv3_1::get_data_list($seed, $order_by = '', $where = '', $row_offset = 0, $limit = -1, $max = -1, $show_deleted = 0, $favorites = false, $singleSelect = false) in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\service\v4\SugarWebServiceUtilv4.php on line 555 [01-Nov-2016 14:00:36 Asia/Kuwait] PHP Warning: Declaration of SugarWebServiceImplv4::get_entries($session, $module_name, $ids, $select_fields, $link_name_to_fields_array) should be compatible with SugarWebServiceImplv3_1::get_entries($session, $module_name, $ids, $select_fields, $link_name_to_fields_array, $track_view = false) in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\service\v4\SugarWebServiceImplv4.php on line 49 [01-Nov-2016 14:00:41 Asia/Kuwait] PHP Warning: Missing argument 1 for DeployedRelationships::build(), called in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\modules\ModuleBuilder\controller.php on line 580 and defined in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\modules\ModuleBuilder\parsers\relationships\DeployedRelationships.php on line 282 [01-Nov-2016 14:00:41 Asia/Kuwait] PHP Warning: Missing argument 2 for DeployedRelationships::build(), called in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\modules\ModuleBuilder\controller.php on line 580 and defined in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\modules\ModuleBuilder\parsers\relationships\DeployedRelationships.php on line 282 [01-Nov-2016 14:00:41 Asia/Kuwait] PHP Warning: Missing argument 3 for DeployedRelationships::build(), called in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\modules\ModuleBuilder\controller.php on line 580 and defined in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\modules\ModuleBuilder\parsers\relationships\DeployedRelationships.php on line 282 [01-Nov-2016 14:00:42 Asia/Kuwait] PHP Warning: Declaration of ManyToOneRelationship::setReadonly() should be compatible with AbstractRelationship::setReadonly($set = true) in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\modules\ModuleBuilder\parsers\relationships\ManyToOneRelationship.php on line 153 [01-Nov-2016 14:00:42 Asia/Kuwait] PHP Warning: Declaration of ManyToOneRelationship::buildLabels() should be compatible with AbstractRelationship::buildLabels($update = false) in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\modules\ModuleBuilder\parsers\relationships\ManyToOneRelationship.php on line 153 [01-Nov-2016 14:01:10 Asia/Kuwait] PHP Notice: Undefined index: CampaignLog in C:\inetpub\wwwroot\GRUPIMATICA\SuiteCRM\include\SearchForm\SearchForm2.php on line 129

[GrupImatica]

Problem is lenght of the fields of the table relationships. After enlarge this to 200 , modules workd fine. It's an error to need to be solved for future releases,maybe it's an issue only for MSSQL ?

[Mac-Rae]

This issue has been closed as version 7.8.x of SuiteCRM has reached its end of life and therefore will no longer be receiving updates. We have also been unable to replicate this issue in any newer version of SuiteCRM such as 7.10.x or 7.11.x however if you are able, please leave a comment explaining how and we'll re-open this issue.

For more information about 7.8.x end of life please visit our blog post