本帖最后由 caohks 于 2013-10-24 22:53 编辑
数据库里边修改(不想碰数据库无视这个)
大家用mysql管理工具(其实大家基本上用PMA,其他可能都没听过,呵呵)。找到你的数据库,找到表common_member_connect
查看表信息是:
ield Type Collation Null Key Default Extra Privileges Comment
---------------- --------------------- -------------- ------ ------ ------- ------ ------------------------------- ---------
uid mediumint(8) unsigned (NULL) NO PRI 0 select,insert,update,references
conuin char(40) gbk_chinese_ci NO MUL select,insert,update,references
conuinsecret char(16) gbk_chinese_ci NO select,insert,update,references
conopenid char(32) gbk_chinese_ci NO MUL select,insert,update,references
conisfeed tinyint(1) unsigned (NULL) NO 0 select,insert,update,references
conispublishfeed tinyint(1) unsigned (NULL) NO 0 select,insert,update,references
conispublisht tinyint(1) unsigned (NULL) NO 0 select,insert,update,references
conisregister tinyint(1) unsigned (NULL) NO 0 select,insert,update,references
conisqzoneavatar tinyint(1) unsigned (NULL) NO 0 select,insert,update,references
conisqqshow tinyint(1) unsigned (NULL) NO 0 select,insert,update,references
看看上面的字段是不是少了conuintoken?
那么我们加上conuintoken吧,sql语句为- alter table pre_common_member_connect add conuintoken char(32) not null;
复制代码
执行上面的sql语句即可,如果是在全局执行,请加上数据库名,比如数据库名为db,则pre_common_member_connect应为db.pre_common_member_connect
下面再看下表信息:
Field Type Collation Null Key Default Extra Privileges Comment
---------------- --------------------- -------------- ------ ------ ------- ------ ------------------------------- ---------
uid mediumint(8) unsigned (NULL) NO PRI 0 select,insert,update,references
conuin char(40) gbk_chinese_ci NO MUL select,insert,update,references
conuinsecret char(16) gbk_chinese_ci NO select,insert,update,references
conopenid char(32) gbk_chinese_ci NO MUL select,insert,update,references
conisfeed tinyint(1) unsigned (NULL) NO 0 select,insert,update,references
conispublishfeed tinyint(1) unsigned (NULL) NO 0 select,insert,update,references
conispublisht tinyint(1) unsigned (NULL) NO 0 select,insert,update,references
conisregister tinyint(1) unsigned (NULL) NO 0 select,insert,update,references
conisqzoneavatar tinyint(1) unsigned (NULL) NO 0 select,insert,update,references
conisqqshow tinyint(1) unsigned (NULL) NO 0 select,insert,update,references
conuintoken char(32) gbk_chinese_ci NO (NULL) select,insert,update,references
|