by zagosweden

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.

Includes a 30 day guarantee
Try it Now

#953 - Email notification enabled for Project Task - Emails Not Working

Open Bug? created by guy13 Verified Purchase 5 years ago

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,

  1. simpledave member avatar

    zagosweden Provider Affiliate

    5 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

  2. nbrown member avatar

    guy13 Verified Purchase

    5 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

  3. nbrown member avatar

    guy13 Verified Purchase

    5 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?

  4. nbrown member avatar

    guy13 Verified Purchase

    5 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.

    • simpledave member avatar

      zagosweden Provider Affiliate

      5 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.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.