Module Relationships

[64674596]

Used Module Builder to create new module, related to Accounts and deployed. Now when I go to Accounts, get the following message at bottom:

Error running count query for Account List: Query Failed SELECT count(*) c FROM eben_medical_benefits LEFT JOIN users jt0 ON jt0.id= eben_medical_benefits.modified_user_id AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= eben_medical_benefits.created_by AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN users jt2 ON jt2.id= eben_medical_benefits.assigned_user_id AND jt2.deleted=0 AND jt2.deleted=0 LEFT JOIN users jt3 ON jt3.id= eben_medical_benefits.modified_user_id AND jt3.deleted=0 AND jt3.deleted=0 INNER JOIN eben_medicaits_accounts ON (eben_medical_benefits.id=eben_medicaits_accounts. eben_medical_benefits_ida AND eben_medicaits_accounts.accounts_idb= 'edfbd868-422a-ae43-a5ea-485a9717bd23') where ( eben_medicaits_accounts.deleted=0 AND eben_medical_benefits.deleted=0) AND eben_medical_benefits.deleted=0 )::MySQL error 1146: Table 'payrollr_sugar.eben_medical_benefits' doesn't exist

I deleted the new module but still get same message. Any suggestions for getting back to normal.

CE version 5.0f

[nirmit]

Used Module Builder to create new module, related to Accounts and deployed. Now when I go to Accounts, get the following message at bottom:

Error running count query for Account List: Query Failed SELECT count(*) c FROM eben_medical_benefits LEFT JOIN users jt0 ON jt0.id= eben_medical_benefits.modified_user_id AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= eben_medical_benefits.created_by AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN users jt2 ON jt2.id= eben_medical_benefits.assigned_user_id AND jt2.deleted=0 AND jt2.deleted=0 LEFT JOIN users jt3 ON jt3.id= eben_medical_benefits.modified_user_id AND jt3.deleted=0 AND jt3.deleted=0 INNER JOIN eben_medicaits_accounts ON (eben_medical_benefits.id=eben_medicaits_accounts. eben_medical_benefits_ida AND eben_medicaits_accounts.accounts_idb= 'edfbd868-422a-ae43-a5ea-485a9717bd23') where ( eben_medicaits_accounts.deleted=0 AND eben_medical_benefits.deleted=0) AND eben_medical_benefits.deleted=0 )::MySQL error 1146: Table 'payrollr_sugar.eben_medical_benefits' doesn't exist

I deleted the new module but still get same message. Any suggestions for getting back to normal.

CE version 5.0f

Did you try rebuilding the relationships and the database port removal of your custom module?

[andreasbalzer]

Did you try rebuilding the relationships and the database port removal of your custom module?

What is database port removal and how to do it?

[nirmit]

Oops.. I meant "post" the removal of your module. Sorry for they typo.