), j’ai décidé de tester Modx sur un site en projet (pas celui de mon profil).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.
Intéressant... Me confirmes-tu que lors de l’installation tu as remplacé le nom de la bdd indiqué par défaut (Modx) par le nom de l’une de tes bdd ?
Ca fonctionne pas mal chez Sivit en mutualisé, la preuve
http://www.lemanssud.fr/index.php?id=123
Tout à fait, il y a un problème avec l’installationd e la base de données. je disais simplement que le problème ne venait pas du nom de la base de données
Les messages que tu indique montrent bien un problème avec ta base de données.
.
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` )