Merci MUSS
oui j'avais rajouté TYPE=MyISAM a la fin de chaque table mais cela ne change pas mon probleme vu que j'ai fais des modifs je vous repost mes 2 fichiers
le fichier SQL :
#
# Structure de la table `xoopsmessenger_user`
#
CREATE TABLE `xoopsmessenger_user` (
`id` int(11) NOT NULL auto_increment,
`username` char(255) default NULL,
`userpass` char(255) default NULL,
`userid` int(11) default NULL,
`useremail` char(255) default NULL,
`userface` varchar(255) default 'default.gif',
`usersign` char(255) default 'Nothing',
`userstatus` int(11) default '7',
`lastonlinetime` datetime default NULL,
`usergender` int(11) default '1',
`userpower` int(11) default '2',
`syscode` int(11) default '0',
PRIMARY KEY (`id`),
KEY `syscode` (`syscode`),
KEY `userid` (`userid`)
)TYPE=MyISAM;
#
# Structure de la table `xoopsmessenger_userconfig`
#
CREATE TABLE `xoopsmessenger_userconfig` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) default NULL,
`distype` int(11) default '1',
`ordertype` int(11) default '1',
`chatside` int(11) default '1',
`msgsendkey` int(11) default '1',
`showfocus` int(11) default '2',
`msgshowtime` int(11) default '1',
PRIMARY KEY (`id`),
KEY `msgsendkey` (`msgsendkey`),
KEY `userid` (`userid`)
)TYPE=MyISAM;
#
# Structure de la table `xoopsmessenger_userfriend`
#
CREATE TABLE `xoopsmessenger_userfriend` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) default NULL,
`friendid` int(11) default NULL,
`groupid` int(11) default '1',
`customname` char(255) default NULL,
`isblocked` int(11) default '2',
PRIMARY KEY (`id`),
KEY `friendid` (`friendid`),
KEY `groupid` (`groupid`),
KEY `userid` (`userid`)
)TYPE=MyISAM;
#
# Structure de la table `xoopsmessenger_usergroup`
#
CREATE TABLE `xoopsmessenger_usergroup` (
`id` int(11) NOT NULL auto_increment,
`groupname` char(255) default NULL,
`userid` int(11) default '-1',
PRIMARY KEY (`id`)
)TYPE=MyISAM;
#
# Structure de la table `xoopsmessenger_usermsg`
#
CREATE TABLE `xoopsmessenger_usermsg` (
`id` int(11) NOT NULL auto_increment,
`fromid` int(11) default NULL,
`toid` int(11) default NULL,
`msgcontent` longtext,
`isconfirm` int(11) default '2',
`typeid` int(11) default '1',
`msgaddtime` datetime default NULL,
`isread` int(11) default '2',
PRIMARY KEY (`id`),
KEY `typeid` (`fromid`),
KEY `typeid1` (`typeid`),
KEY `userid` (`toid`)
)TYPE=MyISAM;
#
# Structure de la table `xoopsmessenger_usernum`
#
CREATE TABLE `xoopsmessenger_usernum` (
`id` int(11) NOT NULL auto_increment,
`num` int(11) default NULL,
`isok` int(11) default '1',
PRIMARY KEY (`id`),
KEY `number` (`num`)
)TYPE=MyISAM;
#
# Structure de la table `xoopsmessenger_usersysmsg`
#
CREATE TABLE `xoopsmessenger_usersysmsg` (
`id` int(11) NOT NULL auto_increment,
`fromid` int(11) default NULL,
`toid` int(11) default NULL,
`msgcontent` longtext,
`isconfirm` int(11) default '2',
`typeid` int(11) default '1',
`msgaddtime` datetime default NULL,
`isread` int(11) default '2',
PRIMARY KEY (`id`),
KEY `typeid` (`fromid`),
KEY `typeid1` (`typeid`),
KEY `userid` (`toid`)
)TYPE=MyISAM;
mon xoops-version
<?php
$modversion['name'] = "xoops-messenger";
$modversion['version'] = 1.01;
$modversion['description'] = "messenger pour xoops";
$modversion['credits'] = "Xoops French Team pour la base,fleaim pour le script";
$modversion['author'] = "Bendenice";
$modversion['help'] = "";
$modversion['license'] = "GPL see LICENSE";
$modversion['official'] = 1;
$modversion['image'] = "docs_slogo.png";
$modversion['dirname'] = "xoopsmessenger";
// Menu
$modversion['hasMain'] = 1;
$modversion['hasAdmin'] = 1;
$modversion['adminindex'] = 'admin/index.php';
$modversion['adminmenu'] = 'admin/menu.php';
$modversion['hasMain'] = 1;
$modversion['sqlfile']['mysql'] = "sql/mysql.sql";
// Tables created by sql file (without prefix!)
$modversion['tables'][0] = "xoopsmessenger_user";
$modversion['tables'][1] = "xoopsmessenger_userconfig";
$modversion['tables'][2] = "xoopsmessenger_userfriend";
$modversion['tables'][3] = "xoopsmessenger_usergroup";
$modversion['tables'][4] = "xoopsmessenger_usermsg";
$modversion['tables'][5] = "xoopsmessenger_usernum";
$modversion['tables'][6] = "xoopsmessenger_usersysmsg";
?>