Skip to main content
sanikat
sanikat
February 2, 2022
Question

MSGraph Email Poller

  • February 2, 2022
  • 4 replies
  • 1 view

Hello.  I am trying to implement MSGraph Email Poller plugin and we are receiving the following message when the poller runs:
(conn=7686054) Unknown column 'BODY_SWAPPED_IMAGES' in 'field list'

Any info around the cause and resolution of this error ? 

MSGraph Email Poller

4 replies

acaciob0002
acaciob0002
February 2, 2022

Hi [mention:41a13301b3e0472f8623672969fac500:e9ed411860ed4f2ba0265705b8793d05],

I faced similar issue, in my case the column BODY_SWAPPED_IMAGES was missing in the table APP_MAIL_POLLER. You probably should check in your table. I also had problem with the column IS_INLINE missing in the table APP_MAIL_POLLER_DOC.

After run the alters on these tables it works. Perhaps they will fix this problem in a future update of the plugin.

Regards,

Acacio B. 

    sanikat
    sanikatAuthor
    February 3, 2022

    [mention:b389a349840947d58879708f8b0249f2:e9ed411860ed4f2ba0265705b8793d05], thank you for your response, appreciate your help here . Yes, the DLL that came along with plugin , does not have the column "BODY_SWAPPED_IMAGES" , but do you know the datatype of BODY_SWAPPED_IMAGES columns that I need to add to APP_MAIL_POLLER.

    Also, could you please share the data type of  IS_INLINE  for APP_MAIL_POLLER_DOC that made the plugin work for you?

    acaciob0002
    acaciob0002
    February 3, 2022

    Hi [mention:41a13301b3e0472f8623672969fac500:e9ed411860ed4f2ba0265705b8793d05],

    Below you can find the alters that we use:

    ALTER TABLE `APP_MAIL_POLLER` ADD COLUMN BODY_SWAPPED_IMAGES longtext AFTER SYS_DATE;
ALTER TABLE `APP_MAIL_POLLER_DOC` ADD COLUMN IS_INLINE TINYINT(1) AFTER SYS_DATE;

    As for the datatypes, you can check the screenshot:

    Regards,

    Acacio B

    Terms & ConditionsAccessibility statement