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

神哥

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

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

注意：此方法仅适用于Discuz! X2.5版本（X3.4版本），如果您的表前缀不是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后，进入站点后台-》工具下，点击更新缓存。



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

发现另外一种解决方法，具体见下：
如果上述方法执行后不起效，您进入您网站目录/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互联';

复制代码

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


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