[vscweb-devel] Failed DB creation

[Chris M. <chris.mielke@DRAKE.EDU>]

I am running into a problem while going through the VSC 2.0 installation process. When I point my web browser to the Install/install.php script everything checks out "ok" on the initial page. However, when I click next and the database tries to load I receive a long list of errors similar to this: 

Loading new table: Host
You have an error in your SQL syntax near 'ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 15
error stmt: CREATE TABLE `Host` (
  `hostid` int(11) NOT NULL auto_increment,
  `dns_name` varchar(255) default NULL,
  `address` varchar(15) NOT NULL default '',
  `mac_address` varchar(50) default NULL,
  `location` tinytext,
  `serialnumber` varchar(50) default NULL,
  `otherid` varchar(50) default NULL,
  `hourly_cost` double default NULL,
  `family_id` int(11) default NULL,
  `smbname` varchar(50) default NULL,
  PRIMARY KEY  (`hostid`),
  UNIQUE KEY `address` (`address`),
  KEY `dns_name` (`dns_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

The error is displayed when attempting to create all of the tables.

The server I am using for the install is running RedHat Enterprise Linux 3.0 and MySQL 3.23, which was installed from rpms. Innodb is configured and set as the "default-table-type" in the my.cnf file.

Any idea what I might have missed?

Thanks,
Chris