大大进~~就这个没有没有成功~~USER的转换！

XConvert info: MySQL Query Error

Time: 2010-2-15 12:58am
SQL: INSERT INTO 52mzd.cdb_members (uid, username, password, secques, gender, adminid, groupid, groupexpiry, extgroupids, regip, regdate, lastip, lastvisit, lastactivity, lastpost, posts, digestposts, oltime, pageviews, credits, extcredits1, extcredits2, extcredits3, extcredits4, extcredits5, extcredits6, extcredits7, extcredits8, email, bday, sigstatus, tpp, ppp, styleid, dateformat, timeformat, pmsound, showemail, newsletter, invisible, timeoffset, prompt, accessmasks, editormode, customshow, xspacestatus) VALUES ( '2', '影影绰绰', 'c92d29b0d9c77ef201d4fa642ca45d18', '', '1', '1', '1', '0', '', '123.53.42.158', '1167550575', '123.53.42.158', '1229521962', '1229521962', '1229521962', '370', '0', '0', '0', '4182', '4182', '0', '1033', '2091', '240', '480', '0', '0', 'wk.0619@qq.com', '0000-00-00', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '9999', '', '0', '2', '26', '0');
Error: Unknown column 'prompt' in 'field list'
Errormsg.: 字段不存在
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖


其它都成功了~~~~

DV8.2 TO DZ7

请检查下您discuz数据库cdb_members表中是否有prompt字段
如果有，修复下该数据库表，重新转换第一步
如果没有，请到phpmyadmin中运行以下sql语句：

1. DROP TABLE IF EXISTS cdb_members;
   
2. CREATE TABLE cdb_members (
   
3.   uid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
   
4.   username char(15) NOT NULL DEFAULT '',
   
5.   `password` char(32) NOT NULL DEFAULT '',
   
6.   secques char(8) NOT NULL DEFAULT '',
   
7.   gender tinyint(1) NOT NULL DEFAULT '0',
   
8.   adminid tinyint(1) NOT NULL DEFAULT '0',
   
9.   groupid smallint(6) unsigned NOT NULL DEFAULT '0',
   
10.   groupexpiry int(10) unsigned NOT NULL DEFAULT '0',
    
11.   extgroupids char(20) NOT NULL DEFAULT '',
    
12.   regip char(15) NOT NULL DEFAULT '',
    
13.   regdate int(10) unsigned NOT NULL DEFAULT '0',
    
14.   lastip char(15) NOT NULL DEFAULT '',
    
15.   lastvisit int(10) unsigned NOT NULL DEFAULT '0',
    
16.   lastactivity int(10) unsigned NOT NULL DEFAULT '0',
    
17.   lastpost int(10) unsigned NOT NULL DEFAULT '0',
    
18.   posts mediumint(8) unsigned NOT NULL DEFAULT '0',
    
19.   digestposts smallint(6) unsigned NOT NULL DEFAULT '0',
    
20.   oltime smallint(6) unsigned NOT NULL DEFAULT '0',
    
21.   pageviews mediumint(8) unsigned NOT NULL DEFAULT '0',
    
22.   credits int(10) NOT NULL DEFAULT '0',
    
23.   extcredits1 int(10) NOT NULL DEFAULT '0',
    
24.   extcredits2 int(10) NOT NULL DEFAULT '0',
    
25.   extcredits3 int(10) NOT NULL DEFAULT '0',
    
26.   extcredits4 int(10) NOT NULL DEFAULT '0',
    
27.   extcredits5 int(10) NOT NULL DEFAULT '0',
    
28.   extcredits6 int(10) NOT NULL DEFAULT '0',
    
29.   extcredits7 int(10) NOT NULL DEFAULT '0',
    
30.   extcredits8 int(10) NOT NULL DEFAULT '0',
    
31.   email char(40) NOT NULL DEFAULT '',
    
32.   bday date NOT NULL DEFAULT '0000-00-00',
    
33.   sigstatus tinyint(1) NOT NULL DEFAULT '0',
    
34.   tpp tinyint(3) unsigned NOT NULL DEFAULT '0',
    
35.   ppp tinyint(3) unsigned NOT NULL DEFAULT '0',
    
36.   styleid smallint(6) unsigned NOT NULL DEFAULT '0',
    
37.   dateformat tinyint(1) NOT NULL DEFAULT '0',
    
38.   timeformat tinyint(1) NOT NULL DEFAULT '0',
    
39.   pmsound tinyint(1) NOT NULL DEFAULT '0',
    
40.   showemail tinyint(1) NOT NULL DEFAULT '0',
    
41.   newsletter tinyint(1) NOT NULL DEFAULT '0',
    
42.   invisible tinyint(1) NOT NULL DEFAULT '0',
    
43.   timeoffset char(4) NOT NULL DEFAULT '',
    
44.   prompt tinyint(1) NOT NULL DEFAULT '0',
    
45.   accessmasks tinyint(1) NOT NULL DEFAULT '0',
    
46.   editormode tinyint(1) unsigned NOT NULL DEFAULT '2',
    
47.   customshow tinyint(1) unsigned NOT NULL DEFAULT '26',
    
48.   xspacestatus tinyint(1) NOT NULL DEFAULT '0',
    
49.   customaddfeed tinyint(1) NOT NULL DEFAULT '0',
    
50.   PRIMARY KEY (uid),
    
51.   UNIQUE KEY username (username),
    
52.   KEY email (email),
    
53.   KEY groupid (groupid)
    
54. ) TYPE=MyISAM;
    
55. INSERT INTO cdb_members VALUES ('1','admin','21232f297a57a5a743894a0e4a801fc3','','0','1','1','0','','hidden','1170596852','127.0.0.1','0','1170597433','1170596852','0','0','1','0','0','0','0','0','0','0','0','0','0','name@domain.com','0000-00-00','0','0','0','0','','0','0','1','1','0','9999','0','0','2','26','0','5');

复制代码

然后，再重新转换第一步

谢谢~~~成功转换成DZ7了~~~~~~

欢迎加入DZ