[markbolyard]

Originally Posted by MissKalunji

how did you? everytime i try to add the first table it keeps giving me errors

can you give me the right syntax for the tables plz?

Ok, here is the sql to create the tables... I have discovered a couple problems, which I will work out and share my fixes here. In the meantime:

-- Table structure for table `jukebox_media`
-- 

CREATE TABLE `jukebox_media` (
  `mediaid` smallint(5) unsigned NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `plays` smallint(5) NOT NULL default '0',
  `active` int(2) NOT NULL default '0',
  `userid` int(11) NOT NULL default '0',
  `username` varchar(225) NOT NULL default '',
  `totalrating` int(5) NOT NULL default '0',
  `announce` int(2) NOT NULL default '0',
  `genre` varchar(50) NOT NULL default '',
  `description` varchar(250) NOT NULL default '',
  `author` varchar(100) NOT NULL default '',
  `date` int(10) NOT NULL default '0',
  `whovoted` varchar(25) NOT NULL default '',
  `totalvotes` int(15) NOT NULL default '0',
  PRIMARY KEY  (`mediaid`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- Table structure for table `jukebox_comments`
-- 

CREATE TABLE `jukebox_comments` (
  `mediaid` int(10) unsigned NOT NULL default '0',
  `commentid` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(25) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `comment` varchar(250) NOT NULL default '',
  `date` int(10) unsigned NOT NULL default '0',
  `title` varchar(50) NOT NULL default '',
  `lasteditdate` int(10) default NULL,
  `lasteditusername` varchar(25) default NULL,
  `lastedituserid` int(10) default NULL,
  `ipaddress` varchar(15) default NULL,
  PRIMARY KEY  (`commentid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Just copy and paste these these into your sql queries box in phpmyadmin.

The one problem I am facing is a error when administering media through the admincp, and the script is trying to locate a field in the table jukebox_media called album. I imagine if I remove this from the sql file, it will take care of it. I will keep you updated as I figure things out...

Additional Note: Phrases do not get added during product import / install.