Getting an error that indicates attachment types are not defined?


I just inherited this site so know nothing about how it got to this state.

Hoping for some insight.

Thanks
Ben
InstantForum Problem

Hi There,

I'm sorry to hear of the trouble. This error would suggest you don't have any attachment types within the "InstantForum_AttachmentTypes" table.

You can add the required attachment types to your database using the TSQL script below...

-----------------------------------------------------------
--Insert data into InstantForum_AttachmentTypes
-----------------------------------------------------------
ALTER TABLE InstantForum_AttachmentTypes NOCHECK CONSTRAINT ALL
GO

TRUNCATE TABLE InstantForum_AttachmentTypes
GO

IF (IDENT_SEED('InstantForum_AttachmentTypes') IS NOT NULL )SET IDENTITY_INSERT InstantForum_AttachmentTypes ON
SET IDENTITY_INSERT InstantForum_AttachmentTypes ON
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('1','.gif','gif.png',1,1,1,1)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('2','.bmp','bmp.png',1,1,1,1)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('3','.jpe','jpg.png',1,1,1,1)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('4','.jpeg','jpg.png',1,1,1,1)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('5','.pdf','pdf.png',1,1,0,0)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('6','.doc','doc.png',1,1,0,0)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('7','.rtf','doc.png',1,1,0,0)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('8','.png','png.png',1,1,1,1)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('9','.txt','txt.png',1,1,0,0)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('10','.zip','zip.png',1,1,0,0)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('11','.xls','xls.png',1,1,0,0)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('12','.jpg','jpg.png',1,1,1,1)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('13','.ascx','ascx.png',1,0,0,0)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('14','.css','txt.png',1,0,0,0)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('15','.aspx','aspx.png',1,0,0,0)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('16','.rar','rar.png',1,1,0,0)
INSERT INTO InstantForum_AttachmentTypes (AttachmentTypeID,AttachmentExtension,AttachmentImagePath,AllowInPosts,AllowInPrivateMessages,AllowInAvatarPhotos,AllowInInsertImage) VALUES('17','.docx','doc.png',1,1,0,0)

IF (IDENT_SEED('InstantForum_AttachmentTypes') IS NOT NULL )SET IDENTITY_INSERT InstantForum_AttachmentTypes OFF
SET IDENTITY_INSERT InstantForum_AttachmentTypes OFF
GO
GO
ALTER TABLE InstantForum_AttachmentTypes CHECK CONSTRAINT ALL
GO


Out of interest which version of InstantForum are you using? I only ask as this should not occur in newer versions even if you don't have any attachment types.

I look forward to your response and assisting further.

http://www.instantasp.co.uk/images/line.gif
Kindest Regards,

Ryan Healey



ryan@instantasp.co.uk
www.instantasp.co.uk
Blog | Community | Docs

http://www.instantasp.co.uk/core/assets/images/email/facebook.png http://www.instantasp.co.uk/core/assets/images/email/twitter.png http://www.instantasp.co.uk/core/assets/images/email/google.png http://www.instantasp.co.uk/core/assets/images/email/linkedin.png
GO

Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....







InstantASP Forums


Search