 |
|
|
www.lehighacreslive.com
Joined: 4/7/2006
Posts: 271
|
|
|
I got the same error as Drew when installing it.
If God does not live in Colorado, I bet he visits there a lot!!
|
| |
|
|
 | |
|
|
Joined: 6/12/2005
Posts: 1
|
|
|
Hello everyone,
I upgraded DNN to 4.3. Everything ok. I used the upgrade package, so, after the upgrade, I went on uploading some new modules. Events module was one of them. I got some SQL errors, but the installation was sucessful. I tried again, and this time no errors. Well, when I checked some of my pages that used this module... the module was there, but the content was gone!  How can I get back its content?? Thanks in advance.
Carlos
|
| |
|
|
| |
|
|
www.repfiles.net
Joined: 6/21/2005
Posts: 608
|
|
|
I have an error during install on all 4.0.3 installations I have:
| Info |
Executing 03.02.00.SqlDataProvider |
| StartJob |
Start Sql execution: 03.02.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'TimeZoneOffset'. Invalid column name 'SendReminder'. Invalid column name 'ReminderTime'. Invalid column name 'ReminderTimeMeasurement'. Invalid column name 'ReminderFrom'. 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.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsAVCalendarImport ( @CalendarModuleID int, @EventModuleID int, @Version nvarchar(8), @TimeZone int, @PortalID int, @ImportCategory bit, @ImportLocation bit ) AS IF EXISTS(SELECT * FROM Calendar) if @Version = '03.02.00' BEGIN INSERT INTO Events (EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, RepeatType, Every, Period, Reminder, Notify, CreatedBy, CreatedDate, Approved, PortalID, Signups, MaxEnrollment, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, Location, Category, TimeZoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, SearchSubmitted) SELECT EventID, @EventModuleID as ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, RepeatType, Every, Period, Reminder, Notify, CreatedBy, CreatedDate, Approved, PortalID, Signups, MaxEnrollment, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, Location, Category, TimeZoneOffset, SendReminder, ReminderTime, ReminderTimeMeasurement, ReminderFrom, 0 FROM Calendar WHERE ModuleID = @CalendarModuleID END ELSE BEGIN INSERT INTO Events (EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, RepeatType, Every, Period, Reminder, Notify, CreatedBy, CreatedDate, Approved, PortalID, Signups, MaxEnrollment, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, Location, Category, TimeZoneOffset) SELECT EventID, @EventModuleID as ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, RepeatType, Every, Period, Reminder, Notify, CreatedBy, CreatedDate, Approved, PortalID, Signups, MaxEnrollment, EnrollRoleID, EnrollFee, EnrollType, PayPalAccount, PayPalPassword, Cancelled, ImageURL, ImageType, ImageWidth, ImageHeight, ImageDisplay, Location, Category, @TimeZone FROM Calendar WHERE ModuleID = @CalendarModuleID END SET IDENTITY_INSERT EventsCategory ON if @ImportCategory <> 0 INSERT INTO EventsCategory (PortalID, Category, CategoryName, Color) SELECT PortalID, Category, CategoryName, Color FROM CalendarCategory WHERE PortalID = @PortalID SET IDENTITY_INSERT EventsCategory OFF SET IDENTITY_INSERT EventsLocation ON if @ImportLocation <> 0 INSERT INTO EventsLocation (PortalID, Location, LocationName, MapURL) SELECT PortalID, Location, LocationName, MapURL FROM CalendarLocation WHERE PortalID = @PortalID SET IDENTITY_INSERT EventsLocation OFF |
| EndJob |
End Sql execution: 03.02.00.SqlDataProvider file |
Icthus Technologies  Building Faith on the Internet
|
| |
|
|
| |
|
|
Joined: 6/24/2005
Posts: 1
|
|
|
Hi,
I had the same error during install on all 4.0.3 but it seems it working fine!!! 
|
| |
|
|
| |