Hola Joe,
He hecho lo que me indicas y esto es lo que ocurre:
La query sql que da el error es esta:
select DISTINCT case when(vtiger_usersCalendar.last_name NOT LIKE '' and vtiger_crmentity.crmid!='' ) THEN CONCAT(vtiger_usersCalendar.first_name,' ',vtiger_usersCalendar.last_name) else vtiger_groupsCalendar.groupname end as 'Calendar_Assigned_To', vtiger_leadscf.cf_866 AS 'Leads_Nombre_de_la_Empresa', vtiger_leaddetails.firstname AS 'Leads_First_Name', vtiger_leaddetails.lastname AS 'Leads_Last_Name', vtiger_leadscf.cf_868 AS 'Leads_Fecha_Ultimo_Contacto', vtiger_leadaddress.state AS 'Leads_State', vtiger_contactscf.cf_865 AS 'Contacts_Nombre_de_la_Empresa', vtiger_contactdetails.firstname AS 'Contacts_First_Name', vtiger_contactdetails.lastname AS 'Contacts_Last_Name', vtiger_contactscf.cf_867 AS 'Contacts_Fecha_Ultimo_Contacto', vtiger_contactaddress.otherstate AS 'Contacts_Other_State', vtiger_crmentity.description AS 'Calendar_Description', vtiger_crmentity.crmid AS "LBL_ACTION" from vtiger_activity inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_activity.activityid left join vtiger_activitycf on vtiger_activitycf.activityid = vtiger_crmentity.crmid left join vtiger_cntactivityrel on vtiger_cntactivityrel.activityid= vtiger_activity.activityid left join vtiger_contactdetails as vtiger_contactdetailsCalendar on vtiger_contactdetailsCalendar.contactid= vtiger_cntactivityrel.contactid left join vtiger_groups as vtiger_groupsCalendar on vtiger_groupsCalendar.groupid = vtiger_crmentity.smownerid left join vtiger_users as vtiger_usersCalendar on vtiger_usersCalendar.id = vtiger_crmentity.smownerid 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_seactivityrel on vtiger_seactivityrel.activityid = vtiger_activity.activityid left join vtiger_activity_reminder on vtiger_activity_reminder.activity_id = vtiger_activity.activityid left join vtiger_recurringevents on vtiger_recurringevents.activityid = vtiger_activity.activityid left join vtiger_crmentity as vtiger_crmentityRelCalendar on vtiger_crmentityRelCalendar.crmid = vtiger_seactivityrel.crmid left join vtiger_account as vtiger_accountRelCalendar on vtiger_accountRelCalendar.accountid=vtiger_crmentityRelCalendar.crmid left join vtiger_leaddetails as vtiger_leaddetailsRelCalendar on vtiger_leaddetailsRelCalendar.leadid = vtiger_crmentityRelCalendar.crmid left join vtiger_potential as vtiger_potentialRelCalendar on vtiger_potentialRelCalendar.potentialid = vtiger_crmentityRelCalendar.crmid left join vtiger_quotes as vtiger_quotesRelCalendar on vtiger_quotesRelCalendar.quoteid = vtiger_crmentityRelCalendar.crmid left join vtiger_purchaseorder as vtiger_purchaseorderRelCalendar on vtiger_purchaseorderRelCalendar.purchaseorderid = vtiger_crmentityRelCalendar.crmid left join vtiger_invoice as vtiger_invoiceRelCalendar on vtiger_invoiceRelCalendar.invoiceid = vtiger_crmentityRelCalendar.crmid left join vtiger_salesorder as vtiger_salesorderRelCalendar on vtiger_salesorderRelCalendar.salesorderid = vtiger_crmentityRelCalendar.crmid left join vtiger_troubletickets as vtiger_troubleticketsRelCalendar on vtiger_troubleticketsRelCalendar.ticketid = vtiger_crmentityRelCalendar.crmid left join vtiger_campaign as vtiger_campaignRelCalendar on vtiger_campaignRelCalendar.campaignid = vtiger_crmentityRelCalendar.crmid left join vtiger_vendor as vtiger_vendorRelCalendar on vtiger_vendorRelCalendar.vendorid = vtiger_crmentityRelCalendar.crmid left join vtiger_users as vtiger_lastModifiedByCalendar on vtiger_lastModifiedByCalendar.id = vtiger_crmentity.modifiedby left join vtiger_cntactivityrel as vtiger_cntactivityreltmpContacts ON (vtiger_activity.activityid=vtiger_cntactivityreltmpContacts.activityid) left join (select vtiger_contactdetails.* from vtiger_contactdetails inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_contactdetails.contactid and vtiger_crmentity.deleted=0) as vtiger_contactdetails on vtiger_contactdetails.contactid=vtiger_cntactivityreltmpContacts.contactid left join vtiger_crmentity as vtiger_crmentityContacts on vtiger_crmentityContacts.crmid = vtiger_contactdetails.contactid and vtiger_crmentityContacts.deleted=0 left join vtiger_contactdetails as vtiger_contactdetailsContacts on vtiger_contactdetailsContacts.contactid = vtiger_contactdetails.reportsto left join vtiger_contactaddress on vtiger_contactdetails.contactid = vtiger_contactaddress.contactaddressid left join vtiger_customerdetails on vtiger_customerdetails.customerid = vtiger_contactdetails.contactid left join vtiger_contactsubdetails on vtiger_contactdetails.contactid = vtiger_contactsubdetails.contactsubscriptionid left join vtiger_account as vtiger_accountContacts on vtiger_accountContacts.accountid = vtiger_contactdetails.accountid left join vtiger_contactscf on vtiger_contactdetails.contactid = vtiger_contactscf.contactid left join vtiger_groups as vtiger_groupsContacts on vtiger_groupsContacts.groupid = vtiger_crmentityContacts.smownerid left join vtiger_users as vtiger_usersContacts on vtiger_usersContacts.id = vtiger_crmentityContacts.smownerid left join vtiger_users as vtiger_lastModifiedByContacts on vtiger_lastModifiedByContacts.id = vtiger_crmentityContacts.modifiedby INNER JOIN vt_tmp_u96_t4 vt_tmp_u96_t4Contacts ON vt_tmp_u96_t4Contacts.id = vtiger_crmentityContacts.smownerid left join vtiger_seactivityrel as vtiger_seactivityreltmpLeads ON (vtiger_activity.activityid=vtiger_seactivityreltmpLeads.activityid) left join (select vtiger_leaddetails.* from vtiger_leaddetails inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_leaddetails.leadid and vtiger_crmentity.deleted=0) as vtiger_leaddetails on vtiger_leaddetails.leadid=vtiger_seactivityreltmpLeads.crmid AND vtiger_leaddetails.converted = 0 left join vtiger_crmentity as vtiger_crmentityLeads on vtiger_crmentityLeads.crmid = vtiger_leaddetails.leadid and vtiger_crmentityLeads.deleted=0 left join vtiger_leadaddress on vtiger_leaddetails.leadid = vtiger_leadaddress.leadaddressid left join vtiger_leadsubdetails on vtiger_leadsubdetails.leadsubscriptionid = vtiger_leaddetails.leadid left join vtiger_leadscf on vtiger_leadscf.leadid = vtiger_leaddetails.leadid left join vtiger_groups as vtiger_groupsLeads on vtiger_groupsLeads.groupid = vtiger_crmentityLeads.smownerid left join vtiger_users as vtiger_usersLeads on vtiger_usersLeads.id = vtiger_crmentityLeads.smownerid left join vtiger_users as vtiger_lastModifiedByLeads on vtiger_lastModifiedByLeads.id = vtiger_crmentityLeads.modifiedby INNER JOIN vt_tmp_u96_t7 vt_tmp_u96_t7Leads ON vt_tmp_u96_t7Leads.id = vtiger_crmentityLeads.smownerid INNER JOIN vt_tmp_u96_t9 vt_tmp_u96_t9 ON (vt_tmp_u96_t9.id = vtiger_crmentity.smownerid and vt_tmp_u96_t9.shared=0) WHERE vtiger_activity.activityid > 0 AND vtiger_crmentity.deleted=0 and (vtiger_activity.activitytype != 'Emails') and (( trim(case when (vtiger_usersCalendar.last_name NOT LIKE '') then CONCAT(vtiger_usersCalendar.first_name,' ',vtiger_usersCalendar.last_name) else vtiger_groupsCalendar.groupname end) like '%MANOLIN%' and vtiger_activity.date_start > '2016-03-28 11:34:00' ) ) order by Leads_Nombre_de_la_Empresa ASC
Y esta es la respuesta:
'cbcrm_XYXYXYXYXYX.vt_tmp_u96_t4' doesn't exist
y esto es lo que reponde despues cuando se queda colgado:
INFO VT PearDatabase ->ADODB disconnect
Me puedes decir que debo hacer? Gracias.
He hecho lo que me indicas y esto es lo que ocurre:
La query sql que da el error es esta:
select DISTINCT case when(vtiger_usersCalendar.last_name NOT LIKE '' and vtiger_crmentity.crmid!='' ) THEN CONCAT(vtiger_usersCalendar.first_name,' ',vtiger_usersCalendar.last_name) else vtiger_groupsCalendar.groupname end as 'Calendar_Assigned_To', vtiger_leadscf.cf_866 AS 'Leads_Nombre_de_la_Empresa', vtiger_leaddetails.firstname AS 'Leads_First_Name', vtiger_leaddetails.lastname AS 'Leads_Last_Name', vtiger_leadscf.cf_868 AS 'Leads_Fecha_Ultimo_Contacto', vtiger_leadaddress.state AS 'Leads_State', vtiger_contactscf.cf_865 AS 'Contacts_Nombre_de_la_Empresa', vtiger_contactdetails.firstname AS 'Contacts_First_Name', vtiger_contactdetails.lastname AS 'Contacts_Last_Name', vtiger_contactscf.cf_867 AS 'Contacts_Fecha_Ultimo_Contacto', vtiger_contactaddress.otherstate AS 'Contacts_Other_State', vtiger_crmentity.description AS 'Calendar_Description', vtiger_crmentity.crmid AS "LBL_ACTION" from vtiger_activity inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_activity.activityid left join vtiger_activitycf on vtiger_activitycf.activityid = vtiger_crmentity.crmid left join vtiger_cntactivityrel on vtiger_cntactivityrel.activityid= vtiger_activity.activityid left join vtiger_contactdetails as vtiger_contactdetailsCalendar on vtiger_contactdetailsCalendar.contactid= vtiger_cntactivityrel.contactid left join vtiger_groups as vtiger_groupsCalendar on vtiger_groupsCalendar.groupid = vtiger_crmentity.smownerid left join vtiger_users as vtiger_usersCalendar on vtiger_usersCalendar.id = vtiger_crmentity.smownerid 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_seactivityrel on vtiger_seactivityrel.activityid = vtiger_activity.activityid left join vtiger_activity_reminder on vtiger_activity_reminder.activity_id = vtiger_activity.activityid left join vtiger_recurringevents on vtiger_recurringevents.activityid = vtiger_activity.activityid left join vtiger_crmentity as vtiger_crmentityRelCalendar on vtiger_crmentityRelCalendar.crmid = vtiger_seactivityrel.crmid left join vtiger_account as vtiger_accountRelCalendar on vtiger_accountRelCalendar.accountid=vtiger_crmentityRelCalendar.crmid left join vtiger_leaddetails as vtiger_leaddetailsRelCalendar on vtiger_leaddetailsRelCalendar.leadid = vtiger_crmentityRelCalendar.crmid left join vtiger_potential as vtiger_potentialRelCalendar on vtiger_potentialRelCalendar.potentialid = vtiger_crmentityRelCalendar.crmid left join vtiger_quotes as vtiger_quotesRelCalendar on vtiger_quotesRelCalendar.quoteid = vtiger_crmentityRelCalendar.crmid left join vtiger_purchaseorder as vtiger_purchaseorderRelCalendar on vtiger_purchaseorderRelCalendar.purchaseorderid = vtiger_crmentityRelCalendar.crmid left join vtiger_invoice as vtiger_invoiceRelCalendar on vtiger_invoiceRelCalendar.invoiceid = vtiger_crmentityRelCalendar.crmid left join vtiger_salesorder as vtiger_salesorderRelCalendar on vtiger_salesorderRelCalendar.salesorderid = vtiger_crmentityRelCalendar.crmid left join vtiger_troubletickets as vtiger_troubleticketsRelCalendar on vtiger_troubleticketsRelCalendar.ticketid = vtiger_crmentityRelCalendar.crmid left join vtiger_campaign as vtiger_campaignRelCalendar on vtiger_campaignRelCalendar.campaignid = vtiger_crmentityRelCalendar.crmid left join vtiger_vendor as vtiger_vendorRelCalendar on vtiger_vendorRelCalendar.vendorid = vtiger_crmentityRelCalendar.crmid left join vtiger_users as vtiger_lastModifiedByCalendar on vtiger_lastModifiedByCalendar.id = vtiger_crmentity.modifiedby left join vtiger_cntactivityrel as vtiger_cntactivityreltmpContacts ON (vtiger_activity.activityid=vtiger_cntactivityreltmpContacts.activityid) left join (select vtiger_contactdetails.* from vtiger_contactdetails inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_contactdetails.contactid and vtiger_crmentity.deleted=0) as vtiger_contactdetails on vtiger_contactdetails.contactid=vtiger_cntactivityreltmpContacts.contactid left join vtiger_crmentity as vtiger_crmentityContacts on vtiger_crmentityContacts.crmid = vtiger_contactdetails.contactid and vtiger_crmentityContacts.deleted=0 left join vtiger_contactdetails as vtiger_contactdetailsContacts on vtiger_contactdetailsContacts.contactid = vtiger_contactdetails.reportsto left join vtiger_contactaddress on vtiger_contactdetails.contactid = vtiger_contactaddress.contactaddressid left join vtiger_customerdetails on vtiger_customerdetails.customerid = vtiger_contactdetails.contactid left join vtiger_contactsubdetails on vtiger_contactdetails.contactid = vtiger_contactsubdetails.contactsubscriptionid left join vtiger_account as vtiger_accountContacts on vtiger_accountContacts.accountid = vtiger_contactdetails.accountid left join vtiger_contactscf on vtiger_contactdetails.contactid = vtiger_contactscf.contactid left join vtiger_groups as vtiger_groupsContacts on vtiger_groupsContacts.groupid = vtiger_crmentityContacts.smownerid left join vtiger_users as vtiger_usersContacts on vtiger_usersContacts.id = vtiger_crmentityContacts.smownerid left join vtiger_users as vtiger_lastModifiedByContacts on vtiger_lastModifiedByContacts.id = vtiger_crmentityContacts.modifiedby INNER JOIN vt_tmp_u96_t4 vt_tmp_u96_t4Contacts ON vt_tmp_u96_t4Contacts.id = vtiger_crmentityContacts.smownerid left join vtiger_seactivityrel as vtiger_seactivityreltmpLeads ON (vtiger_activity.activityid=vtiger_seactivityreltmpLeads.activityid) left join (select vtiger_leaddetails.* from vtiger_leaddetails inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_leaddetails.leadid and vtiger_crmentity.deleted=0) as vtiger_leaddetails on vtiger_leaddetails.leadid=vtiger_seactivityreltmpLeads.crmid AND vtiger_leaddetails.converted = 0 left join vtiger_crmentity as vtiger_crmentityLeads on vtiger_crmentityLeads.crmid = vtiger_leaddetails.leadid and vtiger_crmentityLeads.deleted=0 left join vtiger_leadaddress on vtiger_leaddetails.leadid = vtiger_leadaddress.leadaddressid left join vtiger_leadsubdetails on vtiger_leadsubdetails.leadsubscriptionid = vtiger_leaddetails.leadid left join vtiger_leadscf on vtiger_leadscf.leadid = vtiger_leaddetails.leadid left join vtiger_groups as vtiger_groupsLeads on vtiger_groupsLeads.groupid = vtiger_crmentityLeads.smownerid left join vtiger_users as vtiger_usersLeads on vtiger_usersLeads.id = vtiger_crmentityLeads.smownerid left join vtiger_users as vtiger_lastModifiedByLeads on vtiger_lastModifiedByLeads.id = vtiger_crmentityLeads.modifiedby INNER JOIN vt_tmp_u96_t7 vt_tmp_u96_t7Leads ON vt_tmp_u96_t7Leads.id = vtiger_crmentityLeads.smownerid INNER JOIN vt_tmp_u96_t9 vt_tmp_u96_t9 ON (vt_tmp_u96_t9.id = vtiger_crmentity.smownerid and vt_tmp_u96_t9.shared=0) WHERE vtiger_activity.activityid > 0 AND vtiger_crmentity.deleted=0 and (vtiger_activity.activitytype != 'Emails') and (( trim(case when (vtiger_usersCalendar.last_name NOT LIKE '') then CONCAT(vtiger_usersCalendar.first_name,' ',vtiger_usersCalendar.last_name) else vtiger_groupsCalendar.groupname end) like '%MANOLIN%' and vtiger_activity.date_start > '2016-03-28 11:34:00' ) ) order by Leads_Nombre_de_la_Empresa ASC
Y esta es la respuesta:
'cbcrm_XYXYXYXYXYX.vt_tmp_u96_t4' doesn't exist
y esto es lo que reponde despues cuando se queda colgado:
INFO VT PearDatabase ->ADODB disconnect
Me puedes decir que debo hacer? Gracias.