I am not sure whether this is a server issue or something else. I did archiving yesterday and it seemed everything went fine. Immediately after that the site went down with the following error message.
Either BOF or EOF is true, or the current record has been deleted. Requested operation requires a current record. /inc_required.asp, line 75
lines 74-76 are:
set ReqTopic = my_conn.execute(strSQL) FORUMID=ReqTopic("FORUM_ID") ReqTopic.Close
I had to restore a backup db to resolve the issue. Anyone knows what is going on? I had no problems with archiving with my previous host. My current host says it is a code issue but I doubt that.
That's a non standard Snitz file. Hard to know what is going on. I would say, however, that it has some likelihood of being a coding error, caused by not testing existance of records in a recordset,
Maybe you just archived too much. Not possible to say what happened with certainty. Anyway, that should check for records being returned, as the Snitz code does. For example (simple one, really):
set ReqTopic = my_conn.execute(strSQL)
if not ReqTopic.EOF Then
FORUMID=ReqTopic("FORUM_ID")
end if
ReqTopic.Close
Topic Locked
Posted - 19 August 2009 : 12:18:52
