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

[Tim Mohrbach]

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

It's all in your error log, give it a read again and then you will notice that your table is missing indexes, something went obviously wrong when you moved the database to a new server. Those table names look like temporary tables (urgh). Anyway you could try Google the error and look for a fix or you just recreate all the reports ;) 

On November 26, 2016 4:48:06 PM GMT+08:00, kiran <kiranraju.jakka at gmail.com> wrote:
>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.
>_______________________________________________
>http://www.vtiger.com/

-- 
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20161127/4ef25b04/attachment.html>