1. When we click the paper clip button, we see a list of attachments uploaded earlier. As I understood, these are attachments specific for the current user, right?

2. How can I remove unneeded attachments? I may have big files uploaded earlier I no longer use in my posts, so how can I remove them?

3. How are my attachments stored on the server? Are they stored as BLOBs inside the SQL forum db? And what is the purpose of the upload subfolder in the forum directory? It seems it does not store all attachments we have on our forum as files.

4. How can we change the list of file types available for uploading? For instance, sometime we need to upload .reg files on our forum.

I know that there is the admin page to work with attachments (/forum/admin/attachments), but it is available only for admins. As for my questions regarding the ability to manage attachments, I meant normal 'user mode'.

And I have a suggestion regarding that admin attachment control page: please, implement the ability to filter the forum attachment list (for instance, by user) or at least give us any ability to sort that table by its columns.

When we click the paper clip button, we see a list of attachments uploaded earlier. As I understood, these are attachments specific for the current user, right?

Correct

The next question is how can I remove unneeded attachments? I may have big files uploaded earlier I no longer use in my posts, so how can I remove them?

In your control panel under My Profile, there is an attachments page where you can delete them, you find it here

http://yetanotherforum.net/forum/attachments 

And the last thing: how are my attachments stored on the server? Are they stored as BLOBs inside the SQL forum db? And what is the purpose of the upload subfolder in the forum directory?

By default attachments are stored in the file system inside the uploads folder, but you can enable/disable to store them inside the file table in the data base from within the host settings

And I have a suggestion regarding that admin attachment control page: please, implement the ability to filter the forum attachment list (for instance, by user) or at least give us any ability to sort that table by its columns.

Well that page needs some updates because at the moment it shows only the old attachments not the inline attachments, and sorting by column would be a good idea.

How can we change the list of file types available for uploading? For instance, sometime we need to upload .reg files on our forum.

Under Admin > Settings > File Extensions

The next question is how can I remove unneeded attachments? I may have big files uploaded earlier I no longer use in my posts, so how can I remove them?

In your control panel under My Profile, there is an attachments page where you can delete them, you find it here

http://yetanotherforum.net/forum/attachments 

That's good if you know the link, or how to find it in the web-interface. However, it is hard to to find it using the visual interface. Now I see that it is deep inside - first I need to click 'My Profile', then I see the Attachments link in a series of small links under the 'Personal Profile:' title.

The next question is how can I remove unneeded attachments? I may have big files uploaded earlier I no longer use in my posts, so how can I remove them?

In your control panel under My Profile, there is an attachments page where you can delete them, you find it here

http://yetanotherforum.net/forum/attachments 

That's good if you know the link, or how to find it in the web-interface. However, it is hard to to find it using the visual interface. Now I see that it is deep inside - first I need to click 'My Profile', then I see the Attachments link in a series of small links under the 'Personal Profile:' title.

I think a good idea would be bellow the upload file button in the attachments menu, to have a link "Manage your existing attachments"

Files from the upload folder aren't removed 

Uploads on the cp_message are shown as follows

[ attach ]1[ /attach ] [ attach]4[ /attach ]

How to fix this

Thank you

Please download the latest version

How to enable upload for all users in pmessage?

Please download the latest version

How to enable upload for all users in pmessage?

By default at the moment the upload is always enabled for all users in private messages

Could not find stored procedure \'dbo.aspnet_CheckSchemaVersion\'.

how to fix this error (yaf 2.2.4.2)?

Could not find stored procedure \'dbo.aspnet_CheckSchemaVersion\'.

Where you get that error? Can you post the full error message?

Click to View Image52 View(s)

after this, when visit site show this error

No candidates for a guest were found for the board 1.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: No candidates for a guest were found for the board 1.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): No candidates for a guest were found for the board 1.]

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +282

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +781

System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +5180

System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +87

System.Data.SqlClient.SqlDataReader.get_MetaData() +105

System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) +607

System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3220

System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +734

System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +123

System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +302

System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +217

System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +181

System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +131

YAF.Types.Interfaces.Data.<>c__DisplayClass7_0.<GetDataset>b__0(IDbCommand c) +119

YAF.Core.Data.DbAccessBase.Execute(Func`2 execFunc, IDbCommand cmd, IDbTransaction dbTransaction) +285

YAF.Types.Interfaces.Data.IDbAccessExtensions.GetData(IDbAccess dbAccess, IDbCommand cmd, IDbTransaction dbTransaction) +92

YAF.Classes.Data.LegacyDb.pageload(Object sessionID, Object boardID, Object userKey, Object ip, Object location, Object forumPage, Object browser, Object platform, Object categoryID, Object forumID, Object topicID, Object messageID, Object isCrawler, Object isMobileDevice, Object donttrack) +614

[ApplicationException: Sql Exception with error number 50000 (Tries=0)]

YAF.Classes.Data.LegacyDb.pageload(Object sessionID, Object boardID, Object userKey, Object ip, Object location, Object forumPage, Object browser, Object platform, Object categoryID, Object forumID, Object topicID, Object messageID, Object isCrawler, Object isMobileDevice, Object donttrack) +1137

YAF.Core.LoadPageFromDatabase.Handle(InitPageLoadEvent event) +8421

YAF.Core.ServiceLocatorEventRaiser.Raise(T eventObject) +225

YAF.Core.YafContext.InitUserAndPage() +448

YAF.Core.UserPageBase.get_Page() +115

YAF.Core.UserPageBase.get_PageUserID() +21

YAF.ForumPageBase.Page_Error(Object sender, EventArgs e) +454

System.Web.UI.TemplateControl.OnError(EventArgs e) +138

System.Web.UI.Page.HandleError(Exception e) +106

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +10338

System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +353

System.Web.UI.Page.ProcessRequest() +75

System.Web.UI.Page.ProcessRequest(HttpContext context) +126

System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +880

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +97

in database

User is empty

prov_Membership has one row for my account