Poking Around in EventQueue Table: Can't Find Cause of Error

Rate this topic:

Please Register to post a reply.

Another benefit of registration is the ability to subscribe to and recieve notifications of new posts.

Author

Messages

Terp
Posts:80

08/08/2007 5:07 PM
John, ...still trying to find the entry that keeps triggering pages of this error (though I uninstalled the damn Sixxac menu and the clinger-on'ers): EventQueue.ProcessMessage: Message Processing Failed ProcessorType: DotNetNuke.Entities.Modules.EventMessageProcessor, DotNetNuke Body: Sender: BusinessControllerClass: YourCompany.Modules.SixxacMenu.SixxacMenuController DesktopModuleId: 75 UpgradeVersionsList: 01.01.00 ExceptionMessage: Value cannot be null. Parameter name: type Is there any way to search the tables and find the nasty remnant triggering this?

John Mitchell
Posts:3196

08/08/2007 5:14 PM
You can safely delete records in the EventQueue table, or you may just want to set the isComplete flag on each record to 1 Go to Host > SQL and run this code: Update EventQueue Set isComplete=1

Terp
Posts:80

08/08/2007 5:29 PM
Thanks, John. Good to know; I'll give it a try, as I found a lot of DNN affiliate stuff in there that is taking up room:

Terp
Posts:80

08/08/2007 11:10 PM
I'm 90% there, John. Posted this over in the DNN forums, too, but the forum module forum is not very responsive as of late... ONLY errors I am getting now are from the forum module, which started after the change (spurious?): I am not sure if this is a best practice, but would installing the current upgrade over the top of the current module cause me to lose all the groups I have created and posts? ...other than that, I am clueless on this one, too... AssemblyVersion: 04.05.03 PortalID: 0 UserID: 18 ActiveTabID: 56 ActiveTabName: Forums RawURL: /Forums/tabid/56/Default.aspx AbsoluteURL: /Default.aspx UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.04506.30) DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider InnerException: Object cannot be cast from DBNull to other types. FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: System.DBNull.System.IConvertible.ToInt32 StackTrace: Message: System.InvalidCastException: Object cannot be cast from DBNull to other types.at System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider)at System.Convert.ToInt32(Object value)at DotNetNuke.Modules.Forum.ForumController.ModuleGetAll(Int32 PortalID, String Type)

John Mitchell
Posts:3196

08/09/2007 9:34 AM
I stopped using the core forum module a long time ago, so I don't have much experience there. The best advice I can give you is to make a backup and try the upgrade. If you loose the data then you can restore the backup. The upgrade should work without loosing anything, and I believe that is one of the main reasons that the current forums module in the release tracker has not made it to public release yet.

Please Register to post a reply.

Another benefit of registration is the ability to subscribe to and recieve notifications of new posts.

Forums >DotNetNuke Support >General-DNN-Help > Poking Around in EventQueue Table: Can't Find Cause of Error