Avatar billede grise_bassen Nybegynder
13. september 2004 - 18:03 Der er 5 kommentarer og
1 løsning

hvad er der vejen med min mysql

jeg får fejlen Fejl

SQL-forespørgsel : 

INSERT INTO `ad_groups`
VALUES (

"2", "Banner Ad (468x60)"
)

MySQL returnerede:


#1062 - Duplicate entry '2' for key 1



her er min sql tekst


#
# Table structure for table `wallpaper_ad_groups`
#

CREATE TABLE wallpaper_ad_groups (
  groupid int(10) unsigned NOT NULL default '0',
  groupname varchar(255) NOT NULL default '',
  PRIMARY KEY  (groupid),
  UNIQUE KEY groupid (groupid),
  KEY groupid_2 (groupid)
) TYPE=MyISAM;

#
# Dumping data for table `wallpaper_ad_groups`
#
INSERT INTO `ad_groups` VALUES("2","Banner Ad (468x60)");
INSERT INTO `ad_groups` VALUES("3","Skyscrapper Ad (120x400)");
INSERT INTO `ad_groups` VALUES("4","Box Ad (120x70)");

# --------------------------------------------------------

#
# Table structure for table `wallpaper_admin_control`
#

CREATE TABLE wallpaper_admin_control (
  approve_content char(1) default 'Y',
  wotwid int(3) unsigned default NULL
) TYPE=MyISAM;

#
# Dumping data for table `wallpaper_admin_control`
#

INSERT INTO wallpaper_admin_control VALUES ('Y',121);
# --------------------------------------------------------

#
# Table structure for table `wallpaper_admin_login`
#

CREATE TABLE wallpaper_admin_login (
  login varchar(20) default NULL,
  password varchar(20) default NULL,
  sessionkey int(10) unsigned default NULL
) TYPE=MyISAM;

#
# Dumping data for table `wallpaper_admin_login`
#

INSERT INTO wallpaper_admin_login VALUES ('admin kode','admin kode','');
# --------------------------------------------------------

#
# Table structure for table `wallpaper_ads`
#

CREATE TABLE wallpaper_ads (
  adid int(10) unsigned NOT NULL default '0',
  image varchar(50) default NULL,
  url varchar(255) default NULL,
  code text,
  impressions int(10) unsigned default '0',
  clicks int(11) default '0',
  groupid int(10) unsigned default NULL,
  type char(1) default NULL,
  name varchar(255) default NULL,
  PRIMARY KEY  (adid),
  UNIQUE KEY adid (adid),
  KEY adid_2 (adid)
) TYPE=MyISAM;

#
# Dumping data for table `wallpaper_ads`
#

INSERT INTO wallpaper_ads VALUES (8,NULL,NULL,'<script language="javascript1.2" type="text/javascript" src="http://www.funpageexchange.com/468x60.php?uid=399"></script>',1,'',2,'A','FPE Banner');
INSERT INTO wallpaper_ads VALUES (9,NULL,NULL,'<script language="javascript1.2" type="text/javascript" src="http://www.funpageexchange.com/120x600.php?uid=399"></script>',1,'',3,'A','FPE SkyScrapper');
# --------------------------------------------------------

#
# Table structure for table `wallpaper_categories`
#

CREATE TABLE wallpaper_categories (
  categoryid int(10) unsigned NOT NULL default '0',
  category varchar(100) default NULL,
  PRIMARY KEY  (categoryid),
  UNIQUE KEY categoryid (categoryid),
  KEY categoryid_2 (categoryid)
) TYPE=MyISAM;

#
# Dumping data for table `wallpaper_categories`
#

INSERT INTO wallpaper_categories VALUES ('','Misc');
INSERT INTO wallpaper_categories VALUES (2,'Movies');
INSERT INTO wallpaper_categories VALUES (9,'Celebrities');
INSERT INTO wallpaper_categories VALUES (11,'Video Games');
INSERT INTO wallpaper_categories VALUES (6,'Cars');
INSERT INTO wallpaper_categories VALUES (7,'Nature');
INSERT INTO wallpaper_categories VALUES (8,'TV');
# --------------------------------------------------------

#
# Table structure for table `wallpaper_emailed_wallpaper`
#

CREATE TABLE wallpaper_emailed_wallpaper (
  sender_email varchar(255) default NULL,
  friend_email varchar(255) default NULL,
  recipeid int(10) unsigned default NULL
) TYPE=MyISAM;

#
# Dumping data for table `wallpaper_emailed_wallpaper`
#

# --------------------------------------------------------

#
# Table structure for table `wallpaper_messages`
#

