I ran:

CREATE TABLE `playlist_relate` (
`rid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`parent_id` int( 11 ) NOT NULL default '0',
`child_id` int( 11 ) NOT NULL default '0',
`weight` int( 11 ) default '0',
PRIMARY KEY ( `rid` )

MySQL returned:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6

Comments

zirafa’s picture

zirafa commented

Hmm that doesn't look correct (or match what is in CVS). It should look like the following:

CREATE TABLE `playlist_relate` (
  `rid` int(11) NOT NULL auto_increment,
  `parent_id` int(11) NOT NULL default '0',
  `child_id` int(11) NOT NULL default '0',
  `weight` int(11) default '0',
  PRIMARY KEY  (`rid`)
);

Note the closing parenthesis and semicolon. Try that and let me know if it worked.

Farsheed

zirafa’s picture

zirafa commented
Status: Active » Closed (fixed)