DV7>X ACCESS转DZ5.0备份数据出错

Discuz! info: MySQL Query Error

User: 红尘月影
Time: 2006-12-10 5:19am
Script: /discuz/admincp.php

SQL: UPDATE cdb_sessions SET uid='5', username='红尘月影', groupid='1', styleid='1', invisible='0', action='211', lastactivity='1165699097', lastolupdate='1165699056', seccode='4540', fid='0', tid='0', bloguid='0' , pageviews=pageviews+1 WHERE sid='28hJEk'
Error: MySQL server has gone away
Errno.: 2006

Similar error report has beed dispatched to administrator before.

研究了很久,也找不出问题的原因,转过好几个数据,就这个出问题.

这个不好转，没多少用的，

Discuz! info: MySQL Query Error

User: 红尘月影
Time: 2006-12-10 8:42pm
Script: /discuz/admincp.php

SQL: UPDATE cdb_sessions SET uid='5', username='红尘月影', groupid='1', styleid='1', invisible='0', action='211', lastactivity='1165754521', lastolupdate='0', seccode='9108', fid='0', tid='0', bloguid='0' , pageviews=pageviews+1 WHERE sid='2Q0lpC'
Error: MySQL server has gone away
Errno.: 2006

Similar error report has beed dispatched to administrator before.

删除cdb_sessions表，重建

1. DROP TABLE IF EXISTS cdb_sessions;
   
2. CREATE TABLE cdb_sessions (
   
3.   sid char(6) binary NOT NULL default '',
   
4.   ip1 tinyint(3) unsigned NOT NULL default '0',
   
5.   ip2 tinyint(3) unsigned NOT NULL default '0',
   
6.   ip3 tinyint(3) unsigned NOT NULL default '0',
   
7.   ip4 tinyint(3) unsigned NOT NULL default '0',
   
8.   uid mediumint(8) unsigned NOT NULL default '0',
   
9.   username char(15) NOT NULL default '',
   
10.   groupid smallint(6) unsigned NOT NULL default '0',
    
11.   styleid smallint(6) unsigned NOT NULL default '0',
    
12.   invisible tinyint(1) NOT NULL default '0',
    
13.   `action` tinyint(1) unsigned NOT NULL default '0',
    
14.   lastactivity int(10) unsigned NOT NULL default '0',
    
15.   lastolupdate int(10) unsigned NOT NULL default '0',
    
16.   pageviews smallint(6) unsigned NOT NULL default '0',
    
17.   seccode smallint(6) unsigned NOT NULL default '0',
    
18.   fid smallint(6) unsigned NOT NULL default '0',
    
19.   tid mediumint(8) unsigned NOT NULL default '0',
    
20.   bloguid mediumint(8) unsigned NOT NULL default '0',
    
21.   UNIQUE KEY sid (sid),
    
22.   KEY uid (uid),
    
23.   KEY bloguid (bloguid)
    
24. ) TYPE=Heap;

复制代码

试过了不行啊

备份数据怎么会出错呢？恢复出错倒是有可能，重启MySQL试试～

不知道是我的问题还是数据的问题，我先搭建好环境，然后用求助者给我的最新数据转换以后，没有出错了，有点晕了．．．．．
不过，总算成功了！