Results 1 to 6 of 6

Thread: Accounts module detailview action loads a blank page / white page

  1. 2011-02-02, 05:01 PM #1
    justworkalready
    justworkalready is offline Junior Member
    Join Date
    Feb 2011
    Posts
    4

    Default Accounts module detailview action loads a blank page / white page

    Hi!

    I installed Sugar 6.1 pro, and support is slow. I assume the weather is keeping em slow. Wondering if anyone can help with this problem.

    When I navigate to the Accounts module, the accounts search and the accounts edit work fine, but when I click to view an account, it goes to the detailview action. The page loads but then does not display anything. It is just a blank white page. If I view source on the page, I get:

    ------------------------------------------

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    <HTML><HEAD>
    <META content="text/html; charset=utf-8" http-equiv=Content-Type></HEAD>
    <BODY></BODY></HTML>
    V

    --------------------------------------

    The detailview for the other modules works.

    When this happened, I deleted my installation of sugar and reinstalled it without error. The same devailview of the acounts module problem persisted through the re installation. I have double checked all of the files to make sure that they are present and have correct permissions.

    I have deleted the sugarcrm.log, opened up the accounts page that gives me error, and then downloaded the sugar log. I have attached that isolated log here. The log was set to Debug so I could try to see what was failing to load.

    I'm running:
    Apache version 2.2.17
    PHP version 5.2.16
    MySQL version 5.1.54

    ----------------------------------------
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] using MysqliManager DBManager backend
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] using MysqliHelper DBHelper backend
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] Query Execution Time:8.20159912109E-5
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] Query:SELECT category, name, value FROM config
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] Query Execution Time:0.00012993812561
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system'
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] Query Execution Time:0.000115871429443
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = 'e527a4d8-5e20-9224-5c84-4d488423cdcc'
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] Query Execution Time:8.51154327393E-5
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] Query:SELECT date_start, round_trips, active FROM tracker_sessions WHERE session_id = '46181d2057bcaf25a035e29cdf74b5a5'
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] Query Execution Time:0.000101089477539
    Wed Feb 2 11:22:17 2011 [14106][-none-][DEBUG] We have an authenticated user id: 1
    Wed Feb 2 11:22:17 2011 [14106][-none-][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0
    Wed Feb 2 11:22:17 2011 [14106][-none-][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1
    Wed Feb 2 11:22:17 2011 [14106][-none-][INFO] Query Execution Time:0.000112056732178
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:7.60555267334E-5
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] additional detail query results:
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT team_id, teams.name, teams.name_2 FROM team_memberships rel RIGHT JOIN teams ON (rel.team_id = teams.id) WHERE rel.user_id = '1' AND rel.team_id = '1'
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:5.98430633545E-5
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] SugarBean.load_relationships, Loading relationship (reports_to_id).
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Retrieve Team : SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Limit Query:SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0 Start: 0 count: 1
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0 LIMIT 0,1
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:0.000108957290649
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Retrieve Team : SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Limit Query:SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0 Start: 0 count: 1
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0 LIMIT 0,1
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:8.89301300049E-5
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT id ,teams.name as team_name , teams.created_by owner FROM teams WHERE deleted=0 AND id='1'
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:6.48498535156E-5
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT ea.*, ear.* FROM email_addresses ea
    LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
    WHERE ear.bean_module = 'Users'
    AND ear.bean_id = '1'
    AND ear.deleted = 0
    ORDER BY ear.reply_to_address, ear.primary_address DESC
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:9.98973846436E-5
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Current user is: admin
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Current user is: admin
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] setting cookie ck_login_id_20 to 1
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] setting cookie ck_login_language_20 to en_us
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] current_language is: en_us

    continued in next post
    Reply With Quote Reply With Quote
  2. 2011-02-02, 05:04 PM #2
    justworkalready
    justworkalready is offline Junior Member
    Join Date
    Feb 2011
    Posts
    4

    Default Re: Accounts module detailview action loads a blank page / white page

    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT count(*) as the_count FROM config WHERE category='info' AND name='sugar_version' AND value = '6.1.0'
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:0.000130891799927
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Retrieve Account : SELECT accounts.* FROM accounts WHERE accounts.id = '22e266af-ecc0-1d31-a1d4-4d4884c5accd' AND accounts.deleted=0
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Limit Query:SELECT accounts.* FROM accounts WHERE accounts.id = '22e266af-ecc0-1d31-a1d4-4d4884c5accd' AND accounts.deleted=0 Start: 0 count: 1
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT accounts.* FROM accounts WHERE accounts.id = '22e266af-ecc0-1d31-a1d4-4d4884c5accd' AND accounts.deleted=0 LIMIT 0,1
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:0.0001220703125
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY user_name ASC
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY user_name ASC
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:5.79357147217E-5
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] get_team_array query: SELECT t1.id, t1.name, t1.name_2 FROM teams t1 where t1.deleted = 0 ORDER BY t1.private,t1.name ASC
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT t1.id, t1.name, t1.name_2 FROM teams t1 where t1.deleted = 0 ORDER BY t1.private,t1.name ASC
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:5.19752502441E-5
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT a1.name from accounts a1, accounts a2 where a1.id = a2.parent_id and a2.id = '22e266af-ecc0-1d31-a1d4-4d4884c5accd' and a1.deleted=0
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:5.10215759277E-5
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Retrieve Team : SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Limit Query:SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0 Start: 0 count: 1
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT teams.* FROM teams WHERE teams.id = '1' AND teams.deleted=0 LIMIT 0,1
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:5.69820404053E-5
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] SugarBean.load_relationships, Loading relationship (parent_id).
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] SugarBean.load_relationships, Loading relationship (campaign_id).
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT ea.*, ear.* FROM email_addresses ea
    LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
    WHERE ear.bean_module = 'Accounts'
    AND ear.bean_id = '22e266af-ecc0-1d31-a1d4-4d4884c5accd'
    AND ear.deleted = 0
    ORDER BY ear.reply_to_address, ear.primary_address DESC
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:8.70227813721E-5
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Using Action View Map:detail
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Retrieve Team: SELECT teams.* FROM teams WHERE associated_user_id = '1' AND deleted=0
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Limit Query:SELECT teams.* FROM teams WHERE associated_user_id = '1' AND deleted=0 Start: 0 count: 1
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT teams.* FROM teams WHERE associated_user_id = '1' AND deleted=0 LIMIT 0,1
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:0.000119924545288
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:INSERT INTO tracker (monitor_id,user_id,module_name,item_id,item_summa ry,team_id,date_modified,action,session_id,visible ) VALUES ( 'cb64b46e-a877-72a8-06bf-4d4992ace74b','1','Accounts','22e266af-ecc0-1d31-a1d4-4d4884c5accd','test acct 1','97e90247-25cf-268c-0ff1-4d4884bfdc02','2011-02-02 17:22:17','detailview','46181d2057bcaf25a035e29cdf 74b5a5','1')
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:0.000236988067627
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Retrieve SugarFavorites : SELECT sugarfavorites.* FROM sugarfavorites WHERE sugarfavorites.id = '59272805d5e097c9eb44e1e2332d88b4' AND sugarfavorites.deleted=0
    Wed Feb 2 11:22:17 2011 [14106][1][DEBUG] Limit Query:SELECT sugarfavorites.* FROM sugarfavorites WHERE sugarfavorites.id = '59272805d5e097c9eb44e1e2332d88b4' AND sugarfavorites.deleted=0 Start: 0 count: 1
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query:SELECT sugarfavorites.* FROM sugarfavorites WHERE sugarfavorites.id = '59272805d5e097c9eb44e1e2332d88b4' AND sugarfavorites.deleted=0 LIMIT 0,1
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:8.39233398438E-5
    Wed Feb 2 11:22:17 2011 [14106][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 visible = 1) Start: 0 count: 50
    Wed Feb 2 11:22:17 2011 [14106][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 visible = 1) LIMIT 0,50
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:0.000324010848999
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] QueryELETE FROM tracker where id = '8'
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Query Execution Time:0.0001540184021
    Wed Feb 2 11:22:17 2011 [14106][1][INFO] Tracker: retrieving 3 items
    Wed Feb 2 11:22:17 2011 [14106][1][WARN] Image AddTab.gif not found
    Wed Feb 2 11:22:18 2011 [14106][1][DEBUG] rebuilding cache for Notifications
    Wed Feb 2 11:22:18 2011 [14106][1][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module='Notifications' AND deleted = 0
    Wed Feb 2 11:22:18 2011 [14106][1][INFO] Query Execution Time:0.000140905380249
    Wed Feb 2 11:22:18 2011 [14106][1][DEBUG] metadatafile=custom/modules/Accounts/metadata/detailviewdefs.php
    Wed Feb 2 11:22:18 2011 [14106][1][DEBUG] SUGARVCR is recording more records
    Wed Feb 2 11:22:18 2011 [14106][1][DEBUG] Limit Query: SELECT accounts.id , accounts.name , accounts.billing_address_city , accounts.billing_address_country , accounts.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, accounts.assigned_user_id , sfav.id is_favorite FROM accounts LEFT JOIN users jt0 ON
    jt0.id= accounts.assigned_user_id AND jt0.deleted=0
    AND jt0.deleted=0 LEFT JOIN sugarfavorites sfav ON sfav.module ='Accounts' AND sfav.record_id=accounts.id AND sfav.assigned_user_id='1' AND sfav.deleted=0 where accounts.deleted=0 ORDER BY accounts.date_entered DESC Start: 0 count: 52
    Wed Feb 2 11:22:18 2011 [14106][1][INFO] Query: SELECT accounts.id , accounts.name , accounts.billing_address_city , accounts.billing_address_country , accounts.phone_office , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, accounts.assigned_user_id , sfav.id is_favorite FROM accounts LEFT JOIN users jt0 ON
    jt0.id= accounts.assigned_user_id AND jt0.deleted=0
    AND jt0.deleted=0 LEFT JOIN sugarfavorites sfav ON sfav.module ='Accounts' AND sfav.record_id=accounts.id AND sfav.assigned_user_id='1' AND sfav.deleted=0 where accounts.deleted=0 ORDER BY accounts.date_entered DESC LIMIT 0,52
    Wed Feb 2 11:22:18 2011 [14106][1][INFO] Query Execution Time:0.000648975372314
    Wed Feb 2 11:22:18 2011 [14106][1][INFO] Query:SELECT ea.*, ear.* FROM email_addresses ea
    LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
    WHERE ear.bean_module = 'Accounts'
    AND ear.bean_id = '22e266af-ecc0-1d31-a1d4-4d4884c5accd'
    AND ear.deleted = 0
    ORDER BY ear.reply_to_address, ear.primary_address DESC
    Wed Feb 2 11:22:18 2011 [14106][1][INFO] Query Execution Time:0.000170946121216
    Wed Feb 2 11:22:18 2011 [14106][1][DEBUG] Retrieve SugarFavorites : SELECT sugarfavorites.* FROM sugarfavorites WHERE sugarfavorites.id = '59272805d5e097c9eb44e1e2332d88b4' AND sugarfavorites.deleted=0
    Wed Feb 2 11:22:18 2011 [14106][1][DEBUG] Limit Query:SELECT sugarfavorites.* FROM sugarfavorites WHERE sugarfavorites.id = '59272805d5e097c9eb44e1e2332d88b4' AND sugarfavorites.deleted=0 Start: 0 count: 1
    Wed Feb 2 11:22:18 2011 [14106][1][INFO] Query:SELECT sugarfavorites.* FROM sugarfavorites WHERE sugarfavorites.id = '59272805d5e097c9eb44e1e2332d88b4' AND sugarfavorites.deleted=0 LIMIT 0,1
    Wed Feb 2 11:22:18 2011 [14106][1][INFO] Query Execution Time:0.000128030776978
    Wed Feb 2 11:22:29 2011 [14106][1][DEBUG] Calling DBManager::disconnect()
    Reply With Quote Reply With Quote
  3. 2011-02-02, 05:44 PM #3
    andopes's Avatar
    andopes
    andopes is offline A Sugar Hero | Help Forum Moderator
    Send a message via MSN to andopes Send a message via Skype™ to andopes
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Accounts module detailview action loads a blank page / white page

    It is due initial loading of Connectors which try to allocate a ruge amount of memory.
    You have to increase memory_limit to 256M at php.ini, load the Accounts DetailView then you can restore the initial value.

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.
    Reply With Quote Reply With Quote
  4. 2011-02-02, 06:22 PM #4
    justworkalready
    justworkalready is offline Junior Member
    Join Date
    Feb 2011
    Posts
    4

    Default Re: Accounts module detailview action loads a blank page / white page

    Your knowledge of sugarcrm is an inspiration to us all. Thank you for taking the time to troll these forums.

    It worked.
    Reply With Quote Reply With Quote
  5. 2011-02-07, 11:33 AM #5
    Darrensouthafrica
    Darrensouthafrica is offline Junior Member
    Join Date
    Aug 2010
    Posts
    5

    Default Re: Accounts module detailview action loads a blank page / white page

    On the subject of php memory allocation.
    How much memory do you need to allocate to php?
    I have a number of problems which I think are related to memory.

    process watch killing the cron when Im sending mailing campaigns.
    and
    I want to change one of the lists and I get this, which isnt an error. per-say
    account_type_dom, loading page, please wait done. the page never loads and I think its memory related but I'm not sure.

    The sugarcrm is in a hosted environment and I can only allocate 50mb to the php is that enough? Do you think I must move to a dedicated server?

    Thanks in advance
    Darren
    Last edited by Darrensouthafrica; 2011-02-07 at 11:34 AM. Reason: mistake
    Reply With Quote Reply With Quote
  6. 2011-02-07, 11:58 AM #6
    andopes's Avatar
    andopes
    andopes is offline A Sugar Hero | Help Forum Moderator
    Send a message via MSN to andopes Send a message via Skype™ to andopes
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Accounts module detailview action loads a blank page / white page

    Quote Originally Posted by Darrensouthafrica View Post
    The sugarcrm is in a hosted environment and I can only allocate 50mb to the php is that enough? Do you think I must move to a dedicated server?
    This is not an appropriate memory allocation for SugarCRM.
    Theorically, if you will not deal with a huge amount of data, like Importing, Exporting, Mass Update so this amount would be "enough". But I´d say you will face troubles.
    In my opinion you should consider 256MB for php.
    It would make Sugar run faster.

    If your current environment does not support allocating more memory so you should consider a dedicate server.

    Best regards
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Speeding up page loads over SSL
    By mattn in forum Developer Help
    Replies: 4
    Last Post: 2010-12-21, 06:20 AM
  2. creating custom page (action) for module
    By dogfuel in forum Developer Help
    Replies: 1
    Last Post: 2009-05-18, 12:54 AM
  3. White page after loading custom module
    By blqt in forum Help
    Replies: 2
    Last Post: 2008-08-19, 06:34 PM
  4. Create New Contact/Account loads blank page
    By coreyp in forum Help
    Replies: 3
    Last Post: 2007-11-27, 01:35 PM
  5. action=Detailview module=Accounts
    By lorenzogrilli in forum Customer Support
    Replies: 0
    Last Post: 2005-09-28, 02:23 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules