SQL error

S

SuCcEsS

Registered
Ето я грешката
Код: 
Грешка
SQL заявка: 

CREATE TABLE nes_forum(

rootID INT NOT NULL ,
parentID INT NOT NULL DEFAULT '0',
subject text NOT NULL ,
post text NOT NULL ,
posterid text NOT NULL ,
datetime int NOT NULL ,

) TYPE = ISAM;



MySQL отговори:  

#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 ') TYPE=ISAM' at line 8

Ето ми я базата данни
Код: 
DROP TABLE IF EXISTS `nes_forum`;
CREATE TABLE nes_forum (
  rootID INT NOT NULL,
  parentID INT NOT NULL DEFAULT '0',
  subject text NOT NULL,
  post text NOT NULL,
  posterid text NOT NULL,
  datetime int NOT NULL,
) TYPE=ISAM;

DROP TABLE IF EXISTS `nes_confirm`;
CREATE TABLE nes_confirm (
  mdhash longtext,
  username text,
  password text,
  name text,
  email text,
  age int(3) default NULL,
  sex text,
  school longtext,
  date datetime NOT NULL default '0000-00-00 00:00:00',
  theme text,
  icq text default NULL,
  aim text default NULL,
  msn text default NULL,
  yahoo text default NULL,
  yabber text default NULL
) TYPE=MyISAM;

DROP TABLE IF EXISTS `nes_confirm_email`;
CREATE TABLE nes_confirm_email (
  id int(8) default NULL,
  email text,
  mdhash longtext,
  date datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

DROP TABLE IF EXISTS `nes_data`;
CREATE TABLE nes_data (
  userid text NOT NULL,
  name text NOT NULL,
  email text NOT NULL,
  age int(3) NOT NULL default '0',
  sex text NOT NULL,
  school text NOT NULL,
  theme text,
  icq text default NULL,
  aim text default NULL,
  msn text default NULL,
  yahoo text default NULL,
  yabber text default NULL
) TYPE=MyISAM;

DROP TABLE IF EXISTS `nes_game_options`;
CREATE TABLE nes_game_options (
  game_name text NOT NULL,
  team_members int(11) default '5',
  a_team int(11) default '0',
  a_team_members int(11) default '5',
  min_chars int(11) default '50',
  max_chars int(11) default '150',
  allow_login int(11) default '1',
  starting_sentence text,
  version text
) TYPE=MyISAM;
INSERT INTO `nes_game_options` (`game_name`, `team_members`, `a_team`, 

`a_team_members`, `min_chars`, `max_chars`, `allow_login`, `starting_sentence`, `version`) 

VALUES ('Never Ending Story',5,0,5,50,150,1,'Sun in the cloud-less sky, birds singing on the 

trees, a day perfect for a walk through the park, nothing could go wrong when suddenly ','1.0');

DROP TABLE IF EXISTS `nes_login`;
CREATE TABLE nes_login (
  userid text NOT NULL,
  username text NOT NULL,
  password text NOT NULL,
  status text NOT NULL
) TYPE=MyISAM;

DROP TABLE IF EXISTS `nes_player`;
CREATE TABLE nes_player (
  userid text NOT NULL,
  teamnum int(3) default NULL,
  priority int(3) default NULL,
  posts int default '0',
  chars int default '0'
) TYPE=MyISAM;

DROP TABLE IF EXISTS `nes_team_data`;
CREATE TABLE nes_team_data (
  id int(16) default NULL auto_increment,
  team_number int(11) default '0',
  story text NOT NULL,
  posts int(11) default '0',
  last_post1 text,
  last_post2 text,
  last_post3 text,
  last_post4 text,
  last_post5 text,
  bold int(11) default '0',
  priority int(11) default '0',
  members int(11) default '0',
  PRIMARY KEY (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `nes_pm_messages`;
CREATE TABLE nes_pm_messages (
  receiverid text NOT NULL,
  senderid text NOT NULL,
  message text NOT NULL,
  id int default '0',
  subject text,
  oldmsg int NOT NULL default '0',
  date datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

DROP TABLE IF EXISTS `nes_news`;
CREATE TABLE nes_news (
  posterid text NOT NULL,
  message text NOT NULL,
  id int default '0',
  subject text,
  date datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;
 
DROP TABLE IF EXISTS `nes_forum`;
CREATE TABLE nes_forum (
rootID INT NOT NULL,
parentID INT NOT NULL DEFAULT '0',
subject text NOT NULL,
post text NOT NULL,
posterid text NOT NULL,
datetime int NOT NULL,
) TYPE=MyISAM;
Така?
 
Код: 
Грешка
SQL заявка: 

CREATE TABLE nes_forum(

rootID INT NOT NULL ,
parentID INT NOT NULL DEFAULT '0',
subject text NOT NULL ,
post text NOT NULL ,
posterid text NOT NULL ,
datetime int NOT NULL ,

) TYPE = MYISAM ;



MySQL отговори:  

#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 ') TYPE=MyISAM' at line 8
 
SuCcEsS каза:
Код: 
Грешка
SQL заявка: 

CREATE TABLE nes_forum(

rootID INT NOT NULL ,
parentID INT NOT NULL DEFAULT '0',
subject text NOT NULL ,
post text NOT NULL ,
posterid text NOT NULL ,
datetime int NOT NULL ,

) TYPE = MYISAM ;



MySQL отговори:  

#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 ') TYPE=MyISAM' at line 8
Увеличете...
Незнам какво е това type=myisam но мисля че там е грешката невиждам кмъде другаде би могло да е ти знаеш ли за какво е ? :roll:
 
DROP TABLE IF EXISTS `nes_forum`;
CREATE TABLE nes_forum (
rootID INT NOT NULL,
parentID INT NOT NULL DEFAULT '0',
subject text NOT NULL,
post text NOT NULL,
posterid text NOT NULL,
datetime int NOT NULL,
) TYPE=ISAM;
Увеличете...


Код: 
DROP TABLE IF EXISTS `nes_forum`; 
CREATE TABLE nes_forum ( 
  rootID INT NOT NULL, 
  parentID INT NOT NULL DEFAULT '0', 
  subject text NOT NULL, 
  post text NOT NULL, 
  posterid text NOT NULL, 
  datetime int NOT NULL
) TYPE=ISAM;
 
CREATE TABLE nes_forum(

rootID INT(50) NOT NULL ,
parentID INT(50) NOT NULL DEFAULT '0',
subject text NOT NULL ,
post text NOT NULL ,
posterid text NOT NULL ,
datetime int(50) NOT NULL ,

) TYPE = MYISAM ;
или пак така ?
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе