当Ucenter和应用通信失败,DZ数据库备份恢复

http://blog.sina.com.cn/s/blog_775f158f010135uz.html

ucenter整合自己的项目

http://jingyan.baidu.com/article/d169e186602362436711d858.html

UCenter uc_user_synlogin同步登陆返回值为空（NULL）的解决办法 及 ucenter原理

http://www.cnblogs.com/hellowzd/p/5885000.html

单点登录 Ucenter 分析

http://www.cnblogs.com/dingxiaoyue/p/4926729.html

整合 ucenter 注册自动激活

https://my.oschina.net/banbo/blog/311691

很不错的在线logo设计网站

 http://www.logomaker.com.cn

Discuz提示Table 'common_session' doesn't exist错误的解决方法

http://www.dedejs.com/html/article-929-1.html

备份恢复：在安装包里的utility复制restore.php到bbs/data目录下，运行，前提是在admin后台点击站长，备份数据库了，恢复后然后删除文件

restore.php

DROP TABLE IF EXISTS pre_common_session;
CREATE TABLE pre_common_session (
  sid char(6) NOT NULL DEFAULT '',
  ip1 tinyint(3) unsigned NOT NULL DEFAULT '0',
  ip2 tinyint(3) unsigned NOT NULL DEFAULT '0',
  ip3 tinyint(3) unsigned NOT NULL DEFAULT '0',
  ip4 tinyint(3) unsigned NOT NULL DEFAULT '0',
  uid mediumint(8) unsigned NOT NULL DEFAULT '0',
  username char(15) NOT NULL DEFAULT '',
  groupid smallint(6) unsigned NOT NULL DEFAULT '0',
  invisible tinyint(1) NOT NULL DEFAULT '0',
  `action` tinyint(1) unsigned NOT NULL DEFAULT '0',
  lastactivity int(10) unsigned NOT NULL DEFAULT '0',
  lastolupdate int(10) unsigned NOT NULL DEFAULT '0',
  fid mediumint(8) unsigned NOT NULL DEFAULT '0',
  tid mediumint(8) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY sid (sid),
  KEY uid (uid)
) TYPE=HEAP;

这个pre_common_session建表语句是错误的，改成下面的就对了

CREATE TABLE `pre_common_session` (
`sid` char(6) NOT NULL DEFAULT '',
`ip1` tinyint(3) unsigned NOT NULL DEFAULT '0',
`ip2` tinyint(3) unsigned NOT NULL DEFAULT '0',
`ip3` tinyint(3) unsigned NOT NULL DEFAULT '0',
`ip4` tinyint(3) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`username` char(15) NOT NULL DEFAULT '',
`groupid` smallint(6) unsigned NOT NULL DEFAULT '0',
`invisible` tinyint(1) NOT NULL DEFAULT '0',
`action` tinyint(1) unsigned NOT NULL DEFAULT '0',
`lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
`lastolupdate` int(10) unsigned NOT NULL DEFAULT '0',
`fid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`tid` mediumint(8) unsigned NOT NULL DEFAULT '0',
UNIQUE KEY `sid` (`sid`),
KEY `uid` (`uid`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

 

posted on 2017-03-13 13:32  防空洞123  阅读(318)  评论(0)  编辑  收藏  举报

导航