Erreurs MySQL lors de l'installation chez Sivit (mutualisé).#

Setup will now attempt to setup the database:

Creating connection to the database: OK!

Selecting database `avygeofr`: OK!

Checking table prefix `modx_`: OK!

Creating database tables: Database Alerts!

MODx setup couldn't install/alter some tables inside the selected database.

The following errors had occurred during installation

Nom du champ 'cachepwd' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_web_users` ADD COLUMN `cachepwd` VARCHAR(100) NOT NULL COMMENT 'Store new unconfirmed password' AFTER `password`.


--------------------------------------------------------------------------------
Nom du champ 'editor_type' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_tmplvars` ADD COLUMN `editor_type` INTEGER NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor' AFTER `description` , ADD COLUMN `category` INTEGER NOT NULL DEFAULT '0' COMMENT 'category id' AFTER `editor_type`.
--------------------------------------------------------------------------------
Nom de clef 'indx_rank' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_tmplvars` ADD INDEX `indx_rank`(`rank`).
--------------------------------------------------------------------------------
Nom de clef 'aliasidx' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_content` ADD INDEX `aliasidx` (alias).
--------------------------------------------------------------------------------
Nom du champ 'introtext' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_content` ADD COLUMN `introtext` TEXT NOT NULL COMMENT 'Used to provide quick summary of the document' AFTER `isfolder`.
--------------------------------------------------------------------------------
Nom du champ 'menutitle' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_content` ADD COLUMN `menutitle` VARCHAR(30) NOT NULL COMMENT 'Menu title' AFTER `deletedby` , ADD COLUMN `donthit` TINYINT(1) NOT NULL default '0' COMMENT 'Disable page hit count' AFTER `menutitle` , ADD COLUMN `haskeywords` TINYINT(1) NOT NULL default '0' COMMENT 'has links to keywords' AFTER `donthit` , ADD COLUMN `hasmetatags` TINYINT(1) NOT NULL default '0' COMMENT 'has links to meta tags' AFTER `haskeywords` , ADD COLUMN `privateweb` TINYINT(1) NOT NULL default '0' COMMENT 'Private web document' AFTER `hasmetatags` , ADD COLUMN `privatemgr` TINYINT(1) NOT NULL default '0' COMMENT 'Private manager document' AFTER `privateweb`.
--------------------------------------------------------------------------------
Nom du champ 'content_dispo' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_content` ADD COLUMN `content_dispo` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0-inline, 1-attachment' AFTER `privatemgr`.
--------------------------------------------------------------------------------
Nom du champ 'hidemenu' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_content` ADD COLUMN `hidemenu` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'Hide document from menu' AFTER `content_dispo`.
--------------------------------------------------------------------------------
Nom du champ 'editor_type' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_plugins` ADD COLUMN `editor_type` INTEGER NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor' AFTER `description` , ADD COLUMN `category` INTEGER NOT NULL DEFAULT '0' COMMENT 'category id' AFTER `editor_type` , ADD COLUMN `cache_type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'cache option' AFTER `category`.
--------------------------------------------------------------------------------
Nom du champ 'disabled' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_plugins` ADD COLUMN `disabled` TINYINT NOT NULL COMMENT 'Disables the plugin' AFTER `properties`.
--------------------------------------------------------------------------------
Nom du champ 'moduleguid' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_plugins` ADD COLUMN `moduleguid` VARCHAR(32) NOT NULL COMMENT 'GUID of module from which to import shared parameters' AFTER `disabled`.
--------------------------------------------------------------------------------
Nom du champ 'editor_type' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_htmlsnippets` ADD COLUMN `editor_type` INTEGER NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor' AFTER `description` , ADD COLUMN `category` INTEGER NOT NULL DEFAULT '0' COMMENT 'category id' AFTER `editor_type` , ADD COLUMN `cache_type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'cache option' AFTER `category`.
--------------------------------------------------------------------------------
Nom du champ 'editor_type' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_snippets` ADD COLUMN `editor_type` INTEGER NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor' AFTER `description` , ADD COLUMN `category` INTEGER NOT NULL DEFAULT '0' COMMENT 'category id' AFTER `editor_type` , ADD COLUMN `cache_type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'cache option' AFTER `category`.
--------------------------------------------------------------------------------
Nom du champ 'properties' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_snippets` ADD COLUMN `properties` VARCHAR(255) NOT NULL COMMENT 'Default Properties' AFTER `locked`.
--------------------------------------------------------------------------------
Nom du champ 'moduleguid' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_snippets` ADD COLUMN `moduleguid` VARCHAR(32) NOT NULL COMMENT 'GUID of module from which to import shared parameters' AFTER `properties`.
--------------------------------------------------------------------------------
Nom du champ 'editor_type' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_site_templates` ADD COLUMN `editor_type` INTEGER NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor' AFTER `description` , ADD COLUMN `category` INTEGER NOT NULL DEFAULT '0' COMMENT 'category id' AFTER `editor_type` , ADD COLUMN `icon` VARCHAR(255) NOT NULL COMMENT 'url to icon file' AFTER `category` , ADD COLUMN `template_type` INTEGER NOT NULL DEFAULT '0' COMMENT '0-page,1-content' AFTER `icon`.
--------------------------------------------------------------------------------
Ne peut effacer (DROP) 'indx_doc_groups'. Vérifiez s'il existe during the execution of SQL statement ALTER TABLE `modx_document_groups` DROP INDEX `indx_doc_groups`.
--------------------------------------------------------------------------------
Nom de clef 'document' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_document_groups` ADD INDEX `document` (`document`).
--------------------------------------------------------------------------------
Nom de clef 'document_group' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_document_groups` ADD INDEX `document_group` (`document_group`).
--------------------------------------------------------------------------------
Nom du champ 'groupname' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_system_eventnames` ADD COLUMN `groupname` VARCHAR(20) NOT NULL AFTER `service`.
--------------------------------------------------------------------------------
Nom du champ 'private_memgroup' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_documentgroup_names` ADD COLUMN `private_memgroup` TINYINT DEFAULT '0' COMMENT 'determine whether the document group is private to manager users' AFTER `name`, ADD COLUMN `private_webgroup` TINYINT DEFAULT '0' COMMENT 'determines whether the document is private to web users' AFTER `private_memgroup`.
--------------------------------------------------------------------------------
Nom du champ 'bk_manager' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_user_roles` ADD COLUMN `bk_manager` int(1) NOT NULL DEFAULT '0' AFTER `access_permissions`.
--------------------------------------------------------------------------------
Nom du champ 'new_plugin' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_user_roles` ADD COLUMN `new_plugin` int(1) NOT NULL DEFAULT '0', ADD COLUMN `edit_plugin` int(1) NOT NULL DEFAULT '0', ADD COLUMN `save_plugin` int(1) NOT NULL DEFAULT '0', ADD COLUMN `delete_plugin` int(1) NOT NULL DEFAULT '0', ADD COLUMN `view_unpublished` int(1) NOT NULL DEFAULT '0'.
--------------------------------------------------------------------------------
Nom du champ 'new_module' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_user_roles` ADD COLUMN `new_module` int(1) NOT NULL DEFAULT '0', ADD COLUMN `edit_module` int(1) NOT NULL DEFAULT '0', ADD COLUMN `save_module` int(1) NOT NULL DEFAULT '0', ADD COLUMN `exec_module` int(1) NOT NULL DEFAULT '0', ADD COLUMN `delete_module` int(1) NOT NULL DEFAULT '0', ADD COLUMN `view_eventlog` int(1) NOT NULL DEFAULT '0', ADD COLUMN `delete_eventlog` int(1) NOT NULL DEFAULT '0', ADD COLUMN `manage_metatags` int(1) NOT NULL DEFAULT '0', ADD COLUMN `edit_doc_metatags` int(1) NOT NULL DEFAULT '0', ADD COLUMN `new_web_user` int(1) NOT NULL DEFAULT '0', ADD COLUMN `edit_web_user` int(1) NOT NULL DEFAULT '0', ADD COLUMN `save_web_user` int(1) NOT NULL DEFAULT '0', ADD COLUMN `delete_web_user` int(1) NOT NULL DEFAULT '0', ADD COLUMN `web_access_permissions` int(1) NOT NULL DEFAULT '0'.
--------------------------------------------------------------------------------
Nom du champ 'blockedafter' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_user_attributes` ADD COLUMN `dob` INTEGER(10) NOT NULL DEFAULT 0 AFTER `sessionid` , ADD COLUMN `gender` INTEGER(1) NOT NULL DEFAULT 0 COMMENT '0 - unknown, 1 - Male 2 - female' AFTER `dob` , ADD COLUMN `country` VARCHAR(5) NOT NULL AFTER `gender` , ADD COLUMN `state` VARCHAR(5) NOT NULL AFTER `country` , ADD COLUMN `zip` VARCHAR(5) NOT NULL AFTER `state` , ADD COLUMN `fax` VARCHAR(100) NOT NULL AFTER `zip` , ADD COLUMN `blockedafter` INTEGER(11) NOT NULL DEFAULT 0 AFTER `blockeduntil` , ADD COLUMN `photo` VARCHAR(255) NOT NULL COMMENT 'link to photo' AFTER `fax` , ADD COLUMN `comment` VARCHAR(255) NOT NULL COMMENT 'short comment' AFTER `photo`.
--------------------------------------------------------------------------------
Nom du champ 'blockedafter' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_web_user_attributes` ADD COLUMN `dob` INTEGER(10) NOT NULL DEFAULT 0 AFTER `sessionid` , ADD COLUMN `gender` INTEGER(1) NOT NULL DEFAULT 0 COMMENT '0 - unknown, 1 - Male 2 - female' AFTER `dob` , ADD COLUMN `country` VARCHAR(5) NOT NULL AFTER `gender` , ADD COLUMN `state` VARCHAR(5) NOT NULL AFTER `country` , ADD COLUMN `zip` VARCHAR(5) NOT NULL AFTER `state` , ADD COLUMN `fax` VARCHAR(100) NOT NULL AFTER `zip` , ADD COLUMN `blockedafter` INTEGER(11) NOT NULL DEFAULT 0 AFTER `blockeduntil` , ADD COLUMN `photo` VARCHAR(255) NOT NULL COMMENT 'link to photo' AFTER `fax` , ADD COLUMN `comment` VARCHAR(255) NOT NULL COMMENT 'short comment' AFTER `photo`.
--------------------------------------------------------------------------------
Nom du champ 'view_unpublished' déjà utilisé during the execution of SQL statement ALTER TABLE `modx_user_roles` ADD COLUMN `view_unpublished` int(1) NOT NULL DEFAULT '0' AFTER `web_access_permissions`.
--------------------------------------------------------------------------------
Ne peut effacer (DROP) 'idx_tmplvarid'. Vérifiez s'il existe during the execution of SQL statement ALTER TABLE `modx_site_tmplvar_templates` DROP INDEX `idx_tmplvarid` , DROP INDEX `idx_templateid` , ADD PRIMARY KEY ( `tmplvarid` , `templateid` ).
--------------------------------------------------------------------------------


