 |
|
|
|
Joined: 10/27/2006
Posts: 98
|
|
|
I ran the upgrade from 5.6.1 to 5.6.2 on another DNN installation, and got a SQL error in the log.
The site seems to be working -- is there a problem?
What should I do?
This is what I see in the "05.06.02" log:
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_Lists_ListName_Value_Text_ParentID'. Cannot insert duplicate key in object 'dbo.Lists'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (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)
/* DNN-13449 This procedure is no longer in use */
/*********************************************************/
if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[Dashboard_GetServerErrors]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE dbo.[Dashboard_GetServerErrors]
/* DNN-14577 - Add Data Type Multiline Textbox for Profile Properties */
/*************************************************************************/
IF NOT EXISTS (SELECT value FROM dbo.Lists
WHERE ListName ='DataType' AND Value = 'Multi-line Text')
INSERT INTO dbo.Lists (ListName, Value, Text, DefinitionId, PortalId, SystemList)
VALUES ('DataType', 'Multi-line Text', 'DotNetNuke.UI.WebControls.MultiLineTextEditControl, DotNetNuke', -1, -1, 1)
/************************************************************/
/***** SqlDataProvider *****/
/************************************************************/
|
| |
|
|
 | |
|
|
 |
www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
|
|
|
The second error would be related to the addition of the "Multi-line Text" editor control registration to the database table Lists for use in user profile form, etc.. It may have been that the control was registered previously or there is a data-integrity issue in the contents of the Lists table. If you can take a look at the Lists table (using a tool such as SQL Server Management Studio), you can verify if the entry is there and add it if necessary.
The following columns of the Lists table should have the below values:
ListName: DataType
Text: Multi-line Text
Value: DotNetNuke.UI.WebControls.MultiLineTextEditControl, DotNetNuke
ParentID: 0
Level: 0
SortOrder: 0
DefinitionIID: -1
Description: NULL
PortalID: -1
SystemList: 1
All of the other columns will have NULL values.
If the row in the Lists table is not the last but has the above values, it is likely that the control was already registered and you should be able to ignore this error. You can also ignore the first error.
Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
|
| |
|
|
| |
|
|
|
Joined: 10/27/2006
Posts: 98
|
|
|
This is what I see in that table:
| DataType |
Unknown |
UseSystemType |
| DataType |
Text |
DotNetNuke.UI.WebControls.TextEditControl, DotNetNuke |
| DataType |
Integer |
DotNetNuke.UI.WebControls.IntegerEditControl, DotNetNuke |
| DataType |
TrueFalse |
DotNetNuke.UI.WebControls.TrueFalseEditControl, DotNetNuke |
| DataType |
TimeZone |
DotNetNuke.UI.WebControls.DNNTimeZoneEditControl, DotNetNuke |
| DataType |
Locale |
DotNetNuke.UI.WebControls.DNNLocaleEditControl, DotNetNuke |
| DataType |
Page |
DotNetNuke.UI.WebControls.DNNPageEditControl, DotNetNuke |
| DataType |
RichText |
DotNetNuke.UI.WebControls.DNNRichTextEditControl, DotNetNuke |
| DataType |
Country |
DotNetNuke.UI.WebControls.DNNCountryEditControl, DotNetNuke |
| DataType |
Region |
DotNetNuke.UI.WebControls.DNNRegionEditControl, DotNetNuke |
| DataType |
List |
DotNetNuke.UI.WebControls.DNNListEditControl, DotNetNuke |
| DataType |
Date |
DotNetNuke.UI.WebControls.DateEditControl, DotNetNuke |
| DataType |
DateTime |
DotNetNuke.UI.WebControls.DateTimeEditControl, DotNetNuke |
|
| |
|
|
| |
|
|
|
www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
|
|
|
That is very strange as the Multi-line Text control was not previously registered in the Lists table and the duplicate key error should not have occurred. I would suggest re-running this portion of the 05.06.02.SQLDataProvider script using the Host-->SQL control:
IF NOT EXISTS (SELECT value FROM {databaseOwner}{objectQualifier}Lists
WHERE ListName ='DataType' AND Value = 'Multi-line Text')
INSERT INTO {databaseOwner}{objectQualifier}Lists (ListName, Value, Text, DefinitionId, PortalId, SystemList)
VALUES ('DataType', 'Multi-line Text', 'DotNetNuke.UI.WebControls.MultiLineTextEditControl, DotNetNuke', -1, -1, 1)
Be sure to check the "Run As Script" checkbox before executing the script so that the {databaseOwner} and {objectQualifier} tokens are properly resolved for your particular installation
If the same error occurs I would check the unique index "IX_DNN_Lists_ListName_Value_Text_ParentID" on the Lists table. It should be a composite key dependent on four columns - ListName, Value, Text and ParentID.
Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
|
| |
|
|
| |
|
|
|
the "IF not Exist" will fail, if you previously registered "multi-line Text" with different capitalization ("LIKE" would have been better here, my fault). If "Multi-line text" appears in the list of available profile property types in Admin :: Users, when adding a new property, you may safely ignore the error.
|
| |
|
|
| |