 |
|
|
 |
www.salaro.com
Joined: 12/27/2002
Posts: 1192
|
|
|
Today, I have now upgraded about 3 live sites and all seems to be good on the surface. Only one so far is showing the below error in the logs.
On this site there was a child portal. After upgrade beside the below error. the master portal continued to work. But the child portal completely disapeard from the portal list. It was completely gone.
I have now reverted to the backup and both sites are running under 5.3.1.
However, I wonder if anyone else has seen this. I will probably attempt it once more before later after I do some more research.
-----------------------------------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* ensure existing portal default languages have valid localization records */
DECLARE @PortalID int
DECLARE @DefaultLanguage nvarchar(10)
--Iterate through each portal
DECLARE Portals_Cursor CURSOR FOR
SELECT PortalID, DefaultLanguage
FROM dbo.Portals
OPEN Portals_Cursor
--get first
FETCH NEXT FROM Portals_Cursor
into @PortalID, @DefaultLanguage
WHILE @@FETCH_STATUS = 0
BEGIN
exec dbo.EnsureLocalizationExists @PortalID,@DefaultLanguage
FETCH NEXT FROM Portals_Cursor
into @PortalID, @DefaultLanguage
END
CLOSE Portals_Cursor
DEALLOCATE Portals_Cursor
|
| |
|
|
 | |
|
|
|
www.salaro.com
Joined: 12/27/2002
Posts: 1192
|
|
|
I tried once more. And this time I set the language to US En. Previously the child portal that failed was on UK En. Upgrade did not show any error.
But over the web, the site is unavailable. On the server, I can log in and I went to Admin/Language, and set hte language back to UK En. But I got the error below -
the site no longer functions and url show
http://new.devsalar.com/Default.aspx?error=Object+reference+not+set+to+an+instance+of+an+object.&content=0
-------------------------------
ModuleId: 530
ModuleDefId: 122
FriendlyName: Languages
ModuleControlSource: DesktopModules/Admin/Languages/languageEnabler.ascx
AssemblyVersion: 5.4.1
PortalID: 1
PortalName: 8thdayuk
UserID: 1
UserName: host
ActiveTabID: 104
ActiveTabName: Languages
RawURL: /Admin/Languages/tabid/104/language/en-US/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://new.8thdayuk.com/Admin/Languages/tabid/104/language/en-US/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.9.0.14) Gecko/2009082707 Firefox/3.0.14 ( .NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: b507b00a-ead3-4897-8fd2-c9827b8e6957
InnerException: String or binary data would be truncated. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: String or binary data would be truncated. The statement has been terminated. ---> System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.EnsureLocalizationExists(Int32 portalID, String CultureCode) at DotNetNuke.Entities.Portals.PortalController.UpdatePortalInfo(Int32 PortalId, String PortalName, String LogoFile, String FooterText, DateTime ExpiryDate, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, Double HostFee, Double HostSpace, Int32 PageQuota, Int32 UserQuota, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory, Int32 SplashTabId, Int32 HomeTabId, Int32 LoginTabId, Int32 RegisterTabId, Int32 UserTabId, String DefaultLanguage, Int32 TimeZoneOffset, String HomeDirectory, String CultureCode) at DotNetNuke.Entities.Portals.PortalController.UpdatePortalInfo(PortalInfo Portal) at DotNetNuke.Modules.Admin.Languages.LanguageEnabler.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: PROPERTIES
|
| |
|
|
| |
|
|
|
www.salaro.com
Joined: 12/27/2002
Posts: 1192
|
|
|
I give up today. I will backup to 5.3.1 and see if others see same issue and solutions for it.
OK There seems to be a few Language Related issues reported on 5.4.1. may be I should not try an upgrade for now.
Salar
|
| |
|
|
| |
|
|
Joined: 4/3/2007
Posts: 18
|
|
|
I have been struggling with this one. It looks like an issue with the stored procedure:
EnsureLocalizationExists, which reads:
...INSERT INTO dbo.PortalLocalization (...
FooterText,
Description,
.. )
VALUES (...
@Description,
@FooterText,
... )
...
Clearly the footer text and descriptions should be in the same order, ie:
...INSERT INTO dbo.PortalLocalization (...
FooterText,
Description,
.. )
VALUES (...
@FooterText,
@Description,
... )
...
I am about to see whether this is a problem in the 5.4.1 upgrade script, or in the version of the Stored procedure that is already installed. In the mean time, I hope this helps.
|
| |
|
|
| |
|
|
Joined: 4/3/2007
Posts: 18
|
|
|
Hi Salar,
This is because of a schoolboy mistake in the definition of the "EnsureLocalizationExists" stored procedure in the upgrade script that some pretty basic testing would have found and kept out of the release.
Swap lines 75 and 76 of \Providers\DataProviders\SqlDataProvider\05.04.01.SQLDataProvider before running the upgrade and it will work.
The problem is because the order of the parameters in the insert statement differs in the columns list to the list of values being inserted; somehow the FooterText and Description fields were swapped over. An easy mistake to make, and an easy mistake for the author to have found during the simplest of tests, and one which has undoubtedly cost a lot of people exponentially more time tracking down for themselves in a published release.
I hope that helps,
Brian Boyington
Web Developer
The Biochemical Society / Portland Press Ltd.
|
| |
|
|
| |