Install Errors

Trying to duplicate a site that is currently on Evo 1.0.4. This is the error I get when I run the install. There were a lot more errors but it looks like a global issue.

MySQL: 5.5.33a-MariaDB-log
PHP: 5.2.17

(Was told by my host to "Try setting your int to 11" but I don't know what that means.)

Install results

Setup will now attempt to setup the database:

Creating connection to the database: OK!

Selecting database `..name..`: 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 MariaDB 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.'. [ed. note: susprod last edited this post 10 years, 6 months ago.]

Newer version of MySQL, and thus I would presume also MariaDB, no longer use TYPE=..., it has to be ENGINE=...
http://bugs.cacti.net/view.php?id=2342