sQL hatası alıyorum.

Hata

SQL sorgusu:

# MySQL-Front Dump 2.5
#
# Host: localhost Database: itiraf
# --------------------------------------------------------
# Server version 3.22.34-shareware-debug
#
# Table structure for table 'abone'
#
CREATE TABLE IF NOT EXISTS abone(
id int( 10 ) unsigned NOT lisanssız DEFAULT 0 AUTO_INCREMENT ,
eposta varchar( 255 ) ,
kimin int( 1 ) ,
yas1 int( 2 ) ,
yas2 int( 2 ) ,
nerelichar( 2 ) ,
kac int( 2 ) ,
PRIMARY KEY ( id ) ,
KEY id( id ) ,
KEY id_2( id )
);

MySQL çıktısı: Belgeler
#1067 - Invalid default value for 'id'

CREATE TABLE IF NOT EXISTS abone(
id int( 10 ) unsigned NOT lisanssız AUTO_INCREMENT ,
eposta varchar( 255 ) ,
kimin int( 1 ) ,
yas1 int( 2 ) ,
yas2 int( 2 ) ,
nereli char( 2 ) ,
kac int( 2 ) ,
PRIMARY KEY ( id ) ,
KEY id( id ) ,
KEY id_2( id )
);

Error at the line 23: );

Query: CREATE TABLE IF NOT EXISTS abone (
id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
eposta varchar(255) ,
kimin int(1) ,
yas1 int(2) ,
yas2 int(2) ,
nereli char(2) ,
kac int(2) ,
PRIMARY KEY (id),
KEY id (id),
KEY id_2 (id)
);

MySQL: Invalid default value for 'id'

Error at the line 51: );

Query: CREATE TABLE IF NOT EXISTS anket (
id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
soru varchar(255) ,
soru1 varchar(255) ,
soru2 varchar(255) ,
soru3 varchar(255) ,
soru4 varchar(255) ,
soru5 varchar(255) ,
soru6 varchar(255) ,
soru7 varchar(255) ,
cevap1 int(10) ,
cevap2 int(10) ,
cevap3 int(10) ,
cevap4 int(10) ,
cevap5 int(10) ,
cevap6 int(10) ,
cevap7 int(10) ,
tarih date ,
PRIMARY KEY (id),
KEY id (id),
KEY id_2 (id)
);

MySQL: Invalid default value for 'id'

Error at the line 23: );

Query: CREATE TABLE IF NOT EXISTS abone (
id int(10) unsigned NOT lisanssız auto_increment
eposta varchar(255) ,
kimin int(1) ,
yas1 int(2) ,
yas2 int(2) ,
nereli char(2) ,
kac int(2) ,
PRIMARY KEY (id),
KEY id (id),
KEY id_2 (id)
);

MySQL: 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 'eposta varchar(255) , kimin int(1) , yas1 int(2) , yas2 int(2) , nereli ' at line 3

Error at the line 59: INSERT INTO anket VALUES("1", "Test", "Turizm", "Güncel", "Sýcak Haberler", "Gezi", "", "", "", "6", "2", "2", "2", lisanssız, lisanssız, lisanssız, "2003-08-25");

Query: INSERT INTO anket VALUES("1", "Test", "Turizm", "Güncel", "Sýcak Haberler", "Gezi", "", "", "", "6", "2", "2", "2", lisanssız, lisanssız, lisanssız, "2003-08-25");

MySQL: Duplicate entry '1' for key 1

# MySQL-Front Dump 2.5
#
# Host: localhost   Database: itiraf
# --------------------------------------------------------
# Server version 3.22.34-shareware-debug


#
# Table structure for table 'abone'
#

CREATE TABLE IF NOT EXISTS abone (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  eposta varchar(255) ,
  kimin int(1) ,
  yas1 int(2) ,
  yas2 int(2) ,
  nereli char(2) ,
  kac int(2) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);


#
# Table structure for table 'anket'
#

