[Vtigercrm-developers] [VtigerCRM-Developers] Reports keep getting hanging?

[kiran]

Hi,

I'm using reports from 2 years i didn't get any problem, recently i moved to
another server. Now reports are keep hanging and says below error in logs. I
just tailed the logs to know what is happening.. i came to know that:::

Sat Nov 26 08:49:57 2016,359 [29853] INFO VT - PearDatabase ->ADODB error 
Query Failed:ALTER TABLE vtiger_reptmptbl_158394cb546ddb0829531730 ADD INDEX
(assetsid)::->[1072]Key column 'assetsid' doesn't exist in table
Sat Nov 26 08:49:57 2016,359 [29853] DEBUG VT - Prepared sql query being
executed : ALTER TABLE vtiger_reptmptbl_158394cb546ddb0829531730 ADD INDEX
(crmid)
Sat Nov 26 08:49:57 2016,359 [29853] INFO VT - PearDatabase ->ADODB error 
Query Failed:ALTER TABLE vtiger_reptmptbl_158394cb546ddb0829531730 ADD INDEX
(crmid)::->[1072]Key column 'crmid' doesn't exist in table
Sat Nov 26 08:49:57 2016,359 [29853] DEBUG VT - Prepared sql query being
executed : select DISTINCT vtiger_assetscf.cf_1330 AS 'Assets_Site_Name',
vtiger_assetscf.cf_1332 AS 'Assets_Site_Address',
vtiger_servicecontracts.contract_status AS 'ServiceContracts_Status',
vtiger_crmentity.crmid AS "Assets_LBL_ACTION" from vtiger_assets inner join
vtiger_crmentity on vtiger_crmentity.crmid=vtiger_assets.assetsid inner join
vtiger_assetscf as vtiger_assetscf on
vtiger_assetscf.assetsid=vtiger_assets.assetsid left join vtiger_groups on
vtiger_groups.groupid = vtiger_crmentity.smownerid left join vtiger_users on
vtiger_users.id = vtiger_crmentity.smownerid left join vtiger_crmentityrel
as vtiger_crmentityreltmpServiceContracts ON
(vtiger_assets.assetsid=vtiger_crmentityreltmpServiceContracts.relcrmid OR
vtiger_assets.assetsid=vtiger_crmentityreltmpServiceContracts.crmid) left
join vtiger_reptmptbl_158394cb546ddb0829531730 as vtiger_servicecontracts on
(vtiger_servicecontracts.servicecontractsid=vtiger_crmentityreltmpServiceContracts.relcrmid
OR
vtiger_servicecontracts.servicecontractsid=vtiger_crmentityreltmpServiceContracts.crmid)
left join vtiger_crmentity as vtiger_crmentityServiceContracts on
vtiger_crmentityServiceContracts.crmid =
vtiger_servicecontracts.servicecontractsid and
vtiger_crmentityServiceContracts.deleted=0 WHERE vtiger_assets.assetsid > 0 
AND vtiger_crmentity.deleted=0  order by `ServiceContracts_Status` ASC LIMIT
0, 1000

This would be the error i have identified in logs.

Can anybody help me to get rid of it?


Thanks & Regards,




--
View this message in context: http://vtiger-crm.2324883.n4.nabble.com/VtigerCRM-Developers-Reports-keep-getting-hanging-tp20175.html
Sent from the vtigercrm-developers mailing list archive at Nabble.com.