QQ互联插件乱码问题的解决方法

如果您网站的QQ互联插件出现乱码，肯定是由于插件编码出错导致的，您可以参考下面的方法解决。

请勿删除QQ互联插件目录和数据库里QQ互联插件记录，直接按下述方法操作即可。

注意：此方法仅适用于Discuz! X2.5版本，如果您的表前缀不是pre，请把下面执行的sql里的pre替换成您对应的表前缀，然后执行。

1.根据您网站的编码，选择执行下面对应的sql（需要在数据库里执行）。
简体GBK编码的站点：

1. UPDATE pre_common_plugin SET modules = 'a:6:{i:0;a:10:{s:4:"name";s:7:"connect";s:4:"menu";s:0:"";s:3:"url";s:0:"";s:4:"type";s:2:"11";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"0";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}i:1;a:10:{s:4:"name";s:7:"spacecp";s:4:"menu";s:6:"QQ绑定";s:3:"url";s:0:"";s:4:"type";s:1:"7";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"1";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}i:2;a:10:{s:4:"name";s:6:"qqshow";s:4:"menu";s:4:"QQ秀";s:3:"url";s:0:"";s:4:"type";s:1:"7";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"2";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}i:3;a:10:{s:4:"name";s:7:"connect";s:4:"menu";s:0:"";s:3:"url";s:0:"";s:4:"type";s:2:"28";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"0";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}s:6:"system";i:2;s:5:"extra";a:2:{s:11:"installtype";s:6:"SC_GBK";s:10:"langexists";i:1;}}' WHERE name = 'QQ互联';

复制代码

简体UFT-8编码的站点：

1. UPDATE pre_common_plugin SET modules = 'a:6:{i:0;a:10:{s:4:"name";s:7:"connect";s:4:"menu";s:0:"";s:3:"url";s:0:"";s:4:"type";s:2:"11";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"0";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}i:1;a:10:{s:4:"name";s:7:"spacecp";s:4:"menu";s:6:"QQ绑定";s:3:"url";s:0:"";s:4:"type";s:1:"7";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"1";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}i:2;a:10:{s:4:"name";s:6:"qqshow";s:4:"menu";s:4:"QQ秀";s:3:"url";s:0:"";s:4:"type";s:1:"7";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"2";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}i:3;a:10:{s:4:"name";s:7:"connect";s:4:"menu";s:0:"";s:3:"url";s:0:"";s:4:"type";s:2:"28";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"0";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}s:6:"system";i:2;s:5:"extra";a:2:{s:11:"installtype";s:7:"SC_UTF8";s:10:"langexists";i:1;}}' WHERE name = 'QQ互联';

复制代码

2.执行完上述sql后，进入站点后台-》工具下，点击更新缓存。


如果上述方法仍不能解决乱码问题，请您跟帖回复，我们为您排查一下。

感谢fujiulong 站长提供权限排查，发现另外一种解决方法，具体见下：
如果上述方法执行后不起效，您进入您网站目录/source/plugin/qqconnect目录下，检查是否存在discuz_plugin_qqconnect.xml文件。
如果存在，则可以按下面的方法再试下：
不需要区分网站编码，执行下面的sql：

1. UPDATE pre_common_plugin SET modules = 'a:6:{i:0;a:10:{s:4:"name";s:7:"connect";s:4:"menu";s:0:"";s:3:"url";s:0:"";s:4:"type";s:2:"11";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"0";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}i:1;a:10:{s:4:"name";s:7:"spacecp";s:4:"menu";s:6:"QQ绑定";s:3:"url";s:0:"";s:4:"type";s:1:"7";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"1";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}i:2;a:10:{s:4:"name";s:6:"qqshow";s:4:"menu";s:4:"QQ秀";s:3:"url";s:0:"";s:4:"type";s:1:"7";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"2";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}i:3;a:10:{s:4:"name";s:7:"connect";s:4:"menu";s:0:"";s:3:"url";s:0:"";s:4:"type";s:2:"28";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"0";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}s:6:"system";i:2;s:5:"extra";a:2:{s:11:"installtype";s:0:"";s:10:"langexists";i:1;}}' WHERE name = 'QQ互联';

复制代码

执行完后，进入站点后台-》工具下更新缓存。


如果上述的方法仍无法解决，请您跟帖回复，我们为您排查解决。  ：）

占位·······················

哈哈，收了

UPDATE pre_common_plugin SET modules = 'a:5:{i:0;a:10:{s:4:"name";s:7:"connect";s:4:"menu";s:0:"";s:3:"url";s:0:"";s:4:"type";s:2:"11";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"0";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}i:1;a:10:{s:4:"name";s:7:"spacecp";s:4:"menu";s:6:"QQ绑定";s:3:"url";s:0:"";s:4:"type";s:1:"7";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"1";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}i:2;a:10:{s:4:"name";s:6:"qqshow";s:4:"menu";s:4:"QQ秀";s:3:"url";s:0:"";s:4:"type";s:1:"7";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"2";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}i:3;a:10:{s:4:"name";s:7:"connect";s:4:"menu";s:0:"";s:3:"url";s:0:"";s:4:"type";s:2:"28";s:7:"adminid";s:1:"0";s:12:"displayorder";s:1:"0";s:8:"navtitle";s:0:"";s:7:"navicon";s:0:"";s:10:"navsubname";s:0:"";s:9:"navsuburl";s:0:"";}s:5:"extra";a:2:{s:11:"installtype";s:6:"SC_GBK";s:10:"langexists";i:1;}}' WHERE name = 'QQ互联';

www.ledadw.com

fujiulong 发表于 2012-6-6 17:51
UPDATE pre_common_plugin SET modules = 'a:5:{i:0;a:10:{s:4:"name";s:7:"connect";s:4:"menu";s:0:"";s: ...

短消息一下phpMyAdmin权限吧，我帮你看下

不错 来学习下

按照你说的方法我已经执行了，还是原来现象，不能解决，何因？

fatmonkey 发表于 2012-6-6 18:51
按照你说的方法我已经执行了，还是原来现象，不能解决，何因？

短消息我一下phpMyadmin权限和网站地址、管理员帐号密码，我看下

fujiulong 发表于 2012-6-6 17:51
UPDATE pre_common_plugin SET modules = 'a:5:{i:0;a:10:{s:4:"name";s:7:"connect";s:4:"menu";s:0:"";s: ...

已经解决了，发现是由于source/plugin/qqconnect目录下缺少对应编码的xml文件导致，上传对应的xml文件后更新缓存解决。   

dongdong0925 发表于 2012-6-6 21:00
已经解决了，发现是由于source/plugin/qqconnect目录下缺少对应编码的xml文件导致，上传对应的xml文件后更 ...

多谢！！！！！！！！！！！！！！！！！！！