泉州师范学院论坛

 找回密码
 注册会员

扫一扫,访问微社区

查看: 45|回复: 0

Discuz GBK转编码utf8后 个人资料页只剩下用户名修复教程

[复制链接]
剑指寒江 发表于 2019-9-3 13:03:10 | 显示全部楼层 |阅读模式
Discuz GBK转编码utf8后 个人资料页空白,只剩下一个用户名,其它丢失数据解决方案
DZ论坛由GBK转UTF8编码后。可能会出现一些问题:比如,

积分设置方案丢失
论坛SEO丢失
手机论坛设置丢失

以上等注意事先 记忆一下就行。哈哈
但是还有一个问题,就是会员去设置个人资料设置,就只显示用户名了 一片空白。根本无法修改自己的个人资料。
需要手动进入MYSQL数据库,找到pre_common_setting 里面的 profilegroup字段。
添加以下svalue 值
UTF8版本 profilegroup字段的 svalue值:
  1. a:5:{s:4:"base";a:4:{s:9:"available";i:1;s:12:"displayorder";i:0;s:5:"title";s:12:"基本资料";s:5:"field";a:17:{s:8:"realname";s:8:"realname";s:6:"gender";s:6:"gender";s:8:"birthday";s:8:"birthday";s:9:"birthcity";s:9:"birthcity";s:10:"residecity";s:10:"residecity";s:10:"residedist";s:10:"residedist";s:15:"affectivestatus";s:15:"affectivestatus";s:10:"lookingfor";s:10:"lookingfor";s:9:"bloodtype";s:9:"bloodtype";s:6:"field1";s:6:"field1";s:6:"field2";s:6:"field2";s:6:"field3";s:6:"field3";s:6:"field4";s:6:"field4";s:6:"field5";s:6:"field5";s:6:"field6";s:6:"field6";s:6:"field7";s:6:"field7";s:6:"field8";s:6:"field8";}}s:7:"contact";a:4:{s:5:"title";s:12:"联系方式";s:9:"available";s:1:"1";s:12:"displayorder";s:1:"1";s:5:"field";a:7:{s:9:"telephone";s:9:"telephone";s:6:"mobile";s:6:"mobile";s:3:"icq";s:3:"icq";s:2:"qq";s:2:"qq";s:5:"yahoo";s:5:"yahoo";s:3:"msn";s:3:"msn";s:6:"taobao";s:6:"taobao";}}s:3:"edu";a:4:{s:9:"available";i:1;s:12:"displayorder";i:2;s:5:"title";s:12:"教育情况";s:5:"field";a:2:{s:14:"graduateschool";s:14:"graduateschool";s:9:"education";s:9:"education";}}s:4:"work";a:4:{s:9:"available";i:1;s:12:"displayorder";i:3;s:5:"title";s:12:"工作情况";s:5:"field";a:4:{s:10:"occupation";s:10:"occupation";s:7:"company";s:7:"company";s:8:"position";s:8:"position";s:7:"revenue";s:7:"revenue";}}s:4:"info";a:4:{s:5:"title";s:12:"个人信息";s:9:"available";s:1:"1";s:12:"displayorder";s:1:"4";s:5:"field";a:10:{s:10:"idcardtype";s:10:"idcardtype";s:6:"idcard";s:6:"idcard";s:7:"address";s:7:"address";s:7:"zipcode";s:7:"zipcode";s:4:"site";s:4:"site";s:3:"bio";s:3:"bio";s:8:"interest";s:8:"interest";s:7:"sightml";s:7:"sightml";s:12:"customstatus";s:12:"customstatus";s:10:"timeoffset";s:10:"timeoffset";}}}');
