MySQL Error 1064 with this code

[Alendar]

When trying to execute this code:

Code Select Expand

CREATE TABLE `pastebin` (
`pid` int(11) NOT NULL auto_increment,
`poster` varchar(16) default NULL,
`posted` datetime default NULL,
`code` text,
`parent_pid` int(11) default '0',
`format` varchar(16) default NULL,
`codefmt` mediumtext,
`codecss` text,
`domain` varchar(255) default '',
`expires` DATETIME,
`expiry_flag` ENUM('d','m', 'f') NOT NULL DEFAULT 'm',

PRIMARY KEY (`pid`),
KEY `domain` (`domain`),
KEY `parent_pid`,
KEY `expires`
);

I get the following error:

#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 '
KEY `expires`
)' at line 16

I am trying to install PasteBin an open source code. Yet I get this error when trying to install this part. Thanks for the help!


Alendar

[iago]

MySQL requires the KEYs to have a list of columns (which makes sense), in addition to an optional name. On that query, the last two KEYs only have names, not columns.

This should work:

CREATE TABLE `pastebin` (
`pid` int(11) NOT NULL auto_increment,
`poster` varchar(16) default NULL,
`posted` datetime default NULL,
`code` text,
`parent_pid` int(11) default '0',
`format` varchar(16) default NULL,
`codefmt` mediumtext,
`codecss` text,
`domain` varchar(255) default '',
`expires` DATETIME,
`expiry_flag` ENUM('d','m', 'f') NOT NULL DEFAULT 'm',

PRIMARY KEY (`pid`),
KEY `domain` (`domain`),
KEY (`parent_pid`),
KEY (`expires`)
);

[Alendar]

That worked. Thank you!