Jump to content
×
×
  • Create New...
  • 0

[Résolu][Windows]Problème BDD


tomorow

Question

Bonjour, quand je rempli ma BDD au_server_gs en mettant le document sql au_server_gs

 

Sa me met :

[Err] 1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

[Err] -- ----------------------------

-- server_variables

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

 

CREATE TABLE IF NOT EXISTS `server_variables` (

`key` varchar(30) NOT NULL,

`value` varchar(30) NOT NULL,

PRIMARY KEY (`key`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[Msg] Finished - Unsuccessfully

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

Link to comment
  • Answers 15
  • Created
  • Last Reply

Top Posters For This Question

Top Posters For This Question

15 answers to this question

Recommended Posts

  • 0

Ok merci, j'essaye sa et j'edit le message pour vous dire le résultat =)

 

EDIT : Toujours une erreur , ma ligne est comme sa ENGINE=MyISAM DEFAULT CHARSET=utf8;


Maintenant :

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

-- player_titles

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

CREATE TABLE IF NOT EXISTS `player_titles` (

`player_id` int(11) NOT NULL,

`title_id` in

 

 

EDIT : Pardon pour le double post

Link to comment
  • 0

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

-- player_titles

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

CREATE TABLE IF NOT EXISTS `player_titles` (

`player_id` int(11) NOT NULL,

`title_id` in

[Msg] Finished - Unsuccessfully

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

 

Je préviens que j'ai changer tous les InnoDB par des MyISAM

Link to comment
  • 0

Ben l'erreur dans Navicat sa me met : au début :

[Err] 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 IF NOT EXISTS `players` (

`id` int(11) NOT NULL,

`name` varch' at line 15

[Err] -- ----------------------------

-- server_variables

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

 

CREATE TABLE IF NOT EXISTS `server_variables` (

`key` varchar(30) NOT NULL,

`value` varchar(30) NOT NULL,

PRIMARY KEY (`key`)

) ENGINE=MyISAM

 

et a la fin :

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

-- player_titles

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

CREATE TABLE IF NOT EXISTS `player_titles` (

`player_id` int(11) NOT NULL,

`title_id` in

[Msg] Finished - Unsuccessfully

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

 

Fichier de log = ?

Link to comment
  • 0

Nouveau problème cette fois pour login server. Quand je met au_server_ls dans ma BDD au_server_ls sa me fait :

`membership` tinyint(3) NOT NULL default '0',

`last_server` tinyint(3) NOT NULL default '-1',

`last_ip` varchar(20) default NULL,

`ip_force` varchar(20) default NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`)

) ENGINE=MyISMA DEFAULT CHARSET=utf8;

[Msg] Finished - Unsuccessfully

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

Link to comment


  • Flux d'Activité

    1. 29

      Rodnia.net | PVM | International | The Great Conqueror |

    2. 0

      [Funding/Incubator Program] W Combinator

    3. 25

      File Bvural41 (PAYANT) lvl 1-120 - Multi-Language

    4. 25

      File Bvural41 (PAYANT) lvl 1-120 - Multi-Language

    5. 9

      Canal général

    6. 9

      Canal général

    7. 9

      Canal général

    8. 9

      Canal général

    9. 9

      Canal général

  • Recently Browsing

    No registered users viewing this page.

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.