install won't create database tables

MODx setup couldn't install/alter some tables inside the selected database.

The following errors had occured during installation

Dubbele kolom naam '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`.
Dubbele kolom naam '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`.Dubbele zoeksleutel naam 'indx_rank' during the execution of SQL statement ALTER TABLE `modx_site_tmplvars` ADD INDEX `indx_rank`(`rank`).Dubbele zoeksleutel naam 'aliasidx' during the execution of SQL statement ALTER TABLE `modx_site_content` ADD INDEX aliasidx (alias).Dubbele kolom naam '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`.Dubbele kolom naam '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`.Dubbele kolom naam '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`.Dubbele kolom naam '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`.Dubbele kolom naam '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`.Dubbele kolom naam 'disabled' during the execution of SQL statement ALTER TABLE `modx_site_plugins` ADD COLUMN `disabled` TINYINT NOT NULL COMMENT 'Disables the plugin' AFTER `properties`.Dubbele kolom naam '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`.Dubbele kolom naam '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`.Dubbele kolom naam '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`.Dubbele kolom naam 'properties' during the execution of SQL statement ALTER TABLE `modx_site_snippets` ADD COLUMN `properties` VARCHAR(255) NOT NULL COMMENT 'Default Properties' AFTER `locked`.Dubbele kolom naam '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`.Dubbele kolom naam '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`.Kan 'indx_doc_groups' niet weggooien. Controleer of het veld of de zoeksleutel daadwerkelijk bestaat. during the execution of SQL statement ALTER TABLE `modx_document_groups` DROP INDEX `indx_doc_groups`.Dubbele zoeksleutel naam 'document' during the execution of SQL statement ALTER TABLE `modx_document_groups` ADD INDEX `document`(`document`).Dubbele zoeksleutel naam 'document_group' during the execution of SQL statement ALTER TABLE `modx_document_groups` ADD INDEX `document_group` (document_group).Dubbele kolom naam 'groupname' during the execution of SQL statement ALTER TABLE `modx_system_eventnames` ADD COLUMN `groupname` VARCHAR(20) NOT NULL AFTER `service`.Dubbele kolom naam '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`.Dubbele kolom naam '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`.Dubbele kolom naam '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.Dubbele kolom naam '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.Dubbele kolom naam '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`.Dubbele kolom naam '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`.

Some table were not updated. This might be due to previous modifications.

# This file provides security to the server limiting acces to the localhost only

Order Deny,Allow
Deny from all
Allow from 127.0.0.1

# To allow execution of cgi scripts in this directory uncomment next two lines
#AddHandler cgi-script .bat .exe .pl .cgi
#Options +ExecCGI

#AuthName "test"
#AuthType basic
#AuthUserFile /www/.htpasswd
#require valid-user