PW85转DZX2

Time: 2011-12-4 11:35am
SQL: INSERT INTO root.pre_ucenter_pm_members (plid, uid, isnew, pmnum, lastupdate, lastdateline) VALUES ( '1', '28', '0', '1', '1179407078', '1179407078');
Error: Unknown column 'plid' in 'field list'
Errormsg.: 字段不存在
Errno.: 1054

来看看。

字段不存在，是安装的整合版本的X2后再进行转换的吗？

重建这个字段：pre_ucenter_pm_members

操作前注意备份

执行以下sql语句重建：  注意表前缀

1. 
   
2. DROP TABLE IF EXISTS uc_pm_members;
   
3. CREATE TABLE uc_pm_members (
   
4.   plid mediumint(8) unsigned NOT NULL default '0',
   
5.   uid mediumint(8) unsigned NOT NULL default '0',
   
6.   isnew tinyint(1) unsigned NOT NULL default '0',
   
7.   pmnum int(10) unsigned NOT NULL default '0',
   
8.   lastupdate int(10) unsigned NOT NULL default '0',
   
9.   lastdateline int(10) unsigned NOT NULL default '0',
   
10.   PRIMARY KEY  (plid,uid),
    
11.   KEY isnew (isnew),
    
12.   KEY lastdateline (uid,lastdateline),
    
13.   KEY lastupdate (uid,lastupdate)
    
14. ) TYPE=MyISAM;
    

复制代码

楼上说的有道理啊