 |
|
|
Joined: 5/6/2009
Posts: 5
|
|
|
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.
|
| |
|
|
 | |
|
|
 |
 |
www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676
|
|
|
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
|
| |
|
|
| |
|
|
Joined: 5/6/2009
Posts: 5
|
|
|
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.
|
| |
|
|
| |
|
|
|
|
www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676
|
|
|
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
|
| |
|
|
| |