孙欢@83sun.com

Discuz! info: MySQL Query Error
User: admin
Time: 2008-12-19 8:33pm
Script: /admincp.php
SQL: INSERT INTO [Table]adminsessions (uid, adminid, panel, ip, dateline, errorcount)
VALUES (‘1′, ‘1′, ‘1′, ‘222.173.72.138′, ‘1229690011′, ‘0′)
Error: Duplicate entry ‘1-1′ for key 1
Errno.: 1062
Similar error report has beed dispatched to administrator before.

解决方法:

CREATE TABLE IF NOT EXISTS `cdb_adminsessions` (
`uid` mediumint(8) unsigned NOT NULL default ‘0′,
`adminid` smallint(6) unsigned NOT NULL default ‘0′,
`panel` tinyint(1) NOT NULL default ‘0′,
`ip` varchar(15) NOT NULL default ”,
`dateline` int(10) unsigned NOT NULL default ‘0′,
`errorcount` tinyint(1) NOT NULL default ‘0′,
`storage` mediumtext NOT NULL,
PRIMARY KEY (`uid`,`panel`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk

方法提供者:梅子雨(非原创,在此强调,避免以后有人jjyy)