|
Joined: 2/11/2004
Posts: 22
|
|
|
Hi,
Error during install events v. 4.1.1 RC1 :
| StartJob |
Start Sql execution: 04.01.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The text, ntext, or image data type cannot be selected as DISTINCT. 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) /* Add dummy values to EventsRecurMaster table */ INSERT dbo.EventsRecurMaster ( ModuleID, PortalID, RRULE, DTSTART, Duration, Until, EventName, EventDesc, Importance, Notify, Approved, Signups, MaxEnrollment, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, ImageURL, ImageWidth, ImageHeight, ImageDisplay, Location, Category, Reminder, TimezoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, CustomField1, CustomField2, EnrollListView, DisplayEndDate, AllDayEvent, CultureName, OwnerID, CreatedByID, CreatedDate, UpdatedByID, UpdatedDate ) Select Distinct ModuleID, Portalid, 'Dummy', GetUTCDate(), '0M', GetUTCDate(), '', '', 2, '', 0, 0, 0, '', 0, '', '', '', 0, 0, 0, null, null, '', 0, 0, 0, '', '', '', '', 0, 0, 0, '', 0, 0, GetUTCDate(), 0, GetUTCDate() from dbo.Events |
|
| |
|
|