Re: [vscweb-devel] Failed DB creation

[Matthew W. <wi...@pu...>]

Chris, 
 
 I think if you remove 'DEFAULT CHARSET=latin1' from those table creation
 statements, you won't see the problem.  I use both MySQL 4.0 and MySQL 4.1
 for our dev and production instances here at Purdue, and I believe I even
 had to remove those properties for MySQL 4.0.x.  

 Hope this helps.

Cheers, 
-matt

On Fri, Sep 30, 2005 at 11:08:18AM -0500, Chris Mielke wrote:
> 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
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> vscweb-devel mailing list
> vsc...@li...
> https://lists.sourceforge.net/lists/listinfo/vscweb-devel

-- 
Matthew Wirges
IT Security and Privacy, Purdue University
PGP/GPG: EB69 701E EECC 5DD0 E604  0EE0 1346 74BF 5DBC 5ADB  
Report computer related abuse to ab...@pu...