Is there a snippet to load the SQL and create the tables manually? I'm gettting hammered with errors when enabling the module and it can't create the database:

# user warning: You have an error in your SQL syntax near '; ' at line 16 query: CREATE TABLE audio ( `vid` int(10) unsigned NOT NULL default '0', `nid` int(10) unsigned NOT NULL default '0', `title_format` varchar(128) default '', `play_count` int(10) unsigned NOT NULL default '0', `download_count` int(10) unsigned NOT NULL default '0', `downloadable` tinyint(1) NOT NULL default '1', `fileformat` varchar(10) NOT NULL default '', `sample_rate` int(10) unsigned NOT NULL default '0', `channel_mode` varchar(10) NOT NULL default '', `bitrate` float unsigned NOT NULL default '0', `bitrate_mode` varchar(4) NOT NULL default '', `playtime` varchar(10) NOT NULL default '', PRIMARY KEY (`vid`) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in /var/www/html/drupal/includes/database.mysql.inc on line 120.
# user warning: You have an error in your SQL syntax near '; ' at line 10 query: CREATE TABLE audio_file ( `vid` int(10) unsigned NOT NULL default '0', `origname` varchar(255) NOT NULL default '', `filename` varchar(255) NOT NULL default '', `filepath` varchar(255) NOT NULL default '', `filemime` varchar(255) NOT NULL default '', `filesize` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`vid`) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in /var/www/html/drupal/includes/database.mysql.inc on line 120.
# user warning: You have an error in your SQL syntax near '; ' at line 9 query: CREATE TABLE audio_metadata ( `vid` int(10) unsigned NOT NULL default '0', `tag` varchar(45) NOT NULL default '', `value` varchar(255) NOT NULL default '', `clean` varchar(255) NOT NULL default '', PRIMARY KEY (`vid`,`tag`,`value`), KEY `audio_metadata_tags` (`clean`) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in /var/www/html/drupal/includes/database.mysql.inc on line 120.

Comments

drewish’s picture

the SQL in the install looks good to me. how about providing some version info on your mysql server? the database creation code is in the .install file. you can copy and paste is out of there, all you'll need to do is remove the {} surrounding each table name.

drewish’s picture

Category: bug » support
Priority: Critical » Normal

i'm going to de-prioritize this.

drewish’s picture

Status: Active » Fixed

the lack of follow up leads me to believe they got it working

Anonymous’s picture

Status: Fixed » Closed (fixed)