installation problem

hy all
try to install MODX in local,the tables are created succesfully but don’t finish the procedure because give me a mysql error
MODx setup couldn’t install/alter some tables inside the selected database.
i’ve installed easyphp 1,8 and run apache server
anyone can help me to solve?

Can you post the specific SQL errors you are seeing?

Sure

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

Nome colonna duplicato ’cachepwd’ 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`.


--------------------------------------------------------------------------------
Nome colonna duplicato ’editor_type’ 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`.
--------------------------------------------------------------------------------
Nome chiave duplicato ’indx_rank’ during the execution of SQL statement ALTER TABLE `modx_site_tmplvars` ADD INDEX `indx_rank`(`rank`).
--------------------------------------------------------------------------------
Nome chiave duplicato ’aliasidx’ during the execution of SQL statement ALTER TABLE `modx_site_content` ADD INDEX aliasidx (alias).
--------------------------------------------------------------------------------
Nome colonna duplicato ’introtext’ 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`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’menutitle’ 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`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’content_dispo’ 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`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’hidemenu’ 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`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’editor_type’ 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`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’disabled’ during the execution of SQL statement ALTER TABLE `modx_site_plugins` ADD COLUMN `disabled` TINYINT NOT NULL COMMENT ’Disables the plugin’ AFTER `properties`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’moduleguid’ 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`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’editor_type’ 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`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’editor_type’ 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`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’properties’ during the execution of SQL statement ALTER TABLE `modx_site_snippets` ADD COLUMN `properties` VARCHAR(255) NOT NULL COMMENT ’Default Properties’ AFTER `locked`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’moduleguid’ 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`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’editor_type’ 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`.
--------------------------------------------------------------------------------
Impossibile cancellare ’indx_doc_groups’. Controllare che il campo chiave esista during the execution of SQL statement ALTER TABLE `modx_document_groups` DROP INDEX `indx_doc_groups`.
--------------------------------------------------------------------------------
Nome chiave duplicato ’document’ during the execution of SQL statement ALTER TABLE `modx_document_groups` ADD INDEX `document`(`document`).
--------------------------------------------------------------------------------
Nome chiave duplicato ’document_group’ during the execution of SQL statement ALTER TABLE `modx_document_groups` ADD INDEX `document_group` (document_group).
--------------------------------------------------------------------------------
Nome colonna duplicato ’groupname’ during the execution of SQL statement ALTER TABLE `modx_system_eventnames` ADD COLUMN `groupname` VARCHAR(20) NOT NULL AFTER `service`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’private_memgroup’ 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`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’bk_manager’ during the execution of SQL statement ALTER TABLE `modx_user_roles` ADD COLUMN `bk_manager` int(1) NOT NULL DEFAULT 0 AFTER `access_permissions`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’new_plugin’ 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.
--------------------------------------------------------------------------------
Nome colonna duplicato ’new_module’ 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.
--------------------------------------------------------------------------------
Nome colonna duplicato ’blockedafter’ 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`.
--------------------------------------------------------------------------------
Nome colonna duplicato ’blockedafter’ 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`.

lonely, are you testing MODx locally ?
If so, what is the package you’re using ?

I had the same error with the EasyPHP 1.8 WAMP package (running PHP Version 4.3.10, MySQL 4.1.9, Apache/1.3.33), but it worked flawlessly with XAMPP 1.4.16 (running Apache HTTPD 2.0.54, MySQL 4.1.14, PHP 5.0.5 + 4.4.0).

If not, what are your PHP, Apache and MySQL version ? The source of the problem is not clearly identified, but my guess is MySQL and/or Apache and/or PHP version which is not compatible with 0.9.x.

I submitted a bug about it :
http://modxcms.com/bugs/?do=details&id=81.

You might also want to check : [x9] Known Issues and Resolution

Works perfect if uploaded to a server!
It’s a problem of windows xp?
but i want to test this cms in local!
the error is relative to the update command of the mysql query,don’t able to "alter table".

Think we crossposted

You got the answer, try XAMPP from apachefriends : it works for me local on WinXP SP1.

It would be nice if you told us what is your local setup (package, Apache-MySQL-PHP version) so that we can identify what is not working and why...

THANKS
xampp is really cool!
easyphp is gone!
with xampp all works perfect!
Sorry 4 my english,i’m italian
:)

No problem

So you used EasyPHP, there is the explanation. Good, we can document that now...

That said, EasyPHP is cool to, and with most CMS it works fine (plus it runs on a USB stick...). But MODx needs XAMPP, so be it !

Approved. I run on the same problem. WinXP Sp2, Easyphp 1.8

Does anyone know folks from the Easyphp team that could see if they could help us figure out what is causing the failures?