Bonjour je suis chez OVH
le probleme qui se pose la base SQL ne s'installe pas
pourtant tout semble se dérouler normalement
je vien d'essayer manuellement voila le resulta avec la premiere table
Le probleme semble venir de CHARACTER SET utf8 COLLATE utf8_unicode_ci
quelqu un aurai une idee/solution?
requête SQL:
CREATE TABLE action_recorder(
id INT NOT NULL AUTO_INCREMENT ,
module VARCHAR( 255 ) NOT NULL ,
user_id INT,
user_name VARCHAR( 255 ) ,
identifier VARCHAR( 255 ) NOT NULL ,
success CHAR( 1 ) ,
date_added DATETIME NOT NULL ,
PRIMARY KEY ( id ) ,
KEY idx_action_recorder_module( module ) ,
KEY idx_action_recorder_user_id( user_id ) ,
KEY idx_action_recorder_identifier( identifier ) ,
KEY idx_action_recorder_date_added( date_added )
) CHARACTER SET utf8 COLLATE utf8_unicode_ci
MySQL a répondu:
#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 'COLLATE utf8_unicode_ci' at line 14
Propulsé par Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)