Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsDocumentsDocumentsCannot insert the value NULL into column Cannot insert the value NULL into column 'Clicks'
Previous
 
Next
New Post
10/23/2007 4:10 PM
 

 

Hi, I am getting the following erro when attempting to upload document. Nothing changed anywhere. As far as I can tell there is a problem with Click tracking. Any thoughts or suggestions? Thanks!

Cannot insert the value NULL into column 'Clicks', table 'DotNetNuke.dbo.Dockets'; column does not allow nulls. INSERT fails. The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'Clicks', table 'DotNetNuke.dbo.Dockets'; column does not allow nulls. INSERT fails. The statement has been terminated.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Cannot insert the value NULL into column 'Clicks', table 'DotNetNuke.dbo.Dockets'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +740
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196
   DotNetNuke.DocketDB.AddDocket(Int32 ModuleId, String Title, String DocDate, String Path, String Filename, String UserName) +220
   DotNetNuke.EditDocket.cmdUpdate_Click(Object sender, EventArgs e) +241
   System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +108
   System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138
   System.Web.UI.Page.ProcessRequestMain() +1292

 
New Post
10/24/2007 10:02 AM
 

It doesn't appear thta you are using the core Documents module as the tables used by the module are called "documents".

Which module are you using?


-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
New Post
10/24/2007 1:27 PM
 

Mitch Sellers wrote

It doesn't appear thta you are using the core Documents module as the tables used by the module are called "documents".

Which module are you using?

You are correct. It appears that this was a tweaked Documents module. I inherited this from a previous developer (who probably never finished the project). My question is: can I enable NULLs on the Clicks column? Or better approach is to strip the clicks tracking all together (if so, where should I look for it)? I want this to be a quick fix, since we are moving to SharePoint shortly.

 
New Post
10/24/2007 2:09 PM
 

Theroretically you should be able to just allow nulls, or better yet, set a default value for the column of 0


-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsDocumentsDocumentsCannot insert the value NULL into column Cannot insert the value NULL into column 'Clicks'


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, 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 DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out