CREATE TABLE IF NOT EXISTS anket (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  soru varchar(255) ,
  soru1 varchar(255) ,
  soru2 varchar(255) ,
  soru3 varchar(255) ,
  soru4 varchar(255) ,
  soru5 varchar(255) ,
  soru6 varchar(255) ,
  soru7 varchar(255) ,
  cevap1 int(10) ,
  cevap2 int(10) ,
  cevap3 int(10) ,
  cevap4 int(10) ,
  cevap5 int(10) ,
  cevap6 int(10) ,
  cevap7 int(10) ,
  tarih date ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);



#
# Dumping data for table 'anket'
#

INSERT INTO anket VALUES("1", "Test", "Turizm", "Güncel", "Sıcak Haberler", "Gezi", "", "", "", "6", "2", "2", "2", lisanssız, lisanssız, lisanssız, "2003-08-25");


#
# Table structure for table 'banner'
#

CREATE TABLE IF NOT EXISTS banner (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  src varchar(255) ,
  url varchar(255) ,
  alt varchar(255) ,
  goruntule int(10) ,
  tiklama int(10) ,
  tarih date ,
  k_cpm int(10) ,
  cpm int(10) ,
  durum int(1) ,
  yer int(1) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);



#
# Dumping data for table 'banner'
#

INSERT INTO banner VALUES("3", "banner2.gif", "http://www.deneme.com", "Deneme", "1492", "1", "2003-02-02", "1", "0", "1", "2");
INSERT INTO banner VALUES("4", "banner3.gif", "http://www.deneme.com", "Deneme", "512", "0", "2003-03-03", "1", "0", "1", "3");
INSERT INTO banner VALUES("6", "www.jpg", "http://www.deneme.com", "Deneme", "31", "0", "2004-05-20", "1", "0", "1", "1");


#
# Table structure for table 'duyuru'
#

CREATE TABLE IF NOT EXISTS duyuru (
  id int(5) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  duyuru text ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);



#
# Dumping data for table 'duyuru'
#



#
# Table structure for table 'gidenmesajlar'
#

CREATE TABLE IF NOT EXISTS gidenmesajlar (
  id int(20) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  konu varchar(255) ,
  mesaj text ,
  kimden int(10) ,
  kime int(10) ,
  durum int(1) ,
  tarih int(8) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);



#
# Dumping data for table 'gidenmesajlar'
#



#
# Table structure for table 'itiraf'
#

CREATE TABLE IF NOT EXISTS itiraf (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  itiraf text ,
  kimden int(20) ,
  kategori int(1) ,
  yorum int(1) ,
  tarih int(8) DEFAULT '0' ,
  durum int(1) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);


#
# Table structure for table 'mesajlar'
#

CREATE TABLE IF NOT EXISTS mesajlar (
  id int(20) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  konu varchar(255) ,
  mesaj text ,
  kimden int(10) ,
  kime int(10) ,
  durum int(1) ,
  tarih int(8) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);



#
# Table structure for table 'online'
#

CREATE TABLE IF NOT EXISTS online (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  ziyaretci varchar(100) ,
  zaman int(11) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);


#
# Table structure for table 'online2'
#

CREATE TABLE IF NOT EXISTS online2 (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  kullanici varchar(225) ,
  zaman int(11) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);



#
# Dumping data for table 'online2'
#



#
# Table structure for table 'otomesajlar'
#

CREATE TABLE IF NOT EXISTS otomesajlar (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  kimin int(10) ,
  konu varchar(255) ,
  mesaj text ,
  durum int(1) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);


#
# Table structure for table 'ozellist'
#

CREATE TABLE IF NOT EXISTS ozellist (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  iid int(10) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);

#
# Dumping data for table 'ozellist'
#

INSERT INTO ozellist VALUES("1", "1");
INSERT INTO ozellist VALUES("2", "3");
INSERT INTO ozellist VALUES("3", "4");


#
# Table structure for table 'sayac1'
#

CREATE TABLE IF NOT EXISTS sayac1 (
  id int(20) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  sayac int(10) ,
  tarih varchar(8) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);


#
# Table structure for table 'sayac2'
#

CREATE TABLE IF NOT EXISTS sayac2 (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  sayac int(20) ,
  tarih varchar(8) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);


#
# Table structure for table 'sehir'
#

CREATE TABLE IF NOT EXISTS sehir (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  sehir varchar(255) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);



#
# Dumping data for table 'sehir'
#

