用户栏目个人资料只真实姓名的异常处理

石鑫华视觉

打开数据库，发现在pre_common_member_profile_setting表中，只有真实姓名、出生地、出生县等少量几行。可以将这些数据全部删除。然后打开discuz的全新安装包，查找到\upload\install\data\install_data.sql数据库文件，鼠标右键编辑（文件比较小，可以直接使用txt来编辑），然后查找pre_common_member_profile_setting关键字，可以得到以下内容：

INSERT INTO pre_common_member_profile_setting VALUES('realname', 1, 0, 0, '真实姓名', '', 0, 0, 0, 0, 0, 0, 1, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('gender', 1, 0, 0, '性别', '', 0, 0, 0, 0, 0, 0, 1, 'select', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('birthyear', 1, 0, 0, '出生年份', '', 0, 0, 0, 0, 0, 0, 1, 'select', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('birthmonth', 1, 0, 0, '出生月份', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('birthday', 1, 0, 0, '生日', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('constellation', 1, 1, 0, '星座', '星座(根据生日自动计算)', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('zodiac', 1, 1, 0, '生肖', '生肖(根据生日自动计算)', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('telephone', 1, 1, 0, '固定电话', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('mobile', 1, 1, 0, '手机', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('idcardtype', 1, 1, 0, '证件类型', '身份证 护照 驾驶证等', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '身份证\n护照\n驾驶证', '');
INSERT INTO pre_common_member_profile_setting VALUES('idcard', 1, 1, 0, '证件号', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('address', 1, 1, 0, '邮寄地址', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('zipcode', 1, 1, 0, '邮编', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('nationality', 0, 0, 0, '国籍', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('birthprovince', 1, 0, 0, '出生省份', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('birthcity', 1, 0, 0, '出生地', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('birthdist', 1, 0, 0, '出生县', '出生行政区/县', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('birthcommunity', 1, 0, 0, '出生小区', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('resideprovince', 1, 0, 0, '居住省份', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('residecity', 1, 0, 0, '居住地', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('residedist', 1, 0, 0, '居住县', '居住行政区/县', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('residecommunity', 1, 0, 0, '居住小区', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('residesuite', 0, 0, 0, '房间', '小区、写字楼门牌号', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('graduateschool', 1, 0, 0, '毕业学校', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('education', 1, 0, 0, '学历', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '博士\n硕士\n本科\n专科\n中学\n小学\n其它', '');
INSERT INTO pre_common_member_profile_setting VALUES('company', 1, 0, 0, '公司', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('occupation', 1, 0, 0, '职业', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('position', 1, 0, 0, '职位', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('revenue', 1, 1, 0, '年收入', '单位 元', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('affectivestatus', 1, 1, 0, '情感状态', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('lookingfor', 1, 0, 0, '交友目的', '希望在网站找到什么样的朋友', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('bloodtype', 1, 1, 0, '血型', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, 'A\nB\nAB\nO\n其它', '');
INSERT INTO pre_common_member_profile_setting VALUES('height', 0, 1, 0, '身高', '单位 cm', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('weight', 0, 1, 0, '体重', '单位 kg', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('alipay', 1, 1, 0, '支付宝', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('icq', 0, 1, 0, 'ICQ', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('qq', 1, 1, 0, 'QQ', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('yahoo', 0, 1, 0, 'YAHOO帐号', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('msn', 1, 1, 0, 'MSN', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('taobao', 1, 1, 0, '阿里旺旺', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('site', 1, 0, 0, '个人主页', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('bio', 1, 1, 0, '自我介绍', '', 0, 0, 0, 0, 0, 0, 0, 'textarea', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('interest', 1, 0, 0, '兴趣爱好', '', 0, 0, 0, 0, 0, 0, 0, 'textarea', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('field1', 0, 1, 0, '自定义字段1', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('field2', 0, 1, 0, '自定义字段2', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('field3', 0, 1, 0, '自定义字段3', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('field4', 0, 1, 0, '自定义字段4', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('field5', 0, 1, 0, '自定义字段5', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('field6', 0, 1, 0, '自定义字段6', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('field7', 0, 1, 0, '自定义字段7', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
INSERT INTO pre_common_member_profile_setting VALUES('field8', 0, 1, 0, '自定义字段8', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');



将这些内容复制到php执行语句或者是Discuz的数据库升级中，将新的用户栏目插入到上面的表中即可出现完整的用户栏目。