AnsweredAssumed Answered

BIG ISSUE : Sugar 7.5.1, Contracts not rendering Listview anymore

Question asked by Gaelle Fernandez on Jul 2, 2015
Latest reply on Jul 9, 2015 by Gaelle Fernandez
Hello there,

On Sugar Pro 7.5.1, i'm coming in a biiig issue !
The Contracts listview does not display anymore, though I did not add any custom code in it.
I can display a contract's record, but I can't display the records listview.

I don't know what is happening...

I only set a Role to "no access" for opportunities, and because they're related by a relationship, maybe it is that could cause the norendition, but i'm not using this role with my current user...


here is the Log that Sugar generates when i click on "Contracts" mondule tab :


Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] ACLS for Contracts: array (
)
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] ACLS for KBDocuments: array (
  'SugarACLStatic' => true,
)
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] ACLS for Documents: array (
  'SugarACLStatic' => true,
)
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] ACLS for Cases: array (
  'SugarACLStatic' => true,
)
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] ACLS for Project: array (
  'SugarACLStatic' => true,
)
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] ACLS for Bugs: array (
  'SugarACLStatic' => true,
)
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] ACLS for ag_ActesDeGestion: array (
  'SugarACLStatic' => true,
)
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] ACLS for de_Devis: array (
  'SugarACLStatic' => true,
)
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT  af.name, af.aclaccess FROM acl_fields af  INNER JOIN acl_roles_users aru ON aru.user_id = '1' AND aru.deleted=0
                    INNER JOIN acl_roles ar ON aru.role_id = ar.id AND ar.id = af.role_id AND ar.deleted = 0 WHERE af.deleted = 0  AND af.category='Administration'
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.0011858940124512
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] current_language is: fr_FR
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Found language file: include/language/en_us.lang.php
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Found extended language file: custom/application/Ext/Language/en_us.lang.ext.php
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Found custom language file: custom/include/language/en_us.lang.php
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Found language file: include/language/fr_FR.lang.php
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Found extended language file: custom/application/Ext/Language/fr_FR.lang.ext.php
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Found custom language file: custom/include/language/fr_FR.lang.php
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT  af.name, af.aclaccess FROM acl_fields af  INNER JOIN acl_roles_users aru ON aru.user_id = '1' AND aru.deleted=0
                    INNER JOIN acl_roles ar ON aru.role_id = ar.id AND ar.id = af.role_id AND ar.deleted = 0 WHERE af.deleted = 0  AND af.category='Contracts'
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.0014889240264893
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT count(*) as the_count FROM config WHERE category='info' AND name='sugar_version' AND value = '7.5.2.1'
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.00094413757324219
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT category, name, value, platform FROM config WHERE category = 'license'
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.001060962677002
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system'
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.00058698654174805
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT * FROM outbound_email WHERE id = '4657ae92-f2af-9bf5-7fc3-557868de99ec'
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.00061821937561035
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Performing action: action_listview MODULE: Contracts
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Retrieve Team: SELECT teams.* FROM teams  WHERE associated_user_id = '1' AND deleted=0
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Limit Query:SELECT teams.* FROM teams  WHERE associated_user_id = '1' AND deleted=0 Start: 0 count: 1
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT teams.* FROM teams  WHERE associated_user_id = '1' AND deleted=0 LIMIT 0,1
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.0010430812835693
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Sprites: generated sprite -> border='0' align='absmiddle' data-orig="CreateContracts.gif" class="spr_e2c7942ad9c0201711b251872940605d" title="Nouveau Contrat"
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Sprites: generated sprite -> border='0' align='absmiddle' data-orig="Contracts.gif" class="spr_362b1209f7ff09055d965229e1291df1" title="Liste des Contrats"
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Sprites: generated sprite -> border='0' align='absmiddle' data-orig="Import.gif" class="spr_e463629dc70193ad83faedaa57d510c9" title="Import Contrat"
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT  af.name, af.aclaccess FROM acl_fields af  INNER JOIN acl_roles_users aru ON aru.user_id = '1' AND aru.deleted=0
                    INNER JOIN acl_roles ar ON aru.role_id = ar.id AND ar.id = af.role_id AND ar.deleted = 0 WHERE af.deleted = 0  AND af.category='Trackers'
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.00078511238098145
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Limit Query:SELECT item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = '1' AND deleted = 0 AND visible = 1) Start: 0 count: 50
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = '1' AND deleted = 0 AND visible = 1) LIMIT 0,50
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.0013918876647949
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Tracker: retrieving 10 items
Thu Jul  2 13:07:54 2015 [8400][1][WARN] Image Dashboards.gif not found
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Sprites: generated sprite -> border="0" align="absmiddle" data-orig="Users.gif" class="spr_facaa8696b1e07ff3959c20df08e77d0" title="FERNANDEZ, gaelle"
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Sprites: generated sprite -> border="0" align="absmiddle" data-orig="Contracts.gif" class="spr_362b1209f7ff09055d965229e1291df1" title="contrat06"
Thu Jul  2 13:07:54 2015 [8400][1][WARN] Image Dashboards.gif not found
Thu Jul  2 13:07:54 2015 [8400][1][WARN] Image Dashboards.gif not found
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Sprites: generated sprite -> border="0" align="absmiddle" data-orig="ACLRoles.gif" class="spr_4bdbafe390dba141e79a60553c0abc03" title="Standard User"
Thu Jul  2 13:07:54 2015 [8400][1][WARN] Image Dashboards.gif not found
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Sprites: generated sprite -> border="0" align="absmiddle" data-orig="Calls.gif" class="spr_a981d92515b326825fa94b334ce902da" title="devis mrh"
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Sprites: generated sprite -> border="0" align="absmiddle" data-orig="Users.gif" class="spr_facaa8696b1e07ff3959c20df08e77d0" title="VIOLLEAU, Karen"
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT category, name, value, platform FROM config WHERE category = 'MySettings'
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.0010662078857422
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system'
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.00061297416687012
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT * FROM outbound_email WHERE id = '4657ae92-f2af-9bf5-7fc3-557868de99ec'
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.00084614753723145
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT opportunities.id, opportunities.name FROM opportunities INNER JOIN contracts_opportunities ON opportunities.id=contracts_opportunities.opportunity_id INNER JOIN contracts ON contracts.id=contracts_opportunities.contract_id WHERE contracts.id='' AND contracts.deleted=0 AND opportunities.deleted=0 AND contracts_opportunities.deleted=0
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.0010838508605957
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] get_user_array query: SELECT contract_types.id, name as display from contract_types where deleted=0 AND  contract_types.deleted=0 order by contract_types.list_order
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT contract_types.id, name as display from contract_types where deleted=0 AND  contract_types.deleted=0 order by contract_types.list_order
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.00067305564880371
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] get_full_list:  order_by = 'name' and where = ''
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] process_full_list_query: query is  SELECT  currencies.*  FROM currencies  where currencies.deleted=0 ORDER BY currencies.name
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query: SELECT  currencies.*  FROM currencies  where currencies.deleted=0 ORDER BY currencies.name
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.00061202049255371
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] process_full_list_query: result is mysqli_result Object
(
    [current_field] => 0
    [field_count] => 10
    [lengths] =>
    [num_rows] => 0
    [type] => 0
)  Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Hook called: Currencies::before_retrieve
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Retrieve Currency : SELECT currencies.*  FROM currencies   WHERE currencies.id = 'USD $' AND currencies.deleted=0
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Limit Query:SELECT currencies.*  FROM currencies   WHERE currencies.id = 'USD $' AND currencies.deleted=0 Start: 0 count: 1
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT currencies.*  FROM currencies   WHERE currencies.id = 'USD $' AND currencies.deleted=0 LIMIT 0,1
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.00079703330993652
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:select id,name,list_order from contract_types where deleted = 0 order by list_order
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.0008540153503418
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query:SELECT id, name FROM saved_search
                  WHERE
                    deleted = '0' AND
                    assigned_user_id = '1' AND
                    search_module =  'Contracts'
                  ORDER BY name
Thu Jul  2 13:07:54 2015 [8400][1][INFO] Query Execution Time:0.0009148120880127
Thu Jul  2 13:07:54 2015 [8400][1][DEPRECATED] Using row number in fetchByAssoc is not portable and no longer supported. Please fix your code.
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Hook called: ::server_round_trip
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Creating new instance of hook class SugarMetric_HookManager without parameters
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Unregistered Transaction name for URI: /sugar_recette/index.php?module=Contracts&action=index&bwcFrame=1
Thu Jul  2 13:07:54 2015 [8400][1][DEBUG] Calling MySQLi::disconnect()
  'SugarACLStatic' => true,  


I know this is a bit long but well..


Maybe it is the "Unregistered Transaction name for URI: /sugar_recette/index.php?module=Contracts&action=index&bwcFrame=1" But i don't know what it means...


Could you please help me, it is a big urge we have, our customer are testing it !

Thanks a lot !

Outcomes