Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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...From 4.9.5 to 5.2.3 - ERRORS! Please helpFrom 4.9.5 to 5.2.3 - ERRORS! Please help
Previous
 
Next
New Post
8/2/2010 5:04 AM
 
nectar

Joined: 4/14/2005
Posts: 232
Hello all,
I am trying to upgrade my site from 4.9.5 to 5.4.x. I have read that I should upgrade to the 5.2.3 version first.
Im running WinServer 03, SQL Server 05, and I have installed the .NET 3.5 SP1 and .NET 4.0.

When I try to upgrade, I get the following errors:

Upgrading DotNetNuke

Current Assembly Version: 05.02.03

Current Database Version: 04.09.04



Upgrade Status Report

00:00:00.765 - Upgrading to Version: 05.02.03
00:00:01.125 -   Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log for more information)
00:01:10.421 -   Executing Script: 05.00.01.SqlDataProvider Error! (see 05.00.01.log for more information)
00:01:17.468 -   Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information)
00:02:42.984 -   Executing Script: 05.01.01.SqlDataProvider Error! (see 05.01.01.log for more information)
00:02:50.593 -   Executing Script: 05.01.02.SqlDataProvider Error! (see 05.01.02.log for more information)
00:03:00.578 -   Executing Script: 05.01.03.SqlDataProvider Error! (see 05.01.03.log for more information)
00:03:08.468 -   Executing Script: 05.01.04.SqlDataProvider Error! (see 05.01.04.log for more information)
00:03:14.421 -   Executing Script: 05.02.00.SqlDataProvider Error! (see 05.02.00.log for more information)
00:03:24.500 -   Executing Script: 05.02.01.SqlDataProvider Error! (see 05.02.01.log for more information)
00:03:29.562 -   Executing Script: 05.02.02.SqlDataProvider Error! (see 05.02.02.log for more information)
00:03:35.640 -   Executing Script: 05.02.03.SqlDataProvider Error! (see 05.02.03.log for more information)
00:03:44.515 -   Executing Application Upgrades: 05.00.00 Success
00:04:17.593 -   Executing Application Upgrades: 05.00.01 Success
00:04:17.656 -   Executing Application Upgrades: 05.01.00 Success
00:04:24.218 -   Executing Application Upgrades: 05.01.01 Success
00:04:24.406 -   Executing Application Upgrades: 05.01.02 Success
00:04:24.406 -   Executing Application Upgrades: 05.01.03 Success
00:04:24.859 -   Executing Application Upgrades: 05.01.04 Success
00:04:24.859 -   Executing Application Upgrades: 05.02.00 Success
00:04:25.375 -   Executing Application Upgrades: 05.02.01 Success
00:04:25.390 -   Executing Application Upgrades: 05.02.02 Success
00:04:25.390 -   Executing Application Upgrades: 05.02.03 Success
00:04:25.390 -   Cleaning Up Files: 05.00.00 Success
00:04:27.843 -   Cleaning Up Files: 05.00.01 Success
00:04:28.093 -   Cleaning Up Files: 05.01.00 Success
00:04:31.093 -   Cleaning Up Files: 05.01.01 Success
00:04:31.093 -   Cleaning Up Files: 05.01.02 Success
00:04:31.093 -   Cleaning Up Files: 05.01.03 Success
00:04:31.093 -   Cleaning Up Files: 05.01.04 Success
00:04:31.093 -   Cleaning Up Files: 05.02.00 Success
00:04:31.093 -   Cleaning Up Files: 05.02.01 Success
00:04:31.093 -   Cleaning Up Files: 05.02.02 Success
00:04:31.093 -   Cleaning Up Files: 05.02.03 Success
00:04:31.093 -   Updating Config Files: 05.00.00 Success
00:04:31.093 -   Updating Config Files: 05.00.01 Success
00:04:31.093 -   Updating Config Files: 05.01.00 Success
00:04:31.250 -   Updating Config Files: 05.01.01 Success
00:04:31.250 -   Updating Config Files: 05.01.02 Success
00:04:31.250 -   Updating Config Files: 05.01.03 Success
00:04:31.250 -   Updating Config Files: 05.01.04 Success
00:04:31.250 -   Updating Config Files: 05.02.00 Success
00:04:31.406 -   Updating Config Files: 05.02.01 Success
00:04:31.468 -   Updating Config Files: 05.02.02 Success
00:04:31.468 -   Updating Config Files: 05.02.03 Success
00:04:31.468 - Performing General Upgrades
00:04:31.671 - Installing Optional Modules:
00:04:31.734 -   Installing Package File HTML_Community_05.02.00_Install:  Error!
00:04:39.468 - Installing Optional Skins:
00:04:39.468 -   Installing Package File DNN-MinimalExtropySkin_01.00.05_Install:  Success
00:04:43.593 - Installing Optional Containers:
00:04:43.593 -   Installing Package File DNN-MinimalExtropyContainer_01.00.05_Install:  Success
00:04:44.578 - Installing Optional Languages:
00:04:44.578 - Installing Optional Providers:
00:04:44.578 -   Installing Package File AspNetMembershipProvider_05.02.00_Install:  Success
00:04:45.203 -   Installing Package File CorePermissionProvider_05.01.01_Install:  Success
00:04:45.593 -   Installing Package File DatabaseLoggingProvider_05.01.01_Install:  Success
00:04:45.890 -   Installing Package File DNNMembershipProvider_05.01.03_Install:  Success
00:04:46.171 -   Installing Package File DNNMenuNavigationProvider_05.01.00_Install:  Success
00:04:46.390 -   Installing Package File DNNTreeNavigationProvider_05.01.00_Install:  Success
00:04:46.718 -   Installing Package File FckHtmlEditorProvider_02.00.04_Install:  Success
00:05:12.812 -   Installing Package File FileBasedCachingProvider_05.01.03_Install:  Success
00:05:13.093 -   Installing Package File FileModuleCachingProvider_05.02.01_Install:  Success
00:05:13.328 -   Installing Package File MemoryModuleCachingProvider_05.02.01_Install:  Success
00:05:13.484 -   Installing Package File SchedulingProvider_05.02.01_Install:  Success
00:05:13.718 -   Installing Package File SearchIndexProvider_05.01.00_Install:  Success
00:05:13.906 -   Installing Package File SearchProvider_05.01.01_Install:  Success
00:05:14.156 -   Installing Package File SolpartMenuNavigationProvider_05.01.00_Install:  Success
00:05:14.437 - Installing Optional AuthSystems:
00:05:14.437 -   Installing Package File LiveID_01.00.01_Install:  Success
00:05:14.750 -   Installing Package File OpenID_02.00.00_Install:  Success
00:05:15.093 - Installing Optional Packages:

