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...Upgrading DNN P...Upgrading DNN P...Upgrade from 5.3.1 to 5.4.1Upgrade from 5.3.1 to 5.4.1
Previous
 
Next
New Post
5/2/2010 7:31 AM
 

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

 
New Post
5/2/2010 9:24 AM
 

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
 
New Post
5/2/2010 9:31 AM
 

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

 
New Post
5/10/2010 10:42 AM
 
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.
 
New Post
5/10/2010 11:11 AM
 
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.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Upgrade from 5.3.1 to 5.4.1Upgrade from 5.3.1 to 5.4.1


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.

Copyright 2014 by DNN Corp Terms of Use Privacy
Request
a Demo
See Evoq Live
Latest Blog
How to Make Advocate Marketing Work for You
Read It
Watch the Replay
Top 5 Reasons to Consider a Branded Online Community
Watch