Dev Guide: js | css | HTML(DOM) WEBCAST .NET4 Lib Web.config-WCF MVC3-EF4.1 T-SQL-(2012)

DZ!NT论坛 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

posted @   dotNetDR_  阅读(1373)  评论(2编辑  收藏  举报
编辑推荐:
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列:向量存储与相似性搜索在 .NET 中的实现
阅读排行:
· 周边上新:园子的第一款马克杯温暖上架
· Open-Sora 2.0 重磅开源!
· .NET周刊【3月第1期 2025-03-02】
· 分享 3 个 .NET 开源的文件压缩处理库,助力快速实现文件压缩解压功能!
· [AI/GPT/综述] AI Agent的设计模式综述
点击右上角即可分享
微信分享提示