SQL entry not working

Clan__lt_Test_gt_

SQL entry not working, can you tell me wut is wrong with it

i get this error

#1060 - Duplicate column name 'id'

#
# Table structure for table `news`
#

CREATE TABLE news (
  id smallint(7) NOT NULL auto_increment,
  author varchar(40) default '0',
  email varchar(60) NOT NULL default '0',
  title varchar(70) default '0',
  news blob NOT NULL,
  date text NOT NULL,
  internal tinyint(1) NOT NULL default '0',
  rank tinyint(1) default NULL,
  ip varchar(15) NOT NULL default '',
  PRIMARY KEY  (id,id),
  FULLTEXT KEY date (date)
) TYPE=MyISAM;

#
# Dumping data for table `news`

laserlight

What if you change:
PRIMARY KEY (id,id),
to
PRIMARY KEY (id),

Clan__lt_Test_gt_

it works but i donno if the scipt it proper then, i didn't write it. it a part of clan scripts

laserlight

it works but i donno if the scipt it proper then, i didn't write it.

In which case you have to
a) find out more, or
b) assume that it works.

In any case, PRIMARY KEY(id, id) should be wrong since one shouldnt list the same column as an index (or in this case, a primary key) twice.

Clan__lt_Test_gt_

thanks i'll look into it