by SuiteCRM

The Ultimate Outlook Plugin Has Arrived - In response to user requests, SuiteCRM have created the ultimate Outlook plugin which is maintained by SuiteCRM developers. Our plugin supports Outlook 2010 upwards and includes two way synchronisation with CRM, Calender, Calls, Meeting, Tasks and Email Archiving.

Cancel at any time!
Free Trial

#398 - Outlook Plugin 500 error searching custom modules

Closed Bug? created by silasthomas Verified Purchase 2 years ago

I have a couple of custom modules, which were build using the standard "Account" module template, and other than renaming some of the field labels, are as is. When I enable the modules to search in the Outlook plugin, I get "The remote server returned error: 500..."!
Screen Shot 2017-05-30 at 11.41.47 PM.png

The Suitecrm.log files shows this:

[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'billing_address_street_2'.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'billing_address_street_3'.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'billing_address_street_4'.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'shipping_address_street_2'.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'shipping_address_street_3'.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'shipping_address_street_4'.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'email1'.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'email_addresses_non_primary'.
code text here

I don't have this issue for other custom modules which are based on the "contact" template, only custom modules using the Account Template.

Additionally, if I look in the Vardef (cache/modules/supa_Accounts/supa_Accountsvardefs.php) for the custom module/account I created, it shows the wrong fields names as listed in the MSSQL error above, when I look at them in the Studio or Module builder, it appears correct.

I'm also tracking this in the forum here https://suitecrm.com/forum/suitecrm-outlook-plugin/14401-outlook-plugin-500-error-searching-custom-modules#48103

Any pointers here?

Thanks!!

  1. suitecrm member avatar

    SuiteCRM Provider Affiliate

    2 years ago

    Hi silasthomas,

    Is it possible if we could ask you to send your DEBUG logs (logs set at DEBUG level) during replicating the issue to our support email address outlook[at]salesagility[dot]com referencing this Ticket #398. If you could also include what PHP version you are running off of, that would be much appreciated and we'll investigate.

    SuiteCRM Outlook Plugin Team

  2. silasthomas member avatar

    silasthomas Verified Purchase

    2 years ago

    Just tried to email you at that address, I got a bounce back.

    Final-Recipient: rfc822; outlook[at]salesagility[dot]com
    Action: failed
    Status: 5.0.0
    Remote-MTA: dns; mx.bytemine.net. (2a00:12d8:200a::42, the server for the
    domain salesagility[dot]com.)
    Diagnostic-Code: smtp; 550-Callout verification failed:
    550 550 Unrouteable address
    Last-Attempt-Date: Wed, 31 May 2017 08:36:46 -0700 (PDT)

  3. suitecrm member avatar

    SuiteCRM Provider Affiliate

    2 years ago

    Hi silasthomas,

    We will contact you directly.

  4. silasthomas member avatar

    silasthomas Verified Purchase

    2 years ago

    Bump, any movement on this one? Thanks!

    • suitecrm member avatar

      SuiteCRM Provider Affiliate

      2 years ago

      Hi silasthomas,

      This issue has been fixed and should be included in the next release.

      SuiteCRM Outlook Plugin Team

  5. suitecrm member avatar

    SuiteCRM Provider Affiliate

    2 years ago

    This fix should be included in v3.0.5

    • SuiteCRM Team
    • silasthomas member avatar

      silasthomas Verified Purchase

      2 years ago

      Yes, I can confirm that this patch as fixed the issue for me, I no longer see the error messages when searching custom modules.

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