After migration from SugarCRM 6.5.18 cannot save contacts (fix included)

📦 Install & Upgrade Help
1

Hi.

I migrated from SugarCRM 6.5.18 and could not save contacts.
After checking the logs I found that a missing column in the contacts table stopped this.

I though there may be more to come, so I installed a new version of SuiteCRM (7.2.1) into another directory and database.
I compared the two contact tables and came up with the following SQL to get this issue fixed:


ALTER TABLE `contacts` ADD COLUMN
(
  joomla_account_id varchar(255) DEFAULT NULL,
  portal_account_disabled tinyint(1) DEFAULT NULL,
  portal_user_type varchar(100) DEFAULT 'Single'
);

After the fix we can save contacts, hope that this maybe helpful for other people.

Jobst

2

Hi Jobst,

You can also run a Quick Repair and Rebuild from the admin menu which should pick up any discrepancies between the database tables and the structure in SuiteCRM and allow fixing these.

Thanks,
Jim

3

First thing I always do - did not make any difference this time … :wink: