升级DiscuzX3.2个人资料和栏目分组丢失的解决方法

人生总是充满了各种意外组成的，就比如升级一个网站吧，一不小心就把个人资料还有栏目分组给丢失了，这个问题可急坏了一个苦逼的站长，今天无忧小编就把解决这个问题作为一个案例跟大家讲讲这个问题： 这块主要导致的原因是升级过程中栏目分组丢失导致无法显示，尤其是出现在UTF8版本中   解决方法1：重新进行升级，使用下面附件中的update.php覆盖原有update.php。升级方法和原先相同。   解决方法2： 运行sql进行更新，记得把表前缀修改成自己的安装时的表前缀 REPLACE INTO `pre_common_setting` VALUES ('profilegroup', '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";}}}');   相信各位爷也看出了，这个sql语句比较复杂，所以无忧主机小编个人建议还是重新升级一遍来的方便点，就是耗费点时间。 无忧主机相关文章推荐阅读： DISCUZ X2.0升级X3.1后网站搜索模版重复错位 解决DISCUZ在IE11下发帖编辑器不完全显示问题 DISCUZ论坛网站从百度打开变成BC网站怎么办？网站被黑导致啊不收录  

本文地址：https://www.51php.com/discuz/14899.html