Jump to content
X2Community Forums

Failed Update X2Engine to 6.5.1 from 6.0.4 - x2_calendar_invites


Recommended Posts

I'm a junior user, first time to have problem in updating X2.

 

Please help, thx all in the community!

 

Have tried to change Storage Engine to innodb in x2_calendar & invites in mysql

 

Message I have:

 

 

Update X2Engine to 6.5.1 from 6.0.4

 

Exception: "A database change failed to apply: CREATE TABLE `x2_calendar_invites` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `actionId` int(10) unsigned NOT NULL, `email` varchar(255) DEFAULT NULL, `status` enum('Yes','No','Maybe') DEFAULT NULL, `inviteKey` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `actionId` (`actionId`), CONSTRAINT `x2_calendar_invites_ibfk_1` FOREIGN KEY (`actionId`) REFERENCES `x2_actions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;. The error message given was: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'x2_calendar_invites' already exists
A database change failed to apply: CREATE TABLE `x2_calendar_invites` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `actionId` int(10) unsigned NOT NULL, `email` varchar(255) DEFAULT NULL, `status` enum('Yes','No','Maybe') DEFAULT NULL, `inviteKey` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `actionId` (`actionId`), CONSTRAINT `x2_calendar_invites_ibfk_1` FOREIGN KEY (`actionId`) REFERENCES `x2_actions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;. The error message given was: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'x2_calendar_invites' already exists<br />To restore the database to its previous state, use the database dump file update_backup.sql stored in protected/data<br /><br />Update failed.

Update failed." in /home/zfind/www/crm/protected/components/UpdaterBehavior.php L2230

 

Hosted on icdsoft 

 

Installed software

 

Update X2Engine to 6.5.1 from 6.0.4

 

Exception: "A database change failed to apply: CREATE TABLE `x2_calendar_invites` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `actionId` int(10) unsigned NOT NULL, `email` varchar(255) DEFAULT NULL, `status` enum('Yes','No','Maybe') DEFAULT NULL, `inviteKey` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `actionId` (`actionId`), CONSTRAINT `x2_calendar_invites_ibfk_1` FOREIGN KEY (`actionId`) REFERENCES `x2_actions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;. The error message given was: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'x2_calendar_invites' already exists
A database change failed to apply: CREATE TABLE `x2_calendar_invites` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `actionId` int(10) unsigned NOT NULL, `email` varchar(255) DEFAULT NULL, `status` enum('Yes','No','Maybe') DEFAULT NULL, `inviteKey` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `actionId` (`actionId`), CONSTRAINT `x2_calendar_invites_ibfk_1` FOREIGN KEY (`actionId`) REFERENCES `x2_actions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;. The error message given was: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'x2_calendar_invites' already exists<br />To restore the database to its previous state, use the database dump file update_backup.sql stored in protected/data<br /><br />Update failed.

Update failed." in /home/zfind/www/crm/protected/components/UpdaterBehavior.php L2230

Link to post
Share on other sites

It appears that a table from the new version is still present, likely from the previous failed update as you mentioned that you've already altered the x2_calendars table's engine.

 

First, restore your database with the backup at protected/data/update_backup.sql. In the future, you can perform this step automatically in case of db exceptions by marking the automatic rollback checkbox on the update page. Once you've restored your database to the backup, you'll likely need to update the x2_calendars storage engine again. Then, ensure that the x2_calendar_invites table is not present, and if it is drop it. Finally, proceed to the update page to retry the update.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...