YAFLogo

tecman
  • tecman
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
9 years ago
YAF 2.2 brought us the new post attachment system, which is accessed through the paper clip button in the post editor toolbar. I have some questions regarding it.

  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.
Sponsor
tecman
  • tecman
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
9 years ago
P.S.

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.

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
9 years ago

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?

Originally Posted by: tecman 

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?

Originally Posted by: tecman 

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?

Originally Posted by: tecman 

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.

Originally Posted by: tecman 

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.

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
9 years ago

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

Originally Posted by: tecman 

Under Admin > Settings > File Extensions

tecman
  • tecman
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
9 years ago

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?

Originally Posted by: tha_watcha 

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 

Originally Posted by: tecman 

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.

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
9 years ago

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?

Originally Posted by: tecman 

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 

Originally Posted by: tha_watcha 

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.

Originally Posted by: tecman 

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

tecman
  • tecman
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
9 years ago
Found one problem with the upload folder in YAF 2.2.2. If I remove a file using /forum/attachments, it remains in the upload folder. It's a bug, so I re-asked this question in the Bugs section on this forum:

Files from the upload folder aren't removed 

mojtaba
  • mojtaba
  • 53% (Neutral)
  • YAF Forumling
7 years ago
Hello

Uploads on the cp_message are shown as follows

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

How to fix this

Thank you

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
7 years ago
Thanks for the report issue will be fixed in YAF 2.2.4.2
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
7 years ago
Please download the latest version
mojtaba
  • mojtaba
  • 53% (Neutral)
  • YAF Forumling
7 years ago

Please download the latest version

Originally Posted by: tha_watcha 

How to enable upload for all users in pmessage?

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
7 years ago

Please download the latest version

Originally Posted by: mojtaba 

How to enable upload for all users in pmessage?

Originally Posted by: tha_watcha 

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

mojtaba
  • mojtaba
  • 53% (Neutral)
  • YAF Forumling
7 years ago
how to fix this error (yaf 2.2.4.2)?

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

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
7 years ago

how to fix this error (yaf 2.2.4.2)?

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

Originally Posted by: mojtaba 

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

mojtaba
  • mojtaba
  • 53% (Neutral)
  • YAF Forumling
7 years ago
in the first installing

 forum-error.jpg You have insufficient rights to see the content.

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.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