CREATE TABLE wallpaper_messages (
  messageid int(10) unsigned NOT NULL default '0',
  wallpaperid int(3) unsigned NOT NULL default '0',
  userid int(3) unsigned NOT NULL default '0',
  message text,
  messagedate varchar(40) default NULL,
  PRIMARY KEY  (messageid,wallpaperid,userid),
  UNIQUE KEY messageid (messageid),
  KEY messageid_2 (messageid,wallpaperid,userid)
) TYPE=MyISAM;

#
# Dumping data for table `wallpaper_messages`
#

# --------------------------------------------------------

#
# Table structure for table `wallpaper_meta_data`
#

CREATE TABLE wallpaper_meta_data (
  wallpaperid int(10) unsigned default NULL,
  keyword varchar(255) default NULL
) TYPE=MyISAM;

#
# Dumping data for table `wallpaper_meta_data`
#

# --------------------------------------------------------

#
# Table structure for table `wallpaper_ratings`
#

CREATE TABLE wallpaper_ratings (
  wallpaperid int(11) NOT NULL default '0',
  rating float(10,2) NOT NULL default '0.00',
  ip varchar(50) default NULL
) TYPE=MyISAM;



#
# Table structure for table `wallpaper_search_terms`
#

CREATE TABLE wallpaper_search_terms (
  term varchar(255) default NULL,
  count int(10) unsigned default '0'
) TYPE=MyISAM;


#
# Table structure for table `wallpaper_sizes_lookup`
#

CREATE TABLE wallpaper_sizes_lookup (
  wallpaperid int(10) unsigned NOT NULL default '0',
  sizeid int(3) unsigned NOT NULL default '0'
) TYPE=MyISAM;


#
# Table structure for table `wallpaper_subscribers`
#

CREATE TABLE wallpaper_subscribers (
  emailaddress varchar(255) default NULL
) TYPE=MyISAM;

#
# Dumping data for table `wallpaper_subscribers`
#

INSERT INTO wallpaper_subscribers VALUES ('pault@ratty.net');
# --------------------------------------------------------

#
# Table structure for table `wallpaper_users`
#

CREATE TABLE wallpaper_users (
  userid int(10) unsigned NOT NULL default '0',
  login varchar(50) NOT NULL default '',
  password varchar(50) NOT NULL default '',
  email varchar(255) default NULL,
  newsletter int(1) unsigned default NULL,
  PRIMARY KEY  (userid),
  UNIQUE KEY userid (userid,login),
  KEY userid_2 (userid,login)
) TYPE=MyISAM;


#
# Table structure for table `wallpaper_wallpaper`
#

CREATE TABLE wallpaper_wallpaper (
  wallpaperid int(10) unsigned NOT NULL default '0',
  title varchar(255) default NULL,
  userid int(10) unsigned default NULL,
  rating int(10) unsigned default '0',
  categoryid int(10) unsigned default NULL,
  date varchar(20) NOT NULL default '',
  hits int(10) unsigned default '0',
  status char(1) default 'W',
  downloads int(10) unsigned default '0',
  PRIMARY KEY  (wallpaperid),
  UNIQUE KEY recipieid (wallpaperid),
  KEY recipieid_2 (wallpaperid)
) TYPE=MyISAM;

#
# Table structure for table `wallpaper_wallpaper_sizes`
#

CREATE TABLE wallpaper_wallpaper_sizes (
  sizeid int(10) unsigned NOT NULL default '0',
  size varchar(255) default '0',
  width int(10) unsigned NOT NULL default '0',
  height int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (sizeid),
  UNIQUE KEY sizeid (sizeid),
  KEY sizeid_2 (sizeid)
) TYPE=MyISAM;

#
# Dumping data for table `wallpaper_wallpaper_sizes`
#

INSERT INTO wallpaper_wallpaper_sizes VALUES (2,'1280x1024',1280,1024);
INSERT INTO wallpaper_wallpaper_sizes VALUES (3,'1024x768',1024,768);
INSERT INTO wallpaper_wallpaper_sizes VALUES (4,'800x600',800,600);
INSERT INTO wallpaper_wallpaper_sizes VALUES (1,'1600x1200',1600,1200);
Avatar billede arne_v Ekspert
13. september 2004 - 18:08 #1
Den siger at tabellen ad_groups allerede har en række med primær nøgle 2 !
Avatar billede arne_v Ekspert
13. september 2004 - 18:09 #2
Og så kan du selvfølgelig ikke indsætte en til.
Avatar billede hmm10 Nybegynder
13. september 2004 - 18:33 #3
Der er noget UNIQUE, der skaber det problem.. '2' er allerede oprettet.
Avatar billede arne_v Ekspert
19. september 2004 - 18:43 #4
OK ?
Avatar billede arne_v Ekspert
27. september 2004 - 00:28 #5
??
Avatar billede grise_bassen Nybegynder
27. oktober 2004 - 08:59 #6
tak
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester