We have an odd problem which has come up as our forum has gotten busier.

Sometimes we get a PM with attachments and we just can't access them at all - other ones seem to be fine. The show fine at the foot of the message, but when you click on them you get redirected to the error page.

I'm not sure, but i think it might be when a person has sent the same attachment to multiple people so there are effectively 2 or more "attachments" with the same file details etc.

Any ideas? the error message we get is :

SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.]
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
   System.Data.SqlClient.SqlCommand.ExecuteReader() +42
   InstantASP.Common.Data.Helper.ExecuteSqlServerReader(String statement, CommandType commandType, ArrayList paramCollection, SqlConnection conn, Int32 CommandTimeout)
   InstantASP.Common.Data.Helper.PrivateExecuteReader(Providers EnumProvider, String statement, CommandType commandType, ArrayList paramCollection, IDbConnection conn, Int16 CommandTimeout)
   InstantASP.Common.Data.Helper.ExecuteReader(Providers EnumProvider, String statement, CommandType commandType, ArrayList paramCollection, IDbConnection conn, Int16 CommandTimeout)
   InstantASP.InstantForum.Data.DataProvider.SelectAttachment(Int32 AttachmentID, Int32 UserID)
   InstantASP.InstantForum.Business.Attachments.GetAttachment(Int32 intAttachmentID, Int32 intUserID)
   InstantASP.InstantForum.UI.Controls.Attachment.Initialize(Control ctlSkin)
   InstantASP.Common.UI.Base.Skin.CreateChildControls()
   InstantASP.InstantForum.UI.Skinning.Base.CreateChildControls()
   System.Web.UI.Control.EnsureChildControls() +100
   System.Web.UI.Control.PreRenderRecursiveInternal() +38
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Control.PreRenderRecursiveInternal() +125
   System.Web.UI.Page.ProcessRequestMain() +1499

Sorry - i hadn't noticed the Service Pack existed!

Bad news is though that I have now applied it but I'm still seeing the same problem.

Any other ideas I can try out?

Thanks,

Peter