Upgrade Complete



Click Here To Access Your Portal


--------------------------------------------------------------------------------------

Now, when I navigate into the portal, all the HTML modules do not appear to have any content, 'critical errors' are on display in the middle of the page, but all the rest work fine.

Any ideas? Please help!

Thanks!
 
New Post
8/2/2010 9:47 AM
 
marwan jmean

Joined: 3/11/2009
Posts: 26
Try to read  the log file and to detect the problem,
some times it just a wrong data inside the database,if it so delete it and run the script manually 
 
New Post
8/2/2010 2:24 PM
 
Mitchel Sellers


Mitchel Sellers's Avatar

Mitchel Sellers's Avatar

Mitchel Sellers's Avatar

Mitchel Sellers's Avatar

Mitchel Sellers's Avatar

Mitchel Sellers's Avatar

www.mitchelsellers.com
Joined: 1/24/2007
Posts: 7846
Have you reviewed the log files noted to see what the errors were?
-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
New Post
8/2/2010 2:59 PM
 
nectar

Joined: 4/14/2005
Posts: 232
Hello,


Modules on pages such as the TEXT/HTML gives me the error: A critical error has occurred. Most of the pages who were supposed to have content are blank and the above error is repeated on each page.
Object reference not set to an instance of an object.

under \Providers\DataProviders\SqlDataProvider I get the following errors:

