by SuiteCRM

Official SuiteCRM Outlook Plugin v4 has arrived - Compatible with the Outlook Web App or Outlook 2016+ connected to Office365 or Exchange Server 2016. A complete rebuild developed and maintained by SuiteCRM developers, the addon retains previous functionality while massively improves performance, reliability and stability!

Cancel at any time!
Free Trial

#5657 - Empty email in Suite CRM 8.7

In Progress General Question created by Verified Purchase one week ago

Hi,

The tool seems correctly configured. I can archive emails from Outlook to object in SuiteCRM and see the emails attached to the object in SuiteCRM. Synchronisation with Azure works. However, when I click on an email, it opens a blank window in SuiteCRM.

In the SuiteCRM log file, I get the following error when **open the contact **where the email is listed in History Tue Mar 25 12:28:42 2025 [194757][1][FATAL] Mysqli_query failed. Tue Mar 25 12:28:42 2025 [194757][1][FATAL] SubpanelCustomQueryPort: Error executing custom query Query Failed: SELECT emails.date_sent_received FROM notes LEFT JOIN contacts contacts ON notes.contact_id=contacts.id AND contacts.deleted=0

AND contacts.deleted=0 LEFT JOIN users jt1 ON notes.assigned_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 INNER JOIN contacts notes_rel ON notes.contact_id=notes_rel.id AND notes_rel.deleted=0

where ( notes.contact_id='7931d030-5f88-7f8a-adb4-67e29f146fa0') AND notes.deleted=0 ORDER BY emails.date_sent_received DESC LIMIT 1: MySQL error 1054: Unknown column 'emails.date_sent_received' in 'field list'

And I get the following error **when clicking on the corresponding email in the list: ** Tue Mar 25 12:27:22 2025 [175810][1][FATAL] Exception handling in /var/www/html/suite-crm/public/legacy/include/MVC/Controller/SugarController.php:397 Tue Mar 25 12:27:22 2025 [175810][1][FATAL] Exception in Controller: No module defined

Thanks for your assistance.