Some tables were not updated. This might be due to previous modifications.

ALTER TABLE `{PREFIX}web_users` ADD COLUMN `cachepwd` VARCHAR(100) NOT NULL COMMENT 'Store new unconfirmed password' AFTER `password`;


ALTER TABLE `{PREFIX}site_tmplvars` ADD COLUMN `editor_type` INTEGER NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor' AFTER `description`
, ADD COLUMN `category` INTEGER NOT NULL DEFAULT '0' COMMENT 'category id' AFTER `editor_type`;


ALTER TABLE `{PREFIX}site_tmplvars` MODIFY COLUMN `name` VARCHAR(50) NOT NULL;


ALTER TABLE `{PREFIX}site_tmplvars` ADD INDEX `indx_rank`(`rank`);


ALTER TABLE `{PREFIX}site_content` ADD INDEX `aliasidx` (alias);


ALTER TABLE `{PREFIX}site_content` ADD COLUMN `introtext` TEXT NOT NULL COMMENT 'Used to provide quick summary of the document' AFTER `isfolder`;


ALTER TABLE `{PREFIX}site_content`  ADD COLUMN `menutitle` VARCHAR(30) NOT NULL COMMENT 'Menu title' AFTER `deletedby`
, ADD COLUMN `donthit` TINYINT(1) NOT NULL default '0' COMMENT 'Disable page hit count' AFTER `menutitle`
, ADD COLUMN `haskeywords` TINYINT(1) NOT NULL default '0' COMMENT 'has links to keywords' AFTER `donthit`
, ADD COLUMN `hasmetatags` TINYINT(1) NOT NULL default '0' COMMENT 'has links to meta tags' AFTER `haskeywords`
, ADD COLUMN `privateweb` TINYINT(1) NOT NULL default '0' COMMENT 'Private web document' AFTER `hasmetatags`
, ADD COLUMN `privatemgr` TINYINT(1) NOT NULL default '0' COMMENT 'Private manager document' AFTER `privateweb`;