System.Data.SqlClient.SqlException: Cannot find the object 'SearchAllTables', because it does not exist or you do not have permission.
   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 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, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='dboLB')  begin    declare @exec nvarchar(2000)     declare @name varchar(150)     declare sp_cursor cursor for select o.name as name     from dbo.sysobjects o     where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 )     and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0     and o.name not like N'#%%'     and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_')     open sp_cursor     fetch sp_cursor into @name     while @@fetch_status >= 0       begin        select @exec = 'grant EXECUTE on [' +  @name  + '] to [dboLB]'        execute (@exec)        fetch sp_cursor into @name       end     deallocate sp_cursor  end


-----
When I go under the 'Event Log' I can see the following errors:

AssemblyVersion: 5.2.3
PortalID: 1
PortalName: Laing & Buisson
UserID: 1
UserName: host
ActiveTabID: 52
ActiveTabName: Home
RawURL: /Home.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://xxx.com/Admin/LogViewer.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.8.1.20) Gecko/20081217 Firefox/2.0.0.20 (.NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 0ebae99b-77d4-408d-937c-081af951bfd0
InnerException: Object reference not set to an instance of an object.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Bonosoft.BonosoftLink.BonosoftLinkView.Page_Load
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Bonosoft.BonosoftLink.BonosoftLinkView.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: FILMAKIA

After this I uninstall the module 'Bonosoft LInks' and the pages seem to appear slightly better (meaning that the modules frames appear but html content shows errors).

I tried to install the newest version of the HTML module but I get the following errors:

Error loading files from temporary folder - see below
StartJob Starting Installation
Info Starting Installation - DNN_HTML
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - Providers\DataProviders\SqlDataProvider\05.01.00.SqlDataProvider
Info Created
Info Executing 05.01.00.SqlDataProvider
Info Start Sql execution: 05.01.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot find the object 'SearchAllTables', because it does not exist or you do not have permission. 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 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, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole) if exists (select * from dbo.sysusers where name='dboLB') begin declare @exec nvarchar(2000) declare @name varchar(150) declare sp_cursor cursor for select o.name as name from dbo.sysobjects o where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 ) and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0 and o.name not like N'#%%' and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_') open sp_cursor fetch sp_cursor into @name while @@fetch_status >= 0 begin select @exec = 'grant EXECUTE on [' + @name + '] to [dboLB]' execute (@exec) fetch sp_cursor into @name end deallocate sp_cursor end
Info End Sql execution: 05.01.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - DNN_HTML
Info Deleted temporary install folder
EndJob Installation Failed

------
Please help!!!!!!
 
New Post
8/2/2010 3:11 PM
 
nectar

Joined: 4/14/2005
Posts: 232
After that,

I tried to install the 4.9 version of the HTML Module and when I checked the 'Event log' the following error appears:

ModuleId: 1455
ModuleDefId: 98
FriendlyName: Text/HTML
ModuleControlSource: DesktopModules/HTML/HtmlModule.ascx
AssemblyVersion: 5.2.3
PortalID: 1
PortalName: Laing & Buisson
UserID: 1
UserName: host
ActiveTabID: 52
ActiveTabName: Home
RawURL: /Home.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://lxxx/tabid/18/ctl/Install/rtab/18/portalid/1/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.8.1.20) Gecko/20081217 Firefox/2.0.0.20 (.NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: c56914bc-8764-424c-9506-c22061743b47
InnerException: Parameter count does not match Parameter Value count.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.HTML.SqlDataProvider.GetHtmlText(Int32 moduleId) at DotNetNuke.Modules.HTML.HtmlTextController.GetHtmlText(Int32 moduleId) at DotNetNuke.Modules.Html.HtmlModule.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: FILMAKIA

On the actual module on the page this error appears:

Error: Text/HTML is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.HTML.SqlDataProvider.GetHtmlText(Int32 moduleId) at DotNetNuke.Modules.HTML.HtmlTextController.GetHtmlText(Int32 moduleId) at DotNetNuke.Modules.Html.HtmlModule.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...From 4.9.5 to 5.2.3 - ERRORS! Please helpFrom 4.9.5 to 5.2.3 - ERRORS! Please help


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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out