Increment the size of FooterText in PortalLocalization table to 500 char:
ALTER TABLE [dbo].[PortalLocalization] ALTER COLUMN FooterText nvarchar(500)
The code to modify store procedure UpdatePortalInfo.
GO
/****** Object: StoredProcedure [dbo].[UpdatePortalInfo] Script Date: 02/11/2014 15:27:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[UpdatePortalInfo]
@PortalID int,
@PortalGroupID int,
@PortalName nvarchar(128),
@LogoFile nvarchar(50),
@FooterText nvarchar(500),
@ExpiryDate datetime,
@UserRegistration int,
@BannerAdvertising int,
@Currency char(3),
@AdministratorId int,
@HostFee money,
@HostSpace int,
@PageQuota int,
@UserQuota int,
@PaymentProcessor nvarchar(50),
@ProcessorUserId nvarchar(50),
@ProcessorPassword nvarchar(50),
@Description nvarchar(500),
@KeyWords nvarchar(500),
@BackgroundFile nvarchar(50),
@SiteLogHistory int,
@SplashTabId int,
@HomeTabId int,
@LoginTabId int,
@RegisterTabId int,
@UserTabId int,
@SearchTabId int,
@DefaultLanguage nvarchar(10),
@HomeDirectory varchar(100),
@LastModifiedByUserID int,
@CultureCode nvarchar(50)
AS
UPDATE dbo.Portals
SET
PortalGroupID = @PortalGroupID,
ExpiryDate = @ExpiryDate,
UserRegistration = @UserRegistration,
BannerAdvertising = @BannerAdvertising,
Currency = @Currency,
AdministratorId = @AdministratorId,
HostFee = @HostFee,
HostSpace = @HostSpace,
PageQuota = @PageQuota,
UserQuota = @UserQuota,
PaymentProcessor = @PaymentProcessor,
ProcessorUserId = @ProcessorUserId,
ProcessorPassword = @ProcessorPassword,
SiteLogHistory = @SiteLogHistory,
DefaultLanguage = @DefaultLanguage,
HomeDirectory = @HomeDirectory,
LastModifiedByUserID = @LastModifiedByUserID,
LastModifiedOnDate = getdate()
WHERE PortalId = @PortalID
IF EXISTS (SELECT * FROM dbo.PortalLocalization WHERE PortalId = @PortalID AND CultureCode = @CultureCode)
BEGIN
UPDATE dbo.PortalLocalization
SET
PortalName = @PortalName,
LogoFile = @LogoFile,
FooterText = @FooterText,
Description = @Description,
KeyWords = @KeyWords,
BackgroundFile = @BackgroundFile,
HomeTabId = @HomeTabId,
LoginTabId = @LoginTabId,
RegisterTabId = @RegisterTabId,
UserTabId = @UserTabId,
SplashTabId = @SplashTabId,
SearchTabId = @SearchTabId,
LastModifiedByUserID = @LastModifiedByUserID,
LastModifiedOnDate = getdate()
WHERE PortalId = @PortalID
AND CultureCode = @CultureCode
END
ELSE
BEGIN
DECLARE @AdminTabId int
SET @AdminTabId = (SELECT AdminTabId
FROM dbo.PortalLocalization
WHERE PortalID = @PortalID AND CultureCode='en-US')
INSERT INTO dbo.PortalLocalization (
[PortalID],
[CultureCode],
[PortalName],
[LogoFile],
[FooterText],
[Description],
[KeyWords],
[BackgroundFile],
[HomeTabId],
[LoginTabId],
[UserTabId],
[AdminTabId],
[SplashTabId],
[SearchTabId],
[CreatedByUserID],
[CreatedOnDate],
[LastModifiedByUserID],
[LastModifiedOnDate]
)
VALUES (
@PortalID,
@CultureCode,
@PortalName,
@LogoFile,
@FooterText,
@Description,
@KeyWords,
@BackgroundFile,
@HomeTabId ,
@LoginTabId ,
@UserTabId,
@AdminTabid,
@SplashTabId ,
@SearchTabId,
-1,
getdate(),
-1,
getdate()
)
END
Optional Modify the asp textBox control adding TextMode="Multiline" in the \DesktopModules\Admin\Portals\sitesettings.ascx
|