Customized Task and Dashboard Views Stop Displaying - 500 Internal Server - SuiteCRM 7.9.7 and earlier

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hello Community,

Currently running 7.9.7, but this is preexisting condition from whatever version I started on…7.9.X

Tried recommendations of:

  • changing/updating ownership
  • changing/updating permission level to 755 and/or 777

I did a lot of customization to the different layouts, labels, fields and relationships of the task module and at one point the List view in the task module stopped displaying as well as the dashboard stopped displaying, receiving same 500 error.

I asked my server admin to provide me with the files from the /custom/modules and /modules directory to put on my test server to see if I can notice anything, but this seems to be a programmatic issue with customization. I have not found a clear bug fix but plenty of references.

Thoughts?

2

What do you see in your logs? Both suitecrm.log and php_errors.log (this one should have something FATAL when you get the blank page).

3

This is the entry from the log under system settings in the Admin section:

Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][DEBUG] Hook called: Users::after_retrieve
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][DEBUG] Current user is: mcolangelo@valmarc.com
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][DEBUG] Current user is: mcolangelo@valmarc.com
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][DEBUG] setting cookie ck_login_id_20 to 55eb0377-1c33-97a3-ec14-598a6f4a59cf
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][DEBUG] setting cookie ck_login_language_20 to en_us
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][DEBUG] current_language is: en_us
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][INFO] Found language file: en_us.lang.php
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][INFO] Found extended language file: en_us.lang.ext.php
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][INFO] Found custom language file: en_us.lang.php
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][DEBUG] Performing action: action_listview MODULE: Tasks
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] CSS File yui.css not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Create.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image List.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][INFO] Query:SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = ‘55eb0377-1c33-97a3-ec14-598a6f4a59cf’ AND deleted = 0 ORDER BY date_entered DESC
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][INFO] Query Execution Time:0.00040698051452637
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][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 = ‘55eb0377-1c33-97a3-ec14-598a6f4a59cf’ AND deleted = 0 AND visible = 1) Start: 0 count: 50
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][INFO] Query:SELECT item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = ‘55eb0377-1c33-97a3-ec14-598a6f4a59cf’ AND deleted = 0 AND visible = 1) LIMIT 0,50
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][INFO] Query Execution Time:0.00069499015808105
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][INFO] Tracker: retrieving 10 items
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Create.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image List.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Create.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Create_Contact_Vcard.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image List.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Add.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image View.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Create.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image List.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Create.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image List.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Create.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image List.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Add.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image View.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Create.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image List.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Add.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image View.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Create.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image List.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Add.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image View.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Create.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image List.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image View_Process_Audit.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Schedule_Call.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image List.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image Create.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image List.gif not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][WARN] Image dashboard.png not found
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][DEBUG] metadatafile=custom/modules/Tasks/metadata/listviewdefs.php
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name from users WHERE status=‘Active’ AND portal_only=0 ORDER BY first_name, last_name ASC
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE status=‘Active’ AND portal_only=0 ORDER BY first_name, last_name ASC
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][INFO] Query Execution Time:0.00032281875610352
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][INFO] Query:SELECT id, name FROM saved_search
WHERE
deleted = ‘0’ AND
assigned_user_id = ‘55eb0377-1c33-97a3-ec14-598a6f4a59cf’ AND
search_module = ‘Tasks’
ORDER BY name
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][INFO] Query Execution Time:0.00037121772766113
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][DEPRECATED] Using row number in fetchByAssoc is not portable and no longer supported. Please fix your code.
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][DEBUG] Hook called: ::server_round_trip
Tue Jan 2 19:49:36 2018 [44272][55eb0377-1c33-97a3-ec14-598a6f4a59cf][DEBUG] Calling MySQLi::disconnect()

4

Same section, but reporting only fatal errors:

Tue Jan 2 19:55:48 2018 [42968][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone UTC. Please set date.timezone=“UTC” in php.ini!

5

On another note, I disabled all the Ajax settings for the modules. I then only enabled Tasks. I receive this message

6

Focus on your timezone bug first, you really need to fix that and it should be easy. Edit php.ini.

Keep examining your web server’s PHP log until you can get rid of those 500 errors. Pay attention to the time of the messages in the log - you want the ones given at the moment your server crashes.