Hi,
I am installing Modx Evolution on MAMP. I have already installed MAMP and created a database. When I attempt to install Modx, I get the following incredibly long message. This isn’t the entire message; it was over 30,000 characters--exceeded the posting limit. I did attache the entire error message in case it is important to see the entire thing,
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_active_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_categories` ( `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_document_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_documentgroup_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_event_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_keyword_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_manager_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_manager_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_member_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_membergroup_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_membergroup_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_site_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_site_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_site_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_site_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_site_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_site_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_site_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_site_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_site_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_site_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_site_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_site_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.’.
YIKES! I have no clue what any of this is. I am a total newbie to Modx and localhost servers. Please be very elementary with your instructions on how to fix this!
Thanks in advance!
