Jump to content


Photo

x2crm update fail from 6.9.3 to 8.0

update

  • Please log in to reply
No replies to this topic

#1 pratikpatel939

pratikpatel939

    Advanced Member

  • Members
  • PipPipPip
  • 33 posts

Posted 01 October 2020 - 10:34 AM

Dear Community,

 

we have been trying to update x2crm but not able to to update. can u pls help ?

 

image for referrence 

 

https://ibb.co/b7xysJf 

 

 

 

Exception: "A database change failed to apply: ALTER TABLE `x2_accounts` ADD COLUMN `firstName` varchar(255) NULL AFTER `nameId`, ADD COLUMN `lastName` varchar(255) NULL AFTER `firstName`, ADD COLUMN `title` varchar(100) NULL AFTER `type`, ADD COLUMN `phone2` varchar(40) NULL AFTER `phone`, ADD COLUMN `email` varchar(250) NULL AFTER `phone2`, ADD COLUMN `twitter` varchar(50) NULL AFTER `email`, ADD COLUMN `linkedin` varchar(100) NULL AFTER `twitter`, ADD COLUMN `skype` varchar(32) NULL AFTER `linkedin`, ADD COLUMN `googleplus` varchar(100) NULL AFTER `skype`, ADD COLUMN `otherUrl` varchar(100) NULL AFTER `googleplus`, ADD COLUMN `company` varchar(250) NULL AFTER `otherUrl`, ADD COLUMN `modelName` varchar(100) NOT NULL AFTER `company`, ADD COLUMN `address2` varchar(250) NULL AFTER `address`, ADD COLUMN `backgroundInfo` text NULL AFTER `zipcode`, ADD COLUMN `priority` varchar(40) NULL AFTER `backgroundInfo`, ADD COLUMN `facebook` varchar(100) NULL AFTER `createDate`, ADD COLUMN `timezone` varchar(250) NULL AFTER `facebook`, ADD COLUMN `trackingKey` varchar(32) NULL AFTER `dupeCheck`, ADD COLUMN `doNotCall` tinyint(4) NULL DEFAULT '0' AFTER `expectedCloseDate`, ADD COLUMN `doNotEmail` tinyint(4) NULL DEFAULT '0' AFTER `doNotCall`, ADD INDEX `company` (`company`) USING BTREE;. The error message given was: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'firstName'
A database change failed to apply: ALTER TABLE `x2_accounts` ADD COLUMN `firstName` varchar(255) NULL AFTER `nameId`, ADD COLUMN `lastName` varchar(255) NULL AFTER `firstName`, ADD COLUMN `title` varchar(100) NULL AFTER `type`, ADD COLUMN `phone2` varchar(40) NULL AFTER `phone`, ADD COLUMN `email` varchar(250) NULL AFTER `phone2`, ADD COLUMN `twitter` varchar(50) NULL AFTER `email`, ADD COLUMN `linkedin` varchar(100) NULL AFTER `twitter`, ADD COLUMN `skype` varchar(32) NULL AFTER `linkedin`, ADD COLUMN `googleplus` varchar(100) NULL AFTER `skype`, ADD COLUMN `otherUrl` varchar(100) NULL AFTER `googleplus`, ADD COLUMN `company` varchar(250) NULL AFTER `otherUrl`, ADD COLUMN `modelName` varchar(100) NOT NULL AFTER `company`, ADD COLUMN `address2` varchar(250) NULL AFTER `address`, ADD COLUMN `backgroundInfo` text NULL AFTER `zipcode`, ADD COLUMN `priority` varchar(40) NULL AFTER `backgroundInfo`, ADD COLUMN `facebook` varchar(100) NULL AFTER `createDate`, ADD COLUMN `timezone` varchar(250) NULL AFTER `facebook`, ADD COLUMN `trackingKey` varchar(32) NULL AFTER `dupeCheck`, ADD COLUMN `doNotCall` tinyint(4) NULL DEFAULT '0' AFTER `expectedCloseDate`, ADD COLUMN `doNotEmail` tinyint(4) NULL DEFAULT '0' AFTER `doNotCall`, ADD INDEX `company` (`company`) USING BTREE;. The error message given was: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name &#039;firstName&#039;<br />The database has been restored to the backup copy.<br /><br />Update failed.

Update failed." in /home/cloudcrm/public_html/salesforce/protected/components/UpdaterBehavior.php L2226







0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users