Software Update The following error occurred: ALTER TABLE `perch2_content_items` ADD INDEX `idx_regrev` USING BTREE (itemID, regionID, itemRev) SQLSTATE[42000]: Syntax error or access violation: 1061 Nom de clef 'idx_regrev' déjà utilisé The following error occurred: ALTER TABLE `perch2_content_items` ADD INDEX `idx_order` USING BTREE (itemOrder) SQLSTATE[42000]: Syntax error or access violation: 1061 Nom de clef 'idx_order' déjà utilisé The following error occurred: ALTER TABLE `perch2_content_regions` ADD INDEX `idx_key` USING BTREE (regionKey) SQLSTATE[42000]: Syntax error or access violation: 1061 Nom de clef 'idx_key' déjà utilisé The following error occurred: ALTER TABLE `perch2_content_regions` ADD INDEX `idx_path` USING BTREE (regionPage) SQLSTATE[42000]: Syntax error or access violation: 1061 Nom de clef 'idx_path' déjà utilisé The following error occurred: ALTER TABLE `perch2_page_templates` ADD `templateNavGroups` VARCHAR(255) NULL DEFAULT '' AFTER `templateReference` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'templateNavGroups' déjà utilisé The following error occurred: ALTER TABLE `perch2_user_privileges` ADD UNIQUE INDEX `idx_key` (`privKey`) SQLSTATE[42000]: Syntax error or access violation: 1061 Nom de clef 'idx_key' déjà utilisé The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.navgroups.configure','Configure navigation groups',7), ('content.navgroups.create','Create navigation groups',8), ('content.navgroups.delete','Delete navigation groups',9) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'content.navgroups.configure' pour la clef 'idx_key' The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.pages.create.toplevel','Add new top-level pages',3) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'content.pages.create.toplevel' pour la clef 'idx_key' The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.pages.delete.own','Delete pages they created themselves',4) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'content.pages.delete.own' pour la clef 'idx_key' The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.templates.configure','Configure master pages',6) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'content.templates.configure' pour la clef 'idx_key' The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.pages.republish','Republish pages', 12) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'content.pages.republish' pour la clef 'idx_key' The following error occurred: ALTER TABLE `perch2_pages` ADD `pageAccessTags` VARCHAR(255) NOT NULL DEFAULT '' AFTER `pageNavOnly` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'pageAccessTags' déjà utilisé The following error occurred: ALTER TABLE `perch2_pages` ADD `pageCreatorID` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `pageAccessTags` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'pageCreatorID' déjà utilisé The following error occurred: ALTER TABLE `perch2_pages` ADD `pageModified` DATETIME NOT NULL DEFAULT '2014-01-01 00:00:00' AFTER `pageCreatorID` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'pageModified' déjà utilisé The following error occurred: ALTER TABLE `perch2_pages` ADD `pageAttributes` TEXT NOT NULL AFTER `pageModified` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'pageAttributes' déjà utilisé The following error occurred: ALTER TABLE `perch2_pages` ADD `pageAttributeTemplate` VARCHAR(255) NOT NULL DEFAULT 'default.html' AFTER `pageAttributes` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'pageAttributeTemplate' déjà utilisé The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.pages.attributes','Edit page titles and attributes',6) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'content.pages.attributes' pour la clef 'idx_key' The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceCreated` DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00' AFTER `resourceType` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceCreated' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceUpdated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `resourceCreated` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceUpdated' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceAWOL` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `resourceUpdated` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceAWOL' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD INDEX `idx_awol` (`resourceAWOL`) SQLSTATE[42000]: Syntax error or access violation: 1061 Nom de clef 'idx_awol' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceTitle` CHAR(255) NULL DEFAULT NULL AFTER `resourceAWOL` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceTitle' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceFileSize` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceTitle` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceFileSize' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceWidth` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceFileSize` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceWidth' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceHeight` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceWidth` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceHeight' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceCrop` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `resourceHeight` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceCrop' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceDensity` FLOAT NOT NULL DEFAULT '1' AFTER `resourceCrop` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceDensity' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceTargetWidth` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceDensity` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceTargetWidth' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceTargetHeight` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `resourceTargetWidth` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceTargetHeight' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceMimeType` CHAR(64) NULL DEFAULT NULL AFTER `resourceTargetHeight` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceMimeType' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD FULLTEXT INDEX `idx_search` (`resourceTitle`) SQLSTATE[42000]: Syntax error or access violation: 1061 Nom de clef 'idx_search' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD `resourceInLibrary` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `resourceMimeType` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'resourceInLibrary' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD INDEX `idx_library` (`resourceInLibrary`) SQLSTATE[42000]: Syntax error or access violation: 1061 Nom de clef 'idx_library' déjà utilisé The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('assets.create','Upload assets',1) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'assets.create' pour la clef 'idx_key' The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('assets.manage','Manage assets',2) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'assets.manage' pour la clef 'idx_key' The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('categories.create','Create new categories',1) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'categories.create' pour la clef 'idx_key' The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('categories.delete','Delete categories',2) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'categories.delete' pour la clef 'idx_key' The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('categories.manage','Manage categories',3) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'categories.manage' pour la clef 'idx_key' The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('categories.sets.create','Create category sets',4) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'categories.sets.create' pour la clef 'idx_key' The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('categories.sets.delete','Delete category sets',5) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'categories.sets.delete' pour la clef 'idx_key' The following error occurred: ALTER TABLE `perch2_content_regions` ADD `regionUpdated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `regionEditRoles` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'regionUpdated' déjà utilisé The following error occurred: ALTER TABLE `perch2_content_items` ADD `itemUpdated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `itemSearch` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'itemUpdated' déjà utilisé The following error occurred: ALTER TABLE `perch2_content_items` ADD `itemUpdatedBy` CHAR(32) NOT NULL DEFAULT '' AFTER `itemUpdated` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'itemUpdatedBy' déjà utilisé The following error occurred: ALTER TABLE `perch2_pages` ADD `pageTemplate` CHAR(255) NOT NULL DEFAULT '' AFTER `pageAttributeTemplate` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'pageTemplate' déjà utilisé The following error occurred: ALTER TABLE `perch2_pages` ADD `templateID` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `pageTemplate` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'templateID' déjà utilisé The following error occurred: ALTER TABLE `perch2_pages` ADD `pageSubpageTemplates` VARCHAR(255) NOT NULL DEFAULT '' AFTER `templateID` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'pageSubpageTemplates' déjà utilisé The following error occurred: ALTER TABLE `perch2_pages` ADD `pageCollections` VARCHAR(255) NOT NULL DEFAULT '' AFTER `pageSubpageTemplates` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'pageCollections' déjà utilisé The following error occurred: ALTER TABLE `perch2_resource_log` ADD UNIQUE INDEX `idx_uni` (`appID`, `itemFK`, `itemRowID`, `resourceID`) SQLSTATE[42000]: Syntax error or access violation: 1061 Nom de clef 'idx_uni' déjà utilisé The following error occurred: ALTER TABLE `perch2_users` ADD `userPasswordToken` CHAR(255) NOT NULL DEFAULT 'expired' AFTER `userMasterAdmin` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'userPasswordToken' déjà utilisé The following error occurred: ALTER TABLE `perch2_users` ADD `userPasswordTokenExpires` DATETIME NOT NULL DEFAULT '2015-01-01 00:00:00' AFTER `userPasswordToken` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'userPasswordTokenExpires' déjà utilisé The following error occurred: ALTER TABLE `perch2_users` ADD `userLastFailedLogin` DATETIME NULL AFTER `userPasswordTokenExpires` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'userLastFailedLogin' déjà utilisé The following error occurred: ALTER TABLE `perch2_users` ADD `userFailedLoginAttempts` INT(0) UNSIGNED NOT NULL DEFAULT '0' AFTER `userLastFailedLogin` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'userFailedLoginAttempts' déjà utilisé The following error occurred: ALTER TABLE `perch2_resources` ADD INDEX `idx_list` (`resourceParentID`, `resourceKey`, `resourceAWOL`) SQLSTATE[42000]: Syntax error or access violation: 1061 Nom de clef 'idx_list' déjà utilisé The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('assets.delete','Delete assets',3) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'assets.delete' pour la clef 'idx_key' The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.bulk.delete','Bulk delete content',30) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'content.bulk.delete' pour la clef 'idx_key' The following error occurred: INSERT INTO `perch2_user_privileges` (`privKey`, `privTitle`, `privOrder`) VALUES ('content.pages.manage_urls','Edit page locations',10) SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'content.pages.manage_urls' pour la clef 'idx_key' The following error occurred: ALTER TABLE `perch2_content_regions` ADD `regionPublishRoles` VARCHAR(255) NOT NULL DEFAULT '*' AFTER `regionEditRoles` SQLSTATE[42S21]: Column already exists: 1060 Nom du champ 'regionPublishRoles' déjà utilisé