Hi guys!
I tried to install evo 1.0.5 on my MAMP but at the end I always get the same screen with errors (I tried to create a DB before the installation, different UTF combinations, modx installed a new DB, PHP 5.2.17 / 5.3.5 etc)
my config:
MAMP PRO Version: 1.9.5
PHP Version 5.3.5
System Darwin iMac-27.local 10.6.0 Darwin Kernel Version 10.6.0: Wed Nov 10 18:13:17 PST 2010; root:xnu-1504.9.26~3/RELEASE_I386 i386
mysql
Client API version 5.5.9
pdo_mysql installed
cache disabled
Help! MODx Evolution 1.0.5 (Jan 19, 2011)
MODx CMS
Install results
Setup will now attempt to setup the database:
Creating connection to the database: OK!
Selecting 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
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`
... ....
Some tables were not updated. This might be due to previous modifications.
***
and replacing Type/Engine as suggested here (
http://modxcms.com/forums/index.php/topic,60964.msg346545.html#msg346545 ) doesn’t work
Thank you!
Install results
Setup will now attempt to setup the database:
Creating connection to the database: OK!
Selecting 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
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=’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’.
...
☆ A M B ☆
