香港独立IP空间
香港php空间
美国php空间
域名注册

人生总是充满了各种意外组成的,就比如升级一个网站吧,一不小心就把个人资料还有栏目分组给丢失了,这个问题可急坏了一个苦逼的站长,今天无忧小编就把解决这个问题作为一个案例跟大家讲讲这个问题:

这块主要导致的原因是升级过程中栏目分组丢失导致无法显示,尤其是出现在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网站怎么办?网站被黑导致啊不收录

 

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

喜欢本文或觉得本文对您有帮助,请分享给您的朋友 ^_^

阅读本文的人还阅读:


搜索技术文档