Patrick

  1. suitecrm member avatar

    SuiteCRM Provider Affiliate

    one week ago

    This error seems to be unrelated to the plugin itself. It appears you have some custom code relating to subpanels which is failing. We would suggest you either resolve the error in the custom code or remove it if it's no longer required. Assistance with this is outwith the scope of the outlook plugin support.

    • Novel-T member avatar

      Verified Purchase

      6 days ago

      This is the only plugin that is installed on my SuiteCRM vanilla install. No custom code has been added.So I wouldn't know what custom code to look at. Anyway, the second error above might be because there was some Notes also attached to the contact to which I've archived the emails from outlook. In order to isolate root cause of the blank screen when trying to open the archived email, I created a contact John Doe and archive one email from outlook to this contact. (See attachment BlankEmail.png) Here are the logs resulting from the click on the email and the display of a blank page: it seems the system look for an email template to display the email archive from outlook. Did I miss some required email template configuration? What is the expected behaviour and what should be displayed when clicking on the archived email in SuiteCRM?

      Wed Mar 26 07:11:09 2025 [175809][1][INFO] Query:SELECT acc.id, acc.name, con_reports_to.first_name, con_reports_to.last_name from contacts left join accounts_contacts a_c on a_c.contact_id = '7931d030-5f88-7f8a-adb4-67e29f146fa0' and a_c.deleted=0 left join accounts acc on a_c.account_id = acc.id and acc.deleted=0 left join contacts con_reports_to on con_reports_to.id = contacts.reports_to_id where contacts.id = '7931d030-5f88-7f8a-adb4-67e29f146fa0' ORDER BY a_c.date_modified DESC Wed Mar 26 07:11:09 2025 [175809][1][INFO] Query Execution Time:0.00078010559082031 Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (user_sync). Wed Mar 26 07:11:09 2025 [175809][1][INFO] Query:SELECT user_id id FROM contacts_users WHERE contacts_users.contact_id = '7931d030-5f88-7f8a-adb4-67e29f146fa0' AND contacts_users.deleted=0 Wed Mar 26 07:11:09 2025 [175809][1][INFO] Query Execution Time:0.00035500526428223 Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (account_id). Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] SugarBean.load_relationships, failed Loading relationship (account_id) Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (account_id). Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] SugarBean.load_relationships, failed Loading relationship (account_id) Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (reports_to_link). Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] SugarBean[Contact].load_relationships, Loading relationship (campaign_contacts). Wed Mar 26 07:11:09 2025 [175809][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.confirm_opt_in, 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 = 'Contacts' AND ear.bean_id = '7931d030-5f88-7f8a-adb4-67e29f146fa0' AND ear.deleted = 0 ORDER BY ear.reply_to_address, ear.primary_address DESC Wed Mar 26 07:11:09 2025 [175809][1][INFO] Query Execution Time:0.0005958080291748 Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] Hook called: Contacts::after_retrieve Wed Mar 26 07:11:09 2025 [175809][1][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 = '7931d030-5f88-7f8a-adb4-67e29f146fa0' AND ear.deleted = 0 AND ea.invalid_email = 0 ORDER BY ear.primary_address DESC Start: 0 count: 1 Wed Mar 26 07:11:09 2025 [175809][1][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 = '7931d030-5f88-7f8a-adb4-67e29f146fa0' AND ear.deleted = 0 AND ea.invalid_email = 0 ORDER BY ear.primary_address DESC LIMIT 0,1 Wed Mar 26 07:11:09 2025 [175809][1][INFO] Query Execution Time:0.00049114227294922 Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] Call(4697d14b-089b-0f32-1ffb-67e29fc0d72a): contact_name = Mr. John Doe Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] Call(4697d14b-089b-0f32-1ffb-67e29fc0d72a): contact_phone = Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] Call(4697d14b-089b-0f32-1ffb-67e29fc0d72a): contact_id = 7931d030-5f88-7f8a-adb4-67e29f146fa0 Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] Call(4697d14b-089b-0f32-1ffb-67e29fc0d72a): contact_email1 = jondoe@novel-t.ch Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] SugarBean[Email].load_relationships, Loading relationship (emails_email_templates_idb). Wed Mar 26 07:11:09 2025 [175809][1][ERROR] Unable to find relationship emails_email_templates Wed Mar 26 07:11:09 2025 [175809][1][WARN] emails_email_templates_idb for emails_email_templates failed to load

      Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] Hook called: Emails::after_retrieve Wed Mar 26 07:11:09 2025 [175809][1][INFO] Query:SELECT from_addr, reply_to_addr, to_addrs, cc_addrs, bcc_addrs, description, description_html, raw_source FROM emails_text WHERE email_id = '4697d14b-089b-0f32-1ffb-67e29fc0d72a' Wed Mar 26 07:11:09 2025 [175809][1][INFO] Query Execution Time:0.00034403800964355 Wed Mar 26 07:11:09 2025 [175809][1][INFO] Query:SELECT email_address, address_type FROM emails_email_addr_rel eam JOIN email_addresses ea ON ea.id = eam.email_address_id WHERE eam.email_id = '4697d14b-089b-0f32-1ffb-67e29fc0d72a' AND eam.deleted=0 Wed Mar 26 07:11:09 2025 [175809][1][INFO] Query Execution Time:0.00035786628723145 Wed Mar 26 07:11:09 2025 [175809][1][DEBUG] Using Action View Map:detail Wed Mar 26 07:11:09 2025 [175809][1][DEPRECATED] Array ( )

  2. suitecrm member avatar

    SuiteCRM Provider Affiliate

    6 days ago

    It seems the system look for an email template to display the email archive from outlook. Did I miss some required email template configuration?

    There is no template configuration required, that error relates to a missing relationship rather than a missing template. There is an option in the administration to Rebuild Relationships. It may be worth running this followed by a quick repair and rebuild. Please take a full backup of your code and database before doing so.

    The messages above do not show the reason for the white screen you experience, they are likely recorded in your Apache log files.

  3. Novel-T member avatar

    Verified Purchase

    5 days ago

    Hello, I did a complete reinstall of a vanilla SuiteCRM 8.7 and install the plugin. No other modules or plugins have been installed. All works as before. I can archive emails in SuiteCRM from Outlook. Sync works. I still get a blank page when clicking on the only email listed in the history. The email is stored in the database in table emails and emails_text (email id=f3d75628-6c9c-135e-69c3-67e56cb753cb)

    The last part of the returned html displayed as a blank page in Google Dev tool is: <!-- Start of page content -->

    And nothing after. I don't see anything in the Debug log generated from refreshing the page where the email should be displayed that can explain it (See below) I'm at a loss! I was told that the module is compatible with 8.7.1 despite the site says version 8.6 max is supported. Is it truly? Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Hook called: Emails::before_retrieve Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Including module specific hook file for custom/modules/Emails Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Retrieve Email : SELECT emails.* FROM emails WHERE emails.id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND emails.deleted=0 Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Limit Query:SELECT emails.* FROM emails WHERE emails.id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND emails.deleted=0 Start: 0 count: 1 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT emails.* FROM emails WHERE emails.id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND emails.deleted=0 LIMIT 0,1 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.00025606155395508 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT contacts.first_name, contacts.last_name, contacts.phone_work, contacts.id, contacts.assigned_user_id contact_name_owner, 'Contacts' contact_name_mod FROM contacts, emails_beans WHERE emails_beans.email_id='f3d75628-6c9c-135e-69c3-67e56cb753cb' AND emails_beans.bean_id=contacts.id AND emails_beans.bean_module = 'Contacts' AND emails_beans.deleted=0 AND contacts.deleted=0 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.0002439022064209 Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Call(f3d75628-6c9c-135e-69c3-67e56cb753cb): contact_name = Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Call(f3d75628-6c9c-135e-69c3-67e56cb753cb): contact_phone = Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Call(f3d75628-6c9c-135e-69c3-67e56cb753cb): contact_id = Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Call(f3d75628-6c9c-135e-69c3-67e56cb753cb): contact_email1 = Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] SugarBean[Email].load_relationships, Loading relationship (emails_email_templates_idb). Thu Mar 27 15:28:21 2025 [10010][1][ERROR] Unable to find relationship emails_email_templates Thu Mar 27 15:28:21 2025 [10010][1][WARN] emails_email_templates_idb for emails_email_templates failed to load Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Hook called: Emails::after_retrieve Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT from_addr, reply_to_addr, to_addrs, cc_addrs, bcc_addrs, description, description_html, raw_source FROM emails_text WHERE email_id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.00017189979553223 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT email_address, address_type FROM emails_email_addr_rel eam JOIN email_addresses ea ON ea.id = eam.email_address_id WHERE eam.email_id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND eam.deleted=0 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.00018405914306641 Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Using Action View Map:detail Thu Mar 27 15:28:21 2025 [10010][1][DEPRECATED] Array ( ) Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:INSERT INTO tracker (monitor_id,user_id,module_name,item_id,item_summary,date_modified,action,session_id,visible ) VALUES ( '328de506-9573-d800-b9df-67e56e1bd29e','1','Emails','f3d75628-6c9c-135e-69c3-67e56cb753cb','esa-star: Login Verification Code','2025-03-27 15:28:21','detailview','pakudvbtudpbq3t05mneu88he5','1') Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] current_language is: en_us Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Found cache backend SugarCacheMemory Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Using cache backend SugarCacheMemory, since 999 is less than 1000 Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Found cache backend SugarCacheFile Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Found cache backend SugarCacheMemcache Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Found cache backend SugarCacheZend Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Found cache backend SugarCacheAPC Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Found cache backend SugarCacheRedis Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Found cache backend SugarCacheWincache Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Found cache backend SugarCachesMash Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Found cache backend SugarCacheMemcached Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Found language file: en_us.lang.php Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Found extended language file: en_us.lang.ext.php Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Found custom language file: en_us.lang.php Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0 Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Query Execution Time:0.00024604797363281 Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Query:SELECT category, name, value FROM config Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Query Execution Time:0.00015902519226074 Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system' AND deleted = 0 Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Query Execution Time:0.00013899803161621 Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = '26456699-0af0-3dee-1493-67b70fe24c1e' Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Query Execution Time:0.00015497207641602 Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Hook called: ::after_entry_point Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Including module specific hook file for custom/modules Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Including Ext hook file for custom/application Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.083551168441772 Thu Mar 27 15:28:21 2025 [10010][1][WARN] CSS File Dawn/yui.css not found Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] metadatafile=modules/Emails/metadata/detailviewdefs.php Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Hook called: Emails::before_retrieve Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Retrieve Email : SELECT emails.* FROM emails WHERE emails.id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND emails.deleted=0 Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Limit Query:SELECT emails.* FROM emails WHERE emails.id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND emails.deleted=0 Start: 0 count: 1 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT emails.* FROM emails WHERE emails.id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND emails.deleted=0 LIMIT 0,1 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.00033807754516602 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT contacts.first_name, contacts.last_name, contacts.phone_work, contacts.id, contacts.assigned_user_id contact_name_owner, 'Contacts' contact_name_mod FROM contacts, emails_beans WHERE emails_beans.email_id='f3d75628-6c9c-135e-69c3-67e56cb753cb' AND emails_beans.bean_id=contacts.id AND emails_beans.bean_module = 'Contacts' AND emails_beans.deleted=0 AND contacts.deleted=0 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.00024890899658203 Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Call(f3d75628-6c9c-135e-69c3-67e56cb753cb): contact_name = Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Call(f3d75628-6c9c-135e-69c3-67e56cb753cb): contact_phone = Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Call(f3d75628-6c9c-135e-69c3-67e56cb753cb): contact_id = Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Call(f3d75628-6c9c-135e-69c3-67e56cb753cb): contact_email1 = Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] SugarBean[Email].load_relationships, Loading relationship (emails_email_templates_idb). Thu Mar 27 15:28:21 2025 [10010][1][ERROR] Unable to find relationship emails_email_templates Thu Mar 27 15:28:21 2025 [10010][1][WARN] emails_email_templates_idb for emails_email_templates failed to load Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Hook called: Emails::after_retrieve Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT from_addr, reply_to_addr, to_addrs, cc_addrs, bcc_addrs, description, description_html, raw_source FROM emails_text WHERE email_id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.0001380443572998 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT email_address, address_type FROM emails_email_addr_rel eam JOIN email_addresses ea ON ea.id = eam.email_address_id WHERE eam.email_id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND eam.deleted=0 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.00014615058898926 Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Hook called: Emails::before_retrieve Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Retrieve Email : SELECT emails.* FROM emails WHERE emails.id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND emails.deleted=0 Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Limit Query:SELECT emails.* FROM emails WHERE emails.id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND emails.deleted=0 Start: 0 count: 1 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT emails.* FROM emails WHERE emails.id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND emails.deleted=0 LIMIT 0,1 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.0001518726348877 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT contacts.first_name, contacts.last_name, contacts.phone_work, contacts.id, contacts.assigned_user_id contact_name_owner, 'Contacts' contact_name_mod FROM contacts, emails_beans WHERE emails_beans.email_id='f3d75628-6c9c-135e-69c3-67e56cb753cb' AND emails_beans.bean_id=contacts.id AND emails_beans.bean_module = 'Contacts' AND emails_beans.deleted=0 AND contacts.deleted=0 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.00020384788513184 Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Call(f3d75628-6c9c-135e-69c3-67e56cb753cb): contact_name = Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Call(f3d75628-6c9c-135e-69c3-67e56cb753cb): contact_phone = Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Call(f3d75628-6c9c-135e-69c3-67e56cb753cb): contact_id = Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Call(f3d75628-6c9c-135e-69c3-67e56cb753cb): contact_email1 = Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] SugarBean[Email].load_relationships, Loading relationship (emails_email_templates_idb). Thu Mar 27 15:28:21 2025 [10010][1][ERROR] Unable to find relationship emails_email_templates Thu Mar 27 15:28:21 2025 [10010][1][WARN] emails_email_templates_idb for emails_email_templates failed to load Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Hook called: Emails::after_retrieve Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT from_addr, reply_to_addr, to_addrs, cc_addrs, bcc_addrs, description, description_html, raw_source FROM emails_text WHERE email_id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.0001378059387207 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT email_address, address_type FROM emails_email_addr_rel eam JOIN email_addresses ea ON ea.id = eam.email_address_id WHERE eam.email_id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND eam.deleted=0 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.00014400482177734 Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] SugarBean[Email].load_relationships, Loading relationship (notes). Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT id FROM notes WHERE notes.parent_id = 'f3d75628-6c9c-135e-69c3-67e56cb753cb' AND notes.deleted=0 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.00022196769714355 Thu Mar 27 15:28:21 2025 [10010][1][WARN] Trying to get an empty email address. Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Hook called: EmailAddresses::before_retrieve Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Retrieve EmailAddress : SELECT email_addresses.* FROM email_addresses WHERE email_addresses.id = '' AND email_addresses.deleted=0 Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Limit Query:SELECT email_addresses.* FROM email_addresses WHERE email_addresses.id = '' AND email_addresses.deleted=0 Start: 0 count: 1 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query:SELECT email_addresses.* FROM email_addresses WHERE email_addresses.id = '' AND email_addresses.deleted=0 LIMIT 0,1 Thu Mar 27 15:28:21 2025 [10010][1][INFO] Query Execution Time:0.00015115737915039 Thu Mar 27 15:28:21 2025 [10010][1][FATAL] Exception handling in /var/www/html/suite-crm/public/legacy/include/MVC/Controller/SugarController.php:397 Thu Mar 27 15:28:21 2025 [10010][1][FATAL] Exception in Controller: No module defined Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Hook called: Emails::handle_exception Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Hook called: ::server_round_trip Thu Mar 27 15:28:21 2025 [10010][1][DEBUG] Calling MySQLi::disconnect() Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Hook called: ::after_session_start Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Unable to find SugarController:: index Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] We have an authenticated user id: 1 Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Hook called: Users::before_retrieve Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Including module specific hook file for custom/modules/Users Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Including Ext hook file for custom/modules/Users Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Thu Mar 27 15:28:21 2025 [1526][-none-][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1 Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1 Thu Mar 27 15:28:21 2025 [1526][-none-][INFO] Query Execution Time:0.00033903121948242 Thu Mar 27 15:28:21 2025 [1526][1][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 Thu Mar 27 15:28:21 2025 [1526][1][INFO] Query:SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC Thu Mar 27 15:28:21 2025 [1526][1][INFO] Query Execution Time:0.00018715858459473 Thu Mar 27 15:28:21 2025 [1526][1][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0 Thu Mar 27 15:28:21 2025 [1526][1][INFO] Query Execution Time:0.00014805793762207 Thu Mar 27 15:28:21 2025 [1526][1][DEBUG] SugarBean[User].load_relationships, Loading relationship (reports_to_link). Thu Mar 27 15:28:21 2025 [1526][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.confirm_opt_in, 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 = '1' AND ear.deleted = 0 ORDER BY ear.reply_to_address, ear.primary_address DESC Thu Mar 27 15:28:21 2025 [1526][1][INFO] Query Execution Time:0.0002288818359375
  4. Novel-T member avatar

    Verified Purchase

    4 days ago

    To complement the above: I get a status of code of 200 for URL Request URL: https://crm-uat.novel-t.ch/legacy/index.php?offset=1&module=Emails&action=DetailView&record=3ff8071a-52b0-0e70-8b2f-67e570cd7fde

    No error in Apache logs

    And the last part of the response is only this (nothing after): <!-- Start of page content -->

  5. Novel-T member avatar

    Verified Purchase

    4 days ago

    ~<!-- Start of page content -->

    ~
  6. Novel-T member avatar

    Verified Purchase

    4 days ago

    Sorry the HTML I'm pasting in the comment is interpreted and doesn't show. I put it in attachment as a picture. HTMLBlankPage.png

  7. Novel-T member avatar

    Verified Purchase

    4 days ago

    EmailArchived.png

    EmptyScreen.png

  8. suitecrm member avatar

    SuiteCRM Provider Affiliate

    4 days ago

    Hi Patrick,

    The plugin is working as expected and is currently in production usage by several of our clients on 8.8.0

    The email import process and display functionality is actually part of SuiteCRM Core. It's possible the email you are importing has something unique which is potentially triggering a bug in the application. To help us diagnose this can you please export the full email from Outlook and send it to outlook [at] salesagility [dot] com

    We can then attempt to replicate the issue you see and pass it over to the product team if necessary.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "How to enable "Sync to outlook" checkbox? I follow the instruction and display on Edit/Detail view. The "Sync to outlook" checkbox appear in the pane..." - Yathit

    Read More Reviews