关于如何修复搬家之后出现的QQ互联等错误

问题
1:我搬家之后QQ互联出现内部错误还有乱码.
2:我的帖子分享页面的分享按钮都成了英文如connect_viewthread_share_to_qzone

修复方法
首先对QQ互联文件夹的文件进行了解.找到source/plugin/qqconnect
这个就是QQ互联的文件需要了解的是install.php这个文件这个是开通互联时的执行文件下面我们打开它
这个是源码

1. <FONT size=4><?php
   
2. 
   
3. /**
   
4. * [Discuz!] (C)2001-2099 Comsenz Inc.
   
5. * This is NOT a freeware, use is subject to license terms
   
6. *
   
7. * $Id: install.php 22778 2011-05-20 07:15:53Z monkey $
   
8. */
   
9. 
   
10. if(!defined('IN_DISCUZ')) {
    
11. exit('Access Denied');
    
12. }
    
13. 
    
14. $sql = <<<EOF
    
15. 
    
16. CREATE TABLE IF NOT EXISTS pre_common_member_connect (
    
17. `uid` mediumint(8) unsigned NOT NULL default '0',
    
18. `conuin` char(40) NOT NULL default '',
    
19. `conuinsecret` char(16) NOT NULL default '',
    
20. `conopenid` char(32) NOT NULL default '',
    
21. `conisfeed` tinyint(1) unsigned NOT NULL default '0',
    
22. `conispublishfeed` tinyint(1) unsigned NOT NULL default '0',
    
23. `conispublisht` tinyint(1) unsigned NOT NULL default '0',
    
24. `conisregister` tinyint(1) unsigned NOT NULL default '0',
    
25. `conisqzoneavatar` tinyint(1) unsigned NOT NULL default '0',
    
26. PRIMARY KEY (`uid`),
    
27. KEY `conuin` (`conuin`),
    
28. KEY `conopenid` (`conopenid`)
    
29. ) ENGINE=MyISAM;
    
30. 
    
31. CREATE TABLE IF NOT EXISTS pre_connect_feedlog (
    
32. flid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    
33. tid mediumint(8) unsigned NOT NULL DEFAULT '0',
    
34. uid mediumint(8) unsigned NOT NULL DEFAULT '0',
    
35. publishtimes mediumint(8) unsigned NOT NULL DEFAULT '0',
    
36. lastpublished int(10) unsigned NOT NULL DEFAULT '0',
    
37. dateline int(10) unsigned NOT NULL DEFAULT '0',
    
38. `status` tinyint(1) NOT NULL DEFAULT '1',
    
39. PRIMARY KEY (flid),
    
40. UNIQUE KEY tid (tid)
    
41. ) TYPE=MyISAM;
    
42. 
    
43. CREATE TABLE IF NOT EXISTS pre_connect_memberbindlog (
    
44. mblid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    
45. uid mediumint(8) unsigned NOT NULL DEFAULT '0',
    
46. uin char(40) NOT NULL,
    
47. `type` tinyint(1) NOT NULL DEFAULT '0',
    
48. dateline int(10) unsigned NOT NULL DEFAULT '0',
    
49. PRIMARY KEY (mblid),
    
50. KEY uid (uid),
    
51. KEY uin (uin),
    
52. KEY dateline (dateline)
    
53. ) TYPE=MyISAM;
    
54. 
    
55. CREATE TABLE IF NOT EXISTS pre_connect_tlog (
    
56. tlid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    
57. tid mediumint(8) unsigned NOT NULL DEFAULT '0',
    
58. uid mediumint(8) unsigned NOT NULL DEFAULT '0',
    
59. publishtimes mediumint(8) unsigned NOT NULL DEFAULT '0',
    
60. lastpublished int(10) unsigned NOT NULL DEFAULT '0',
    
61. dateline int(10) unsigned NOT NULL DEFAULT '0',
    
62. `status` tinyint(1) NOT NULL DEFAULT '1',
    
63. PRIMARY KEY (tlid),
    
64. UNIQUE KEY tid (tid)
    
65. ) TYPE=MyISAM;
    
66. 
    
67. CREATE TABLE IF NOT EXISTS pre_common_uin_black (
    
68. uin char(40) NOT NULL,
    
69. uid mediumint(8) unsigned NOT NULL DEFAULT '0',
    
70. dateline int(10) unsigned NOT NULL DEFAULT '0',
    
71. PRIMARY KEY (uin),
    
72. UNIQUE KEY uid (uid)
    
73. ) TYPE=MyISAM;
    
74. 
    
75. REPLACE INTO pre_common_setting VALUES ('regconnect', '1');
    
76. REPLACE INTO pre_common_setting VALUES ('connect', 'a:19:{s:5:"allow";s:1:"1";s:4:"feed";a:2:{s:5:"allow";s:1:"1";s:5:"group";s:1:"0";}s:1:"t";a:2:{s:5:"allow";s:1:"1";s:5:"group";s:1:"0";}s:10:"like_allow";s:1:"1";s:7:"like_qq";s:0:"";s:10:"turl_allow";s:1:"1";s:7:"turl_qq";s:0:"";s:8:"like_url";s:0:"";s:17:"register_birthday";s:1:"0";s:15:"register_gender";s:1:"0";s:17:"register_uinlimit";s:0:"";s:21:"register_rewardcredit";s:1:"1";s:18:"register_addcredit";s:0:"";s:16:"register_groupid";s:1:"0";s:18:"register_regverify";s:1:"1";s:15:"register_invite";s:1:"1";s:10:"newbiespan";s:0:"";s:9:"turl_code";s:0:"";s:13:"mblog_app_key";s:3:"abc";}');
    
77. 
    
78. EOF;
    
79. 
    
80. runquery($sql);
    
81. 
    
82. $finish = true;
    
83. 
    
84. ?></FONT>

复制代码

相信有基础的会看懂这几句数据库执行语句他总共创建5个数据表插入俩个字段
pre_common_member_connect
pre_connect_feedlog
pre_connect_memberbindlog
pre_connect_tlog
pre_common_uin_black
pre_common_setting表中插入了字段regconnect和connect
大家在修复之前最好保存一下这几个表和这俩个字段
在你搬家之后出现乱码等问题都跟这几个表有莫大的关系
----------------------------------
修复第一步:现在删除这几个表和字段
----------------------------------
据我反复测试重新开通随机又插入了这些表之后还是会内部错误和乱码？为什么了这个我大概猜测是bug这个就需要我们手动去修改.
----------------------------------
返回第一步删除表和字段然后进入mysql数据库手动查询语句命令把上面代码区域的代码通过SQL查询语句输入进去执行进后台更新缓存进入云平台重新开通QQ互联   测试成功！
----------------------------------
温馨提示:在以上操作之前先备份数据以防发生不必要的损失！
有什么问题可以随时站内信和跟帖！

首先感谢站长分享

pre_common_member_connect
pre_connect_feedlog
pre_connect_memberbindlog
pre_connect_tlog
pre_common_uin_black

如果搬家前站点有云平台的注册登录数据，不要清空这几个表，清空之后会清除掉注册登录转发等记录

关于

1:我搬家之后QQ互联出现内部错误还有乱码.
2:我的帖子分享页面的分享按钮都成了英文如connect_viewthread_share_to_qzone

只需要覆盖下"\source\plugin\qqconnect\"这个文件夹，同步站点信息，重新开通下QQ互联即可修复

Discuz! X2.5云平台太牛了。有腾讯安全做防水墙
https://discuz.dismall.com/thread-2704384-1-1.html

谢谢继续支持！