Closed (fixed)
Project:
Audio
Version:
4.7.x-1.x-dev
Component:
Miscellaneous
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
24 Oct 2006 at 10:46 UTC
Updated:
27 Nov 2006 at 06:48 UTC
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
Comment #1
drewish commentedthe 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.
Comment #2
drewish commentedi'm going to de-prioritize this.
Comment #3
drewish commentedthe lack of follow up leads me to believe they got it working
Comment #4
(not verified) commented