Author |
Topic |
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 04 January 2003 : 12:24:01
|
Sorry, I can't find anyone with a problem like this. I Archive my topics, and this shows: .......... All replies to Topics older than 12/4/2002 12:11:38 PM were archived
INSERT INTO FORUM_A_TOPICS (CAT_ID, FORUM_ID, TOPIC_ID, T_STATUS, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_ISPOLL, T_POLLSTATUS, T_SIG, T_ISEVENT) VALUES (2, 2, 4, 0, 'Transition from code 100 to 83 track', 'Any problems with locos and rolling stock running on code 83 vs what i have now code 100.I was thinking of changing to code 83 on my expansion!', 5, 10, 0, 107, '20021203212824', '20021124234044', 0, '24.64.223.205', 20, 207, '20021124234218', 5, 0, 0, 0, 1 , '', 0 )
(I uncommented the two lines in Admin_forums.asp)
So I think they are archiving... But if I search with the keyword "a" and "Archived posts" checked, I get nothing. The icon is also not at the end of the row where the forum is..
http://www.railway-forum.com/forum < user=snitz pw=snitz >
So Whats wrong?
Thank you
Dave |
Edited by - ruirib on 06 January 2003 18:23:51 |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 04 January 2003 : 23:37:59
|
I guess they are NOT archived, search will not work for 'rolling stock' either. Whats wrong? I do have 20+ MODs installed... |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 05 January 2003 : 14:35:48
|
There is no archive topic link, where should I click? |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 January 2003 : 18:22:45
|
Tell me something - one of the lines that you uncommented is Response.End, right? Did you uncomment it before this problem manifested itself?
Can you access this specific topic ('Transition from code 100 to 83 track') in the live topics area? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 06 January 2003 : 15:09:31
|
OK, I recommented the lines, and I now get this error:
............................................... All replies to Topics older than 12/6/2002 3:00:51 PM were archived
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/forum/admin_forums.asp, line 581
Thanks for your help! |
|
|
Dave.
Senior Member
USA
1037 Posts |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 06 January 2003 : 16:58:52
|
Looks like the replies were archived but the topics were not. No big deal, I think we will be able to put everything working once we are able to archive topics.
I think you have an extra value in your SQL statement. Please post a link to a text version of your admin_forums.asp. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 06 January 2003 17:00:32 |
|
|
Dave.
Senior Member
USA
1037 Posts |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 06 January 2003 : 18:23:31
|
Check lines# 577. You're missing a statement to add the T_EVENT_DATE column name to it:
strsql = "INSERT INTO " & strArchiveTablePrefix & "TOPICS (CAT_ID, FORUM_ID, TOPIC_ID, T_STATUS, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_ISPOLL, T_POLLSTATUS, T_SIG, T_EVENT_DATE,T_ISEVENT)"
I'm moving this to the MOD Implementation forum, since this is a problem related to Calendar mod. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 06 January 2003 : 18:39:42
|
Now I get this:
No Replies were Archived: none found
Microsoft JET Database Engine error '80040e14'
The INSERT INTO statement contains the following unknown field name: 'T_EVENT_DATE'. Make sure you have typed the name correctly, and try the operation again.
/forum/admin_forums.asp, line 581
I'll look for the MOD, maybe a dbs problem...? |
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 06 January 2003 : 18:46:39
|
I ran the dbs setup again, and a new table was added, then I archived, and got: .... All replies to Topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
All topics older than 12/6/2002 6:37:56 PM were archived
Updating Counts
Topics: .. Topic Replies: ................................................................... Forum Replies: ................. Totals: Total Topics: 153 Total Archived Topics: 29 Total Posts: 1023 Total Archived Posts: 84 Count Update Complete
Ok I clicked the, now visable folder, and I got this error:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/forum.asp, line 336
?????????????
Oh, but, I can find them if I search though. |
Edited by - Dave. on 06 January 2003 18:50:08 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
|
|