用户组无法设置，无法编辑【谢谢玻璃屋女孩】

玻璃屋女孩 · 发表于 2009-11-15 17:32:06

用pma登录uchome的数据库，执行下面的SQL语句

DROP TABLE IF EXISTS uchome_usergroup ;
CREATE TABLE uchome_usergroup (
gid smallint(6) unsigned NOT NULL auto_increment,
grouptitle varchar(20) NOT NULL default '',
system tinyint(1) NOT NULL default '0',
banvisit tinyint(1) NOT NULL default '0',
explower int(10) NOT NULL default '0',
maxfriendnum smallint(6) unsigned NOT NULL default '0',
maxattachsize int(10) unsigned NOT NULL default '0',
allowhtml tinyint(1) NOT NULL default '0',
allowcomment tinyint(1) NOT NULL default '0',
searchinterval smallint(6) unsigned NOT NULL default '0',
searchignore tinyint(1) NOT NULL default '0',
postinterval smallint(6) unsigned NOT NULL default '0',
spamignore tinyint(1) NOT NULL default '0',
videophotoignore tinyint(1) NOT NULL default '0',
allowblog tinyint(1) NOT NULL default '0',
allowdoing tinyint(1) NOT NULL default '0',
allowupload tinyint(1) NOT NULL default '0',
allowshare tinyint(1) NOT NULL default '0',
allowmtag tinyint(1) NOT NULL default '0',
allowthread tinyint(1) NOT NULL default '0',
allowpost tinyint(1) NOT NULL default '0',
allowcss tinyint(1) NOT NULL default '0',
allowpoke tinyint(1) NOT NULL default '0',
allowfriend tinyint(1) NOT NULL default '0',
allowpoll tinyint(1) NOT NULL default '0',
allowclick tinyint(1) NOT NULL default '0',
allowevent tinyint(1) NOT NULL default '0',
allowmagic tinyint(1) NOT NULL default '0',
allowpm tinyint(1) NOT NULL default '0',
allowviewvideopic tinyint(1) NOT NULL default '0',
allowmyop tinyint(1) NOT NULL default '0',
allowtopic tinyint(1) NOT NULL default '0',
allowstat tinyint(1) NOT NULL default '0',
magicdiscount tinyint(1) NOT NULL default '0',
verifyevent tinyint(1) NOT NULL default '0',
edittrail tinyint(1) NOT NULL default '0',
domainlength smallint(6) unsigned NOT NULL default '0',
closeignore tinyint(1) NOT NULL default '0',
seccode tinyint(1) NOT NULL default '0',
color varchar(10) NOT NULL default '',
icon varchar(100) NOT NULL default '',
manageconfig tinyint(1) NOT NULL default '0',
managenetwork tinyint(1) NOT NULL default '0',
manageprofilefield tinyint(1) NOT NULL default '0',
manageprofield tinyint(1) NOT NULL default '0',
manageusergroup tinyint(1) NOT NULL default '0',
managefeed tinyint(1) NOT NULL default '0',
manageshare tinyint(1) NOT NULL default '0',
managedoing tinyint(1) NOT NULL default '0',
manageblog tinyint(1) NOT NULL default '0',
managetag tinyint(1) NOT NULL default '0',
managetagtpl tinyint(1) NOT NULL default '0',
managealbum tinyint(1) NOT NULL default '0',
managecomment tinyint(1) NOT NULL default '0',
managemtag tinyint(1) NOT NULL default '0',
managethread tinyint(1) NOT NULL default '0',
manageevent tinyint(1) NOT NULL default '0',
manageeventclass tinyint(1) NOT NULL default '0',
managecensor tinyint(1) NOT NULL default '0',
managead tinyint(1) NOT NULL default '0',
managesitefeed tinyint(1) NOT NULL default '0',
managebackup tinyint(1) NOT NULL default '0',
manageblock tinyint(1) NOT NULL default '0',
managetemplate tinyint(1) NOT NULL default '0',
managestat tinyint(1) NOT NULL default '0',
managecache tinyint(1) NOT NULL default '0',
managecredit tinyint(1) NOT NULL default '0',
managecron tinyint(1) NOT NULL default '0',
managename tinyint(1) NOT NULL default '0',
manageapp tinyint(1) NOT NULL default '0',
managetask tinyint(1) NOT NULL default '0',
managereport tinyint(1) NOT NULL default '0',
managepoll tinyint(1) NOT NULL default '0',
manageclick tinyint(1) NOT NULL default '0',
managemagic tinyint(1) NOT NULL default '0',
managemagiclog tinyint(1) NOT NULL default '0',
managebatch tinyint(1) NOT NULL default '0',
managedelspace tinyint(1) NOT NULL default '0',
managetopic tinyint(1) NOT NULL default '0',
manageip tinyint(1) NOT NULL default '0',
managehotuser tinyint(1) NOT NULL default '0',
managedefaultuser tinyint(1) NOT NULL default '0',
managespacegroup tinyint(1) NOT NULL default '0',
managespaceinfo tinyint(1) NOT NULL default '0',
managespacecredit tinyint(1) NOT NULL default '0',
managespacenote tinyint(1) NOT NULL default '0',
managevideophoto tinyint(1) NOT NULL default '0',
managelog tinyint(1) NOT NULL default '0',
magicaward text NOT NULL,
PRIMARY KEY (gid)
) ENGINE=MyISAM;

