Note du Modérateur : Merci de vous reporter au sujet :
[Test] Bugfix du fichier setup.sql
modif je viens de voir que c’est déjà dans le bug tracker depuis le 10 octobre. En tout cas il semble que le pare feu soit en cause car je viens d’intaller cmsms sans problème. Avec celui ci la version 4.1 de Msql me refusait la connexion.
sans pare-feu et sans antivirus en installation sur easyphp 1.8 tout fonctionne bien jusqu’au dernier épisode de l’installation ou j’obtien sles erreurs suivantes ( désolé se surcharger le post)
un petit coup de main serait le bienvenu
Setup will now attempt to setup the database:
Creating connection to the database: OK!
Selecting database `modx`: Database selection failed... The database does not exist. Setup will attempt to create it.
Creating database `modx`: 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 paramaters’ 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 paramaters’ 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.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`.