03-15-2024, 07:22 PM
(This post was last modified: 03-15-2024, 07:48 PM by inspectorflint.)
Gracias, Joe, por la rapidez.
Activando el debug me aparece esto:
SELECT count(*) AS count FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_account.accountid INNER JOIN vtiger_crmentityreldenorm ON vtiger_crmentityreldenorm.relcrmid=vtiger_crmentity.crmid INNER JOIN vtiger_accountscf ON vtiger_accountscf.accountid = vtiger_account.accountid LEFT JOIN vtiger_accountbillads ON vtiger_accountbillads.accountaddressid = vtiger_account.accountid LEFT JOIN vtiger_accountshipads ON vtiger_accountshipads.accountaddressid = vtiger_account.accountid LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted = 0 AND vtiger_crmentityreldenorm.crmid=18722 Query: SELECT count(*) AS count FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_account.accountid INNER JOIN vtiger_crmentityreldenorm ON vtiger_crmentityreldenorm.relcrmid=vtiger_crmentity.crmid INNER JOIN vtiger_accountscf ON vtiger_accountscf.accountid = vtiger_account.accountid LEFT JOIN vtiger_accountbillads ON vtiger_accountbillads.accountaddressid = vtiger_account.accountid LEFT JOIN vtiger_accountshipads ON vtiger_accountshipads.accountaddressid = vtiger_account.accountid LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted = 0 AND vtiger_crmentityreldenorm.crmid=18722 failed. Table 'corallo_8_penultima.vtiger_crmentityreldenorm' doesn't exist
1146: Table 'corallo_8_penultima.vtiger_crmentityreldenorm' doesn't exist
ADOConnection._Execute(SELECT count(*) AS count FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_account.accountid INNE..., false) % line 1241, file: adodb.inc.php
ADOConnection.Execute(SELECT count(*) AS count FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_account.accountid INNE...) % line 374, file: PearDatabase.php
PearDatabase.query(SELECT count(*) AS count FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_account.accountid INNE...) % line 154, file: RelatedListView.php
GetRelatedListBase(DiscountLine, Accounts, Object:Accounts, SELECT vtiger_crmentity.* , CASE WHEN (vtiger_users.user_name NOT LIKE '') THEN vtiger_users.ename ELSE vtiger_groups.groupname ..., <table cellspacing=0 cellpadding=2><tr><td><input title='Seleccionar Cuentas' class='crmbutton small edit' type='button' onclick..., &return_module=DiscountLine&return_action=CallRelatedList&return_id=18722, , , , false) % line 18, file: RelatedListView.php
GetRelatedList(DiscountLine, Accounts, Object:Accounts, SELECT vtiger_crmentity.* , CASE WHEN (vtiger_users.user_name NOT LIKE '') THEN vtiger_users.ename ELSE vtiger_groups.groupname ..., <input title='Seleccionar Cuentas' class='crmbutton small edit' type='button' onclick="return window.open('index.php?module=Acco..., &return_module=DiscountLine&return_action=CallRelatedList&return_id=18722) % line 2692, file: CRMEntity.php
He ejecutado las actualizaciones de la BD y solucionado!!
Saludos
Activando el debug me aparece esto:
SELECT count(*) AS count FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_account.accountid INNER JOIN vtiger_crmentityreldenorm ON vtiger_crmentityreldenorm.relcrmid=vtiger_crmentity.crmid INNER JOIN vtiger_accountscf ON vtiger_accountscf.accountid = vtiger_account.accountid LEFT JOIN vtiger_accountbillads ON vtiger_accountbillads.accountaddressid = vtiger_account.accountid LEFT JOIN vtiger_accountshipads ON vtiger_accountshipads.accountaddressid = vtiger_account.accountid LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted = 0 AND vtiger_crmentityreldenorm.crmid=18722 Query: SELECT count(*) AS count FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_account.accountid INNER JOIN vtiger_crmentityreldenorm ON vtiger_crmentityreldenorm.relcrmid=vtiger_crmentity.crmid INNER JOIN vtiger_accountscf ON vtiger_accountscf.accountid = vtiger_account.accountid LEFT JOIN vtiger_accountbillads ON vtiger_accountbillads.accountaddressid = vtiger_account.accountid LEFT JOIN vtiger_accountshipads ON vtiger_accountshipads.accountaddressid = vtiger_account.accountid LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted = 0 AND vtiger_crmentityreldenorm.crmid=18722 failed. Table 'corallo_8_penultima.vtiger_crmentityreldenorm' doesn't exist
1146: Table 'corallo_8_penultima.vtiger_crmentityreldenorm' doesn't exist
ADOConnection._Execute(SELECT count(*) AS count FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_account.accountid INNE..., false) % line 1241, file: adodb.inc.php
ADOConnection.Execute(SELECT count(*) AS count FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_account.accountid INNE...) % line 374, file: PearDatabase.php
PearDatabase.query(SELECT count(*) AS count FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid=vtiger_account.accountid INNE...) % line 154, file: RelatedListView.php
GetRelatedListBase(DiscountLine, Accounts, Object:Accounts, SELECT vtiger_crmentity.* , CASE WHEN (vtiger_users.user_name NOT LIKE '') THEN vtiger_users.ename ELSE vtiger_groups.groupname ..., <table cellspacing=0 cellpadding=2><tr><td><input title='Seleccionar Cuentas' class='crmbutton small edit' type='button' onclick..., &return_module=DiscountLine&return_action=CallRelatedList&return_id=18722, , , , false) % line 18, file: RelatedListView.php
GetRelatedList(DiscountLine, Accounts, Object:Accounts, SELECT vtiger_crmentity.* , CASE WHEN (vtiger_users.user_name NOT LIKE '') THEN vtiger_users.ename ELSE vtiger_groups.groupname ..., <input title='Seleccionar Cuentas' class='crmbutton small edit' type='button' onclick="return window.open('index.php?module=Acco..., &return_module=DiscountLine&return_action=CallRelatedList&return_id=18722) % line 2692, file: CRMEntity.php
He ejecutado las actualizaciones de la BD y solucionado!!
Saludos