ALTER TABLE `{PREFIX}site_content` ADD COLUMN `content_dispo` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0-inline, 1-attachment' AFTER `privatemgr`;


ALTER TABLE `{PREFIX}site_content` ADD COLUMN `hidemenu` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'Hide document from menu' AFTER `content_dispo`;


ALTER TABLE `{PREFIX}site_plugins` ADD COLUMN `editor_type` INTEGER NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor' AFTER `description`
, ADD COLUMN `category` INTEGER NOT NULL DEFAULT '0' COMMENT 'category id' AFTER `editor_type`
, ADD COLUMN `cache_type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'cache option' AFTER `category`;


ALTER TABLE `{PREFIX}site_plugins` ADD COLUMN `disabled` TINYINT NOT NULL COMMENT 'Disables the plugin' AFTER `properties`;


ALTER TABLE `{PREFIX}site_plugins` ADD COLUMN `moduleguid` VARCHAR(32) NOT NULL COMMENT 'GUID of module from which to import shared parameters' AFTER `disabled`;


ALTER TABLE `{PREFIX}site_htmlsnippets` ADD COLUMN `editor_type` INTEGER NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor' AFTER `description`
, ADD COLUMN `category` INTEGER NOT NULL DEFAULT '0' COMMENT 'category id' AFTER `editor_type`
, ADD COLUMN `cache_type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'cache option' AFTER `category`;


