Ok.
Php info :
http://php4info.celeonet.fr/
Système d’exploitation : Linux 2.4.20-28.9
Version d’Apache : 2.0.54 (Unix)
Version de MySQL : 4.1.14
Version de PHP : 4.4.0 / 5.0.4 ( j’ai essayé les deux)
J’installe modx comme à l’accoutumée avec ou sans les deux modifs proposées (j’ai essayé avec et sans), à savoir sqlParser.class.php ET setup.sql, ma base (neuve et re-créée à chaque fois) est prête à recevoir les tables créées par modx et, alors que tout est vert, que la connexion avec la base est validée et que tout est prêt pour la phase finale de l’installation, j’obtiens ça :
Setup will now attempt to setup the database:
Creating connection to the database: OK!
Selecting database `blabla`: OK!
Checking table prefix `sublimo_`: 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 `sublimo_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 `sublimo_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 du champ ’introtext’ déjà utilisé during the execution of SQL statement ALTER TABLE `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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`.
--------------------------------------------------------------------------------
Nom du champ ’groupname’ déjà utilisé during the execution of SQL statement ALTER TABLE `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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 `sublimo_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`.
--------------------------------------------------------------------------------
Some tables were not updated. This might be due to previous modifications.
Au passage, j’ai deja installé trois ou quatre MODx sans problème, y compris cette version, mais sur une autre host - infomaniak.ch)
(all fixed now)