复制代码
后台更新一下就OK,再回去设置个人资料试试。
另外注意,上面是UTF8版的。。 如果是发现GBK版的空白,profilegroup的svalue要用下面的。

  1. a:5:{s:4:"base";a:4:{s:5:"title";s:8:"基本资料";s:9:"available";s:1:"1";s:12:"displayorder";s:1:"0";s:5:"field";a:8:{s:8:"realname";s:8:"realname";s:6:"gender";s:6:"gender";s:8:"birthday";s:8:"birthday";s:2:"qq";s:2:"qq";s:15:"affectivestatus";s:15:"affectivestatus";s:6:"field1";s:6:"field1";s:6:"field2";s:6:"field2";s:7:"sightml";s:7:"sightml";}}s:7:"contact";a:4:{s:5:"title";s:8:"联系方式";s:9:"available";s:1:"1";s:12:"displayorder";s:1:"1";s:5:"field";a:6:{s:6:"idcard";s:6:"idcard";s:6:"mobile";s:6:"mobile";s:7:"company";s:7:"company";s:14:"graduateschool";s:14:"graduateschool";s:10:"residecity";s:10:"residecity";s:10:"timeoffset";s:10:"timeoffset";}}s:3:"edu";a:4:{s:9:"available";i:0;s:12:"displayorder";s:1:"2";s:5:"title";s:8:"教育情况";s:5:"field";a:2:{s:9:"education";s:9:"education";s:14:"graduateschool";s:14:"graduateschool";}}s:4:"work";a:4:{s:9:"available";i:0;s:12:"displayorder";s:1:"3";s:5:"title";s:8:"工作情况";s:5:"field";a:4:{s:10:"occupation";s:10:"occupation";s:7:"company";s:7:"company";s:8:"position";s:8:"position";s:7:"revenue";s:7:"revenue";}}s:4:"info";a:4:{s:5:"title";s:8:"个人信息";s:9:"available";i:0;s:12:"displayorder";s:1:"4";s:5:"field";a:9:{s:10:"idcardtype";s:10:"idcardtype";s:7:"address";s:7:"address";s:7:"zipcode";s:7:"zipcode";s:4:"site";s:4:"site";s:8:"interest";s:8:"interest";s:3:"bio";s:3:"bio";s:7:"sightml";s:7:"sightml";s:12:"customstatus";s:12:"customstatus";s:10:"timeoffset";s:10:"timeoffset";}}}
复制代码

原因在于,GBK四个汉字占8个字符,UTF8四个汉字占12个字符,s:8:"基本资料",在UTF8里面就是 要写成 s:12:
需要GBK转UTF8   或者搬家。 数据不大的,可以联系 not free。数据太大我懒。
im im
ut8私人专用 无视
  1. a:5:{s:4:"base";a:4:{s:5:"title";s:12:"基本资料";s:9:"available";s:1:"1";s:12:"displayorder";s:1:"0";s:5:"field";a:7:{s:8:"realname";s:8:"realname";s:6:"gender";s:6:"gender";s:8:"birthday";s:8:"birthday";s:2:"qq";s:2:"qq";s:15:"affectivestatus";s:15:"affectivestatus";s:6:"field1";s:6:"field1";s:7:"sightml";s:7:"sightml";}}s:7:"contact";a:4:{s:5:"title";s:12:"联系方式";s:9:"available";s:1:"1";s:12:"displayorder";s:1:"1";s:5:"field";a:6:{s:6:"idcard";s:6:"idcard";s:6:"mobile";s:6:"mobile";s:7:"company";s:7:"company";s:14:"graduateschool";s:14:"graduateschool";s:10:"residecity";s:10:"residecity";s:10:"timeoffset";s:10:"timeoffset";}}s:3:"edu";a:4:{s:9:"available";i:0;s:12:"displayorder";s:1:"2";s:5:"title";s:12:"教育情况";s:5:"field";a:2:{s:9:"education";s:9:"education";s:14:"graduateschool";s:14:"graduateschool";}}s:4:"work";a:4:{s:5:"title";s:12:"工作情况";s:9:"available";i:0;s:12:"displayorder";s:1:"3";s:5:"field";a:0:{}}s:4:"info";a:4:{s:5:"title";s:12:"个人信息";s:9:"available";i:0;s:12:"displayorder";s:1:"4";s:5:"field";a:7:{s:10:"idcardtype";s:10:"idcardtype";s:2:"qq";s:2:"qq";s:7:"address";s:7:"address";s:9:"telephone";s:9:"telephone";s:7:"sightml";s:7:"sightml";s:12:"customstatus";s:12:"customstatus";s:10:"timeoffset";s:10:"timeoffset";}}}
复制代码


泉州师院论坛域名: www.Qzubbs.com 手机浏览器照样访问。
您需要登录后才可以回帖 登录 | 注册会员

本版积分规则

关于我们|免责声明|学校风景|企业招聘|二手市场|违规帐号|手机论坛|手机论坛|京ICP备10001858号|广告联系

Copyright 1958-2018 泉州大学 泉州师范学院 - 相聚西岸阳光,相遇、相识、相知;一起邂逅骄傲,梦想,未来!

GMT+8, 2019-9-18 16:10 , Processed in 0.031357 second(s), 8 queries , Gzip On, MemCached On.

快速回复 返回顶部 返回列表