1. YAF.NET Support Forum
  2. YAF Forum Discussions
  3. YAF General
  4. Working with attachments in YAF 2.2
tecman
  •  tecman
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
2015-07-01T08:06:55Z
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
2015-07-01T08:49:19Z
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
2015-07-01T10:28:16Z
Originally Posted by: tecman 

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

Originally Posted by: tecman 


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 

Originally Posted by: tecman 


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

Originally Posted by: tecman 

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.

UserPostedImage
tha_watcha
2015-07-01T10:29:26Z
Originally Posted by: tecman 

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
UserPostedImage
tecman
  •  tecman
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
2015-07-01T10:37:09Z
Originally Posted by: tha_watcha 


Originally Posted by: tecman 


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.
tha_watcha
2015-07-01T10:49:49Z
Originally Posted by: tecman 

Originally Posted by: tha_watcha 


Originally Posted by: tecman 


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"
UserPostedImage
tecman
  •  tecman
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter
2015-07-01T10:52:54Z
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
2017-08-05T05:25:30Z
Hello
Uploads on the cp_message are shown as follows
[ attach ]1[ /attach ] [ attach]4[ /attach ]
How to fix this
Thank you
tha_watcha
2017-08-06T15:55:27Z
Thanks for the report issue will be fixed in YAF 2.2.4.2
UserPostedImage
tha_watcha
2017-08-07T15:42:28Z
Please download the latest version
UserPostedImage
mojtaba
2017-08-09T09:39:13Z
Originally Posted by: tha_watcha 

Please download the latest version


How to enable upload for all users in pmessage?
tha_watcha
2017-08-10T07:44:30Z
Originally Posted by: mojtaba 

Originally Posted by: tha_watcha 

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

UserPostedImage
mojtaba
2017-08-12T10:51:49Z
how to fix this error (yaf 2.2.4.2)?
Could not find stored procedure \'dbo.aspnet_CheckSchemaVersion\'.
tha_watcha
2017-08-13T18:13:02Z
Originally Posted by: mojtaba 

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?

UserPostedImage
mojtaba
2017-08-14T04:28:50Z
in the first installing
forum-error.jpg

Click to View Image43 View(s)


after this, when visit site show this error


Quote:

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
 Atom Feed Rss Feed
Similar Topics
Users browsing this topic
    1. YAF.NET Support Forum
    2. YAF Forum Discussions
    3. YAF General
    4. Working with attachments in YAF 2.2
     

    About Us

    The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

    Powered by Resharper Donate with PayPal button

    Project Twitter Updates

    Useful Links

    Our Contacts

    www.yetanotherforum.net

    Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved