Issue Install Modx Evolution on Localhost

Hi,
I am trying to install Modx Evolution 1.0.5 for the first time on my computer for learning purposes, and am having some problems doing so. I am mostly a designer, however do have some experience with development. Any help would be greatly appreciated...

Some details about my setup:
* OSX Lion (all latest updates)
* MAMP (including all latest updates)
* VirtualHostX (which allows me to use urls such as dev.modx.dev instead of localhost/)
I have tested in both Chrome and Firefox, with no differences in results.
Note that I tried both installing the sample site and not, with no differences either. I was able to install directly to a real web domain (however I prefer a localhost domain at the moment). Note I was able to also install Revolution without any concerns. I also followed the tutorial here http://rtfm.modx.com/display/Evo1/Basic+Installation, including enabling read-write access for appropriate folders and files.

During the installation process the default database connection method of SET CHARACTER SET and Collation of utf8_general_ci prompts the following error: "failed - database collation mismatch; use SET NAMES or choose latin1_swedish_ci". So when I switch to SET NAMES and use the same collation, I manage to progress right through to pre-install validation (no errors or warnings are listed on this screen). However on the Install Results page I receive the following errors:

Creating database tables: Database Alerts! MODx setup couldn't install/alter some tables inside the selected database. The following errors had occurred during installation You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains data about active users.'' at line 9 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evoactive_users` ( `internalKey` int(9) NOT NULL default '0', `username` varchar(50) NOT NULL default '', `lasthit` int(20) NOT NULL default '0', `id` int(10) default NULL, `action` varchar(10) NOT NULL default '', `ip` varchar(20) NOT NULL default '', PRIMARY KEY (`internalKey`) ) TYPE=MyISAM COMMENT='Contains data about active users.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=MyISAM COMMENT='Categories to be used snippets,tv,chunks, etc'' at line 5 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evocategories` ( `id` integer NOT NULL AUTO_INCREMENT, `category` varchar(45) NOT NULL DEFAULT '', PRIMARY KEY(`id`) ) Type=MyISAM COMMENT='Categories to be used snippets,tv,chunks, etc'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains data used for access permissions.'' at line 8 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evodocument_groups` ( `id` int(10) NOT NULL auto_increment, `document_group` int(10) NOT NULL default '0', `document` int(10) NOT NULL default '0', PRIMARY KEY (`id`), KEY `document` (document), KEY `document_group` (document_group) ) TYPE=MyISAM COMMENT='Contains data used for access permissions.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains data used for access permissions.'' at line 8 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evodocumentgroup_names` ( `id` int(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `private_memgroup` tinyint DEFAULT 0 COMMENT 'determine whether the document group is private to manager users', `private_webgroup` tinyint DEFAULT 0 COMMENT 'determines whether the document is private to web users', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) TYPE=MyISAM COMMENT='Contains data used for access permissions.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MYISAM COMMENT='Stores event and error logs'' at line 12 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evoevent_log` ( `id` integer NOT NULL AUTO_INCREMENT, `eventid` integer DEFAULT 0, `createdon` integer NOT NULL DEFAULT 0, `type` tinyint NOT NULL DEFAULT 1 COMMENT '1- information, 2 - warning, 3- error', `user` integer NOT NULL DEFAULT 0 COMMENT 'link to user table', `usertype` tinyint NOT NULL DEFAULT 0 COMMENT '0 - manager, 1 - web', `source` varchar(50) NOT NULL DEFAULT '', `description` text, PRIMARY KEY(`id`), KEY `user`(`user`) ) TYPE=MYISAM COMMENT='Stores event and error logs'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Cross reference bewteen keywords and content'' at line 6 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evokeyword_xref` ( `content_id` int(11) NOT NULL default '0', `keyword_id` int(11) NOT NULL default '0', KEY `content_id` (`content_id`), KEY `keyword_id` (`keyword_id`) ) TYPE=MyISAM COMMENT='Cross reference bewteen keywords and content'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains a record of user interaction.'' at line 11 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evomanager_log` ( `id` int(10) NOT NULL auto_increment, `timestamp` int(20) NOT NULL default '0', `internalKey` int(10) NOT NULL default '0', `username` varchar(255) default NULL, `action` int(10) NOT NULL default '0', `itemid` varchar(10) default '0', `itemname` varchar(255) default NULL, `message` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Contains a record of user interaction.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains login information for backend users.'' at line 7 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evomanager_users` ( `id` int(10) NOT NULL auto_increment, `username` varchar(100) NOT NULL default '', `password` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) TYPE=MyISAM COMMENT='Contains login information for backend users.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains data used for access permissions.'' at line 7 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evomember_groups` ( `id` int(10) NOT NULL auto_increment, `user_group` int(10) NOT NULL default '0', `member` int(10) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE INDEX `ix_group_member` (`user_group`,`member`) ) TYPE=MyISAM COMMENT='Contains data used for access permissions.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains data used for access permissions.'' at line 6 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evomembergroup_access` ( `id` int(10) NOT NULL auto_increment, `membergroup` int(10) NOT NULL default '0', `documentgroup` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Contains data used for access permissions.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains data used for access permissions.'' at line 6 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evomembergroup_names` ( `id` int(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) TYPE=MyISAM COMMENT='Contains data used for access permissions.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains the site document tree.'' at line 44 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_content` ( `id` int(10) NOT NULL auto_increment, `type` varchar(20) NOT NULL default 'document', `contentType` varchar(50) NOT NULL default 'text/html', `pagetitle` varchar(255) NOT NULL default '', `longtitle` varchar(255) NOT NULL default '', `description` varchar(255) NOT NULL default '', `alias` varchar(255) default '', `link_attributes` varchar(255) NOT NULL default '', `published` int(1) NOT NULL default '0', `pub_date` int(20) NOT NULL default '0', `unpub_date` int(20) NOT NULL default '0', `parent` int(10) NOT NULL default '0', `isfolder` int(1) NOT NULL default '0', `introtext` text COMMENT 'Used to provide quick summary of the document', `content` mediumtext, `richtext` tinyint(1) NOT NULL default '1', `template` int(10) NOT NULL default '1', `menuindex` int(10) NOT NULL default '0', `searchable` int(1) NOT NULL default '1', `cacheable` int(1) NOT NULL default '1', `createdby` int(10) NOT NULL default '0', `createdon` int(20) NOT NULL default '0', `editedby` int(10) NOT NULL default '0', `editedon` int(20) NOT NULL default '0', `deleted` int(1) NOT NULL default '0', `deletedon` int(20) NOT NULL default '0', `deletedby` int(10) NOT NULL default '0', `publishedon` int(20) NOT NULL default '0', `publishedby` int(10) NOT NULL default '0', `menutitle` varchar(255) NOT NULL DEFAULT '' COMMENT 'Menu title', `donthit` tinyint(1) NOT NULL default '0' COMMENT 'Disable page hit count', `haskeywords` tinyint(1) NOT NULL default '0' COMMENT 'has links to keywords', `hasmetatags` tinyint(1) NOT NULL default '0' COMMENT 'has links to meta tags', `privateweb` tinyint(1) NOT NULL default '0' COMMENT 'Private web document', `privatemgr` tinyint(1) NOT NULL default '0' COMMENT 'Private manager document', `content_dispo` tinyint(1) NOT NULL default '0' COMMENT '0-inline, 1-attachment', `hidemenu` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Hide document from menu', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `parent` (`parent`), KEY aliasidx (alias), FULLTEXT KEY `content_ft_idx` (`pagetitle`,`description`,`content`) ) TYPE=MyISAM COMMENT='Contains the site document tree.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Reference table between meta tags and content'' at line 6 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_content_metatags` ( `content_id` int(11) NOT NULL default '0', `metatag_id` int(11) NOT NULL default '0', KEY `content_id` (`content_id`), KEY `metatag_id` (`metatag_id`) ) TYPE=MyISAM COMMENT='Reference table between meta tags and content'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains the site chunks.'' at line 11 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_htmlsnippets` ( `id` int(10) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `description` varchar(255) NOT NULL default 'Chunk', `editor_type` integer NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor', `category` integer NOT NULL DEFAULT '0' COMMENT 'category id', `cache_type` tinyint(1) NOT NULL default '0' COMMENT 'Cache option', `snippet` mediumtext, `locked` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Contains the site chunks.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Site keyword list'' at line 6 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_keywords` ( `id` int(11) NOT NULL auto_increment, `keyword` varchar(40) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `keyword` (`keyword`) ) TYPE=MyISAM COMMENT='Site keyword list'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MYISAM COMMENT='Site meta tags'' at line 8 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_metatags` ( `id` integer NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '', `tag` varchar(50) NOT NULL DEFAULT '' COMMENT 'tag name', `tagvalue` varchar(255) NOT NULL DEFAULT '', `http_equiv` tinyint NOT NULL DEFAULT 0 COMMENT '1 - use http_equiv tag style, 0 - use name', PRIMARY KEY(`id`) ) TYPE=MYISAM COMMENT='Site meta tags'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Site Modules'' at line 20 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_modules` ( `id` integer NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '0', `editor_type` integer NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor', `disabled` tinyint NOT NULL DEFAULT '0', `category` integer NOT NULL DEFAULT '0' COMMENT 'category id', `wrap` tinyint NOT NULL DEFAULT '0', `locked` tinyint NOT NULL default '0', `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'url to module icon', `enable_resource` tinyint NOT NULL DEFAULT '0' COMMENT 'enables the resource file feature', `resourcefile` varchar(255) NOT NULL DEFAULT '' COMMENT 'a physical link to a resource file', `createdon` integer NOT NULL DEFAULT '0', `editedon` integer NOT NULL DEFAULT '0', `guid` varchar(32) NOT NULL DEFAULT '' COMMENT 'globally unique identifier', `enable_sharedparams` tinyint NOT NULL DEFAULT '0', `properties` text, `modulecode` mediumtext COMMENT 'module boot up code', PRIMARY KEY(`id`) ) TYPE=MyISAM COMMENT='Site Modules'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MYISAM COMMENT='Module Dependencies'' at line 7 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_module_depobj` ( `id` integer NOT NULL AUTO_INCREMENT, `module` integer NOT NULL DEFAULT 0, `resource` integer NOT NULL DEFAULT 0, `type` integer(2) NOT NULL DEFAULT 0 COMMENT '10-chunks, 20-docs, 30-plugins, 40-snips, 50-tpls, 60-tvs', PRIMARY KEY(`id`) ) TYPE=MYISAM COMMENT='Module Dependencies'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MYISAM COMMENT='Module users group access permission'' at line 6 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_module_access` ( `id` integer UNSIGNED NOT NULL AUTO_INCREMENT, `module` integer NOT NULL DEFAULT 0, `usergroup` integer NOT NULL DEFAULT 0, PRIMARY KEY(`id`) ) TYPE=MYISAM COMMENT='Module users group access permission'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains the site plugins.'' at line 14 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_plugins` ( `id` int(10) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `description` varchar(255) NOT NULL default 'Plugin', `editor_type` integer NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor', `category` integer NOT NULL DEFAULT '0' COMMENT 'category id', `cache_type` tinyint(1) NOT NULL default '0' COMMENT 'Cache option', `plugincode` mediumtext, `locked` tinyint(4) NOT NULL default '0', `properties` text COMMENT 'Default Properties', `disabled` tinyint NOT NULL DEFAULT '0' COMMENT 'Disables the plugin', `moduleguid` varchar(32) NOT NULL default '' COMMENT 'GUID of module from which to import shared parameters', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Contains the site plugins.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Links to system events'' at line 5 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_plugin_events` ( `pluginid` INT(10) NOT NULL, `evtid` INT(10) NOT NULL default 0, `priority` INT(10) NOT NULL default 0 COMMENT 'determines plugin run order' ) TYPE=MyISAM COMMENT='Links to system events'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains the site snippets.'' at line 13 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_snippets` ( `id` int(10) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `description` varchar(255) NOT NULL default 'Snippet', `editor_type` integer NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor', `category` integer NOT NULL DEFAULT '0' COMMENT 'category id', `cache_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Cache option', `snippet` mediumtext, `locked` tinyint(4) NOT NULL default '0', `properties` text COMMENT 'Default Properties', `moduleguid` varchar(32) NOT NULL default '' COMMENT 'GUID of module from which to import shared parameters', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Contains the site snippets.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains the site templates.'' at line 12 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_templates` ( `id` int(10) NOT NULL auto_increment, `templatename` varchar(50) NOT NULL default '', `description` varchar(255) NOT NULL default 'Template', `editor_type` integer NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor', `category` integer NOT NULL DEFAULT '0' COMMENT 'category id', `icon` varchar(255) NOT NULL default '' COMMENT 'url to icon file', `template_type` integer NOT NULL DEFAULT '0' COMMENT '0-page,1-content', `content` mediumtext, `locked` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Contains the site templates.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MYISAM COMMENT='System Event Names.'' at line 7 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosystem_eventnames` ( `id` INT(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL default '', `service` tinyint NOT NULL default '0' COMMENT 'System Service number', `groupname` varchar(20) NOT NULL default '', PRIMARY KEY(`id`) ) TYPE=MYISAM COMMENT='System Event Names.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains Content Manager settings.'' at line 5 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosystem_settings` ( `setting_name` varchar(50) NOT NULL default '', `setting_value` text, UNIQUE KEY `setting_name` (`setting_name`) ) TYPE=MyISAM COMMENT='Contains Content Manager settings.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=MyISAM COMMENT='Contains data used for template variable access permissions' at line 6 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_tmplvar_access` ( `id` int(10) NOT NULL auto_increment, `tmplvarid` int(10) NOT NULL default '0', `documentgroup` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) Type=MyISAM COMMENT='Contains data used for template variable access permissions.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Site Template Variables Content Values Link Table'' at line 9 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_tmplvar_contentvalues` ( `id` int(11) NOT NULL auto_increment, `tmplvarid` int(10) NOT NULL default '0' COMMENT 'Template Variable id', `contentid` int(10) NOT NULL default '0' COMMENT 'Site Content Id', `value` text, PRIMARY KEY (id), KEY idx_tmplvarid (tmplvarid), KEY idx_id (contentid) ) TYPE=MyISAM COMMENT='Site Template Variables Content Values Link Table'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Site Template Variables Templates Link Table'' at line 6 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_tmplvar_templates` ( `tmplvarid` int(10) NOT NULL default '0' COMMENT 'Template Variable id', `templateid` int(11) NOT NULL default '0', `rank` int(11) NOT NULL default '0', PRIMARY KEY (`tmplvarid`, `templateid`) ) TYPE=MyISAM COMMENT='Site Template Variables Templates Link Table'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Site Template Variables'' at line 17 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evosite_tmplvars` ( `id` INT(11) NOT NULL auto_increment, `type` varchar(20) NOT NULL default '', `name` varchar(50) NOT NULL default '', `caption` varchar(80) NOT NULL default '', `description` varchar(255) NOT NULL default '', `editor_type` integer NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor', `category` integer NOT NULL DEFAULT '0' COMMENT 'category id', `locked` tinyint(4) NOT NULL default '0', `elements` text, `rank` int(11) NOT NULL default '0', `display` varchar(20) NOT NULL default '' COMMENT 'Display Control', `display_params` text COMMENT 'Display Control Properties', `default_text` text, PRIMARY KEY (id), KEY `indx_rank`(`rank`) ) TYPE=MyISAM COMMENT='Site Template Variables'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains information about the backend users.'' at line 27 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evouser_attributes` ( `id` int(10) NOT NULL auto_increment, `internalKey` int(10) NOT NULL default '0', `fullname` varchar(100) NOT NULL default '', `role` int(10) NOT NULL default '0', `email` varchar(100) NOT NULL default '', `phone` varchar(100) NOT NULL default '', `mobilephone` varchar(100) NOT NULL default '', `blocked` int(1) NOT NULL default '0', `blockeduntil` int(11) NOT NULL default '0', `blockedafter` int(11) NOT NULL default '0', `logincount` int(11) NOT NULL default '0', `lastlogin` int(11) NOT NULL default '0', `thislogin` int(11) NOT NULL default '0', `failedlogincount` int(10) NOT NULL default '0', `sessionid` varchar(100) NOT NULL default '', `dob` int(10) NOT NULL DEFAULT '0', `gender` int(1) NOT NULL DEFAULT '0' COMMENT '0 - unknown, 1 - Male 2 - female', `country` varchar(5) NOT NULL default '', `state` varchar(25) NOT NULL default '', `zip` varchar(25) NOT NULL default '', `fax` varchar(100) NOT NULL default '', `photo` varchar(255) NOT NULL default '' COMMENT 'link to photo', `comment` varchar(255) NOT NULL default '' COMMENT 'short comment', PRIMARY KEY (`id`), KEY `userid` (`internalKey`) ) TYPE=MyISAM COMMENT='Contains information about the backend users.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains messages for the Content Manager messaging system.' at line 12 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evouser_messages` ( `id` int(10) NOT NULL auto_increment, `type` varchar(15) NOT NULL default '', `subject` varchar(60) NOT NULL default '', `message` text, `sender` int(10) NOT NULL default '0', `recipient` int(10) NOT NULL default '0', `private` tinyint(4) NOT NULL default '0', `postdate` int(20) NOT NULL default '0', `messageread` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Contains messages for the Content Manager messaging system.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Contains information describing the user roles.'' at line 74 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evouser_roles` ( `id` int(10) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `description` varchar(255) NOT NULL default '', `frames` int(1) NOT NULL default '0', `home` int(1) NOT NULL default '0', `view_document` int(1) NOT NULL default '0', `new_document` int(1) NOT NULL default '0', `save_document` int(1) NOT NULL default '0', `publish_document` int(1) NOT NULL default '0', `delete_document` int(1) NOT NULL default '0', `empty_trash` int(1) NOT NULL default '0', `action_ok` int(1) NOT NULL default '0', `logout` int(1) NOT NULL default '0', `help` int(1) NOT NULL default '0', `messages` int(1) NOT NULL default '0', `new_user` int(1) NOT NULL default '0', `edit_user` int(1) NOT NULL default '0', `logs` int(1) NOT NULL default '0', `edit_parser` int(1) NOT NULL default '0', `save_parser` int(1) NOT NULL default '0', `edit_template` int(1) NOT NULL default '0', `settings` int(1) NOT NULL default '0', `credits` int(1) NOT NULL default '0', `new_template` int(1) NOT NULL default '0', `save_template` int(1) NOT NULL default '0', `delete_template` int(1) NOT NULL default '0', `edit_snippet` int(1) NOT NULL default '0', `new_snippet` int(1) NOT NULL default '0', `save_snippet` int(1) NOT NULL default '0', `delete_snippet` int(1) NOT NULL default '0', `edit_chunk` int(1) NOT NULL default '0', `new_chunk` int(1) NOT NULL default '0', `save_chunk` int(1) NOT NULL default '0', `delete_chunk` int(1) NOT NULL default '0', `empty_cache` int(1) NOT NULL default '0', `edit_document` int(1) NOT NULL default '0', `change_password` int(1) NOT NULL default '0', `error_dialog` int(1) NOT NULL default '0', `about` int(1) NOT NULL default '0', `file_manager` int(1) NOT NULL default '0', `save_user` int(1) NOT NULL default '0', `delete_user` int(1) NOT NULL default '0', `save_password` int(11) NOT NULL default '0', `edit_role` int(1) NOT NULL default '0', `save_role` int(1) NOT NULL default '0', `delete_role` int(1) NOT NULL default '0', `new_role` int(1) NOT NULL default '0', `access_permissions` int(1) NOT NULL default '0', `bk_manager` int(1) NOT NULL DEFAULT 0, `new_plugin` int(1) NOT NULL DEFAULT 0, `edit_plugin` int(1) NOT NULL DEFAULT 0, `save_plugin` int(1) NOT NULL DEFAULT 0, `delete_plugin` int(1) NOT NULL DEFAULT 0, `new_module` int(1) NOT NULL DEFAULT 0, `edit_module` int(1) NOT NULL DEFAULT 0, `save_module` int(1) NOT NULL DEFAULT 0, `delete_module` int(1) NOT NULL DEFAULT 0, `exec_module` int(1) NOT NULL DEFAULT 0, `view_eventlog` int(1) NOT NULL DEFAULT 0, `delete_eventlog` int(1) NOT NULL DEFAULT 0, `manage_metatags` int(1) NOT NULL DEFAULT 0 COMMENT 'manage site meta tags and keywords', `edit_doc_metatags` int(1) NOT NULL DEFAULT 0 COMMENT 'edit document meta tags and keywords' , `new_web_user` int(1) NOT NULL default '0', `edit_web_user` int(1) NOT NULL default '0', `save_web_user` int(1) NOT NULL default '0', `delete_web_user` int(1) NOT NULL default '0', `web_access_permissions` int(1) NOT NULL default '0', `view_unpublished` int(1) NOT NULL default '0', `import_static` int(1) NOT NULL default '0', `export_static` int(1) NOT NULL default '0', `remove_locks` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Contains information describing the user roles.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=MyISAM COMMENT='Contains backend user settings.'' at line 7 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evouser_settings` ( `user` integer NOT NULL, `setting_name` varchar(50) NOT NULL default '', `setting_value` text, KEY `setting_name` (`setting_name`), KEY `user` (`user`) ) Type=MyISAM COMMENT='Contains backend user settings.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=MyISAM COMMENT='Contains data used for web access permissions.'' at line 7 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evoweb_groups` ( `id` int(10) NOT NULL auto_increment, `webgroup` int(10) NOT NULL default '0', `webuser` int(10) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE INDEX `ix_group_user` (`webgroup`,`webuser`) ) Type=MyISAM COMMENT='Contains data used for web access permissions.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=MyISAM COMMENT='Contains data used for web access permissions.'' at line 6 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_evowebgroup_access` ( `id` int(10) NOT NULL auto_increment, `webgroup` int(10) NOT NULL default '0', `documentgroup` int(10) NOT NULL default '0', PRIMARY KEY (`id`) ) Type=MyISAM COMMENT='Contains data used for web access permissions.'. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=MyISAM COMMENT='Contains data used for web access permissions.'' at line 6 during the execution of SQL statement CREATE TABLE

Looks like all those tables are present, have you checked your tables in the database to see if they are present, and if so you then you should be fine. One other note, your database prefix might help to add and underscore at the end so your table names are easier to read, not required though. Currently you have it set as "modx_evo" which results in table names like "modx_evoactive_users" vs. "modx_evo_active_users".

Also make sure that the database user information your using has the appropriate permissions to create and alter tables in the database.

You'll need to modify a couple of the installation files.

/install/setup.sql
/install/setup.data.sql

do a search/replace:


That should get it straightened out

Thanks for the tip breezer, but unfortunately it didn't work I'm still getting the same errors as earlier

Just a thought: You probably know this, but any time you make changes to the schema, you have to re-run parseSchema() to update the class and map files. The schema itself is ignored at runtime.

Maybe there were some tables already created during the first try, go and delete all the tables from the database and run the install again.

@bob: that might work if this was a revo install but not so much for evolution

Thanks for the suggestions. I had already considered partial table installation prior to installation-death, and had already checked that. No tables had been created, so it seems to be that its failing to create any tables at all...

Quote from: breezer at Dec 19, 2011, 11:47 PM

@bob: that might work if this was a revo install but not so much for evolution

And it's in the subject line. Doh!

Did you verify that the permission for the user will allow them to create/alter tables? and that the database your trying to install to has be created?

I'm using the default "root" user for the local development, and never had any issues with the other 10 CMS installs (Wordpress, Drupal, etc). I did check the permissions for that user and its good. The database itself does exist. I also tried deleting and recreating a database with a different name, and then installing to that, but no luck there either.

Since I was able to install online quite fine, there is obviously some "problem" with my local machine, but I have absolutely no clue.