probleme install sql mod phpbb

probleme install sql mod phpbb - SQL/NoSQL - Programmation

Marsh Posté le 21-03-2009 à 00:37:52    

Error at the line 24: ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
 
Query: CREATE TABLE IF NOT EXISTS `gwbbcode_rating` (
`rating_id` int(10) unsigned NOT NULL auto_increment,
`rating_build` varchar(40) NOT NULL,
`rating_value` tinyint(3) unsigned NOT NULL,
`rating_ip` varchar(25) NOT NULL,
PRIMARY KEY (`rating_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
 
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 'DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC' at line 7
 
Stopped on error
 
 
 
quelle estla bonne syntaxe de : ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
en sql 4....
 
 
??
 
merci à vous

Reply

Marsh Posté le 21-03-2009 à 00:37:52   

Reply

Marsh Posté le 21-03-2009 à 12:42:50    

Si j'enleve raw_format=dynamic j'ai :
 

Code :
  1. requête SQL:
  2. # --------------------------------------------------------
  3. # Table structure for table 'gwbbcode_rating'
  4. # --------------------------------------------------------
  5. CREATE TABLE IF NOT EXISTS `gwbbcode_rating` (
  6. `rating_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
  7. `rating_build` varchar( 40 ) NOT NULL ,
  8. `rating_value` tinyint( 3 ) unsigned NOT NULL ,
  9. `rating_ip` varchar( 25 ) NOT NULL ,
  10. PRIMARY KEY ( `rating_id` )
  11. ) ENGINE = InnoDB DEFAULT CHARSET = utf8
  12. MySQL a répondu:Documentation
  13. #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 'DEFAULT CHARSET=utf8' at line 10


 
si j'enleve DEFAULT CHARSET=utf8 j'ai :
 

Code :
  1. requête SQL:
  2. # --------------------------------------------------------
  3. # Table structure for table 'gwbbcode_skill'
  4. # --------------------------------------------------------
  5. CREATE TABLE `gwbbcode_skill` (
  6. `skill_id` smallint( 6 ) NOT NULL default '0',
  7. `skill_name` varchar( 75 ) NOT NULL ,
  8. `skill_sanitized` varchar( 75 ) NOT NULL ,
  9. `skill_prof` tinyint( 4 ) default '0',
  10. `skill_attr` tinyint( 4 ) default '99',
  11. `skill_special` tinyint( 4 ) default '0',
  12. `skill_pve` tinyint( 4 ) default '0',
  13. `skill_version` tinyint( 4 ) default '0',
  14. `skill_related` smallint( 6 ) default '0',
  15. `skill_title` tinyint( 4 ) default '0',
  16. `skill_type` tinyint( 4 ) default '0',
  17. `skill_elite` tinyint( 4 ) default '0',
  18. `skill_campaign` tinyint( 4 ) default '0',
  19. `skill_desc` varchar( 500 ) default '',
  20. `skill_desc_c` varchar( 500 ) default '',
  21. `skill_adre` tinyint( 4 ) default '0',
  22. `skill_ener` tinyint( 4 ) default '0',
  23. `skill_cast` float default '0',
  24. `skill_rech` float default '0',
  25. `skill_ereg` tinyint( 4 ) default '0',
  26. `skill_exhaust` tinyint( 4 ) default '0',
  27. `skill_sacri` tinyint( 4 ) default '0',
  28. PRIMARY KEY ( `skill_id` )
  29. ) ENGINE = InnoDB
  30. MySQL a répondu:Documentation
  31. #1074 - Too big column length for column 'skill_desc' (max = 255). Use BLOB instead


 
 
 
 H E L P !!!!!!


Message édité par leevf101 le 21-03-2009 à 12:43:49
Reply

Marsh Posté le 26-03-2009 à 16:48:13    

la seule pseudo solution à été de mettre :
 
ENGINE=InnoDB CHARSET=latin7 ROW_FORMAT=DYNAMIC
 
 
le DEFAULT n'est pas reconnu en sql 4

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed