I have carried out a test upgrade of my existing SugarCRM CE system to SuiteCRM which passed off relatively smoothly once I ironed out the bugs in the existing system. Since then I have run into a number of problems while testing which all appear to have been caused by the upgrade process failing to add the required new columns to the existing back-end MySQL database. Trying to add a new contact fails because the portal_user_type column has not been added to the “contacts” table for instance.
Does anyone have a SQL script that can be run to add these missing additional fields? As things stand my system is pretty much read-only.
Thanks in advance,
Ben