Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...dbo.AddFile missing?dbo.AddFile missing?
Previous
 
Next
New Post
3/5/2014 8:43 AM
 

After transfering domain to new hosting, image upload through DNN does not work  ( IE in HTML editor, image manager i can no uplod files/pictures ). We checked permissions on server and they are correct (read&write). Database acess rigtht ( dbo.FolderPersmissions ) is generally also correct. Analyzing the event viewer, i have found and error relating to missing dbo.AddFile procedure, and it is really missing in my database?

 

Hot to fix this? My DNN version is 7.0.2. Can i copy any procedure there? Do you have a script to enter this procedure into database?

 

 

many thanks for you help

 

D.

 
New Post
3/5/2014 5:43 PM
 
as it was working before and isn't working now, I would guess the procedure is still there but your new sql cannot see it for some reason (i.e. new server is case sensitive, or is running an old version of sql), but as it's very close to this issue I suspect http://www.declanward.com/Blog/tabid/... is the problem. You'll have to ask your hosting provider to check and change this setting as needed.

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
3/6/2014 3:27 AM
 

Hi

thanks for link, but it is not that. looking thru logs  of restore procedure i found some errors. Do you think it is OK if i just run SQL statements who returned erorrs on live DNN site? Is that OK?

Thanks

D.

 

  • Error executing database objects script file [CREATE_mydatabase.2014.02.18.084855_Script_000002.sql]:
    • Error executing SQL:
      IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[Forum_vw_ForumUsers]')) EXEC dbo.sp_executesql @statement = N'CREATE VIEW dbo.[Forum_vw_ForumUsers] AS SELECT U.Username, U.FirstName, U.LastName, U.DisplayName, U.Email, U.UserID, FU.PortalID, FU.EnablePM, FU.EnableOnlineStatus, FU.EnableDisplayInMemberList, FU.PostCount, UP.CreatedDate FROM dbo.Users U INNER JOIN dbo.Forum_Users FU ON U.UserID = FU.UserID INNER JOIN dbo.UserPortals UP ON U.UserID = UP.UserId AND FU.PortalID = UP.PortalId WHERE (FU.EnableDisplayInMemberList = 1)'
      The exception is:
      Invalid column name 'EnableDisplayInMemberList'. Invalid column name 'EnablePM'. Invalid column name 'EnableDisplayInMemberList'.
    • Error executing SQL:
      IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AddEventMessage]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE dbo.AddEventMessage @EventName nvarchar(100), @Priority int, @ProcessorType nvarchar(250), @ProcessorCommand nvarchar(250), @Body nvarchar(250), @Sender nvarchar(250), @Subscriber nvarchar(100), @AuthorizedRoles nvarchar(250), @ExceptionMessage nvarchar(250), @SentDate datetime, @ExpirationDate datetime, @Attributes ntext AS INSERT dbo.EventQueue ( EventName, Priority, ProcessorType, ProcessorCommand, Body, Sender, Subscriber, AuthorizedRoles, ExceptionMessage, SentDate, ExpirationDate, Attributes ) VALUES ( @EventName, @Priority, @ProcessorType, @ProcessorCommand, @Body, @Sender, @Subscriber, @AuthorizedRoles, @ExceptionMessage, @SentDate, @ExpirationDate, @Attributes ) SELECT SCOPE_IDENTITY()' END
      The exception is:
      Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    • Error executing SQL:
      IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AddFile]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE dbo.[AddFile] @PortalId int, @UniqueId uniqueidentifier, @VersionGuid uniqueidentifier, @FileName nvarchar(246), @Extension nvarchar(100), @Size int, @Width int, @Height int, @ContentType nvarchar(200), @Folder nvarchar(246), @FolderID int, @CreatedByUserID int, @Hash varchar(40), @LastModificationTime DATETIME AS BEGIN DECLARE @FileID int UPDATE dbo.Files SET /* retrieves FileId from table */ @FileID = FileId, FileName = @FileName, VersionGuid = @VersionGuid, Extension = @Extension, Size = @Size, Width = @Width, Height = @Height, ContentType = @ContentType, Folder = @Folder, FolderID = @FolderID, LastModifiedByUserID = @CreatedByUserID, LastModifiedOnDate = getdate(), SHA1Hash = @Hash, LastModificationTime = @LastModificationTime WHERE FolderID = @FolderID AND FileName = @FileName IF @@ROWCOUNT = 0 BEGIN INSERT INTO dbo.Files ( PortalId, UniqueId, VersionGuid, FileName, Extension, Size, Width, Height, ContentType, Folder, FolderID, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate, SHA1Hash, LastModificationTime ) VALUES ( @PortalId, @UniqueId, @VersionGuid, @FileName, @Extension, @Size, @Width, @Height, @ContentType, @Folder, @FolderID, @CreatedByUserID, getdate(), @CreatedByUserID, getdate(), @Hash, @LastModificationTime ) SELECT @FileID = SCOPE_IDENTITY() END SELECT @FileID END' END
      The exception is:
      Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
 
New Post
3/6/2014 5:00 PM
 
your first error seems to be a script error in a forums module, not sure about those, but the other 2 are platform scripts that simply timed out - rerunning those scripts (and any scripts that followed) is fine as platform scripts are designed to be reentrant

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...dbo.AddFile missing?dbo.AddFile missing?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out