Upgrading VTigerCRM SVN

From Proxmox VE

Contents 1 Upgrading vTigerCRM from SVN 13033 to 13053 2 Upgrading vTigerCRM from SVN 13053 to 13070 3 VTigerCRM SVN 13070 to 13095 4 VTigerCRM SVN 13095 to 13099

Upgrading vTigerCRM from SVN 13033 to 13053

On March 13th, 2010, a slew of updates to vTigerCRM v5.2.0 branch occurred. This necessitated the following database change exemplified for the default install:

ALTER TABLE `vtiger_inventorynotification` ADD COLUMN `status` VARCHAR(30) NULL AFTER `label`;

The changed files can be uploaded using the following console commands:

cd /var/www/vtigercrm
wget http://www.sacollege.net/files/appliances/vtiger-svn-diff-13033-13053.tar.gz
tar -zxvpf vtiger-svn-diff-13033-13053.tar.gz
rm vtiger-svn-diff-13033-13053.tar.gz

Upgrading vTigerCRM from SVN 13053 to 13070

On April 01st, 2010, a set of updates to vTigerCRM v5.2.0 branch occurred. This necessitated the following database changes exemplified for the default install:

CREATE TABLE `vtiger_campaignaccountrel`(
	`campaignid` int(19) NULL  , 
	`accountid` int(19) NULL  , 
	`campaignrelstatusid` int(19) NULL  
) ENGINE=InnoDB DEFAULT CHARSET='utf8';


ALTER TABLE `vtiger_campaigncontrel` 
	ADD COLUMN `campaignrelstatusid` int(19)   NOT NULL DEFAULT '0' after  `contactid`, 
	DROP KEY `PRIMARY`, add PRIMARY KEY(`campaignid`,`contactid`,`campaignrelstatusid`);

ALTER TABLE `vtiger_campaignleadrel` 
	ADD COLUMN `campaignrelstatusid` int(19)   NOT NULL DEFAULT '0' after `leadid`, 
	DROP KEY `PRIMARY`, add PRIMARY KEY(`campaignid`,`leadid`,`campaignrelstatusid`);

CREATE TABLE `vtiger_campaignrelstatus`(
	`campaignrelstatusid` int(19) NULL  , 
	`campaignrelstatus` varchar(256) COLLATE utf8_general_ci NULL  , 
	`sortorderid` int(19) NULL  , 
	`presence` int(19) NULL  
) ENGINE=InnoDB DEFAULT CHARSET='utf8';


CREATE TABLE `vtiger_campaignrelstatus_seq`(
	`id` int(11) NOT NULL  
) ENGINE=MyISAM DEFAULT CHARSET='utf8';


ALTER TABLE `vtiger_systems` 
	ADD COLUMN `from_email_field` varchar(50)  COLLATE utf8_general_ci NULL after `server_path`;

The DEFAULT CHARSET='utf8' needs to be there in the above SQL statements if you have enabled utf8 during your original install.

There are no changes in the config.inc.php file for now.

The changed files can be uploaded using the following console commands:

cd /var/www/vtigercrm
wget http://www.sacollege.net/files/appliances/vtiger520-svn-13053-13070.tar.gz
tar -zxvpf vtiger520-svn-13053-13070.tar.gz
rm vtiger520-svn-13053-13070.tar.gz

VTigerCRM SVN 13070 to 13095

VTigerCRM SVN 13095 to 13099