复制代码

81os · 发表于 2009-11-15 18:44:03

谢谢，我试试去

81os · 发表于 2009-11-15 18:46:40

晕，执行完了，用户组又空了……

81os · 发表于 2009-11-15 18:49:18

受不了……

玻璃屋女孩 · 发表于 2009-11-15 22:52:44

执行下面的代码

INSERT INTO `uchome_usergroup` (`gid`, `grouptitle`, `system`, `banvisit`, `explower`, `maxfriendnum`, `maxattachsize`, `allowhtml`, `allowcomment`, `searchinterval`, `searchignore`, `postinterval`, `spamignore`, `videophotoignore`, `allowblog`, `allowdoing`, `allowupload`, `allowshare`, `allowmtag`, `allowthread`, `allowpost`, `allowcss`, `allowpoke`, `allowfriend`, `allowpoll`, `allowclick`, `allowevent`, `allowmagic`, `allowpm`, `allowviewvideopic`, `allowmyop`, `allowtopic`, `allowstat`, `magicdiscount`, `verifyevent`, `edittrail`, `domainlength`, `closeignore`, `seccode`, `color`, `icon`, `manageconfig`, `managenetwork`, `manageprofilefield`, `manageprofield`, `manageusergroup`, `managefeed`, `manageshare`, `managedoing`, `manageblog`, `managetag`, `managetagtpl`, `managealbum`, `managecomment`, `managemtag`, `managethread`, `manageevent`, `manageeventclass`, `managecensor`, `managead`, `managesitefeed`, `managebackup`, `manageblock`, `managetemplate`, `managestat`, `managecache`, `managecredit`, `managecron`, `managename`, `manageapp`, `managetask`, `managereport`, `managepoll`, `manageclick`, `managemagic`, `managemagiclog`, `managebatch`, `managedelspace`, `managetopic`, `manageip`, `managehotuser`, `managedefaultuser`, `managespacegroup`, `managespaceinfo`, `managespacecredit`, `managespacenote`, `managevideophoto`, `managelog`, `magicaward`) VALUES
(1, '站点管理员', -1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 1, 1, 0, 'red', 'image/group/admin.gif', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, ''),
(2, '信息管理员', -1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, 1, 0, 'blue', 'image/group/infor.gif', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(3, '贵宾VIP', 1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 3, 0, 0, 'green', 'image/group/vip.gif', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(4, '受限会员', 0, 0, -999999999, 10, 10, 0, 0, 600, 0, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(5, '普通会员', 0, 0, 0, 1, 20, 0, 1, 60, 0, 60, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'a:0:{}'),
(6, '中级会员', 0, 0, 100, 200, 50, 0, 1, 30, 0, 30, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 5, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(7, '高级会员', 0, 0, 1000, 300, 100, 1, 1, 10, 1, 10, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 3, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(8, '禁止发言', -1, 0, 0, 1, 1, 0, 0, 9999, 0, 9999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 99, 0, 1, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(9, '禁止访问', -1, 1, 0, 1, 1, 0, 0, 9999, 0, 9999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 99, 0, 1, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');

复制代码

81os · 发表于 2009-11-16 09:43:46

谢谢，我再试试……

81os · 发表于 2009-11-16 09:47:21

执行后提示：

提示信息
Duplicate entry '1' for key 1

后台仍然看不到……

81os · 发表于 2009-11-16 09:49:25

非常感谢这位可爱的女孩，问题解决了，太感谢了！

玻璃屋女孩 · 发表于 2009-11-16 09:50:46

你打开这个表，看一下都有哪些用户组

81os · 发表于 2009-11-16 09:52:10

非常感谢，问题解决了，我已经修改了标题。

		自动登录	找回密码
密码			立即注册

[已解决] 用户组无法设置，无法编辑【谢谢玻璃屋女孩】