Erreur de Syntaxe pour une requête SQL

Mimouuu Messages postés 4 Statut Membre -  
Mimouuu Messages postés 4 Statut Membre -
Bonjour,

J'ai un forum hébergé sur free.fr avec PHP Version 4.4.3
J'ai un problème losque je veux lancer une requête sur ma base de données depuis PhpMyAdmin un message d'erreur d'affiche
#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 'CREATE TABLE 'ipb_games_cats' ( 'c_id' mediumint(8) NOT NULL auto_increment, ' at line 16



Voici la requête que j'aimerais lancer

#
# Structure de la table 'ipb_games_banned_ip'
#

CREATE TABLE 'ipb_games_banned_ip' (
  'ip' varchar(15) NOT NULL default '',
  PRIMARY KEY  ('ip')
) TYPE=MyISAM;

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

#
# Structure de la table 'ipb_games_cats'
#

CREATE TABLE 'ipb_games_cats' (
  'c_id' mediumint(8) NOT NULL auto_increment,
  'cat_name' varchar(32) NOT NULL default '',
  'active' tinyint(1) NOT NULL default '1',
  PRIMARY KEY  ('c_id')
) TYPE=MyISAM;

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

#
# Structure de la table 'ipb_games_groups'
#

CREATE TABLE 'ipb_games_groups' (
  'group_id' int(3) NOT NULL default '0',
  'access' tinyint(1) NOT NULL default '1',
  'p_require' mediumint(8) NOT NULL default '0',
  'max_play' int(11) NOT NULL default '0'
) TYPE=MyISAM;

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

#
# Structure de la table 'ipb_games_last_record'
#

CREATE TABLE 'ipb_games_last_record' (
  'gid' int(11) NOT NULL default '0',
  'gtitle' varchar(30) NOT NULL default '',
  'mname' varchar(30) NOT NULL default '',
  'score' int(11) NOT NULL default '0',
  'datescored' int(10) NOT NULL default '0'
) TYPE=MyISAM;

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

#
# Structure de la table 'ipb_games_list'
#

CREATE TABLE 'ipb_games_list' (
  'gid' int(11) NOT NULL auto_increment,
  'gname' varchar(40) NOT NULL default '',
  'gwords' text NOT NULL,
  'gcount' int(11) NOT NULL default '0',
  'gtitle' varchar(40) NOT NULL default '',
  'bgcolor' varchar(6) NOT NULL default '000000',
  'active' tinyint(1) NOT NULL default '1',
  'gwidth' int(11) NOT NULL default '0',
  'gheight' int(11) NOT NULL default '0',
  'gcat' int(2) NOT NULL default '0',
  'object' text NOT NULL,
  'gkeys' text NOT NULL,
  'rating' tinyint(4) NOT NULL default '0',
  'votes' tinyint(4) NOT NULL default '0',
  'total' tinyint(4) NOT NULL default '0',
  'highscores' char(3) NOT NULL default 'MAX',
  'record' int(11) NOT NULL default '0',
  'champion' varchar(30) NOT NULL default '',
  UNIQUE KEY 'gid' ('gid')
) TYPE=MyISAM COMMENT='Game List';

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

#
# Structure de la table 'ipb_games_rate'
#

CREATE TABLE 'ipb_games_rate' (
  'gid' int(11) NOT NULL default '0',
  'mid' mediumint(8) NOT NULL default '0'
) TYPE=MyISAM;

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

#
# Structure de la table 'ipb_games_scores'
#

CREATE TABLE 'ipb_games_scores' (
  's_id' int(11) NOT NULL auto_increment,
  'mid' int(11) NOT NULL default '0',
  'gid' int(11) NOT NULL default '0',
  'name' text NOT NULL,
  'score' int(11) NOT NULL default '0',
  'ip' text NOT NULL,
  'comment' text NOT NULL,
  'datescored' int(10) NOT NULL default '0',
  PRIMARY KEY  ('s_id')
) TYPE=MyISAM;

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

#
# Structure de la table 'ipb_games_settings'
#

CREATE TABLE 'ipb_games_settings' (
  'arcade_status' tinyint(1) NOT NULL default '1',
  'g_display_sort' varchar(15) NOT NULL default '',
  'g_display_order' varchar(4) NOT NULL default '',
  'scores_amount' mediumint(8) NOT NULL default '10',
  'next_day' int(10) NOT NULL default '0',
  'skin' tinyint(1) NOT NULL default '0',
  'use_cats' tinyint(1) NOT NULL default '1',
  'log' tinyint(1) NOT NULL default '0',
  'score_type' char(3) NOT NULL default '',
  'crown_type' tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

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

#
# Structure de la table 'ipb_tournament_players'
#

CREATE TABLE 'ipb_tournament_players' (
  'mid' int(11) NOT NULL default '0',
  'tid' int(11) NOT NULL default '0',
  'rung' int(11) NOT NULL default '0',
  'rungscore' int(11) NOT NULL default '0',
  'faceoff' int(11) NOT NULL default '0',
  'timeplayed' int(10) NOT NULL default '0',
  'timesplayed' int(11) NOT NULL default '0',
  'timessaved' tinyint(1) NOT NULL default '3'
) TYPE=MyISAM;

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

#
# Structure de la table 'ipb_tournament_players_statut'
#

CREATE TABLE 'ipb_tournament_players_statut' (
  'tid' int(11) NOT NULL default '0',
  'mid' int(11) NOT NULL default '0',
  'statut' tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

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

#
# Structure de la table 'ipb_tournaments'
#

CREATE TABLE 'ipb_tournaments' (
  'tid' int(11) NOT NULL auto_increment,
  'gid' int(11) NOT NULL default '0',
  'numplayers' int(11) NOT NULL default '0',
  'champion' text NOT NULL,
  'datestarted' int(10) NOT NULL default '0',
  'url_discut' varchar(250) NOT NULL default '',
  'demare' tinyint(1) NOT NULL default '0',
  'creat' varchar(30) NOT NULL default '',
  'plibre' tinyint(1) NOT NULL default '0',
  'nbtries' tinyint(1) NOT NULL default '3',
  UNIQUE KEY 'tid' ('tid')
) TYPE=MyISAM;


INSERT INTO 'ipb_games_settings' VALUES ('1', 'gtitle', 'ASC', '10', '0', '0', '1', '0', 'top', 0);
INSERT INTO 'ipb_games_cats' VALUES ('1', 'General', '1');

ALTER TABLE 'ipb_sessions' ADD 'in_game' VARCHAR( 32 ) NOT NULL;
ALTER TABLE 'ipb_members' ADD 'arcade_ban' tinyint(1) DEFAULT '0' NOT NULL;
ALTER TABLE 'ipb_members' ADD 'times_played' int(11) DEFAULT '0' NOT NULL;


Quelqu'un saurait où est le problème?
Il doit y avoir une erreur dans la syntaxe mais je ne vois pas où...

1 réponse

Mimouuu Messages postés 4 Statut Membre 1
 
Excusez-moi j'ai réécrit 2 fois le même sujet sans le vouloir.
1