Products

Solutions

Resources

Partners

Community

Blog

About

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...DNN 5.2.1 DB Upgrade ErrorDNN 5.2.1 DB Upgrade Error
Previous
 
Next
New Post
12/23/2009 4:52 PM
 

I had problems related to the script not prefixing some objects with dnn_ .  That prevented the sqldataprovider from running.  I re-ran the script after fixing this.  Is there anything else I need to do to finish the install or am I done?


Bryan Johns
K4GDW

"There are 10 types of people. Those who understand binary and those who do not."
 
New Post
12/23/2009 10:17 PM
 
@Joe,

Continuing for where this left off earlier...

All the attempts to solve the error have been without luck. The last conversation I had with my hosting environment is entered below. I could use help on this, has anyone else run into this problem in a shared environment?

------- Comment from my provider ---------
Hi, I already viewed the post and the comments from "Joe Brinkman" at "DotNet Nuke Group" suggest that the "defensive" code should active only when 1) the "Upgradeconnection" string is not specified" or 2) the DB login do not own "dbo" schema for the database.

However, in your case, DNN upgrade process still seem to run the "defensive" code even the condition do not meet and it should an issue of DNN. As "giving" the "database" login "grant" permission may introduce vulnerability on shared environment, we cannot give out this "permission" to user login. Could you please confer with them to verify the "defensive" code can be safety bypass if "upgrade connection string" is in place and can the SQL upgrade statement in "05.02.01.SqlDataProvider" be executed via "Management Studio" instead?
-------------------------------------------------------

Any thoughts, anyone?


Wisconsins DNN User Group: www.WIDNN.com
Visit my home page: www.HerbBenton.com
 
New Post
12/25/2009 7:14 AM
 

 Well, for the fisrt time in months i got the first error in my dnn upgrade process since first install... untill now everything went fine but still i cannot complain Let´s see, is this error GRANT PERMISSION only!? I have the backup of my db and dnn previous to update, is it enought to restore, ask for GRANT PERMISSION to my host and after that to make the update?

Upgrading DotNetNuke

Current Assembly Version: 05.02.01

Current Database Version: 05.02.00

 

Upgrade Status Report

00:00:00.062 - Upgrading to Version: 05.02.01
00:00:00.281 -   Executing Script: 05.02.01.SqlDataProvider Error! (see 05.02.01.log for more information)
00:00:02.172 -   Executing Application Upgrades: 05.02.01 Success
00:00:02.234 -   Cleaning Up Files: 05.02.01 Success
00:00:02.250 -   Updating Config Files: 05.02.01 Success
00:00:02.313 - Performing General Upgrades
00:00:03.016 - Installing Optional Modules:
00:00:03.031 -   Installing Package File HTML_Community_05.02.00_Install:  Success
00:00:04.016 - Installing Optional Skins:
00:00:04.032 - Installing Optional Containers:
00:00:04.047 - Installing Optional Languages:
00:00:04.047 - Installing Optional Providers:
00:00:04.079 -   Installing Package File AspNetMembershipProvider_05.02.00_Install:  Success
00:00:04.172 -   Installing Package File CorePermissionProvider_05.01.01_Install:  Success
00:00:04.297 -   Installing Package File DatabaseLoggingProvider_05.01.01_Install:  Success
00:00:04.376 -   Installing Package File DNNMembershipProvider_05.01.03_Install:  Success
00:00:04.469 -   Installing Package File DNNMenuNavigationProvider_05.01.00_Install:  Success
00:00:04.563 -   Installing Package File DNNTreeNavigationProvider_05.01.00_Install:  Success
00:00:04.657 -   Installing Package File FckHtmlEditorProvider_02.00.04_Install:  Success
00:00:07.908 -   Installing Package File FileBasedCachingProvider_05.01.03_Install:  Success
00:00:08.048 -   Installing Package File FileModuleCachingProvider_05.02.01_Install:  Success
00:00:08.486 -   Installing Package File MemoryModuleCachingProvider_05.02.01_Install:  Success
00:00:08.642 -   Installing Package File SchedulingProvider_05.02.01_Install:  Success
00:00:08.908 -   Installing Package File SearchIndexProvider_05.01.00_Install:  Success
00:00:09.002 -   Installing Package File SearchProvider_05.01.01_Install:  Success
00:00:09.095 -   Installing Package File SolpartMenuNavigationProvider_05.01.00_Install:  Success
00:00:09.236 - Installing Optional AuthSystems:
00:00:09.236 -   Installing Package File LiveID_01.00.01_Install:  Success
00:00:09.471 -   Installing Package File OpenID_02.00.00_Install:  Success
00:00:09.689 - Installing Optional Packages:
 

Upgrade Complete

....

and the log says:

System.Data.SqlClient.SqlException: Cannot find the user 'SQL2008_user', 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)

GRANT EXECUTE TO [SQL2008_user]

Anyway, my site is working normaly for now( didn´t got the time to make all the tests...), but if i´m not wrong, i won´t be able to make the next update, true!?

Looks everybody has the same problem... so now, how can we fix it, in a begginers way!? And guys, you´ve allready seen this comming

Thanks!


mPowered by realhacker.net
 
New Post
12/26/2009 3:58 AM
 
I have tried to install 5.2.1 twice on an external server and both failed.
This is the log file - I set "DNN_" as the qualifier and this is missing from the script, so this looks to me like an error in the script. 5.1 installs fine.
JC
System.Data.SqlClient.SqlException: Invalid object name 'Lists'.
   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)


/* Set DataType List to be a SystemList */
/****************************************/

UPDATE Lists SET SystemList = 'True' WHERE ListName = 'DataType'

[end]
 
New Post
12/26/2009 6:29 AM
 

I have searched in my web.config for the UpgradeConnectionString and copied the value from my connectionStringName to the value of the upgradeConnectionString. When manually firing up the upgrade process I got the following server error:

Format of the initializationstring does not conform to specification starting at index o.

Anyone any suggestions?

 


Regards,
Marc

www.biservices.eu for free nl-NL resourcepacks.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...DNN 5.2.1 DB Upgrade ErrorDNN 5.2.1 DB Upgrade Error


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