[Vtigercrm-developers] Anyone got the Outlook plugin working on vtiger 7.2?

[Alan Lord]

On 27/11/2019 16:46, David wrote:
> Hi Alan
> 
> A clean install of 7.2 with the same server config returns the error:-
>           “The remote server returned and error (500).  Internal server
> error.”

Thanks for the info.

This is the same error my customer is seeing too.

I've got php error logging going to the apache log and there are a lot 
of Uncaught Exception: Bad Request  errors...

Things like:

> [Wed Nov 27 14:17:59.867198 2019] [php7:error] [pid 8248] [client 80.209.147.166:60432] PHP Fatal error:  Uncaught Exception: Bad Request in /var/www/html/vt-720/vtlib/Vtiger/Functions.php:1481\nStack trace:\n#0 /var/www/html/vt-720/includes/http/Request.php(22): Vtiger_Functions::validateRequestParameters(Array)\n#1 /var/www/html/vt-720/index.php(20): Vtiger_Request->__construct(Array, Array)\n#2 {main}\n  thrown in /var/www/html/vt-720/vtlib/Vtiger/Functions.php on line 1481, referer: https://redacted.libertus.co.uk/index.php?module=Reports&view=List

There are a *lot* of these from multiple referers. But these all look to 
be web-based requests from normal user activity so am not sure if this 
is a cause of the issue or not.

In the vtiger debug log - when I asked my customer to search of an 
Account from the Outlook client, the search request itself seems to be 
processed correctly, e.g.

> Wed Nov 27 14:53:00 2019,116 [26438] DEBUG webservice - Prepared sql query being executed : SELECT vtiger_account.accountname,vtiger_account.phone,vtiger_account.website,vtiger_account.fax,vtiger_account.tickersymbol,vtiger_account.otherphone,vtiger_account.parentid,vtiger_account.email1,vtiger_account.employees,vtiger_account.email2,vtiger_account.ownership,vtiger_account.industry,vtiger_account.siccode,vtiger_account.account_type,vtiger_account.annualrevenue,vtiger_account.emailoptout,vtiger_account.notify_owner,vtiger_crmentity.smownerid,vtiger_crmentity.createdtime,vtiger_crmentity.modifiedtime,vtiger_accountbillads.bill_street,vtiger_accountshipads.ship_street,vtiger_accountbillads.bill_city,vtiger_accountshipads.ship_city,vtiger_accountbillads.bill_state,vtiger_accountshipads.ship_state,vtiger_accountbillads.bill_code,vtiger_accountshipads.ship_code,vtiger_accountbillads.bill_country,vtiger_accountshipads.ship_country,vtiger_accountbillads.bill_pobox,vtiger_accountshipads.ship_pobox,vtiger_crmentity.description,vtiger_accountscf.cf_656,vtiger_accountscf.cf_658,vtiger_accountscf.cf_722,vtiger_accountscf.cf_734,vtiger_accountscf.cf_740,vtiger_account.account_no,vtiger_accountscf.cf_886,vtiger_accountscf.cf_892,vtiger_accountscf.cf_979,vtiger_accountscf.cf_980,vtiger_accountscf.cf_981,vtiger_accountscf.cf_982,vtiger_accountscf.cf_1010,vtiger_accountscf.cf_1011,vtiger_crmentity.modifiedby,vtiger_accountscf.cf_1041,vtiger_accountscf.cf_1044,vtiger_accountscf.cf_1045,vtiger_accountscf.cf_1051,vtiger_accountscf.cf_1236,vtiger_accountscf.cf_1248,vtiger_accountscf.cf_1288,vtiger_account.imagename,vtiger_accountscf.cf_1398,vtiger_accountscf.cf_1399,vtiger_accountscf.cf_1402,vtiger_account.isconvertedfromlead,vtiger_accountscf.cf_1526,vtiger_accountscf.cf_1530,vtiger_accountscf.cf_1684,vtiger_accountscf.cf_1696,vtiger_accountscf.cf_1698,vtiger_accountscf.cf_1707,vtiger_accountscf.cf_1709,vtiger_accountscf.cf_1711,vtiger_accountscf.cf_1713,vtiger_accountscf.cf_1715,vtiger_accountscf.cf_1717,vtiger_crmentity.source,vt
iger_crmentity_user_field.starred,vtiger_account.tags,vtiger_account.accountid FROM vtiger_account LEFT JOIN vtiger_crmentity ON vtiger_account.accountid=vtiger_crmentity.crmid LEFT JOIN vtiger_accountbillads ON vtiger_account.accountid=vtiger_accountbillads.accountaddressid LEFT JOIN vtiger_accountshipads ON vtiger_account.accountid=vtiger_accountshipads.accountaddressid LEFT JOIN vtiger_accountscf ON vtiger_account.accountid=vtiger_accountscf.accountid LEFT JOIN vtiger_crmentity_user_field ON vtiger_account.accountid=vtiger_crmentity_user_field.recordid AND vtiger_crmentity_user_field.userid = 65386   WHERE (vtiger_account.accountname LIKE '%whitel%' or vtiger_account.email2 LIKE '%whitel%' or vtiger_account.email1 LIKE '%whitel%') AND  vtiger_crmentity.deleted=0 LIMIT 100;

And I can see multiple rows of arrays of returned [account] data in the 
debug log - so that part seems to be working but I can see no errors 
after all the rows returned from the search have been processed i te log...

Unfortunately - I don't have any Windows computers and hence no Outlook 
to do any local testing myself.

I will continue to examine the logs to see if I can find anything but 
I'm at a bit of a loss on this to be honest :-(



Alan