Hi
I've been trying to develop a module using the video tutorial put on dnnjungle 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. Everything seems to work fine in the videos
Thanks
Mike