17
I was also interested in this module but received the same errors. Turned on debugging (Admin/Preferences/General/Debug) for MySQL during installation and ... whaddayaknow ...
There are two things to change in the '/filmmakers/sql/mysql.sql' file:
In the CREATE TABLE `fm_jobs` and CREATE TABLE `fm_genres' remove the comma at the end of the UNIQUE KEY line, just before TYPE=MyISAM. For fm_jobs (i.e.) change this :
CREATE TABLE `fm_jobs` (
`jobID` int(4) NOT NULL,
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`jobID`),
UNIQUE KEY jobID (`jobID`),
) TYPE=MyISAM;
Into this :
CREATE TABLE `fm_jobs` (
`jobID` int(4) NOT NULL,
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`jobID`),
UNIQUE KEY jobID (`jobID`)
) TYPE=MyISAM;
I was able to install but haven't played with it much ....