Les messages que tu indique montrent bien un problème avec ta base de données.
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
.
Bonne nouvelle ! Je crois avoir trouvé un moyen de régler le pbm. Pour ceux qui seraient amenés à l'affronter, voici la solution qui semble avoir marcher de mon côté :
J'ai supprimé à la main (enfin, avec un éditeur de texte tout de même) un bout de code du fichier "/install/setup.sql"
Pour être plus précis, voici ce que j'ai supprimmé :
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` )
Le mauvais technicien autodidacte que je suis s'aventure à une interprétation : ces lignes de code servent à compléter les tables crées par des versions antérieures de Modx. En temps normal, un serveur MySQL se contente d'ignorer ces requêtes s'il constate que tous les ajouts sont déjà présents. Peut-être que le serveur de mon site est configuré pour réagir différemment : il émet des messages d'erreur alertant que les requêtes ne sont pas possibles. Ces messages d'erreur auraient empéché l'installation de se poursuivrte correctement ?
Bon, j'ai bon ou j'ai tout faux
Quoi qu'il en soit, merci à chacun pour sa participation, ça fait plaisir !
A+
Topic: Erreurs MySQL lors de l'installation chez Sivit (mutualisé). (Read 4462 times)