INSERT INTO sehir VALUES("34", "İstanbul");
INSERT INTO sehir VALUES("6", "Ankara");
INSERT INTO sehir VALUES("35", "İzmir");
INSERT INTO sehir VALUES("1", "Adana");
INSERT INTO sehir VALUES("2", "Adıyaman");
INSERT INTO sehir VALUES("3", "Afyon");
INSERT INTO sehir VALUES("4", "Ağrı");
INSERT INTO sehir VALUES("68", "Aksaray");
INSERT INTO sehir VALUES("5", "Amasya");
INSERT INTO sehir VALUES("7", "Antalya");
INSERT INTO sehir VALUES("75", "Ardahan");
INSERT INTO sehir VALUES("8", "Artvin");
INSERT INTO sehir VALUES("9", "Aydın");
INSERT INTO sehir VALUES("10", "Balıkesir");
INSERT INTO sehir VALUES("74", "Bartın");
INSERT INTO sehir VALUES("72", "Batman");
INSERT INTO sehir VALUES("69", "Bayburt");
INSERT INTO sehir VALUES("11", "Bilecik");
INSERT INTO sehir VALUES("12", "Bingöl");
INSERT INTO sehir VALUES("13", "Bitlis");
INSERT INTO sehir VALUES("14", "Bolu");
INSERT INTO sehir VALUES("15", "Burdur");
INSERT INTO sehir VALUES("16", "Bursa");
INSERT INTO sehir VALUES("17", "Çanakkale");
INSERT INTO sehir VALUES("18", "Çankırı");
INSERT INTO sehir VALUES("19", "Çorum");
INSERT INTO sehir VALUES("20", "Denizli");
INSERT INTO sehir VALUES("21", "Diyarbakır");
INSERT INTO sehir VALUES("81", "Duzce");
INSERT INTO sehir VALUES("22", "Edirne");
INSERT INTO sehir VALUES("23", "Elazığ");
INSERT INTO sehir VALUES("24", "Erzincan");
INSERT INTO sehir VALUES("25", "Erzurum");
INSERT INTO sehir VALUES("26", "Eskişehir");
INSERT INTO sehir VALUES("27", "Gaziantep");
INSERT INTO sehir VALUES("28", "Giresun");
INSERT INTO sehir VALUES("29", "Gümüşhane");
INSERT INTO sehir VALUES("30", "Hakkari");
INSERT INTO sehir VALUES("31", "Hatay");
INSERT INTO sehir VALUES("76", "Iğdır");
INSERT INTO sehir VALUES("32", "Isparta");
INSERT INTO sehir VALUES("33", "İçel(Mersin)");
INSERT INTO sehir VALUES("78", "Karabük");
INSERT INTO sehir VALUES("70", "Karaman");
INSERT INTO sehir VALUES("36", "Kars");
INSERT INTO sehir VALUES("37", "Kastamonu");
INSERT INTO sehir VALUES("38", "Kayseri");
INSERT INTO sehir VALUES("71", "Kırıkkale");
INSERT INTO sehir VALUES("39", "Kırklareli");
INSERT INTO sehir VALUES("40", "Kırşehir");
INSERT INTO sehir VALUES("79", "Kilis");
INSERT INTO sehir VALUES("41", "Kocaeli");
INSERT INTO sehir VALUES("42", "Konya");
INSERT INTO sehir VALUES("43", "Kütahya");
INSERT INTO sehir VALUES("44", "Malatya");
INSERT INTO sehir VALUES("45", "Manisa");
INSERT INTO sehir VALUES("46", "Maraş");
INSERT INTO sehir VALUES("47", "Mardin");
INSERT INTO sehir VALUES("48", "Muğla");
INSERT INTO sehir VALUES("49", "Muş");
INSERT INTO sehir VALUES("50", "Nevşehir");
INSERT INTO sehir VALUES("51", "Niğde");
INSERT INTO sehir VALUES("52", "Ordu");
INSERT INTO sehir VALUES("80", "Osmaniye");
INSERT INTO sehir VALUES("53", "Rize");
INSERT INTO sehir VALUES("54", "Sakarya");
INSERT INTO sehir VALUES("55", "Samsun");
INSERT INTO sehir VALUES("56", "Siirt");
INSERT INTO sehir VALUES("57", "Sinop");
INSERT INTO sehir VALUES("58", "Sivas");
INSERT INTO sehir VALUES("73", "Şırnak");
INSERT INTO sehir VALUES("59", "Tekirdağ");
INSERT INTO sehir VALUES("60", "Tokat");
INSERT INTO sehir VALUES("61", "Trabzon");
INSERT INTO sehir VALUES("62", "Tunceli");
INSERT INTO sehir VALUES("63", "Urfa");
INSERT INTO sehir VALUES("64", "Uşak");
INSERT INTO sehir VALUES("65", "Van");
INSERT INTO sehir VALUES("77", "Yalova");
INSERT INTO sehir VALUES("66", "Yozgat");
INSERT INTO sehir VALUES("67", "Zonguldak");


