hello beat !
i had make fresh install of joomla "local"
& install CB for compare with the new bdd...
but it's completement different.....
this is my table user
maybe someone can see the problem:P
# Tabellenstructure for `jos_users`
#
# ===============================================================
DROP TABLE IF EXISTS `jos_users`;
CREATE TABLE IF NOT EXISTS `jos_users` (
`id` mediumint(8) NOT NULL auto_increment,
`user_active` tinyint(1) default '1',
`username` varchar(25) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`usertype` varchar(25) NOT NULL default '',
`block` tinyint(4) NOT NULL default '0',
`sendEmail` tinyint(4) default '1',
`gid` tinyint(3) unsigned NOT NULL default '1',
`registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_lastvisit` int(11) NOT NULL default '0',
`user_regdate` int(11) NOT NULL default '0',
`user_level` tinyint(4) default '0',
`user_posts` mediumint(8) unsigned NOT NULL default '0',
`user_timezone` decimal(5,2) NOT NULL default '0.00',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) default NULL,
`user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_viewemail` tinyint(1) default NULL,
`user_attachsig` tinyint(1) default NULL,
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(1) NOT NULL default '1',
`user_notify_pm` tinyint(1) NOT NULL default '0',
`user_popup_pm` tinyint(1) NOT NULL default '0',
`user_rank` int(11) default '0',
`user_avatar` varchar(100) default NULL,
`user_avatar_type` tinyint(4) NOT NULL default '0',
`email` varchar(255) default NULL,
`user_icq` varchar(15) default NULL,
`user_website` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_from_flag` varchar(25) default NULL,
`user_sig` text,
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_aim` varchar(255) default NULL,
`user_yim` varchar(255) default NULL,
`user_msnm` varchar(255) default NULL,
`user_occ` varchar(100) default NULL,
`user_interests` varchar(255) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`activation` varchar(200) NOT NULL default '''''',
PRIMARY KEY (`id`),
KEY `user_session_time` (`user_session_time`),
KEY `usertype` (`usertype`),
KEY `email_2` (`email`),
KEY `activation` (`activation`),
KEY `block` (`block`),
KEY `gid` (`gid`),
KEY `id` (`id`),
KEY `lastvisitDate` (`lastvisitDate`),
KEY `name` (`name`),
KEY `password` (`password`),
KEY `registerDate` (`registerDate`),
KEY `sendEmail` (`sendEmail`),
KEY `user_active` (`user_active`),
KEY `user_actkey` (`user_actkey`),
KEY `user_aim` (`user_aim`),
KEY `user_allow_pm` (`user_allow_pm`),
KEY `user_allow_viewonline` (`user_allow_viewonline`),
KEY `user_allowavatar` (`user_allowavatar`),
KEY `user_allowbbcode` (`user_allowbbcode`),
KEY `user_allowhtml` (`user_allowhtml`),
KEY `user_allowsmile` (`user_allowsmile`),
KEY `user_attachsig` (`user_attachsig`),
KEY `user_avatar` (`user_avatar`),
KEY `user_avatar_type` (`user_avatar_type`),
KEY `user_dateformat` (`user_dateformat`),
KEY `user_emailtime` (`user_emailtime`),
KEY `user_from` (`user_from`),
KEY `user_from_flag` (`user_from_flag`),
KEY `user_icq` (`user_icq`),
KEY `user_interests` (`user_interests`),
FULLTEXT KEY `email` (`email`)
) TYPE=MyISAM AUTO_INCREMENT=3633;
pierre
plugins-audio.com
regard