Author |
Topic |
richfed
Average Member
United States
999 Posts |
Posted - 08 December 2004 : 05:44:37
|
I just archived posts over 1 year old in one forum on a secondary message board I have that still uses Access for it's database ... Snitz version 3.4.03 ... [first time ever archiving on that board]
When clicking on the Archived Posts icon for that forum, you see this: http://www.mohicanpress.com/messageboard2/forum.asp?ARCHIVE=true&FORUM_ID=8
Error message is:
quote: ADODB.Field error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/messageboard2/inc_func_common.asp, line 237
You can see that the table is incomplete. That is the first page of archives.
On the 2nd & 3rd pages, you see this error message:
quote: Anonymous Poster ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/messageboard2/inc_func_common.asp, line 222
It appears that whenever an Anonymous Poster is involved, an error message arises. So, this post may need to be moved to the MOD forum. [Anonymous Posting Mod is installed]
Here is a link to my current inc_func_common file: http://www.mohicanpress.com/battles/inc_func_common.txt
I'd like to be able to either fix OR retrieve the archive ...
Thanks for any assistance ... |
Rich [size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
Edited by - richfed on 12 December 2004 05:43:44 |
|
richfed
Average Member
United States
999 Posts |
Posted - 10 December 2004 : 05:06:53
|
Let me ask this question in another way. First of all, what does "Either BOF or EOF is True ..." mean? How is the situation normally corrected?
I'm thinking that maybe a database record needs to be changed? I can access my database via Table Editor ... |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 December 2004 : 05:08:06
|
it means it didn't find any records in your table |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 11 December 2004 : 08:41:20
|
That is strange, because the data is there.
What can I do? |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 14 December 2004 : 05:56:36
|
Any helpers on this? Not sure what to do ... all data is present, but as soon as an anonymous poster has a post, the table is lost from there on out. I tried the unarchive MOD, but I ended up with multiple posts ... I've cleaned up the first page ...
Guidance appreciated! |
|
|
richfed
Average Member
United States
999 Posts |
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 16 December 2004 : 08:42:15
|
Fixed thanks to mr Maven (my new collegue who knows how to read ASP...)
In in post_info.asp you've pasted this code:
'Insert reply info as new topic into Topic table
strSql = "INSERT INTO " & strTablePrefix & "TOPICS (FORUM_ID"
strSql = strSql & ", CAT_ID"
strSql = strSql & ", T_SUBJECT"
strSql = strSql & ", T_MESSAGE"
strSql = strSql & ", T_AUTHOR"
strSql = strSql & ", T_LAST_POST"
strSql = strSql & ", T_LAST_POST_AUTHOR"
strSql = strSql & ", T_LAST_POST_REPLY_ID"
strSql = strSql & ", T_DATE"
strSql = strSql & ", T_STATUS"
strSql = strSql & ", T_IP"
strSql = strSql & ", T_STICKY"
strSql = strSql & ", T_SIG"
strSql = strSql & ", T_ARCHIVE_FLAG"
strSql = strSql & ", T_REPLIES"
strSql = strSql & ", T_UREPLIES"
strSql = strSql & ") VALUES ("
strSql = strSql & NewForumID
strSql = strSql & ", " & NewCatID
strSql = strSql & ", '" & txtSubject & "'"
strSql = strSql & ", '" & ChkString(Reply_Message, "message") & "'"
strSql = strSql & ", " & Reply_Author
strSql = strSql & ", '" & Reply_Date & "'"
strSql = strSql & ", " & Reply_Author
strSql = strSql & ", 0"
strSql = strSql & ", '" & Reply_Date & "'"
strSql = strSql & ", 1"
strSql = strSql & ", '" & Reply_IP & "'"
strSql = strSql & ", 0"
strSql = strSql & ", " & Reply_Sig
strSql = strSql & ", 1"
strSql = strSql & ", 0"
strSql = strSql & ", 0)" Change the GREEN line, and remove the ChkString part. We were checking the already checked string for the 2nd time...thus removing all formatting. So, the new code looks like this:
'Insert reply info as new topic into Topic table
strSql = "INSERT INTO " & strTablePrefix & "TOPICS (FORUM_ID"
strSql = strSql & ", CAT_ID"
strSql = strSql & ", T_SUBJECT"
strSql = strSql & ", T_MESSAGE"
strSql = strSql & ", T_AUTHOR"
strSql = strSql & ", T_LAST_POST"
strSql = strSql & ", T_LAST_POST_AUTHOR"
strSql = strSql & ", T_LAST_POST_REPLY_ID"
strSql = strSql & ", T_DATE"
strSql = strSql & ", T_STATUS"
strSql = strSql & ", T_IP"
strSql = strSql & ", T_STICKY"
strSql = strSql & ", T_SIG"
strSql = strSql & ", T_ARCHIVE_FLAG"
strSql = strSql & ", T_REPLIES"
strSql = strSql & ", T_UREPLIES"
strSql = strSql & ") VALUES ("
strSql = strSql & NewForumID
strSql = strSql & ", " & NewCatID
strSql = strSql & ", '" & txtSubject & "'"
strSql = strSql & ", '" & Reply_Message & "'"
strSql = strSql & ", " & Reply_Author
strSql = strSql & ", '" & Reply_Date & "'"
strSql = strSql & ", " & Reply_Author
strSql = strSql & ", 0"
strSql = strSql & ", '" & Reply_Date & "'"
strSql = strSql & ", 1"
strSql = strSql & ", '" & Reply_IP & "'"
strSql = strSql & ", 0"
strSql = strSql & ", " & Reply_Sig
strSql = strSql & ", 1"
strSql = strSql & ", 0"
strSql = strSql & ", 0)" Woeps...posted this reply in the wrong topic...was about the Split topic mod where OneWayMule posted the exact same solution 3 minutes earlier... |
portfolio - linkshrinker - oxle - twitter |
Edited by - MarcelG on 16 December 2004 08:47:38 |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 16 December 2004 : 19:46:12
|
This is DoraMoon's version. |
|
|
richfed
Average Member
United States
999 Posts |
|
richfed
Average Member
United States
999 Posts |
Posted - 14 January 2005 : 19:20:44
|
Well, I continue to struggle with this ...
Finally decided the heck with it & went with the "delete all archived posts in a forum" option in the administration area. Unfortunately, this deleted ALL the posts in the forum ... whether archived or not. I had backed up, so I'm back to square one ... |
|
|
dcronin
Starting Member
5 Posts |
Posted - 21 January 2005 : 00:31:51
|
Where did you find the Anonymous Posting MOD? I have been looking for a mod like this and can't seem to find it.
|
|
|
richfed
Average Member
United States
999 Posts |
|
dcronin
Starting Member
5 Posts |
Posted - 23 January 2005 : 23:06:00
|
Thanks richfed,
Do you have a link to Davio's version as well?
Much appreciated. |
|
|
dcronin
Starting Member
5 Posts |
|
richfed
Average Member
United States
999 Posts |
Posted - 24 February 2005 : 05:11:02
|
Still stuck here ...
Anyone ... ? |
|
|
Topic |
|