Official SuiteCRM Outlook Plugin v4 has arrived - A complete plugin rebuild developed and maintained by SuiteCRM developers entirely from scratch, the addon retains previous functionality while massively improves performance, reliability and stability!
#398 - Outlook Plugin 500 error searching custom modules
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!!
3 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
3 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 years ago
Hi silasthomas,
We will contact you directly.
3 years ago
Bump, any movement on this one? Thanks!
3 years ago
Hi silasthomas,
This issue has been fixed and should be included in the next release.
SuiteCRM Outlook Plugin Team
3 years ago
This fix should be included in v3.0.5
3 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.