| Author |
 Topic  |
|
Zenfor
Junior Member
372 Posts |
 Posted - 17 November 2007 : 14:37:26
|
Hi,
I'm just starting to use archiving and not quite sure where the items go after I archive them, how to permanantly delete them and I'm also getting this error. Thank you kindly!
All replies to Topics older than 9/17/2007 2:38:14 PM were archived
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/admin_forums.asp, line 537
This is line 537
set drs = my_conn.execute(strsql)
|
Edited by - Zenfor on 17 November 2007 17:41:23 |
|
|
Etymon
Advanced Member
United States
2385 Posts |
|
|
Zenfor
Junior Member
372 Posts |
Posted - 18 November 2007 : 04:35:55
|
quote:
Originally posted by Etymon
Hi Zenfor,
This link below should help you understand how the archiving process works:
Thanks but it doesn't help me solve the error other than seeing that it could be due to the calendar mod that was installed. I'm stumped still.  |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Zenfor
Junior Member
372 Posts |
Posted - 19 November 2007 : 07:56:27
|
quote:
Originally posted by ruirib
You will need to output the SQL to see what is going wrong with it. Was the file changed?
The file was changed when I installed the calendar mod several years ago. Everything has been working fine and the only problem I have is with this archiving error when I decided to activate it to help clean up old postings. Not quite sure I remember how to output the sql, appreciate it if you could please advise. Thanks for the help! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Zenfor
Junior Member
372 Posts |
Posted - 20 November 2007 : 08:19:30
|
quote:
Originally posted by ruirib
Add this above the line causing the error:
Response.Write strSQL
Response.End
This what I get. Thanks!
=======================
No Replies were Archived: none found
SELECT CAT_ID,FORUM_ID,TOPIC_ID,T_SUBJECT,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_MESSAGE FROM FORUM_TOPICS WHERE T_LAST_POST < '20071020082154' AND FORUM_TOPICS.FORUM_ID=127 AND T_ARCHIVE_FLAG <> 0
|
Edited by - Zenfor on 20 November 2007 09:05:19 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Zenfor
Junior Member
372 Posts |
Posted - 20 November 2007 : 09:13:37
|
quote:
Originally posted by ruirib
There is no error in that statement. Have you tried the same settings that were giving you the error in the first place?
This is the response with the sql output code removed.
==============================================
No Replies were Archived: none found
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/admin_forums.asp, line 537
|
|
|
|
Zenfor
Junior Member
372 Posts |
Posted - 20 November 2007 : 09:21:35
|
| Looking at this again, I think I have some old Poll Mod code in there that's causing this. I evidently didn't remove the code when I had abandoned it due to a conflict with the calendar mod. I'll try to clean this up. |
|
|
|
Zenfor
Junior Member
372 Posts |
Posted - 20 November 2007 : 09:34:00
|
I removed the poll code now I get this:
No Replies were Archived: none found
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/forum/admin_forums.asp, line 590
This is the sql out statement before line 590:
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_SIG) VALUES (40, 127, 1987, 0, 'Moving Sale', 'This Saturday at 10 am, 122 Center St.', 550, 2, 0, 386, '20050512100938', '20050512091111', 0, '70.19.194.64', 3, 12466, '', NULL, 0, 0, 0 )
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Zenfor
Junior Member
372 Posts |
Posted - 20 November 2007 : 10:43:10
|
quote:
Originally posted by ruirib
You have one more value than columns, that's the error. You must have one line from one of the mods adding a value. Can you identify it on your own?
I'm not having any luck figuring it out on my own other than what I just already removed. Apparently I am missing something else but I can't locate it. Appreciate any other ideas so i can fix this. Thanks! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 20 November 2007 : 11:18:05
|
COLUMN
1. CAT_ID
2. FORUM_ID
3. TOPIC_ID
4. T_STATUS
5. T_SUBJECT
6. T_MESSAGE
7. T_AUTHOR
8. T_REPLIES
9. T_UREPLIES
10. T_VIEW_COUNT
11. T_LAST_POST
12. T_DATE
13. T_LAST_POSTER
14. T_IP
15. T_LAST_POST_AUTHOR
16. T_LAST_POST_REPLY_ID
17. T_LAST_EDIT
18. T_LAST_EDITBY
19. T_STICKY
20. T_SIG
21.
VALUES
1. 40
2. 127
3. 1987
4. 0
5. 'Moving Sale'
6. 'This Saturday at 10 am, 122 Center St.'
7. 550
8. 2
9. 0
10. 386
11. '20050512100938'
12. '20050512091111'
13. 0
14. '70.19.194.64'
15. 3
16. 12466
17. ''
18. NULL
19. 0
20. 0
21. 0 < - A COLUMN is missing for this VALUE. |
Edited by - Etymon on 20 November 2007 11:25:37 |
|
|
|
Topic |
|
Topic Locked
