bug mos user store failed

16 years 7 months ago #44535 by pierredemarque
Replied by pierredemarque on topic Re:bug mos user store failed
sorry it was in "rar"
here

Attachment repairuseracl-7ff1c1e539f4df3f63e3ebfdf167ee85.zip not found

Attachments:

Please Log in to join the conversation.

16 years 7 months ago #44560 by beat
Replied by beat on topic Re:bug mos user store failed
Thanks for sharing. We will see if we can integrate such a tool in cb.

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

16 years 7 months ago #44561 by beat
Replied by beat on topic Re:bug mos user store failed
pierredemarque wrote:

hello the comunity !

when i whant to edit any members
i get that
i had looking for this problem and i didn't found

mosuser::store failed
Unknown column \'params\' in \'field list\' SQL=UPDATE jos_users SET `name`=\'bro\',`username`=\'dor bugale evit ar\',`email`=\'s.brehu@voila.fr\',`usertype`=\'Author\',`block`=\'0\',`sendEmail`=\'1\',`gid`=\'19\',`params`=\'editor=\' WHERE id=\'2329\'

all registerd are like that
the website working very well
poeple can register evrey day
but i cannot edit them
if someone can hel me please?
cordially


It looks like your jos_users table is missing the column params.

Best is to check the table by comparing its structure to a new joomla install of same version using a tool like phpMyAdmin and then to fix it.

Do a backup first, and if unsure on how to do or how to restore backup, ask a pro to do it for you ;)

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

16 years 7 months ago #44574 by pierredemarque
Replied by pierredemarque on topic Re:bug mos user store failed
ok beat !!
i will check that know
hope can fix it .....
thanks for your answer
respect
pierre

Please Log in to join the conversation.

16 years 7 months ago #44604 by pierredemarque
Replied by pierredemarque on topic Re:bug mos user store failed
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

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.168 seconds

Facebook Twitter LinkedIn