ALTER TABLE `{PREFIX}site_snippets` ADD COLUMN `editor_type` INTEGER NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor' AFTER `description`
, ADD COLUMN `category` INTEGER NOT NULL DEFAULT '0' COMMENT 'category id' AFTER `editor_type`
, ADD COLUMN `cache_type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'cache option' AFTER `category`;


ALTER TABLE `{PREFIX}site_snippets` ADD COLUMN `properties` VARCHAR(255) NOT NULL COMMENT 'Default Properties' AFTER `locked`;


ALTER TABLE `{PREFIX}site_snippets` ADD COLUMN `moduleguid` VARCHAR(32) NOT NULL COMMENT 'GUID of module from which to import shared parameters' AFTER `properties`


ALTER TABLE `{PREFIX}site_templates` ADD COLUMN `editor_type` INTEGER NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor' AFTER `description`
, ADD COLUMN `category` INTEGER NOT NULL DEFAULT '0' COMMENT 'category id' AFTER `editor_type`
, ADD COLUMN `icon` VARCHAR(255) NOT NULL COMMENT 'url to icon file' AFTER `category`
, ADD COLUMN `template_type` INTEGER NOT NULL DEFAULT '0' COMMENT '0-page,1-content' AFTER `icon`;


ALTER TABLE `{PREFIX}document_groups` DROP INDEX `indx_doc_groups`;


ALTER TABLE `{PREFIX}document_groups` ADD INDEX `document` (`document`);


ALTER TABLE `{PREFIX}document_groups` ADD INDEX `document_group` (`document_group`);


ALTER TABLE `{PREFIX}system_settings` MODIFY COLUMN `setting_value` TEXT NOT NULL;


ALTER TABLE `{PREFIX}site_plugins` MODIFY COLUMN `properties` TEXT;


ALTER TABLE `{PREFIX}system_eventnames` ADD COLUMN `groupname` VARCHAR(20) NOT NULL AFTER `service`;


ALTER TABLE `{PREFIX}documentgroup_names` 
 ADD COLUMN `private_memgroup` TINYINT DEFAULT '0' COMMENT 'determine whether the document group is private to manager users' AFTER `name`,
 ADD COLUMN `private_webgroup` TINYINT DEFAULT '0' COMMENT 'determines whether the document is private to web users' AFTER `private_memgroup`;


ALTER TABLE `{PREFIX}user_roles` ADD COLUMN `bk_manager` int(1) NOT NULL DEFAULT '0' AFTER `access_permissions`;


ALTER TABLE `{PREFIX}user_roles` 
 ADD COLUMN `new_plugin` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `edit_plugin` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `save_plugin` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `delete_plugin` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `view_unpublished` int(1) NOT NULL DEFAULT '0';


ALTER TABLE `{PREFIX}user_roles` 
 ADD COLUMN `new_module` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `edit_module` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `save_module` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `exec_module` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `delete_module` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `view_eventlog` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `delete_eventlog` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `manage_metatags` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `edit_doc_metatags` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `new_web_user` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `edit_web_user` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `save_web_user` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `delete_web_user` int(1) NOT NULL DEFAULT '0',
 ADD COLUMN `web_access_permissions` int(1) NOT NULL DEFAULT '0';


ALTER TABLE `{PREFIX}user_attributes` ADD COLUMN `dob` INTEGER(10) NOT NULL DEFAULT 0 AFTER `sessionid`
, ADD COLUMN `gender` INTEGER(1) NOT NULL DEFAULT 0 COMMENT '0 - unknown, 1 - Male 2 - female' AFTER `dob`
, ADD COLUMN `country` VARCHAR(5) NOT NULL AFTER `gender`
, ADD COLUMN `state` VARCHAR(5) NOT NULL AFTER `country`
, ADD COLUMN `zip` VARCHAR(5) NOT NULL AFTER `state`
, ADD COLUMN `fax` VARCHAR(100) NOT NULL AFTER `zip`
, ADD COLUMN `blockedafter` INTEGER(11) NOT NULL DEFAULT 0 AFTER `blockeduntil`
, ADD COLUMN `photo` VARCHAR(255) NOT NULL COMMENT 'link to photo' AFTER `fax`
, ADD COLUMN `comment` VARCHAR(255) NOT NULL COMMENT 'short comment' AFTER `photo`;


ALTER TABLE `{PREFIX}web_users` MODIFY COLUMN `username` VARCHAR(100) NOT NULL;


ALTER TABLE `{PREFIX}web_user_attributes` ADD COLUMN `dob` INTEGER(10) NOT NULL DEFAULT 0 AFTER `sessionid`
, ADD COLUMN `gender` INTEGER(1) NOT NULL DEFAULT 0 COMMENT '0 - unknown, 1 - Male 2 - female' AFTER `dob`
, ADD COLUMN `country` VARCHAR(5) NOT NULL AFTER `gender`
, ADD COLUMN `state` VARCHAR(5) NOT NULL AFTER `country`
, ADD COLUMN `zip` VARCHAR(5) NOT NULL AFTER `state`
, ADD COLUMN `fax` VARCHAR(100) NOT NULL AFTER `zip`
, ADD COLUMN `blockedafter` INTEGER(11) NOT NULL DEFAULT 0 AFTER `blockeduntil`
, ADD COLUMN `photo` VARCHAR(255) NOT NULL COMMENT 'link to photo' AFTER `fax`
, ADD COLUMN `comment` VARCHAR(255) NOT NULL COMMENT 'short comment' AFTER `photo`;


ALTER TABLE `{PREFIX}user_roles` ADD COLUMN `view_unpublished` int(1) NOT NULL DEFAULT '0' AFTER `web_access_permissions`;

ALTER TABLE `{PREFIX}site_tmplvar_templates` DROP INDEX `idx_tmplvarid`
, DROP INDEX `idx_templateid`
, ADD PRIMARY KEY ( `tmplvarid` , `templateid` )