Hi edwin,
I renew my subscription of JMS and take multiusersite on the same way...
But when i install it, i got this :

JInstaller::Install : erreur SQL Fonction DB échouée avec le numéro d'erreur 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 'TYPE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8' at line 17 SQL=CREATE TABLE IF NOT EXISTS ..............

Have you an idea about this issue?
Regards,

You report an error in the MySQL statement but you didn't provide all the MySQL statement.
So it is difficult to tell you the reason.

Check the MySQL statement to identify what could be the cause.
For example, perhaps you put a special character in the table prefix.

Cela ne serait pas parce que ma BDD n'est pas en utf8 ?

Mais voici ce que j'ai en entier :


JInstaller::Install : erreur SQL Fonction DB échouée avec le numéro d'erreur 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 'TYPE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8' at line 17 SQL=CREATE TABLE IF NOT EXISTS `wer77_multisites_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL COMMENT 'reference to the joomla user id', `site_id` varchar(100) NOT NULL COMMENT 'reference to the MULTISITES_ID that created the record', `home` tinyint(1) NOT NULL default '0' COMMENT 'Default or home websites where the user were registered', `params` text NULL COMMENT 'Additional parameters.', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Creation date/time', `created_by` int(10) unsigned NULL COMMENT 'reference to the user id who created the record', `modified_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date/Time of the modification', `modified_by` int(10) unsigned NULL COMMENT 'reference to the user id who modified the record', PRIMARY KEY (`id`), KEY `idx_usersite` (`user_id`, `site_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `#__multisites_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL COMMENT 'reference to the joomla user id',
`site_id` varchar(100) NOT NULL COMMENT 'reference to the MULTISITES_ID that created the record',
`home` tinyint(1) NOT NULL default '0' COMMENT 'Default or home websites where the user were registered',
`params` text NULL COMMENT 'Additional parameters.',

`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Creation date/time',
`created_by` int(10) unsigned NULL COMMENT 'reference to the user id who created the record',
`modified_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date/Time of the modification',
`modified_by` int(10) unsigned NULL COMMENT 'reference to the user id who modified the record',

PRIMARY KEY (`id`),
KEY `idx_usersite` (`user_id`, `site_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
Installation d'un composant : erreur SQL du fichier Fonction DB échouée avec le numéro d'erreur 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 'TYPE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8' at line 17 SQL=CREATE TABLE IF NOT EXISTS `wer77_multisites_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL COMMENT 'reference to the joomla user id', `site_id` varchar(100) NOT NULL COMMENT 'reference to the MULTISITES_ID that created the record', `home` tinyint(1) NOT NULL default '0' COMMENT 'Default or home websites where the user were registered', `params` text NULL COMMENT 'Additional parameters.', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Creation date/time', `created_by` int(10) unsigned NULL COMMENT 'reference to the user id who created the record', `modified_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date/Time of the modification', `modified_by` int(10) unsigned NULL COMMENT 'reference to the user id who modified the record', PRIMARY KEY (`id`), KEY `idx_usersite` (`user_id`, `site_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `#__multisites_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL COMMENT 'reference to the joomla user id',
`site_id` varchar(100) NOT NULL COMMENT 'reference to the MULTISITES_ID that created the record',
`home` tinyint(1) NOT NULL default '0' COMMENT 'Default or home websites where the user were registered',
`params` text NULL COMMENT 'Additional parameters.',

`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Creation date/time',
`created_by` int(10) unsigned NULL COMMENT 'reference to the user id who created the record',
`modified_dt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date/Time of the modification',
`modified_by` int(10) unsigned NULL COMMENT 'reference to the user id who modified the record',

PRIMARY KEY (`id`),
KEY `idx_usersite` (`user_id`, `site_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

Oui je crois que c'est parce que la nouvelle base n'est pas en UTF8.
Vous lisez une base avec de l'UTF8 et vous essayé de la répliquer dans une autre base qui n'est pas UTF8. Donc la syntax SQL utilisée par MySQL lors de la création de la table dans la nouvelle base échoue à cause d'une erreur de syntaxe.

Est-ce que cette erreur apparait lors de l'installation du composant "Multisites User Site" ou lors de la réplication d'un site.