After Quick Repair I see at the bottom some errors like "relation⦠due to deleted Aforex module
I am trying to get rid of the Aforex Module,even after delete Module, still some left behindsā¦
William
After Quick Repair I see at the bottom some errors like "relation⦠due to deleted Aforex module
I am trying to get rid of the Aforex Module,even after delete Module, still some left behindsā¦
William
/* Table : fo_aforex /
/COLUMNS/
/MISSING IN DATABASE - id - ROW/
/MISSING IN DATABASE - name - ROW/
/MISSING IN DATABASE - date_entered - ROW/
/MISSING IN DATABASE - date_modified - ROW/
/MISSING IN DATABASE - modified_user_id - ROW/
/MISSING IN DATABASE - created_by - ROW/
/MISSING IN DATABASE - description - ROW/
/MISSING IN DATABASE - deleted - ROW/
/MISSING IN DATABASE - assigned_user_id - ROW/
/MISSING IN DATABASE - localcurrate - ROW/
/MISSING IN DATABASE - standusdrate - ROW/
/ INDEXES */
ALTER TABLE fo_aforex add COLUMN id char(36) NOT NULL , add COLUMN name varchar(255) NULL , add COLUMN date_entered datetime NULL , add COLUMN date_modified datetime NULL , add COLUMN modified_user_id char(36) NULL , add COLUMN created_by char(36) NULL , add COLUMN description text NULL , add COLUMN deleted bool DEFAULT ā0ā NULL , add COLUMN assigned_user_id char(36) NULL , add COLUMN localcurrate varchar(100) NULL , add COLUMN standusdrate varchar(100) NULL ;
Youāll have to look for those left-overs in the custom directory, and in the database (table fields_meta_data).
Thereās a nice script to find these broken references for you here:
http://www.jsmackin.co.uk/suitecrm/suitecrm-missing-field-definitions/