Using mysql 3.23, the db_geberate script gives syntax errors on each database definition. The errors are
ERROR 1064: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1
Fix is to replace ") ENGINE=MyISAM DEFAULT CHARSET=latin1;" with ") TYPE=MyISAM;".
gtomlin
2005-04-18 11:10
reporter ~0009834
I get a similar error with MySQL 4.0.20a-nt. For me it was not necessary to change "ENGINE=MyISAM" to "TYPE=MyISAM", but it was necessary to get rid of "DEFAULT CHARSET=latin1".
thraxisp
2005-04-19 07:33
reporter ~0009838
Fixed in CVS
sql/db_generate.sql -> 1.26
