Discuz Nt 以前用着很好。但最近数据库服务器老是占用CPU 100%
跟踪了一下，有个错误
E000 exec sp_executesql N'INSERT INTO [dnt_online] ([userid],[ip],[username],[nickname],[password],[groupid],[olimg],[adminid],[invisible],[action],[lastactivity],[lastposttime],[lastpostpmtime],[lastsearchtime],[lastupdatetime],[forumid],[forumname],[titleid],[title], [verifycode])VALUES(@userid,@ip,@username,@nickname,@password,@groupid,@olimg,@adminid,@invisible,@action,@lastactivity,@lastposttime,@lastpostpmtime,@lastsearchtime,@lastupdatetime,@forumid,@forumname,@titleid,@title,@verifycode);SELECT SCOPE_IDENTITY()',N'@userid int,@ip varchar(15),@username nvarchar(40),@nickname nvarchar(40),@password char(32),@groupid smallint,@olimg varchar(80),@adminid smallint,@invisible smallint,@action smallint,@lastactivity smallint,@lastposttime datetime,@lastpostpmtime datetime,@lastsearchtime datetime,@lastupdatetime datetime,@forumid int,@forumname nvarchar(50),@titleid int,@title nvarchar(80),@verifycode varchar(10)',@userid=-1,@ip='221.189.57.209',@username=N'游客',@nickname=N'游客',@password=' ',@groupid=7,@olimg='<img src="images\groupicons\guest.gif" />',@adminid=0,@invisible=0,@action=0,@lastactivity=0,@lastposttime=''1900-01-01 00:00:00:000'',@lastpostpmtime=''1900-01-01 00:00:00:000'',@lastsearchtime=''1900-01-01 00:00:00:000'',@lastupdatetime=''2008-07-10 16:06:14:000'',@forumid=0,@forumname=N'',@titleid=0,@title=N'',@verifycode='k81yk' 1 [Microsoft][SQL Native Client][SQL Server]'1900' 附近有语法错误。
即插入日期数据时有两个''
另一个问题是：dnt_online 反复添加数据，把 dnt_online 表清空后，几秒内记录会激增到好几百，实际不可能有这么多人在线的。
这个问题是哪部分源码出问题了？告知下，我自己改。