probleme install sql mod phpbb

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 :

requête SQL:
# --------------------------------------------------------
# Table structure for table 'gwbbcode_rating'
# --------------------------------------------------------
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
MySQL a répondu:Documentation
#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 :

requête SQL:
# --------------------------------------------------------
# Table structure for table 'gwbbcode_skill'
# --------------------------------------------------------
CREATE TABLE `gwbbcode_skill` (
`skill_id` smallint( 6 ) NOT NULL default '0',
`skill_name` varchar( 75 ) NOT NULL ,
`skill_sanitized` varchar( 75 ) NOT NULL ,
`skill_prof` tinyint( 4 ) default '0',
`skill_attr` tinyint( 4 ) default '99',
`skill_special` tinyint( 4 ) default '0',
`skill_pve` tinyint( 4 ) default '0',
`skill_version` tinyint( 4 ) default '0',
`skill_related` smallint( 6 ) default '0',
`skill_title` tinyint( 4 ) default '0',
`skill_type` tinyint( 4 ) default '0',
`skill_elite` tinyint( 4 ) default '0',
`skill_campaign` tinyint( 4 ) default '0',
`skill_desc` varchar( 500 ) default '',
`skill_desc_c` varchar( 500 ) default '',
`skill_adre` tinyint( 4 ) default '0',
`skill_ener` tinyint( 4 ) default '0',
`skill_cast` float default '0',
`skill_rech` float default '0',
`skill_ereg` tinyint( 4 ) default '0',
`skill_exhaust` tinyint( 4 ) default '0',
`skill_sacri` tinyint( 4 ) default '0',
PRIMARY KEY ( `skill_id` )
) ENGINE = InnoDB
MySQL a répondu:Documentation
#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

probleme install sql mod phpbb

Sujets relatifs:

Leave a Replay