Login
Register
17-05-2008

Resources for the DotNetNuke Community
Join WebHost4Life.com
Support this site

  Support forums  

You need to be logged in in order to post to this forums.
SearchForum Home
  DotNetNuke Development  Templates  dnn template pr...
 dnn template problems
 
imgOfflinemjliscio
17 posts
Joined
10/1/2006

dnn template problems
Posted: 25 Oct 06 10:02 AM

Hi

I've been trying to develop a module using the video tutorial put on this site by seabury design, and the dnn 4x module template available in the starter kit on dotnetnuke.com.  Everything works fine until I reach the end of video 3.  I have followed all of the instructions given in the video, but when I try to add text to my blog module, and store it in the database i get the following message

 

Error: Edit First Module is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot insert the value NULL into column 'FirstID', table 'DotNetNukeDevelop.dbo.First'; column does not allow nulls. INSERT fails. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'FirstID', table 'DotNetNukeDevelop.dbo.First'; column does not allow nulls. INSERT fails. The statement has been terminated. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at YourCompany.Modules.First.SqlDataProvider.AddFirst(Int32 portalID, Int32 moduleID, String title, String text, DateTime dateAdd, DateTime dateMod) in C:\DotNetNukeDevelop\App_Code\First\SqlDataProvider.vb:line 135 at YourCompany.Modules.First.FirstController.AddFirst(FirstInfo objFirst) in C:\DotNetNukeDevelop\App_Code\First\FirstController.vb:line 29 at YourCompany.Modules.First.EditFirst.cmdUpdate_Click(Object sender, EventArgs e) in C:\DotNetNukeDevelop\DesktopModules\First\EditFirst.ascx.vb:line 150 --- End of inner exception stack trace ---

 

Is there something I need to do that is not includded in the video.  I don't understand why my primary key firstID is being set to null

 

Thanks

Mike

imgOfflinemjliscio
17 posts
Joined
10/1/2006

Re: dnn template problems
Posted: 01 Nov 06 8:00 AM
I was able to find an answe to this on dotnetnukes forrums.  If anyone else is having the same problem the problem was that my table identy collumn was not set to FirstID which is my primary key
  DotNetNuke Development  Templates  dnn template pr...
© Vicenç Masanas Terms Of Use Privacy Statement   
.