 |
|
|
Joined: 4/23/2005
Posts: 70
|
|
|
When installed Events 5.0.0.1 on a fresh installation of DNN 4.9.4 I get the following error:
(...)
| Info |
Executing 04.00.00.SqlDataProvider |
| StartJob |
Start Sql execution: 04.00.00.SqlDataProvider file |
| EndJob |
End Sql execution: 04.00.00.SqlDataProvider file |
| |
| Info |
Executing 04.00.01.SqlDataProvider |
| StartJob |
Start Sql execution: 04.00.01.SqlDataProvider file |
| EndJob |
End Sql execution: 04.00.01.SqlDataProvider file |
| |
| Info |
Executing 04.00.02.SqlDataProvider |
| StartJob |
Start Sql execution: 04.00.02.SqlDataProvider file |
| EndJob |
End Sql execution: 04.00.02.SqlDataProvider file |
| |
| Info |
Executing 04.01.00.SqlDataProvider |
| 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 |
| EndJob |
End Sql execution: 04.01.00.SqlDataProvider file |
| |
| Info |
Executing 04.01.01.SqlDataProvider |
| StartJob |
Start Sql execution: 04.01.01.SqlDataProvider file |
| EndJob |
End Sql execution: 04.01.01.SqlDataProvider file |
| |
| Info |
Executing 04.01.02.SqlDataProvider |
| StartJob |
Start Sql execution: 04.01.02.SqlDataProvider file |
| EndJob |
End Sql execution: 04.01.02.SqlDataProvider file |
| |
| Info |
Executing 05.00.00.SqlDataProvider |
| StartJob |
Start Sql execution: 05.00.00.SqlDataProvider file |
| EndJob |
End Sql execution: 05.00.00.SqlDataProvider file |
(...)
Everything else looks fine and the module seems to work... at least at first glance.
Should I ignore the error?
I tried first installing over the Events module that came with DNN 4.9.4 and after that I removed the Events module and tried to install again - same result both times
|
| |
|
|
 | |
|
|
 |
www.thedivingclub.co.uk
Joined: 9/23/2004
Posts: 3531
|
|
|
If this is a new install you can ignore this. It is a bug in the 5.0.1 install on SQL 2000. If you are upgrading from a previous version, please let me know, and I can help you resolve if you have 'lost' events.
Cheers
Roger
|
| |
|
|
| |
|
|
|
Joined: 7/17/2003
Posts: 2
|
|
|
Hi Roger,
I´ve run into the same problem. Can you please help me to restore my old events?
Thanks in advanced.
Dirk
|
| |
|
|
| |
|
|
|
www.thedivingclub.co.uk
Joined: 9/23/2004
Posts: 3531
|
|
|
Hi Dirk,
Mail me - webmaster @ the domain in my profile. Can you also provide the information below in the email, so I can ensure I have the right resolution for you:-
- What version of Events are you upgrading from?
- What version of Events was your first install?
- What version of DNN are you on?
- What version of SQL Server are you using?
- Have you checked that AutoUpgrade=True in your web.config? If it is False, have you manually started all DNN upgrades ?
- Have you checked in the Module Settings to see if the 'Restart Upgrade' link is visible next to a red banner warning that the upgrade isn't complete?
- Were there any errors on the initial module install screen?
- Is an error displayed when you access the module?
Thanks
Roger
|
| |
|
|
| |
|
|
|
www.thedivingclub.co.uk
Joined: 9/23/2004
Posts: 3531
|
|
|
fyi - This problem has been resolved.
If you see this error on install, let me know, I have a SQL script to resolve the problem.
Thanks
Roger
|
| |
|
|
| |