DZNT论坛 3.6.711删除用户各种错解决方案

首先删除一个用户~ado.net报错

对象名  'dnt_spaceposts' 无效。

对象名  'dnt_spaceconfigs' 无效。

对象名  'dnt_photocomments' 无效。

对象名  'dnt_photos' 无效。

对象名  'dnt_albums' 无效。

 

各种错误！！！我是利用向导安装的居然还来这么一出！！！！fuck !shit!

好吧手动添加建表脚本如下：

create table [dnt_spaceposts] (
	[postid] [int] identity (1, 1) not null ,
	[author] [nvarchar] (40)  not null ,
	[uid] [int] not null ,
	[postdatetime] [datetime] not null ,
	[content] [ntext]  not null ,
	[title] [nvarchar] (120)  not null ,
	[category] [varchar] (255)  not null ,
	[poststatus] [tinyint] not null ,
	[commentstatus] [tinyint] not null ,
	[postupdatetime] [datetime] not null ,
	[commentcount] [int] not null ,
	[views] [int] not null constraint [df_dnt_spaceposts_views] default (0),
	constraint [pk_dnt_spaceposts] primary key  clustered 
	(
		[postid]
	)  on [primary] 
) on [primary] textimage_on [primary]
go

create table [dnt_spaceconfigs] (
	[spaceid] [int] identity (1, 1) not null ,
	[userid] [int] not null ,
	[spacetitle] [nchar] (100)  not null constraint [df_dnt_spaceconfig_spacetitle] default (''),
	[description] [nchar] (200)  not null constraint [df_dnt_spaceconfig_description] default (''),
	[blogdispmode] [tinyint] not null constraint [df_dnt_spaceconfig_blogdispmode] default (0),
	[bpp] [int] not null constraint [df_dnt_spaceconfig_bpp] default (16),
	[commentpref] [tinyint] not null constraint [df_dnt_spaceconfig_commentpref] default (0),
	[messagepref] [tinyint] not null constraint [df_dnt_spaceconfig_messagepref] default (0),
	[rewritename] [char] (100)  not null constraint [df_dnt_spaceconfig_rewritename] default (''),
	[themeid] [int] not null constraint [df_dnt_spaceconfig_theme] default (0),
	[themepath] [nchar] (50)  not null constraint [df_dnt_spaceconfig_template] default (''),
	[postcount] [int] not null constraint [df_dnt_spaceconfigs_postcount] default (0),
	[commentcount] [int] not null constraint [df_dnt_spaceconfigs_commentcount] default (0),
	[visitedtimes] [int] not null constraint [df_dnt_spaceconfigs_visitedtimes] default (0),
	[createdatetime] [smalldatetime] not null constraint [df_dnt_spaceconfigs_createdatetime] default (getdate()),
	[updatedatetime] [smalldatetime] not null constraint [df_dnt_spaceconfigs_updatedatetime] default (getdate()),
	[defaulttab] [int] not null constraint [df_dnt_spaceconfigs_defaulttab] default (0),
	[status] [int] not null constraint [df_dnt_spaceconfigs_status] default (0),
	constraint [pk_dnt_spaceconfig] primary key  clustered 
	(
		[spaceid]
	)  on [primary] 
) on [primary]
go

create table [dnt_photocomments] (
	[commentid] [int] identity (1, 1) not null ,
	[photoid] [int] not null ,
	[username] [nvarchar] (20)  not null ,
	[userid] [int] not null ,
	[ip] [varchar] (100)  not null constraint [df_dnt_photocomments_ip] default (''),
	[postdatetime] [smalldatetime] not null ,
	[content] [nvarchar] (2000)  not null 
) on [primary]
go


create table [dnt_photos] (
	[photoid] [int] identity (1, 1) not null ,
	[filename] [char] (255)  not null ,
	[attachment] [nchar] (255)  not null ,
	[filesize] [int] not null ,
	[title] [nchar] (20)  not null ,
	[description] [nchar] (200)  not null constraint [df_dnt_spacephoto_description] default (''),
	[postdate] [datetime] not null constraint [df_dnt_spacephoto_postdate] default (getdate()),
	[albumid] [int] not null ,
	[userid] [int] not null ,
	[username] [nchar] (20)  not null constraint [df_dnt_photos_username] default (''),
	[views] [int] not null constraint [df_dnt_photos_viewcount] default (0),
	[commentstatus] [tinyint] not null constraint [df_dnt_photos_commentstatus] default (0),
	[tagstatus] [tinyint] not null constraint [df_dnt_photos_tagstatus] default (0),
	[comments] [int] not null constraint [df_dnt_photos_comments] default (0),
	[isattachment] [int] not null constraint [df_dnt_photos_isattachment] default (0),
	[width] [int] null ,
	[height] [int] null ,
	constraint [pk_dnt_spacephoto] primary key  clustered 
	(
		[photoid]
	)  on [primary] 
) on [primary]
go

create table [dnt_albums] (
	[albumid] [int] identity (1, 1) not null ,
	[albumcateid] [int] not null ,
	[userid] [int] not null constraint [df_dnt_spacealbums_userid] default ((-1)),
	[username] [nchar] (20)  not null constraint [df_dnt_albums_username] default (''),
	[title] [nchar] (50)  not null constraint [df_dnt_spacealbums_title] default (''),
	[description] [nchar] (200)  not null constraint [df_dnt_spacealbums_description] default (''),
	[logo] [nchar] (255)  not null constraint [df_dnt_spacealbums_logo] default (''),
	[password] [nchar] (50)  not null constraint [df_dnt_spacealbums_password] default (''),
	[imgcount] [int] not null constraint [df_dnt_spacealbums_imgcount] default (0),
	[views] [int] not null constraint [df_dnt_spacealbums_views] default (0),
	[type] [int] not null constraint [df_dnt_spacealbums_type] default (0),
	[createdatetime] [datetime] not null constraint [df_dnt_spacealbums_createdatetime] default (getdate()),
	constraint [pk_dnt_spacealbums] primary key  clustered 
	(
		[albumid]
	)  on [primary] 
) on [primary]
go



 create  unique  index [userid] on [dnt_spaceconfigs]([userid]) on [primary]
go


 create  index [postiduid] on [dnt_spaceposts]([postid], [uid]) on [primary]
go

 create  index [postidcommentcount] on [dnt_spaceposts]([postid], [commentcount]) on [primary]
go


 create  index [albumid] on [dnt_photos]([albumid]) on [primary]
go

 create  index [photoiduserid] on [dnt_photos]([photoid], [userid]) on [primary]
go

 create  index [userid] on [dnt_photos]([userid]) on [primary]
go



 create index [list_albumcateid] on [dnt_albums]([imgcount], [albumcateid], [albumid]) on [primary]
go

 create index [list_userid] on [dnt_albums]([type], [imgcount], [userid], [albumid]) on [primary]

　　然后就解决了！注意好dz!nt版本~~我这是3.6.711