Unable to Save Duplicate Contact

richardp · 23 March 2015 17:59

Hello!

I’ve ran into a possible bug in Suite CRM when trying to save a contact that has the same first and last name as one in an existing record.

In this case I am attempting to add a contact named Li Reeve

I go to create a new contact>Enter the contact information>click save.

I am then prompted to the “Save Contact” screen with the following message “The contact record you are about to create might be a duplicate of a contact record that already exists. Contacts records containing similar names are listed below. Click Save to continue creating this new contact, or click Cancel to return to the module without creating the contact.”

I click save and then I get this message “Error retrieving record. This record may be deleted or you may not be authorized to view it.”

Not sure if this is a setting I need to change or if it’s a bug. Any help would be appreciated.

Log files

03/23/15 11:51:58 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.001227855682373
03/23/15 11:51:59 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT meetings.id, name,reminder_time, CAST(description AS varchar(8000)) 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 =N’55549fe0-c0aa-b754-4128-542cc652acd9’
AND meetings_users.accept_status != N’decline’
AND meetings.reminder_time != -1
AND meetings_users.deleted != 1
AND meetings.status = N’Planned’
AND date_start >= CONVERT(datetime,N’2015-03-23 17:51:58’,120)
AND date_start <= CONVERT(datetime,N’2015-03-24 18:51:58’,120)
03/23/15 11:51:59 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.010382890701294
03/23/15 11:51:59 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:
SELECT calls.id, name, reminder_time, CAST(description AS varchar(8000)) 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 =N’55549fe0-c0aa-b754-4128-542cc652acd9’
AND calls_users.accept_status != N’decline’
AND calls.reminder_time != -1
AND calls_users.deleted != 1
AND calls.status = N’Planned’
AND date_start >= CONVERT(datetime,N’2015-03-23 17:51:58’,120)
AND date_start <= CONVERT(datetime,N’2015-03-24 18:51:58’,120)
03/23/15 11:51:59 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0061488151550293
03/23/15 11:52:00 [4976][-none-][INFO] Found language file: en_us.lang.php
03/23/15 11:52:00 [4976][-none-][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:00 [4976][-none-][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:00 [4976][-none-][INFO] Connect:Resource id #187
03/23/15 11:52:00 [4976][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = N’Active’ and deleted = 0
03/23/15 11:52:00 [4976][-none-][INFO] Query Execution Time:0.00056195259094238
03/23/15 11:52:00 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Users’ AND deleted = 0
03/23/15 11:52:00 [4976][-none-][INFO] Query Execution Time:0.00081491470336914
03/23/15 11:52:00 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Employees’ AND deleted = 0
03/23/15 11:52:00 [4976][-none-][INFO] Query Execution Time:0.00066685676574707
03/23/15 11:52:00 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’EmailAddresses’ AND deleted = 0
03/23/15 11:52:00 [4976][-none-][INFO] Query Execution Time:0.00067019462585449
03/23/15 11:52:00 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’UserPreferences’ AND deleted = 0
03/23/15 11:52:00 [4976][-none-][INFO] Query Execution Time:0.00066208839416504
03/23/15 11:52:00 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Administration’ AND deleted = 0
03/23/15 11:52:00 [4976][-none-][INFO] Query Execution Time:0.00061893463134766
03/23/15 11:52:00 [4976][-none-][INFO] Query:SELECT category, name, value FROM config
03/23/15 11:52:00 [4976][-none-][INFO] Query Execution Time:0.00062203407287598
03/23/15 11:52:00 [4976][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:00 [4976][-none-][INFO] Query Execution Time:0.0005180835723877
03/23/15 11:52:00 [4976][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:00 [4976][-none-][INFO] Query Execution Time:0.00050711631774902
03/23/15 11:52:00 [4976][-none-][INFO] Query:SELECT TOP 1 users.* FROM users WHERE users.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND users.deleted=0
03/23/15 11:52:00 [4976][-none-][INFO] Query Execution Time:0.00055599212646484
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY first_name, last_name ASC
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00065279006958008
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ and u1.deleted=0
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00051212310791016
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][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 = N’Users’
AND ear.bean_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00061702728271484
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found language file: en_us.lang.php
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT count() as the_count FROM config WHERE category=N’info’ AND name=N’sugar_version’ AND CAST(value AS varchar(8000)) = N’6.5.20’
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00059294700622559
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’tracker’
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00050497055053711
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00193190574646
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00050592422485352
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’MySettings’
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00058698654174805
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00058102607727051
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:00 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00097990036010742
03/23/15 11:52:40 [4976][-none-][INFO] Found language file: en_us.lang.php
03/23/15 11:52:40 [4976][-none-][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:40 [4976][-none-][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:40 [4976][-none-][INFO] Connect:Resource id #185
03/23/15 11:52:40 [4976][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = N’Active’ and deleted = 0
03/23/15 11:52:40 [4976][-none-][INFO] Query Execution Time:0.00050711631774902
03/23/15 11:52:40 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Users’ AND deleted = 0
03/23/15 11:52:40 [4976][-none-][INFO] Query Execution Time:0.00069403648376465
03/23/15 11:52:40 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Employees’ AND deleted = 0
03/23/15 11:52:40 [4976][-none-][INFO] Query Execution Time:0.00061893463134766
03/23/15 11:52:40 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’EmailAddresses’ AND deleted = 0
03/23/15 11:52:40 [4976][-none-][INFO] Query Execution Time:0.00070691108703613
03/23/15 11:52:40 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’UserPreferences’ AND deleted = 0
03/23/15 11:52:40 [4976][-none-][INFO] Query Execution Time:0.0005340576171875
03/23/15 11:52:40 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Administration’ AND deleted = 0
03/23/15 11:52:40 [4976][-none-][INFO] Query Execution Time:0.00055789947509766
03/23/15 11:52:40 [4976][-none-][INFO] Query:SELECT category, name, value FROM config
03/23/15 11:52:40 [4976][-none-][INFO] Query Execution Time:0.00075697898864746
03/23/15 11:52:40 [4976][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:40 [4976][-none-][INFO] Query Execution Time:0.00060319900512695
03/23/15 11:52:40 [4976][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:40 [4976][-none-][INFO] Query Execution Time:0.0005180835723877
03/23/15 11:52:40 [4976][-none-][INFO] Query:SELECT TOP 1 users. FROM users WHERE users.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND users.deleted=0
03/23/15 11:52:40 [4976][-none-][INFO] Query Execution Time:0.0006871223449707
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY first_name, last_name ASC
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00070810317993164
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ and u1.deleted=0
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00060796737670898
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][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 = N’Users’
AND ear.bean_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00065398216247559
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found language file: en_us.lang.php
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT count() as the_count FROM config WHERE category=N’info’ AND name=N’sugar_version’ AND CAST(value AS varchar(8000)) = N’6.5.20’
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0011019706726074
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’tracker’
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00066399574279785
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00077509880065918
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00056791305541992
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][WARN] Image icon_Home_32.png not found
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][WARN] Image icon_Home_32.png not found
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][WARN] Image Home.gif not found
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Trackers’ AND deleted = 0
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00066685676574707
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT TOP 50 item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND deleted = 0 AND visible = 1)
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00052499771118164
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Tracker: retrieving 10 items
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’MySettings’
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00059199333190918
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00036001205444336
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00043201446533203
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Emails’ AND deleted = 0
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0068230628967285
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][WARN] Image CreateFP_Event_Locations.gif not found
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][WARN] Image FP_Event_Locations.gif not found
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’license’
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00086092948913574
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.001162052154541
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:40 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0004878044128418
03/23/15 11:52:41 [4976][-none-][INFO] Found language file: en_us.lang.php
03/23/15 11:52:41 [4976][-none-][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:41 [4976][-none-][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:41 [4976][-none-][INFO] Connect:Resource id #187
03/23/15 11:52:41 [4976][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = N’Active’ and deleted = 0
03/23/15 11:52:41 [4976][-none-][INFO] Query Execution Time:0.00052094459533691
03/23/15 11:52:41 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Users’ AND deleted = 0
03/23/15 11:52:41 [4976][-none-][INFO] Query Execution Time:0.000946044921875
03/23/15 11:52:41 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Employees’ AND deleted = 0
03/23/15 11:52:41 [4976][-none-][INFO] Query Execution Time:0.00076794624328613
03/23/15 11:52:41 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’EmailAddresses’ AND deleted = 0
03/23/15 11:52:41 [4976][-none-][INFO] Query Execution Time:0.00090909004211426
03/23/15 11:52:41 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’UserPreferences’ AND deleted = 0
03/23/15 11:52:41 [4976][-none-][INFO] Query Execution Time:0.00062203407287598
03/23/15 11:52:41 [4976][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Administration’ AND deleted = 0
03/23/15 11:52:41 [4976][-none-][INFO] Query Execution Time:0.00051712989807129
03/23/15 11:52:41 [4976][-none-][INFO] Query:SELECT category, name, value FROM config
03/23/15 11:52:41 [4976][-none-][INFO] Query Execution Time:0.0015380382537842
03/23/15 11:52:41 [4976][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:41 [4976][-none-][INFO] Query Execution Time:0.00051093101501465
03/23/15 11:52:41 [4976][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:41 [4976][-none-][INFO] Query Execution Time:0.00042200088500977
03/23/15 11:52:41 [4976][-none-][INFO] Query:SELECT TOP 1 users. FROM users WHERE users.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND users.deleted=0
03/23/15 11:52:41 [4976][-none-][INFO] Query Execution Time:0.0018460750579834
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY first_name, last_name ASC
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00069904327392578
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ and u1.deleted=0
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0017528533935547
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][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 = N’Users’
AND ear.bean_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0006718635559082
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found language file: en_us.lang.php
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT count() as the_count FROM config WHERE category=N’info’ AND name=N’sugar_version’ AND CAST(value AS varchar(8000)) = N’6.5.20’
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0006568431854248
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’tracker’
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00061893463134766
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00041508674621582
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0004570484161377
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’MySettings’
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00060296058654785
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00045180320739746
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:41 [4976][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0004570484161377
03/23/15 11:52:41 [10752][-none-][INFO] Found language file: en_us.lang.php
03/23/15 11:52:41 [10752][-none-][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:41 [10752][-none-][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:41 [10752][-none-][INFO] Connect:Resource id #185
03/23/15 11:52:41 [10752][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = N’Active’ and deleted = 0
03/23/15 11:52:41 [10752][-none-][INFO] Query Execution Time:0.00043487548828125
03/23/15 11:52:41 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Users’ AND deleted = 0
03/23/15 11:52:41 [10752][-none-][INFO] Query Execution Time:0.00065898895263672
03/23/15 11:52:41 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Employees’ AND deleted = 0
03/23/15 11:52:41 [10752][-none-][INFO] Query Execution Time:0.0013179779052734
03/23/15 11:52:41 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’EmailAddresses’ AND deleted = 0
03/23/15 11:52:41 [10752][-none-][INFO] Query Execution Time:0.0013759136199951
03/23/15 11:52:41 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’UserPreferences’ AND deleted = 0
03/23/15 11:52:41 [10752][-none-][INFO] Query Execution Time:0.001133918762207
03/23/15 11:52:41 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Administration’ AND deleted = 0
03/23/15 11:52:41 [10752][-none-][INFO] Query Execution Time:0.00051999092102051
03/23/15 11:52:41 [10752][-none-][INFO] Query:SELECT category, name, value FROM config
03/23/15 11:52:41 [10752][-none-][INFO] Query Execution Time:0.00065803527832031
03/23/15 11:52:41 [10752][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:41 [10752][-none-][INFO] Query Execution Time:0.00070691108703613
03/23/15 11:52:41 [10752][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:41 [10752][-none-][INFO] Query Execution Time:0.00049304962158203
03/23/15 11:52:41 [10752][-none-][INFO] Query:SELECT TOP 1 users. FROM users WHERE users.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND users.deleted=0
03/23/15 11:52:41 [10752][-none-][INFO] Query Execution Time:0.00064301490783691
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY first_name, last_name ASC
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00055789947509766
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ and u1.deleted=0
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00039386749267578
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][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 = N’Users’
AND ear.bean_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00052499771118164
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found language file: en_us.lang.php
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT count() as the_count FROM config WHERE category=N’info’ AND name=N’sugar_version’ AND CAST(value AS varchar(8000)) = N’6.5.20’
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00061392784118652
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Contacts’ AND deleted = 0
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00071001052856445
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’tracker’
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0010361671447754
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00046992301940918
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0004570484161377
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’MySettings’
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00080394744873047
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00047206878662109
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:41 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00077486038208008
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Campaigns’ AND deleted = 0
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00091695785522461
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT meetings.id, name,reminder_time, CAST(description AS varchar(8000)) 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 =N’55549fe0-c0aa-b754-4128-542cc652acd9’
AND meetings_users.accept_status != N’decline’
AND meetings.reminder_time != -1
AND meetings_users.deleted != 1
AND meetings.status = N’Planned’
AND date_start >= CONVERT(datetime,N’2015-03-23 17:52:41’,120)
AND date_start <= CONVERT(datetime,N’2015-03-24 18:52:41’,120)
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.010884046554565
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:
SELECT calls.id, name, reminder_time, CAST(description AS varchar(8000)) 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 =N’55549fe0-c0aa-b754-4128-542cc652acd9’
AND calls_users.accept_status != N’decline’
AND calls.reminder_time != -1
AND calls_users.deleted != 1
AND calls.status = N’Planned’
AND date_start >= CONVERT(datetime,N’2015-03-23 17:52:41’,120)
AND date_start <= CONVERT(datetime,N’2015-03-24 18:52:41’,120)
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0061359405517578
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Trackers’ AND deleted = 0
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00093793869018555
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT TOP 50 item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND deleted = 0 AND visible = 1)
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00079083442687988
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Tracker: retrieving 10 items
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Emails’ AND deleted = 0
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0011169910430908
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][WARN] Image CreateFP_Event_Locations.gif not found
03/23/15 11:52:42 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][WARN] Image FP_Event_Locations.gif not found
03/23/15 11:52:53 [10752][-none-][INFO] Found language file: en_us.lang.php
03/23/15 11:52:53 [10752][-none-][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:53 [10752][-none-][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:53 [10752][-none-][INFO] Connect:Resource id #185
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = N’Active’ and deleted = 0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00063800811767578
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Users’ AND deleted = 0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00082707405090332
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Employees’ AND deleted = 0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.0010190010070801
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’EmailAddresses’ AND deleted = 0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00078606605529785
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’UserPreferences’ AND deleted = 0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.0010290145874023
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Administration’ AND deleted = 0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00070691108703613
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT category, name, value FROM config
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00069117546081543
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00080394744873047
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00048208236694336
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT TOP 1 users. FROM users WHERE users.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND users.deleted=0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00071310997009277
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY first_name, last_name ASC
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00062894821166992
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ and u1.deleted=0
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00047802925109863
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][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 = N’Users’
AND ear.bean_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00064802169799805
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found language file: en_us.lang.php
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT count() as the_count FROM config WHERE category=N’info’ AND name=N’sugar_version’ AND CAST(value AS varchar(8000)) = N’6.5.20’
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0013530254364014
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Contacts’ AND deleted = 0
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00094294548034668
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’MySettings’
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00086712837219238
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00042390823364258
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00055789947509766
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT TOP 1 users. FROM users WHERE users.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND users.deleted=0
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00085210800170898
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ and u1.deleted=0
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00087594985961914
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][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 = N’Users’
AND ear.bean_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0006721019744873
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT user_id id FROM contacts_users WHERE contacts_users.contact_id = N’77ef1a91-af7e-efd8-201a-551052f008b4’ AND contacts_users.deleted=0
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0029568672180176
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT contact_id id FROM contacts_users WHERE contacts_users.user_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND contacts_users.deleted=0
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0005030632019043
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:UPDATE contacts_users set deleted=1 , date_modified = N’2015-03-23 17:52:53’ WHERE contact_id = N’77ef1a91-af7e-efd8-201a-551052f008b4’ AND user_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00076699256896973
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT user_id id FROM contacts_users WHERE contacts_users.contact_id = N’77ef1a91-af7e-efd8-201a-551052f008b4’ AND contacts_users.deleted=0
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0018279552459717
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT contact_id id FROM contacts_users WHERE contacts_users.user_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND contacts_users.deleted=0
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00045204162597656
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT contacts.id, contacts.first_name, contacts.last_name, contacts.title FROM contacts where contacts.deleted = 0 AND contacts.first_name LIKE N’Li%’ AND contacts.last_name = N’Reeve’
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0011739730834961
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT DISTINCT er.bean_id AS id FROM email_addr_bean_rel er, email_addresses ea WHERE ea.id = er.email_address_id AND ea.deleted = 0 AND er.deleted = 0 AND er.bean_module = N’Contacts’ AND email_address_caps IN (‘’)
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0013761520385742
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’tracker’
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00067591667175293
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00047588348388672
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00069904327392578
03/23/15 11:52:53 [10752][-none-][INFO] Found language file: en_us.lang.php
03/23/15 11:52:53 [10752][-none-][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:53 [10752][-none-][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:53 [10752][-none-][INFO] Connect:Resource id #185
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = N’Active’ and deleted = 0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00060701370239258
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Users’ AND deleted = 0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00084996223449707
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Employees’ AND deleted = 0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00093412399291992
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’EmailAddresses’ AND deleted = 0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00098705291748047
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’UserPreferences’ AND deleted = 0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00071310997009277
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Administration’ AND deleted = 0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00067710876464844
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT category, name, value FROM config
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00058293342590332
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00060510635375977
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.00043106079101562
03/23/15 11:52:53 [10752][-none-][INFO] Query:SELECT TOP 1 users.* FROM users WHERE users.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND users.deleted=0
03/23/15 11:52:53 [10752][-none-][INFO] Query Execution Time:0.000701904296875
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY first_name, last_name ASC
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00058889389038086
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ and u1.deleted=0
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00053691864013672
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][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 = N’Users’
AND ear.bean_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0006110668182373
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found language file: en_us.lang.php
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT count() as the_count FROM config WHERE category=N’info’ AND name=N’sugar_version’ AND CAST(value AS varchar(8000)) = N’6.5.20’
03/23/15 11:52:53 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00092697143554688
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Contacts’ AND deleted = 0
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0020589828491211
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’tracker’
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0007328987121582
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00074601173400879
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0013210773468018
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Trackers’ AND deleted = 0
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0008089542388916
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT TOP 50 item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND deleted = 0 AND visible = 1)
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00052499771118164
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Tracker: retrieving 10 items
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’MySettings’
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00059199333190918
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00045013427734375
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00053000450134277
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Emails’ AND deleted = 0
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0009009838104248
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][WARN] Image CreateFP_Event_Locations.gif not found
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][WARN] Image FP_Event_Locations.gif not found
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’license’
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0009009838104248
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0051109790802002
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0021190643310547
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:select id, first_name, last_name, title from contacts where deleted=0 and (id=N’93b22751-96de-0425-256a-550c33e94672’ )
03/23/15 11:52:54 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00058603286743164
03/23/15 11:52:55 [10752][-none-][INFO] Found language file: en_us.lang.php
03/23/15 11:52:55 [10752][-none-][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:55 [10752][-none-][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:55 [10752][-none-][INFO] Connect:Resource id #187
03/23/15 11:52:55 [10752][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = N’Active’ and deleted = 0
03/23/15 11:52:55 [10752][-none-][INFO] Query Execution Time:0.00064182281494141
03/23/15 11:52:55 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Users’ AND deleted = 0
03/23/15 11:52:55 [10752][-none-][INFO] Query Execution Time:0.00076198577880859
03/23/15 11:52:55 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Employees’ AND deleted = 0
03/23/15 11:52:55 [10752][-none-][INFO] Query Execution Time:0.0007328987121582
03/23/15 11:52:55 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’EmailAddresses’ AND deleted = 0
03/23/15 11:52:55 [10752][-none-][INFO] Query Execution Time:0.0017580986022949
03/23/15 11:52:55 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’UserPreferences’ AND deleted = 0
03/23/15 11:52:55 [10752][-none-][INFO] Query Execution Time:0.00095486640930176
03/23/15 11:52:55 [10752][-none-][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module=N’Administration’ AND deleted = 0
03/23/15 11:52:55 [10752][-none-][INFO] Query Execution Time:0.0010781288146973
03/23/15 11:52:55 [10752][-none-][INFO] Query:SELECT category, name, value FROM config
03/23/15 11:52:55 [10752][-none-][INFO] Query Execution Time:0.00067496299743652
03/23/15 11:52:55 [10752][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:55 [10752][-none-][INFO] Query Execution Time:0.00060105323791504
03/23/15 11:52:55 [10752][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:55 [10752][-none-][INFO] Query Execution Time:0.00049114227294922
03/23/15 11:52:55 [10752][-none-][INFO] Query:SELECT TOP 1 users. FROM users WHERE users.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ AND users.deleted=0
03/23/15 11:52:55 [10752][-none-][INFO] Query Execution Time:0.00069403648376465
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY first_name, last_name ASC
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0006401538848877
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = N’55549fe0-c0aa-b754-4128-542cc652acd9’ and u1.deleted=0
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00043201446533203
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][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 = N’Users’
AND ear.bean_id = N’55549fe0-c0aa-b754-4128-542cc652acd9’
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0010812282562256
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found language file: en_us.lang.php
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found extended language file: en_us.lang.ext.php
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Found custom language file: en_us.lang.php
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT count(*) as the_count FROM config WHERE category=N’info’ AND name=N’sugar_version’ AND CAST(value AS varchar(8000)) = N’6.5.20’
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00066399574279785
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’tracker’
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00055885314941406
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00040102005004883
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.0014839172363281
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT category, name, value FROM config WHERE category = N’MySettings’
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00068807601928711
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT id FROM outbound_email WHERE type = N’system’
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00040411949157715
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query:SELECT * FROM outbound_email WHERE id = N’14ec4cb7-bf90-ee4f-374b-542b2d07fd32’
03/23/15 11:52:55 [10752][55549fe0-c0aa-b754-4128-542cc652acd9][INFO] Query Execution Time:0.00061607360839844

Will · 23 March 2015 22:58

This is a known bug, and is something we are working on.

Thanks,

Will.

pov · 30 March 2015 16:29

We are experiencing same problem after upgrade to 7.2

could anyone point us atleast to the file that could be causing this?
so that atleast we could do a workaround untill this issue is fixed?

Pretty please?

Matt · 30 March 2015 17:55

go to include/SugarFields/Fields/Image/SugarFieldImage.php

and comment out lines 74 - 77:-

 if (empty($bean->id)) {
$bean->id = create_guid();
$bean->new_with_id = true;
}

pov · 30 March 2015 18:41

perfect thanks

Was looking around in all files except this one as thought image field is not relevant for contacts…

but now i see there is a new feature of contact photo

Thank you !

bgoodall · 14 May 2015 15:18

Thanks this was very helpful to us!