Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

telerik -- supercharge your DNN websites
  Ads  
Iron Speed Designer is a software development tool for building database, reporting, and forms applications for .NET without hand-coding.
 


  Sponsors  

Meet Our Sponsors

OnyakTech
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
SteadyRain
DataSprings - Great Ideas. Always Flowing.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Events Module [...  Bug report: Cannot insert explicit value for identity column in table 'Tmp_Events'
Previous Previous
 
Next Next
New Post 4/6/2006 4:06 PM
User is offline Shane Miller
518 posts
www.callcenters24x7.com
8th Ranked


Bug report: Cannot insert explicit value for identity column in table 'Tmp_Events' 

I got the error below while installing 03.02.00 onto DNN 3.2.2, running on SQL Server 2005:

StartJob Start Sql execution: 03.02.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot insert explicit value for identity column in table 'Tmp_Events' when IDENTITY_INSERT is set to OFF. 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) IF EXISTS(SELECT * FROM dbo.Events) INSERT INTO dbo.Tmp_Events (EventID, ModuleID, EventDateBegin, EventDateEnd, EventTimeBegin, Duration, EventName, EventDesc, Importance, RepeatType, Every, Period, CreatedBy, CreatedDate, Approved, ImageURL, ImageType, ImageDisplay, PayPalAccount, EnrollFee) SELECT ItemID, ModuleID, DateTime, ExpireDate, DateTime, 60, Title, Description, 2, Period, Every, Period, CreatedByUser, CreatedDate, 1, IconFile, 'F', 0, 'UPGRADEDEVENT', 0 FROM dbo.Events 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.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



Shane Miller
Call Centers 24x7
 
New Post 2/12/2007 9:14 AM
User is offline Trevor Major
17 posts
10th Ranked


Re: Bug report: Cannot insert explicit value for identity column in table 'Tmp_Events' 
Did you ever get an answer to this? I am getting something similar on DNN 3.3.7 under .net 2.0.
 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Events Module [...  Bug report: Cannot insert explicit value for identity column in table 'Tmp_Events'
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Lucede Systems Group
Providing a full range of IT services for large and medium sized companies
www.lucede.com
Adaptive InfoSystems, Inc.
We provide custom programming and various levels of support for DotNetNuke and the .Net framework.
www.aisysweb.com
Multipartner Virtual Data Rooms
The Virtual Data Rooms (VDR) provided by an expert advisor, far from any ordinary software company!, supporting the sellers and their consultants. Multipartner builds and services higly professional Virtual Data Rooms (VDR) specifically tailored to M&A, Real Estate and NPL deals.
www.multipartner.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP