| Author |
 Topic  |
|
celder
Starting Member
USA
11 Posts |
 Posted - 01 February 2006 : 09:35:19
|
http://www.odcmp.org/new_forum/
[Snitz Forums 2000 Version 3.4.05], Using Access database,
I was able to archive the first two topics but then I received the following error when I tried to archive the rest of the topics!
All replies to Topics older than 1/1/2006 9:12:04 AM were archived
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/new_forum/admin_forums.asp, line 577
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_SIG)"
strsql = strsql & " VALUES (" & strsqlvalues & ")"
'Response.Write strSql
'Response.End
my_conn.execute(strsql),,adCmdText + adExecuteNoRecords
Any help would be appreciated! 
Christine |
Edited by - celder on 01 February 2006 09:35:51 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 01 February 2006 : 10:36:08
|
Can be a bit difficult to track down. Seems like you have a topic that may have some content that causes a syntax error. It would be necessary to find out which one.
Remove the comment from that line Response.Write strSql and tell us what it shows just before the error message is shown again. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
celder
Starting Member
USA
11 Posts |
Posted - 01 February 2006 : 11:14:00
|
Here is the error message once I removed the comment!
Topic exists, Stats Updated......
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 (1, 1, 26, 0, 'How about M14 gas systems - please', 'Will the gas systems be made available again?', 242, 0, 0, 0, '20020521113526', '20020521113526', 0, '000.000.000.000', , 0, '', NULL, 0, 0 )
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/new_forum/admin_forums.asp, line 577
Thank you very much for your help!
Christine |
Edited by - celder on 01 February 2006 11:14:20 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 01 February 2006 : 11:54:58
|
| Well the problem seems to be caused by the fact that that topic has no info for the last post author in the topic. Why would that happen? Did any mod or admin change that topic, or was a member deleted or something? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
celder
Starting Member
USA
11 Posts |
Posted - 01 February 2006 : 12:23:50
|
I don't believe the member was deleted or the topic was changed......I did a simple reply to the topic above, tried to run the achiving again, and received a few more errors....it looks like all the errors are topics that have no replies. Is there anyway to archive the topics with no replies?
Thanks!
Christine |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
celder
Starting Member
USA
11 Posts |
Posted - 01 February 2006 : 12:31:19
|
Microsoft Access .mdb
Christine |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
celder
Starting Member
USA
11 Posts |
Posted - 01 February 2006 : 13:00:49
|
Thanks! I appreciate any help you can offer!
Here is the error from my last attempt to archive:
.
Topic exists, Stats Updated......
.
Topic exists, Stats Updated......
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 (1, 1, 56, 0, '03 springfield', 'what the chances of a o3 receiver failing serial # 234717? ROCK ISLAND', 291, 0, 0, 2, '20020703191336', '20020703191336', 0, '000.000.000.000', , 0, '', NULL, 0, 0 )
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/new_forum/admin_forums.asp, line 577
Christine
|
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
celder
Starting Member
USA
11 Posts |
Posted - 08 February 2006 : 10:38:46
|
 Thanks! That file fixed the error and I was able to archive the Forum topics.
Thanks again!
Christine  |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 01 March 2006 : 11:53:59
|
Yes!
Thanks alot, that file (with some alternations) and some other hacks to the db solved my archiving errors!
This is a good week so far, both the archiving AND the search functions are working! =)
|
/Tribaliztic
- www.gotlandrace.se -
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Comicozzi
Starting Member
49 Posts |
Posted - 07 March 2006 : 08:35:47
|
Is that file usable and recommended for 3.4.03
|
|
|
|
Topic |
|
|
|
Topic Locked