#
# Table structure for table 'tanitim'
#

CREATE TABLE IF NOT EXISTS tanitim (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  siteadi varchar(255) ,
  tanitim varchar(255) ,
  adres varchar(255) ,
  tiklama int(10) ,
  durum int(1) ,
  tarih date ,
  nekadar int(10) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);



#
# Dumping data for table 'tanitim'
#

INSERT INTO tanitim VALUES("1", "sevgiliye.com", "Cep melodi, aşk şiirleri, cep şiirleri, forum...", "http://www.sevgiliye.com", "5", "1", "2003-11-10", "6");
INSERT INTO tanitim VALUES("2", "xkare.com", "xkare Her türlü alt yapı hizmeti vermektedir...", "http://www.xkare.com", "2", "1", "2003-11-10", "5");

#
# Table structure for table 'ulke'
#

CREATE TABLE IF NOT EXISTS ulke (
  id int(5) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  ulke varchar(255) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);



#
# Dumping data for table 'ulke'
#

INSERT INTO ulke VALUES("150", "ABD");
INSERT INTO ulke VALUES("151", "Almanya");
INSERT INTO ulke VALUES("153", "Avusturya");
INSERT INTO ulke VALUES("154", "Belçika");
INSERT INTO ulke VALUES("156", "Fransa");
INSERT INTO ulke VALUES("155", "Hollanda");
INSERT INTO ulke VALUES("152", "İngiltere");
INSERT INTO ulke VALUES("157", "İsviçre");
INSERT INTO ulke VALUES("158", "KKTC");
INSERT INTO ulke VALUES("159", "Diğer");


#
# Table structure for table 'uyeler'
#

CREATE TABLE IF NOT EXISTS uyeler (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  rumuz varchar(20) ,
  sifre varchar(16) ,
  dogum date ,
  cins char(1) ,
  sehir int(3) ,
  ulke int(3) ,
  gizlisoru varchar(255) ,
  sorucevabi varchar(255) ,
  tarih date ,
  durum int(1) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);



#
# Dumping data for table 'uyeler'
#

INSERT INTO uyeler VALUES("1", "admin", "admin", "1983-10-10", "1", "34", "0", lisanssız, lisanssız, "2003-11-13", "9");


#
# Table structure for table 'yardim'
#

CREATE TABLE IF NOT EXISTS yardim (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  baslik varchar(255) ,
  devam text ,
  kategori int(4) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);

#
# Table structure for table 'yardim_kategori'
#

CREATE TABLE IF NOT EXISTS yardim_kategori (
  id int(4) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  kategori varchar(255) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);



#
# Dumping data for table 'yardim_kategori'
#

INSERT INTO yardim_kategori VALUES("1", "GENEL MESELELER");
INSERT INTO yardim_kategori VALUES("2", "ÜYELİK OLAYI");


#
# Table structure for table 'yasaklilar'
#

CREATE TABLE IF NOT EXISTS yasaklilar (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  sid int(10) ,
  oid int(10) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);


#
# Table structure for table 'yorumlar'
#

CREATE TABLE IF NOT EXISTS yorumlar (
  id int(10) unsigned NOT lisanssız DEFAULT '0' auto_increment,
  iid int(20) ,
  yorum varchar(255) ,
  durum int(1) ,
  PRIMARY KEY (id),
   KEY id (id),
   KEY id_2 (id)
);



#
# Dumping data for table 'yorumlar'
#