Cannot insert the value NULL into column 'Description' Search Item

Last post 12-30-2005 9:44 AM by Javelin. 21 replies.

Sort Posts:

  • Cannot insert the value NULL into column 'Description' Search Item

    04-21-2005, 10:12 AM
    • Star
      11,292 point Star
    • brian_c
    • Member since 01-22-2004, 6:31 PM
    • Frisco, TX
    • Posts 2,259

    I have hundreds of these in my log ..   is this a bug ... or did I miss something?

     

    Cannot insert the value NULL into column 'Description'  SearchItem

  • Re: Cannot insert the value NULL into column 'Description' Search Item

    04-21-2005, 1:23 PM
    • Star
      11,292 point Star
    • brian_c
    • Member since 01-22-2004, 6:31 PM
    • Frisco, TX
    • Posts 2,259
    bump..  anyone see this in their logs...
  • Re: Cannot insert the value NULL into column 'Description' Search Item

    04-21-2005, 1:38 PM
    • Contributor
      2,850 point Contributor
    • Nocturnal
    • Member since 10-14-2003, 10:58 PM
    • Ridgefield, CT - USA
    • Posts 570
    I'm looking in my site logs but I don't see which log would contain such messages. All I see is site usage. Where do I look, please?
    SquadEngine for game squad and clan hosting
    GravityPoint for all other group portal hosting
    TungstenTech: DNN Site
  • Re: Cannot insert the value NULL into column 'Description' Search Item

    04-21-2005, 1:59 PM
    • Star
      11,292 point Star
    • brian_c
    • Member since 01-22-2004, 6:31 PM
    • Frisco, TX
    • Posts 2,259

    not site ..  but Log Viewer .. 

    the search schedule is running every 5 minutes ...  and I have many log entries every 5 minutes .... hmmmm

     

     

  • Re: Cannot insert the value NULL into column 'Description' Search Item

    04-21-2005, 2:10 PM
    • Contributor
      2,850 point Contributor
    • Nocturnal
    • Member since 10-14-2003, 10:58 PM
    • Ridgefield, CT - USA
    • Posts 570
    Ah, sorry about. I found the correct page and I don't see any of those errors. My site is tiny but I quess it's not something that affects everyone.
    SquadEngine for game squad and clan hosting
    GravityPoint for all other group portal hosting
    TungstenTech: DNN Site
  • Re: Cannot insert the value NULL into column 'Description' Search Item

    04-21-2005, 2:33 PM
    • Contributor
      3,090 point Contributor
    • DougV
    • Member since 02-23-2004, 4:27 PM
    • Missouri
    • Posts 618

    I have a site SGP & its been around for a while.  Looked in log viewer, no errors such as you mentioned in there.  It's DNN ver. 03.00.12

    Got an error when I then clicked "Search" on empty search box, Bad Data. at System.Security.Cryptography, etc., etc.

  • Re: Cannot insert the value NULL into column 'Description' Search Item

    04-21-2005, 2:38 PM
    • Star
      11,292 point Star
    • brian_c
    • Member since 01-22-2004, 6:31 PM
    • Frisco, TX
    • Posts 2,259

    are you saying it is .13?  :)

    is DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE  enabled in your services...

    It would be nice if logging logged some data of the record ..  I have no idea what who why where ...  module is giving the problem ..  what instance .. nothing...

     

     

     

     

  • Re: Cannot insert the value NULL into column 'Description' Search Item

    04-21-2005, 2:40 PM
    • Contributor
      3,090 point Contributor
    • DougV
    • Member since 02-23-2004, 4:27 PM
    • Missouri
    • Posts 618
    Don't know;  just hoping to get a few more clues to u maybe.....Confused [*-)]
  • Re: Cannot insert the value NULL into column 'Description' Search Item

    04-21-2005, 2:43 PM
    • Contributor
      3,090 point Contributor
    • DougV
    • Member since 02-23-2004, 4:27 PM
    • Missouri
    • Posts 618
     brian_c wrote:

    is DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE  enabled in your services...

    YES

     

  • Re: Cannot insert the value NULL into column 'Description' Search Item

    04-21-2005, 2:45 PM
    • Contributor
      3,090 point Contributor
    • DougV
    • Member since 02-23-2004, 4:27 PM
    • Missouri
    • Posts 618

    in HOST>>Schedule  click on "history" here's what mine looks like:

    Description Duration (ms) Succeeded Start/End/Next Start
    DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE
    Notes: Completed re-indexing content
    0.783 True 4/21/2005 11:43:31 AM
    4/21/2005 11:43:32 AM
    4/21/2005 11:48:31 AM
    DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE
    Notes: Completed re-indexing content
    0.64 True 4/21/2005 11:38:19 AM
    4/21/2005 11:38:20 AM
    4/21/2005 11:43:19 AM
    DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE
    Notes: Completed re-indexing content
    0.764 True 4/21/2005 11:33:07 AM
    4/21/2005 11:33:08 AM
    4/21/2005 11:38:07 AM
    DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE
    Notes: Completed re-indexing content
    0.627 True 4/21/2005 11:28:05 AM
    4/21/2005 11:28:06 AM
    4/21/2005 11:33:05 AM

  • Re: Cannot insert the value NULL into column 'Description' Search Item

    04-21-2005, 3:07 PM
    • Star
      11,292 point Star
    • brian_c
    • Member since 01-22-2004, 6:31 PM
    • Frisco, TX
    • Posts 2,259
    mine has that too ..  all true ..
  • Re: Cannot insert the value NULL into column 'Description' Search Item

    04-25-2005, 2:13 AM
    • Contributor
      4,760 point Contributor
    • DBuckner
    • Member since 01-23-2003, 11:10 PM
    • Illinois
    • Posts 952

    I noticed this on a image module in a site. From the looks of it, the settings had not yet been set so the items was null when the indexer ran across it.

    Dave

  • Re: Cannot insert the value NULL into column 'Description' Search Item

    05-02-2005, 2:43 PM
    • Participant
      830 point Participant
    • liffey
    • Member since 05-20-2003, 2:00 PM
    • Dublin, Ireland
    • Posts 166

    I to have been having strange problems related to the Search Indexing.  I posted http://forums.asp.net/884002/ShowPost.aspx but no luck.  I have now removed the SearchEngineScheduler task and it still runs!!!

    I initially thought the problem may have been caused by an upgrade but I am now having the same problems on a clean 3.0.13 installation.

    On the thread above I show where the error is thrown.  Why there are duplicates in the table in the first place escapes me.

  • Re: Cannot insert the value NULL into column 'Description' Search Item

    05-03-2005, 3:00 AM
    • Contributor
      7,163 point Contributor
    • ErikVB
    • Member since 12-10-2004, 1:14 PM
    • Netherlands
    • Posts 1,433
    • TrustedFriends-MVPs

    i think there was in issue in one of the later beta versions that caused errors in the search indexer after you deleted modules. However, an upgrade to 3.0.12 should have fixed that ...

    The other reason for errors during search indexing is an obvious, but i think often overlooked, one. Chances are you are using a module with a poorly implemented GetSearchItems method ... It can be a tedious job to track down the module in question though. A hint would be looking at the exact error that you get (either duplicate values, or null values). If the error is a duplicate value, try to find the value in the searchitems table, check the moduleid for that record, and find out what module it is ... Null values are a bit harder to do. One way is to create a new portal on a new instance of dnn, and start adding your modules, reindex the search parameters after every addition ... this way you will find the module that is causing the error ...

    it would help a lot if the exception would mention at least the moduleid that is causing the error ....

    cheers,

    erik

    Erik van Ballegoij, The Netherlands
  • Re: Cannot insert the value NULL into column 'Description' Search Item

    05-03-2005, 4:30 AM
    • Participant
      830 point Participant
    • liffey
    • Member since 05-20-2003, 2:00 PM
    • Dublin, Ireland
    • Posts 166

    I have run a query to show me any duplicates on the table SearchWords. I included joins to get the ModuleID, Module Title and friendly name.

    The modules where duplicates are found are:

    Text/HTML
    FAQ
    Announcements
    Links
    Documents

    all core modules!

Page 1 of 2 (22 items) 1 2 Next >