Blank screen when select contact detail view

**lindquie** · 2006-07-28, 08:51 PM

When I select a contact to view details, I get a blank screen. Internet Explorer says the server dropped connection.

I have been reviewing the forum for two weeks:

It does not seem to be a problem of rebuilding relationships. my relationships.cache.php seems to be fine (attached).
It does not seem to be a memory related problem.

I need to get this problem resolved, as our sales are growing fast, and we need to be able to edit our contacts.

Thanks,
Erik

I am running:
Sugar Suite Open Source Version 4.2.1
Category: Contacts
Operating System: Linux (paid host)
MySQL - 4.1.18-standard
PHP Version 5.1.4 php:
memory_limit 25M (can't increase) but does not seem to be a problem either
Apache

Debug Log

Code:

Fri Jul 28 15:35:08 2006,189 [8846] INFO SugarCRM - In module: Contacts -- About to take action DetailView
Fri Jul 28 15:35:08 2006,192 [8846] DEBUG SugarCRM - in module Contacts -- in DetailView
Fri Jul 28 15:35:08 2006,195 [8846] DEBUG SugarCRM - ----------------------------------------------------------------------------------------------------------------------------------------------
Fri Jul 28 15:35:08 2006,199 [8846] INFO SugarCRM - current page is modules/Contacts/DetailView.php
Fri Jul 28 15:35:08 2006,202 [8846] INFO SugarCRM - current module is Contacts
Fri Jul 28 15:35:08 2006,206 [8846] INFO SugarCRM - Query:SELECT count(*) as the_count FROM config WHERE category='info' AND name='sugar_version' AND value = '4.2.1'
Fri Jul 28 15:35:08 2006,210 [8846] INFO SugarCRM - Query Execution Time:0.000141
Fri Jul 28 15:35:08 2006,214 [8846] DEBUG SugarCRM - current_language is: en_us
Fri Jul 28 15:35:08 2006,228 [8846] INFO SugarCRM - Found custom language file: en_us.lang.php
Fri Jul 28 15:35:08 2006,234 [8846] DEBUG SugarCRM - ----> BEGIN DETAILVIEW TRACKER <----
Fri Jul 28 15:35:08 2006,307 [8846] DEBUG SugarCRM - Retrieve Contact : SELECT contacts.* FROM contacts  WHERE contacts.id = '351ad9d8-fd63-11a0-b2c9-44b5605ae148' 
Fri Jul 28 15:35:08 2006,309 [8846] DEBUG SugarCRM - Limit Query:SELECT contacts.* FROM contacts  WHERE contacts.id = '351ad9d8-fd63-11a0-b2c9-44b5605ae148'  Start: 0 count: 1
Fri Jul 28 15:35:08 2006,311 [8846] INFO SugarCRM - Query:SELECT contacts.* FROM contacts  WHERE contacts.id = '351ad9d8-fd63-11a0-b2c9-44b5605ae148'  LIMIT 0,1
Fri Jul 28 15:35:08 2006,314 [8846] INFO SugarCRM - Query Execution Time:0.00023200000000001
Fri Jul 28 15:35:08 2006,328 [8846] DEBUG SugarCRM - get_user_array query: SELECT id, first_name, last_name, user_name from users WHERE 1=1 AND is_group=0  order by user_name asc
Fri Jul 28 15:35:08 2006,330 [8846] INFO SugarCRM - Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 AND is_group=0  order by user_name asc
Fri Jul 28 15:35:08 2006,333 [8846] INFO SugarCRM - Query Execution Time:0.00042500000000001
Fri Jul 28 15:35:08 2006,336 [8846] INFO SugarCRM - Query:SELECT acc.id, acc.name, con_reports_to.first_name, con_reports_to.last_name 
		from contacts 
		left join accounts_contacts a_c on a_c.contact_id = '351ad9d8-fd63-11a0-b2c9-44b5605ae148' and a_c.deleted=0
		left join accounts acc on a_c.account_id = acc.id and acc.deleted=0
		left join contacts con_reports_to on con_reports_to.id = contacts.reports_to_id
		where contacts.id = '351ad9d8-fd63-11a0-b2c9-44b5605ae148'
Fri Jul 28 15:35:08 2006,338 [8846] INFO SugarCRM - Query Execution Time:0.00010099999999996
Fri Jul 28 15:35:08 2006,341 [8846] DEBUG SugarCRM - SugarBean.load_relationships, Loading relationship (user_sync).
Fri Jul 28 15:35:08 2006,349 [8846] DEBUG SugarCRM - Link Constructor, relationship name: contacts_users
Fri Jul 28 15:35:08 2006,352 [8846] DEBUG SugarCRM - Link Constructor, Table name: 
Fri Jul 28 15:35:08 2006,354 [8846] DEBUG SugarCRM - Link Constructor, Key name: 
Fri Jul 28 15:35:08 2006,358 [8846] INFO SugarCRM - Query:SELECT * from relationships where deleted=0
Fri Jul 28 15:35:08 2006,362 [8846] INFO SugarCRM - Query Execution Time:0.001508
Fri Jul 28 15:35:08 2006,401 [8846] DEBUG SugarCRM - Link Constructor, _bean_table_name: contacts
Fri Jul 28 15:35:08 2006,403 [8846] DEBUG SugarCRM - Link Constructor, _bean_key_name: id
Fri Jul 28 15:35:08 2006,406 [8846] DEBUG SugarCRM - Link Constructor, relationship record found.
Fri Jul 28 15:35:08 2006,408 [8846] DEBUG SugarCRM - getQuery, Bean is LHS: 1
Fri Jul 28 15:35:08 2006,410 [8846] DEBUG SugarCRM - getQuery, Relationship type=many-to-many
Fri Jul 28 15:35:08 2006,413 [8846] DEBUG SugarCRM - getQuery, Relationship role column name=
Fri Jul 28 15:35:08 2006,415 [8846] DEBUG SugarCRM - Processing many-to-many.
Fri Jul 28 15:35:08 2006,418 [8846] DEBUG SugarCRM - Finding linked records Contact:  SELECT users.id FROM users INNER JOIN contacts_users ON (users.id=contacts_users.user_id AND contacts_users.contact_id='351ad9d8-fd63-11a0-b2c9-44b5605ae148')  WHERE contacts_users.deleted=0 AND users.deleted=0 AND users.id = '1'
Fri Jul 28 15:35:08 2006,420 [8846] INFO SugarCRM - Query: SELECT users.id FROM users INNER JOIN contacts_users ON (users.id=contacts_users.user_id AND contacts_users.contact_id='351ad9d8-fd63-11a0-b2c9-44b5605ae148')  WHERE contacts_users.deleted=0 AND users.deleted=0 AND users.id = '1'
Fri Jul 28 15:35:08 2006,423 [8846] INFO SugarCRM - Query Execution Time:0.00035299999999999

**frb** · 2006-08-18, 07:44 AM

blank screen = apache did not finish its job => look at the apache logs for more info (it also contains the php errors: syntax, unset variables, etc...)