Using Community Edition as Project Management software and want your users to get an email when the are assigned to a Project Task? Simply install this fix for SugarCRM CE and your users will be notified upon being assigned to any Project Task.
#953 - Email notification enabled for Project Task - Emails Not Working
I just installed the Email notification enabled for Project Task add-on and it isn't sending emails. The default modules that send emails are working but the add-on is not. I did the install and I ran a quick repair. Please assist in getting this resolved.
SugarCRM CE 6.5
Best Regards,
-
"Notifications work well, but are very basic. would love to have the ability to customize the email." - dgreene
Read More Reviews
- Most Recent Love from Users
pbsvb- pbsvb
- Evalentine
- roger
- CRM Ninjas
10 years ago
Hi, first of all sorry for any inconvenience. Can you mark and paste the log of the error if its possible here?
You can do that by:
Click to admin -> setting -> log -> mark and then refresh from mark after you created the tasks.
Please let me know
Best regards
10 years ago
Wed Nov 19 23:59:52 2014 [22618][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Configurator::after_ui_frame Wed Nov 19 23:59:52 2014 [22618][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ::after_ui_footer Wed Nov 19 23:59:52 2014 [22618][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ::server_round_trip Wed Nov 19 23:59:52 2014 [22618][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Calling MySQLi::disconnect() Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] current_language is: en_us Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheMemcache Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheFile Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheMemory Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Using cache backend SugarCacheMemory, since 999 is less than 1000 Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheWincache Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheAPC Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCachesMash Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheZend Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheRedis Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheMemcached Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Found language file: en_us.lang.php Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Found extended language file: en_us.lang.ext.php Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Found custom language file: en_us.lang.php Wed Nov 19 23:59:58 2014 [22902][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone UTC. Please set date.timezone="UTC" in php.ini! Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0 Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query Execution Time:0.00086784362792969 Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query:SELECT category, name, value FROM config Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query Execution Time:0.0028529167175293 Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query Execution Time:0.0010020732879639 Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = '6a5276ab-2850-0a50-7121-5466d222f6e6' Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query Execution Time:0.00087904930114746 Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Hook called: ::after_entry_point Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Including module specific hook file for custom/modules Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Including Ext hook file for custom/application Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Hook called: ::after_session_start Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] We have an authenticated user id: a5d51c5c-69d1-7021-7dd2-5467ac195295 Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Hook called: Users::before_retrieve Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Including module specific hook file for custom/modules/Users Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND users.deleted=0 Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND users.deleted=0 Start: 0 count: 1 Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query:SELECT users.* FROM users WHERE users.id = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND users.deleted=0 LIMIT 0,1 Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query Execution Time:0.0014050006866455 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY first_name, last_name ASC Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY first_name, last_name ASC Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00088906288146973 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' and u1.deleted=0 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0010221004486084 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[User].load_relationships, Loading relationship (reports_to_link). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[User].load_relationships, Loading relationship (dash_dashboardmanager_users_1dash_dashboardmanager_ida). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT dash_dashboardmanager_users_1dash_dashboardmanager_ida id FROM dash_dashboardmanager_users_1_c WHERE dash_dashboardmanager_users_1_c.dash_dashboardmanager_users_1users_idb = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND dash_dashboardmanager_users_1_c.deleted=0 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00099802017211914 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[User].load_relationships, Loading relationship (dash_dashboardmanager_users_2dash_dashboardmanager_ida). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT dash_dashboardmanager_users_2dash_dashboardmanager_ida id FROM dash_dashboardmanager_users_2_c WHERE dash_dashboardmanager_users_2_c.dash_dashboardmanager_users_2users_idb = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND dash_dashboardmanager_users_2_c.deleted=0 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0010128021240234 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[User].load_relationships, Loading relationship (dash_dashboardmanager_usersdash_dashboardmanager_ida). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT dash_dashboardmanager_usersdash_dashboardmanager_ida id FROM dash_dashboardmanager_users_c WHERE dash_dashboardmanager_users_c.dash_dashboardmanager_usersusers_idb = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND dash_dashboardmanager_users_c.deleted=0 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00084090232849121 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified, ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted 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 = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND ear.deleted = 0 ORDER BY ear.reply_to_address, ear.primary_address DESC Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00090289115905762 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Users::after_retrieve Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Current user is: nb0110 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Current user is: nb0110 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] setting cookie ck_login_id_20 to a5d51c5c-69d1-7021-7dd2-5467ac195295 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] setting cookie ck_login_language_20 to en_us Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] current_language is: en_us Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Found language file: en_us.lang.php Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Found extended language file: en_us.lang.ext.php Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Found custom language file: en_us.lang.php Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT count() as the_count FROM config WHERE category='info' AND name='sugar_version' AND value = '6.5.18' Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0010008811950684 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT category, name, value FROM config WHERE category = 'license' Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00092887878417969 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00081801414489746 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT * FROM outbound_email WHERE id = '6a5276ab-2850-0a50-7121-5466d222f6e6' Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00080394744873047 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Module:ProjectTask using file: Save Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT category, name, value FROM config WHERE category = 'MySettings' Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0010099411010742 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00085186958312988 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT * FROM outbound_email WHERE id = '6a5276ab-2850-0a50-7121-5466d222f6e6' Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00090789794921875 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEPRECATED] Formatting correction: ProjectTask->order_number had formatting automatically corrected. This will be removed in the future, please upgrade your external code Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[ProjectTask].load_relationships, Loading relationship (projects_project_tasks). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean.load_relationships, Error Loading relationship (projects_project_tasks) Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[ProjectTask].load_relationships, Loading relationship (project_name_link). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][ERROR] Unable to get proper side for link project_name_link Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Project::before_retrieve Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Retrieve Project : SELECT project.,project_cstm.* FROM project LEFT JOIN project_cstm ON project.id = project_cstm.id_c WHERE project.id = '37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND project.deleted=0 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Limit Query:SELECT project.,project_cstm. FROM project LEFT JOIN project_cstm ON project.id = project_cstm.id_c WHERE project.id = '37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND project.deleted=0 Start: 0 count: 1 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT project.,project_cstm. FROM project LEFT JOIN project_cstm ON project.id = project_cstm.id_c WHERE project.id = '37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND project.deleted=0 LIMIT 0,1 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0012640953063965 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Accounts::before_retrieve Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Including module specific hook file for custom/modules/Accounts Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Retrieve Account : SELECT accounts.* FROM accounts WHERE accounts.id = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' AND accounts.deleted=0 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Limit Query:SELECT accounts.* FROM accounts WHERE accounts.id = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' AND accounts.deleted=0 Start: 0 count: 1 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT accounts.* FROM accounts WHERE accounts.id = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' AND accounts.deleted=0 LIMIT 0,1 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0011551380157471 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT a1.name from accounts a1, accounts a2 where a1.id = a2.parent_id and a2.id = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' and a1.deleted=0 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00082802772521973 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Account].load_relationships, Loading relationship (member_of). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Account].load_relationships, Loading relationship (campaign_accounts). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified, ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted 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 = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' AND ear.deleted = 0 ORDER BY ear.reply_to_address, ear.primary_address DESC Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00084400177001953 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Accounts::after_retrieve Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id ,accounts.name as accountname_c , accounts.assigned_user_id owner FROM accounts WHERE deleted=0 AND id='9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00084209442138672 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Project::after_retrieve Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][ERROR] Unable to get proper side for link project_name_link Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[ProjectTask].load_relationships, Loading relationship (projects). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Project].load_relationships, Loading relationship (projecttask). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id FROM project_task WHERE project_task.project_id = '37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND project_task.deleted=0 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0011889934539795 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Project::before_relationship_add Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::before_relationship_add Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Project::after_relationship_add Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::after_relationship_add Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::before_save Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:INSERT INTO project_task (id,date_entered,date_modified,project_id,name,status,description,date_start,date_finish,duration,time_due,assigned_user_id,modified_user_id,priority,created_by,milestone_flag,order_number,deleted,utilization) VALUES ('c38705e5-cc39-e4ed-213d-546d2e019b18','2014-11-19 23:59:58','2014-11-19 23:59:58','37e219ec-1b76-0e8f-ea0f-546a4feb7b08','Notification Test1','Not Started','',NULL,NULL,0,NULL,'a5d51c5c-69d1-7021-7dd2-5467ac195295','a5d51c5c-69d1-7021-7dd2-5467ac195295','High','a5d51c5c-69d1-7021-7dd2-5467ac195295',0,1,0,100) Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0029420852661133 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT category, name, value FROM config WHERE category = 'tracker' Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00085997581481934 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00079512596130371 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT * FROM outbound_email WHERE id = '6a5276ab-2850-0a50-7121-5466d222f6e6' Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00084686279296875 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::after_save Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[ProjectTask].load_relationships, Loading relationship (modified_user_link). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[ProjectTask].load_relationships, Loading relationship (created_by_link). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[ProjectTask].load_relationships, Loading relationship (project_name_link). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][ERROR] Unable to get proper side for link project_name_link Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][ERROR] Unable to get proper side for link project_name_link Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[ProjectTask].load_relationships, Loading relationship (assigned_user_link). Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query: SELECT project_task.* , LTRIM(RTRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')))) modified_by_name , jt0.created_by modified_by_name_owner , 'Users' modified_by_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(jt1.first_name,''),' ',IFNULL(jt1.last_name,'')))) created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , project.name project_name , project.assigned_user_id project_name_owner , 'Project' project_name_mod , LTRIM(RTRIM(CONCAT(IFNULL(jt3.first_name,''),' ',IFNULL(jt3.last_name,'')))) assigned_user_name , jt3.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod FROM project_task LEFT JOIN users jt0 ON project_task.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON project_task.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN project project ON project_task.project_id=project.id AND project.deleted=0
AND project.deleted=0 LEFT JOIN users jt3 ON project_task.assigned_user_id=jt3.id AND jt3.deleted=0
AND jt3.deleted=0 where (project_id = '37e219ec-1b76-0e8f-ea0f-546a4feb7b08') AND project_task.deleted=0 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.003054141998291 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::after_ui_frame Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ::after_ui_footer Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:INSERT INTO tracker (monitor_id,user_id,module_name,item_id,item_summary,date_modified,action,session_id,visible ) VALUES ( 'c96225f7-8b6b-90d1-34bc-546d2ee51ff1','a5d51c5c-69d1-7021-7dd2-5467ac195295','ProjectTask','c38705e5-cc39-e4ed-213d-546d2e019b18','Notification Test1','2014-11-19 23:59:58','save','vv19mr7cuejdu1jfgi4lta13k7','1') Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0027451515197754 Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ::server_round_trip Wed Nov 19 23:59:58 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Calling MySQLi::disconnect() Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] current_language is: en_us Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheMemcache Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheFile Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheMemory Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Using cache backend SugarCacheMemory, since 999 is less than 1000 Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheWincache Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheAPC Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCachesMash Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheZend Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheRedis Wed Nov 19 23:59:58 2014 [22902][-none-][DEBUG] Found cache backend SugarCacheMemcached Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Found language file: en_us.lang.php Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Found extended language file: en_us.lang.ext.php Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Found custom language file: en_us.lang.php Wed Nov 19 23:59:58 2014 [22902][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone UTC. Please set date.timezone="UTC" in php.ini! Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0 Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query Execution Time:0.00079488754272461 Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query:SELECT category, name, value FROM config Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query Execution Time:0.0025041103363037 Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query Execution Time:0.00098299980163574 Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = '6a5276ab-2850-0a50-7121-5466d222f6e6' Wed Nov 19 23:59:58 2014 [22902][-none-][INFO] Query Execution Time:0.00085186958312988 Wed Nov 19 23:59:59 2014 [22902][-none-][DEBUG] Hook called: ::after_entry_point Wed Nov 19 23:59:59 2014 [22902][-none-][DEBUG] Including module specific hook file for custom/modules Wed Nov 19 23:59:59 2014 [22902][-none-][DEBUG] Including Ext hook file for custom/application Wed Nov 19 23:59:59 2014 [22902][-none-][DEBUG] Hook called: ::after_session_start Wed Nov 19 23:59:59 2014 [22902][-none-][DEBUG] We have an authenticated user id: a5d51c5c-69d1-7021-7dd2-5467ac195295 Wed Nov 19 23:59:59 2014 [22902][-none-][DEBUG] Hook called: Users::before_retrieve Wed Nov 19 23:59:59 2014 [22902][-none-][DEBUG] Including module specific hook file for custom/modules/Users Wed Nov 19 23:59:59 2014 [22902][-none-][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND users.deleted=0 Wed Nov 19 23:59:59 2014 [22902][-none-][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND users.deleted=0 Start: 0 count: 1 Wed Nov 19 23:59:59 2014 [22902][-none-][INFO] Query:SELECT users.* FROM users WHERE users.id = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND users.deleted=0 LIMIT 0,1 Wed Nov 19 23:59:59 2014 [22902][-none-][INFO] Query Execution Time:0.0012950897216797 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY first_name, last_name ASC Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY first_name, last_name ASC Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00082492828369141 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' and u1.deleted=0 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00090312957763672 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[User].load_relationships, Loading relationship (reports_to_link). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[User].load_relationships, Loading relationship (dash_dashboardmanager_users_1dash_dashboardmanager_ida). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT dash_dashboardmanager_users_1dash_dashboardmanager_ida id FROM dash_dashboardmanager_users_1_c WHERE dash_dashboardmanager_users_1_c.dash_dashboardmanager_users_1users_idb = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND dash_dashboardmanager_users_1_c.deleted=0 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00094985961914062 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[User].load_relationships, Loading relationship (dash_dashboardmanager_users_2dash_dashboardmanager_ida). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT dash_dashboardmanager_users_2dash_dashboardmanager_ida id FROM dash_dashboardmanager_users_2_c WHERE dash_dashboardmanager_users_2_c.dash_dashboardmanager_users_2users_idb = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND dash_dashboardmanager_users_2_c.deleted=0 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00081491470336914 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[User].load_relationships, Loading relationship (dash_dashboardmanager_usersdash_dashboardmanager_ida). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT dash_dashboardmanager_usersdash_dashboardmanager_ida id FROM dash_dashboardmanager_users_c WHERE dash_dashboardmanager_users_c.dash_dashboardmanager_usersusers_idb = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND dash_dashboardmanager_users_c.deleted=0 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00090980529785156 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified, ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted 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 = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND ear.deleted = 0 ORDER BY ear.reply_to_address, ear.primary_address DESC Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00087404251098633 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Users::after_retrieve Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Current user is: nb0110 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Current user is: nb0110 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] setting cookie ck_login_id_20 to a5d51c5c-69d1-7021-7dd2-5467ac195295 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] setting cookie ck_login_language_20 to en_us Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] current_language is: en_us Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Found language file: en_us.lang.php Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Found extended language file: en_us.lang.ext.php Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Found custom language file: en_us.lang.php Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT count() as the_count FROM config WHERE category='info' AND name='sugar_version' AND value = '6.5.18' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00088405609130859 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT category, name, value FROM config WHERE category = 'license' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00082087516784668 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00077319145202637 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT * FROM outbound_email WHERE id = '6a5276ab-2850-0a50-7121-5466d222f6e6' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00093793869018555 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Project::before_retrieve Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Retrieve Project : SELECT project.,project_cstm.* FROM project LEFT JOIN project_cstm ON project.id = project_cstm.id_c WHERE project.id = '37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND project.deleted=0 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Limit Query:SELECT project.,project_cstm. FROM project LEFT JOIN project_cstm ON project.id = project_cstm.id_c WHERE project.id = '37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND project.deleted=0 Start: 0 count: 1 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT project.,project_cstm. FROM project LEFT JOIN project_cstm ON project.id = project_cstm.id_c WHERE project.id = '37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND project.deleted=0 LIMIT 0,1 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0011770725250244 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Accounts::before_retrieve Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Including module specific hook file for custom/modules/Accounts Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Retrieve Account : SELECT accounts.* FROM accounts WHERE accounts.id = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' AND accounts.deleted=0 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Limit Query:SELECT accounts.* FROM accounts WHERE accounts.id = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' AND accounts.deleted=0 Start: 0 count: 1 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT accounts.* FROM accounts WHERE accounts.id = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' AND accounts.deleted=0 LIMIT 0,1 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0011138916015625 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT a1.name from accounts a1, accounts a2 where a1.id = a2.parent_id and a2.id = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' and a1.deleted=0 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0008389949798584 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Account].load_relationships, Loading relationship (member_of). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Account].load_relationships, Loading relationship (campaign_accounts). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified, ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted 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 = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' AND ear.deleted = 0 ORDER BY ear.reply_to_address, ear.primary_address DESC Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00089907646179199 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Accounts::after_retrieve Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id ,accounts.name as accountname_c , accounts.assigned_user_id owner FROM accounts WHERE deleted=0 AND id='9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00082302093505859 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Project::after_retrieve Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Using Action View Map:detail Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT category, name, value FROM config WHERE category = 'tracker' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00084280967712402 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00082683563232422 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT * FROM outbound_email WHERE id = '6a5276ab-2850-0a50-7121-5466d222f6e6' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00090718269348145 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:INSERT INTO tracker (monitor_id,user_id,module_name,item_id,item_summary,date_modified,action,session_id,visible ) VALUES ( '1806943f-ade1-471b-38ef-546d2e5acaf4','a5d51c5c-69d1-7021-7dd2-5467ac195295','Project','37e219ec-1b76-0e8f-ea0f-546a4feb7b08','Medivation - T&E Staff Aug','2014-11-19 23:59:58','detailview','vv19mr7cuejdu1jfgi4lta13k7','1') Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0029799938201904 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][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 = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND deleted = 0 AND visible = 1) Start: 0 count: 50 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = 'a5d51c5c-69d1-7021-7dd2-5467ac195295' AND deleted = 0 AND visible = 1) LIMIT 0,50 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0015411376953125 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:DELETE FROM tracker where id = '1141' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0024831295013428 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Tracker: retrieving 10 items Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT category, name, value FROM config WHERE category = 'MySettings' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00085687637329102 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00079584121704102 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT * FROM outbound_email WHERE id = '6a5276ab-2850-0a50-7121-5466d222f6e6' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00085902214050293 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][WARN] Image CreateSERV_Server.gif not found Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][WARN] Image dashboard.png not found Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] metadatafile=custom/modules/Project/metadata/detailviewdefs.php Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Project::before_retrieve Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Retrieve Project : SELECT project.,project_cstm. FROM project LEFT JOIN project_cstm ON project.id = project_cstm.id_c WHERE project.id = '37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND project.deleted=0 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Limit Query:SELECT project.,project_cstm. FROM project LEFT JOIN project_cstm ON project.id = project_cstm.id_c WHERE project.id = '37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND project.deleted=0 Start: 0 count: 1 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT project.,project_cstm. FROM project LEFT JOIN project_cstm ON project.id = project_cstm.id_c WHERE project.id = '37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND project.deleted=0 LIMIT 0,1 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0012269020080566 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Accounts::before_retrieve Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Retrieve Account : SELECT accounts.* FROM accounts WHERE accounts.id = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' AND accounts.deleted=0 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Limit Query:SELECT accounts.* FROM accounts WHERE accounts.id = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' AND accounts.deleted=0 Start: 0 count: 1 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT accounts.* FROM accounts WHERE accounts.id = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' AND accounts.deleted=0 LIMIT 0,1 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0011751651763916 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT a1.name from accounts a1, accounts a2 where a1.id = a2.parent_id and a2.id = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' and a1.deleted=0 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00081086158752441 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Account].load_relationships, Loading relationship (member_of). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Account].load_relationships, Loading relationship (campaign_accounts). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified, ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted 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 = '9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' AND ear.deleted = 0 ORDER BY ear.reply_to_address, ear.primary_address DESC Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00091290473937988 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Accounts::after_retrieve Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id ,accounts.name as accountname_c , accounts.assigned_user_id owner FROM accounts WHERE deleted=0 AND id='9fd5ee93-ea7a-9d9f-3820-5467b4f1661a' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00092720985412598 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Project::after_retrieve Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Creating new instance of hook class teams_logic without parameters Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Project::after_ui_frame Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT meetings.id, name,reminder_time, description,location, status, parent_type, parent_id, date_start, assigned_user_id FROM meetings LEFT JOIN meetings_users ON meetings.id = meetings_users.meeting_id WHERE meetings_users.user_id ='a5d51c5c-69d1-7021-7dd2-5467ac195295' AND meetings_users.accept_status != 'decline' AND meetings.reminder_time != -1 AND meetings_users.deleted != 1 AND meetings.status = 'Planned' AND date_start >= '2014-11-19 23:59:58' AND date_start <= '2014-11-21 00:59:58' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0013649463653564 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query: SELECT calls.id, name, reminder_time, description, date_start, status, parent_type, parent_id FROM calls LEFT JOIN calls_users ON calls.id = calls_users.call_id WHERE calls_users.user_id ='a5d51c5c-69d1-7021-7dd2-5467ac195295' AND calls_users.accept_status != 'decline' AND calls.reminder_time != -1 AND calls_users.deleted != 1 AND calls.status = 'Planned' AND date_start >= '2014-11-19 23:59:58' AND date_start <= '2014-11-21 00:59:58' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0011801719665527 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SubPanelDefinitions->get_available_tabs(): projecttask= exempt Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SubPanelDefinitions->get_available_tabs(): activities= not exempt ACL OK Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SubPanelDefinitions->get_available_tabs(): history= exempt Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SubPanelDefinitions->get_available_tabs(): contacts= not exempt ACL OK Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SubPanelDefinitions->get_available_tabs(): accounts= not exempt ACL OK Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SubPanelDefinitions->get_available_tabs(): opportunities= not exempt ACL OK Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SubPanelDefinitions->get_available_tabs(): cases= not exempt ACL OK Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SubPanelDefinitions->get_available_tabs(): project_documents_1= not exempt ACL OK Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SubPanelDefinitions->get_available_tabs(): serv_server= not exempt ACL OK Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Project].load_relationships, Loading relationship (projecttask). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[ProjectTask].load_relationships, Loading relationship (assigned_user_link). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] process_union_list_query: (SELECT project_task.id , project_task.name , project_task.priority , project_task.status , project_task.percent_complete , project_task.date_start , project_task.estimated_effort , project_task.actual_effort , project_task.date_due , LTRIM(RTRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')))) assigned_user_name , project_task.assigned_user_id , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, project_task.created_by , 'projecttask' panel_name FROM project_task LEFT JOIN users jt0 ON project_task.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 INNER JOIN project projecttask_rel ON project_task.project_id=projecttask_rel.id AND projecttask_rel.deleted=0
where ( project_task.project_id='37e219ec-1b76-0e8f-ea0f-546a4feb7b08') AND project_task.deleted=0) ORDER BY project_task.status desc Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:( SELECT count(*) c FROM project_task INNER JOIN project projecttask_rel ON project_task.project_id=projecttask_rel.id AND projecttask_rel.deleted=0
where ( project_task.project_id='37e219ec-1b76-0e8f-ea0f-546a4feb7b08') AND project_task.deleted=0 ) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0014290809631348 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Limit Query:(SELECT project_task.id , project_task.name , project_task.priority , project_task.status , project_task.percent_complete , project_task.date_start , project_task.estimated_effort , project_task.actual_effort , project_task.date_due , LTRIM(RTRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')))) assigned_user_name , project_task.assigned_user_id , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, project_task.created_by , 'projecttask' panel_name FROM project_task LEFT JOIN users jt0 ON project_task.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 INNER JOIN project projecttask_rel ON project_task.project_id=projecttask_rel.id AND projecttask_rel.deleted=0
where ( project_task.project_id='37e219ec-1b76-0e8f-ea0f-546a4feb7b08') AND project_task.deleted=0) ORDER BY project_task.status desc Start: 0 count: 10 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:(SELECT project_task.id , project_task.name , project_task.priority , project_task.status , project_task.percent_complete , project_task.date_start , project_task.estimated_effort , project_task.actual_effort , project_task.date_due , LTRIM(RTRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')))) assigned_user_name , project_task.assigned_user_id , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, project_task.created_by , 'projecttask' panel_name FROM project_task LEFT JOIN users jt0 ON project_task.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 INNER JOIN project projecttask_rel ON project_task.project_id=projecttask_rel.id AND projecttask_rel.deleted=0
where ( project_task.project_id='37e219ec-1b76-0e8f-ea0f-546a4feb7b08') AND project_task.deleted=0) ORDER BY project_task.status desc LIMIT 0,10 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0019199848175049 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Offsets: (start, previous, next, last)(0, -10, 10, 10) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Offset (next, current, prev)(10, , -10) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Start/end records (1, 11) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT category, name, value FROM config WHERE category = 'system' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0010128021240234 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00091385841369629 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT * FROM outbound_email WHERE id = '6a5276ab-2850-0a50-7121-5466d222f6e6' Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00094914436340332 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::process_record Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::process_record Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::process_record Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::process_record Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::process_record Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::process_record Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::process_record Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::process_record Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::process_record Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: ProjectTask::process_record Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Project].load_relationships, Loading relationship (cases). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Case].load_relationships, Loading relationship (accounts). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Case].load_relationships, Loading relationship (assigned_user_link). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] process_union_list_query: (SELECT cases.id , cases.case_number , cases.name , accounts.name account_name , cases.account_id , accounts.assigned_user_id account_name_owner , 'Accounts' account_name_mod, cases.status , cases.priority , cases.date_entered , LTRIM(RTRIM(CONCAT(IFNULL(jt1.first_name,''),' ',IFNULL(jt1.last_name,'')))) assigned_user_name , cases.assigned_user_id , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, cases.created_by , 'cases' panel_name FROM cases LEFT JOIN accounts accounts ON cases.account_id=accounts.id AND accounts.deleted=0
AND accounts.deleted=0 LEFT JOIN users jt1 ON cases.assigned_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 INNER JOIN projects_cases ON cases.id=projects_cases.case_id AND projects_cases.project_id='37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND projects_cases.deleted=0
where cases.deleted=0) ORDER BY cases.case_number desc Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:( SELECT count(*) c FROM cases INNER JOIN projects_cases ON cases.id=projects_cases.case_id AND projects_cases.project_id='37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND projects_cases.deleted=0
where cases.deleted=0 ) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0014381408691406 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Limit Query:(SELECT cases.id , cases.case_number , cases.name , accounts.name account_name , cases.account_id , accounts.assigned_user_id account_name_owner , 'Accounts' account_name_mod, cases.status , cases.priority , cases.date_entered , LTRIM(RTRIM(CONCAT(IFNULL(jt1.first_name,''),' ',IFNULL(jt1.last_name,'')))) assigned_user_name , cases.assigned_user_id , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, cases.created_by , 'cases' panel_name FROM cases LEFT JOIN accounts accounts ON cases.account_id=accounts.id AND accounts.deleted=0
AND accounts.deleted=0 LEFT JOIN users jt1 ON cases.assigned_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 INNER JOIN projects_cases ON cases.id=projects_cases.case_id AND projects_cases.project_id='37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND projects_cases.deleted=0
where cases.deleted=0) ORDER BY cases.case_number desc Start: 0 count: 10 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:(SELECT cases.id , cases.case_number , cases.name , accounts.name account_name , cases.account_id , accounts.assigned_user_id account_name_owner , 'Accounts' account_name_mod, cases.status , cases.priority , cases.date_entered , LTRIM(RTRIM(CONCAT(IFNULL(jt1.first_name,''),' ',IFNULL(jt1.last_name,'')))) assigned_user_name , cases.assigned_user_id , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, cases.created_by , 'cases' panel_name FROM cases LEFT JOIN accounts accounts ON cases.account_id=accounts.id AND accounts.deleted=0
AND accounts.deleted=0 LEFT JOIN users jt1 ON cases.assigned_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 INNER JOIN projects_cases ON cases.id=projects_cases.case_id AND projects_cases.project_id='37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND projects_cases.deleted=0
where cases.deleted=0) ORDER BY cases.case_number desc LIMIT 0,10 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00090599060058594 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Offsets: (start, previous, next, last)(0, -10, 10, 0) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Offset (next, current, prev)(10, , -10) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Start/end records (1, 2) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Cases::process_record Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Including module specific hook file for custom/modules/Cases Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Project].load_relationships, Loading relationship (project_documents_1). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] process_union_list_query: (SELECT documents.id , documents.document_name , documents.document_revision_id , documents.category_id , documents.status_id , documents.active_date , documents.assigned_user_id , 'project_documents_1' panel_name FROM documents INNER JOIN project_documents_1_c ON documents.id=project_documents_1_c.project_documents_1documents_idb AND project_documents_1_c.project_documents_1project_ida='37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND project_documents_1_c.deleted=0
where documents.deleted=0) ORDER BY documents.id asc Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:( SELECT count(*) c FROM documents INNER JOIN project_documents_1_c ON documents.id=project_documents_1_c.project_documents_1documents_idb AND project_documents_1_c.project_documents_1project_ida='37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND project_documents_1_c.deleted=0
where documents.deleted=0 ) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0011248588562012 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Offsets: (start, previous, next, last)(0, -10, 10, 0) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Offset (next, current, prev)(10, , -10) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Start/end records (0, 1) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] SugarBean[Project].load_relationships, Loading relationship (contacts). Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] process_union_list_query: (SELECT contacts.id , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) as name, contacts.phone_mobile , contacts.phone_work , contacts.primary_address_street , contacts.primary_address_city , contacts.primary_address_state , contacts.primary_address_postalcode , contacts.first_name , contacts.last_name , contacts.salutation , contacts.assigned_user_id , 'contacts' panel_name FROM contacts INNER JOIN projects_contacts ON contacts.id=projects_contacts.contact_id AND projects_contacts.project_id='37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND projects_contacts.deleted=0
where contacts.deleted=0) ORDER BY contacts.last_name, contacts.first_name asc Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:( SELECT count(*) c FROM contacts INNER JOIN projects_contacts ON contacts.id=projects_contacts.contact_id AND projects_contacts.project_id='37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND projects_contacts.deleted=0
where contacts.deleted=0 ) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.0012249946594238 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Limit Query:(SELECT contacts.id , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) as name, contacts.phone_mobile , contacts.phone_work , contacts.primary_address_street , contacts.primary_address_city , contacts.primary_address_state , contacts.primary_address_postalcode , contacts.first_name , contacts.last_name , contacts.salutation , contacts.assigned_user_id , 'contacts' panel_name FROM contacts INNER JOIN projects_contacts ON contacts.id=projects_contacts.contact_id AND projects_contacts.project_id='37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND projects_contacts.deleted=0
where contacts.deleted=0) ORDER BY contacts.last_name, contacts.first_name asc Start: 0 count: 10 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:(SELECT contacts.id , LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')))) as name, contacts.phone_mobile , contacts.phone_work , contacts.primary_address_street , contacts.primary_address_city , contacts.primary_address_state , contacts.primary_address_postalcode , contacts.first_name , contacts.last_name , contacts.salutation , contacts.assigned_user_id , 'contacts' panel_name FROM contacts INNER JOIN projects_contacts ON contacts.id=projects_contacts.contact_id AND projects_contacts.project_id='37e219ec-1b76-0e8f-ea0f-546a4feb7b08' AND projects_contacts.deleted=0
where contacts.deleted=0) ORDER BY contacts.last_name, contacts.first_name asc LIMIT 0,10 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query Execution Time:0.00091981887817383 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Offsets: (start, previous, next, last)(0, -10, 10, 0) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Offset (next, current, prev)(10, , -10) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Start/end records (1, 2) Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Hook called: Contacts::process_record Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Including module specific hook file for custom/modules/Contacts Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][DEBUG] Limit Query:SELECT ea.email_address FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id WHERE ear.bean_module = 'Contacts' AND ear.bean_id = '4676463b-f375-5ee7-724b-546cc98dc094' AND ear.deleted = 0 AND ea.invalid_email = 0 ORDER BY ear.primary_address DESC Start: 0 count: 1 Wed Nov 19 23:59:59 2014 [22902][a5d51c5c-69d1-7021-7dd2-5467ac195295][INFO] Query:SELECT ea.email_address FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id WHERE ear.bean_module = 'Contacts' AND ear.bean_id = '4676463b-f375-5ee7-724b-546cc98dc094' AND ear.deleted = 0 AND ea.invalid_email = 0 ORDER BY ear.primary_address DESC LIMIT 0,1 We
10 years ago
Any Update? I need this module to work. Do I need to tune down the logging level? If so, what level would you like?
10 years ago
Ticket can be closed, my testing was invalid. It won't send an email if the user creating the record is also the user who is being assigned the record. Sorry for the alarm. The product works great.
10 years ago
Thanks Guy13. Great to hear that the problem has been solved.
If you have any further question please feel free to contact us.