0
Kayıt Ol

Db sorun

1

●

504

  • 12-05-2009, 17:14:01
    #1
    TheXjL
    TheXjL
    Üyeliği durduruldu
    SQL sorgunuzda bir hata olduğu görünüyor. Eğer varsa, aşağıdaki MySQL sunucu hata çıktısı, sorunu teşhis etmenizde ayrıca size yardımcı olabilir.

ERROR: Geçersiz Tanımlayıcı @ 150
STR: 4.1.
SQL: -- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Anamakine: localhost
-- ܲetim Zaman?޵bat 2008 saat 12:53:52
-- Sunucu s? 4.1.22
-- PHP S? 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";# MySQL boş bir sonuç kümesi döndürdü (örn. sıfır satır).


--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Veritaban?wther_portalv2`
--

-- --------------------------------------------------------

--
-- Tablo yap?admin`
--

CREATE TABLE `admin` (
  `id` bigint(255) NOT NULL auto_increment,
  `adminadi` longtext NOT NULL,
  `adminsifre` longtext NOT NULL,
  `adminlvl` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;


SQL sorgusu: 

-- -- Veritaban?wther_portalv2` -- -- -------------------------------------------------------- -- -- Tablo yap?admin` -- CREATE TABLE `admin` ( `id` bigint(255) NOT NULL auto_increment, `adminadi` longtext NOT NULL, `adminsifre` longtext NOT NULL, `adminlvl` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; 

MySQL çıktısı:  

#1046 - No database selected
    Böle bi hata aliyorum yardimci olurmusunuz?
  • 12-05-2009, 18:37:32
    #2
    erkutarhan
    erkutarhan
    Bence parça parça kopyala öyle sorgu yap
    mesela
    CREATE TABLE `admin` (
    `id` bigint(255) NOT NULL auto_increment,
    `adminadi` longtext NOT NULL,
    `adminsifre` longtext NOT NULL,
    `adminlvl` longtext NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

    bunu çalıştır
    sonra diğerini falan