After adding the time edit mod I am now getting the following error when I try to create a new web link.
"Microsoft JET Database Engine error '80004005'
The field 'FORUM_FORUM.F_EDIT_TIME' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.
/forums/post_info.asp, line 1347"
I assume it may have something to do with the web link not posting any info regarding time and delete editing but obviously web links don't need that.
So anybody have a clue as to how to fix this?
Sorry if this has been covered in the past. I tried doing a search and came up dry and when I added the archive it kept timing out.
I didn't even know there was a time edit mod. Don't know how much help I'll be but... have you double-checked the code you added to make sure that nothing was missing? Run through the readme a fourth time? Was this working right before you added the mod? Which files does this mod require alterations to?
It's the mod for limiting the amount of time you can edit or delete a post. I thought it was kind of a common one. I double checked all the code but I think it's more a problem with the web link not having any info regarding the time edit mod hence the error that it can't contain a null value when you try to create one.
Off the cuff (since I'm on a short break at the moment) I'd say that you need to find the SQL Statement where the links are being added/edited and make sure that that "0" is being inserted into that field.
Alternatly you could allow nulls - I strongly recommend against this as the requirement was probably put in for a reason.
I don't have the line numbers handy at the moment. If I get a chance between now and when I get back from class tonight I'll get more specifics.
Adding: It could be that the value in F_EDIT_TIME isn't set in the update routine of an url insert.. infact there is not the definition in strsql. Try adding the definition and the value... '## Edit Time Mod ### ADD Code below ######## if Time_Limits then strSql = strSql & ", F_EDIT_TIME " end if '## End Add on ########################################################### and after
'## Edit Time ### Add code below ################ if Time_Limits then strSql = strSql & ", '" & strTimeArr & "'" end if '## End code add on ########################
Ok I kind of forgot about this. But today I needed to add a link and got the error. I tried the help above but don't think I know exactly where to put it. Do I edit post.asp or post_info.asp? Where do I put the code? I thought maybe I could just shut off the delete and edit time mod in forum configuation but I still get the error. Any help would be great. I really need to add a link. I also tried removing all the references to the time edit mod in post.asp and post_info.asp but I stll got the error.
Topic Locked
Posted - 02 November 2005 : 19:32:09
