DZNT论坛 3.6.711删除用户各种错解决方案
来源:互联网 发布:无间道3全解析知乎 编辑:程序博客网 时间:2024/06/10 16:18
首先删除一个用户~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]gocreate 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]gocreate 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]gocreate 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]gocreate 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
阅读全文
0 0
- DZNT论坛 3.6.711删除用户各种错解决方案
- 各种论坛
- 删除用户时提示用户已连接时的解决方案
- Maven 各种报错解决方案
- 安装各种论坛小记
- mysql增加用户并赋予、删除、查看各种权限
- 一个统计当前在线用户的解决方案,可以在聊天室、论坛、网站中使用
- 一个统计当前在线用户的解决方案,可以在聊天室、论坛、网站中使用
- 一个统计当前在线用户的解决方案,可以在聊天室、论坛、网站中使用
- ORA-01940无法删除当前已连接用户的解决方案
- ORA-01940无法删除当前已连接用户的解决方案
- ubuntu 用户sudo组不小心被删除解决方案
- Discuz!论坛教程之如何禁止/允许用户删除自己发布的帖子
- 网站与discuz的论坛进行整合,实现用户同步注册,单点登陆,同步删除用户,同步修改用户密码
- 网站与discuz的论坛进行整合,实现用户同步注册,单点登陆,同步删除用户,同步修改用户密码
- 对于各种报错的解决方案
- Oracle中删除用户和表空间的常见问题(比如:ORA-01940无法删除当前已连接用户的解决方案)
- Oracle中删除用户和表空间的常见问题(比如:ORA-01940无法删除当前已连接用户的解决方案)
- 2、算法分析
- Handler声明成内部类所引起的内存泄露问题
- 大数定律(1):Markov不等式
- [Python]Anaconda连接mysql数据库,生成的200个激活码保存在数据库
- PAT 乙级 1064.朋友数(20)
- DZNT论坛 3.6.711删除用户各种错解决方案
- 相对布局
- 隐藏虚拟按键,但不进去全屏模式(沉浸模式)
- rpm 安装软件
- VIM改造成source insight版IDE(windows)
- JS日期格式化
- ReceptiveField Compute
- pt-query-digest查询日志分析工具
- 百度、腾讯这次的步伐异常一致,或许这是信息安全的最佳保障。