| Author |
 Topic  |
|
richfed
Average Member
United States
999 Posts |
 Posted - 01 December 2002 : 13:26:10
|
quote:
All replies to Topics older than 8/1/2002 12:39:12 PM were archived
All topics older than 8/1/2002 12:39:12 PM were archived
All topics older than 8/1/2002 12:39:12 PM were archived
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/messageboard/admin_forums.asp, line 581
That's the error message I received. If I go to the Forum in question, all the topics that should have been archived are still there, only they show 0 replies. In the Archive folder for this forum, the two earliest threads are there in total - topics & replies. Nothing else appears. I updated forum counts; I ran the Jump to Last Post fix.
This is the first time I've Archived that paricular forum, but I have successfully archived other forums in the past, just earlier this AM, in fact! The only change I have made on my forum in between, was adding the alternating cell color hack, which is applied to forum.asp only. Those changes can be found at: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=35584
Any ideas on this one? I think all the data is still in the database. |
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 01 December 2002 19:21:24 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 01 December 2002 : 17:29:08
|
Thanks, ruirib!
Those two lines are already there, so I uncommented them and ran admin_forums.asp
quote:
No Replies were Archived: none found
.
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/messageboard/admin_forums.asp, line 602
Somehow, I don't think that's what you meant. I had received this error prior to making the change you asked me to make when I tried my hand at archiving that forum a second time [after the 1st error mentioned above].
Line 602, btw, is: my_conn.execute(strsql),,adCmdText + adExecuteNoRecords
Not having one of my better days today  |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 01 December 2002 : 17:46:10
|
Here you go:
This is one of the archived posts showing up ...
quote:
No Replies were Archived: none found
. UPDATE FORUM_A_TOPICS SET T_STATUS = 0, T_SUBJECT = 'CLABERT ... the Movie Star', T_MESSAGE = ' Received from Clabert the other day, after a tip from Theresa ... thought you all might find it of interest. Consider it The E-Mail of the Week! Yep!! Could be!!! I just got back from Dallas/Ft. Worth where I took my resume and photos and talked to these people. I`ve been in contact with them for about two weeks after they sent me an email asking for reenactment photos and a resume. When I walked in and told them who I was, they stood up with big smiles and said "We know who you are Mr. Menard". They had already been showing some of my pictures around and told me they had emailed them to Hollywood. This is what they emailed to me Tuesday. I go back to Dallas June 1st for an interview. I have a very good chance of getting a part in this TV Series. If the TV show is a hit, a full length movie will follow and everyone in the TV show will be in the movie. It starts filming in Oklahoma in August. One episode a month for 12 months. All I know right now is things are happening way to fast! If I get any part other then a non-speaking extra, it could mean a career change. Wish me luck!! You may post any part of this if you wish. We will be needing lots of prayer so that we make the right decision as I`ld be giving up a $50,000 a year job and all the benefits. Maybe they will let me take a "leave of absents" and keep my job if it doesn`t work out. I`m not going to talk to them about it till after June 1st. :) Clabert P.S. Maybe this is why we couldn`t make it to Gathering 2002? :) From: SummitTalent@aol.com To: SummitTalent@aol.com Sent: Wednesday, May 22, 2002 4:22 AM Subject: Western TV Series Auditions What: Auditions-Western TV Series (13 episodes) What TV Series- The Legend Of Jeremiah Cain When: Friday, May 31, 2001 Where: The Actors Place, 11166 Ables Ln, ste A, Dallas, TX 75229 Location:Filmed on location in Texas & Oklahoma Market: To be aired on Cable Access in Dallas, Austin, Houston, San Antonio, El Paso, Oklahoma City, Tulsa, Pilot will be filmed in August 2002, 12 episodes filmed every month for the next year Pay-Union/Non Union Deferred Pay Producers-Summit Pictures (LA) CHAPS Productions (Dallas) Writer/Director Will Boroski To submit send headshot to Attn: Will Boroski-Legend-TV The Actors Place, 11166 Ables Ln, Ste A Dallas, TX 75229 NOTE- Tell us what part you are submitting for. Or on APCasting.com email link your headshot to Summittalent@aol.com- No attachments! For cowboy reinactors a go see or EXTRAS all-call will be on June 1st (SAT) from 10am to 4pm at the above address. For question email Summittalent@aol.com The Following is the current breakdown of characters. Jeremiah Cain: MALE-Caucasian, age range 45-55, Tall 5 10 to 6 4 US Marshal, Strong, confident, soft-spoken. Sheriff Adam Cain-MALE-Already Cast- Known Actor Hannah Britt-FEMALE-28 34 yrs, Caucasian sweet loving girlfriend of Sheriff Adam Cain. Long hair, Classical Beauty. From Texas(accent) Caitlin Summers FEMALE-Already Cast- Known Actor Dusty McGuire MALE- Town Drunk, Age 50 s or 60 s, a character type, Festus type or any long haired or bearded actor. Fast Draw a plus, must have southern/Texas accent. Also does the narration and Voice Over in the beginning and end. Leon Czolgosz-MALE- Already Cast Known Actor Skinner Male- Already Cast- Known Actor ', T_REPLIES = T_REPLIES + 0, T_UREPLIES = T_UREPLIES + 0, T_VIEW_COUNT = T_VIEW_COUNT + 160, T_LAST_POST = '20020530103011', T_LAST_POST_AUTHOR = 30, T_LAST_POST_REPLY_ID = 198, T_LAST_EDIT = '', T_LAST_EDITBY = NULL, T_STICKY = 0, T_SIG = 0, T_EVENT_DATE = , T_ISEVENT = 0 WHERE TOPIC_ID = 44
I don't understand. |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 01 December 2002 : 17:52:13
|
| Looks like the problem lies with that parameter T_EVENT_DATE, which has no value assigned to it. So you need to determine which mod is responsible for that column and verify that you did update the code correctly, according to the mod's instructions. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
richfed
Average Member
United States
999 Posts |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 01 December 2002 : 18:41:03
|
After a search, I found it turns out there was a dbs file error available for download inadvertantly for a short while. I'm not sure if I was one of the unfortunates, but I uploaded a new one & ran it from mod setup. Got the usual "table already exists" messages, but no errors ...
Tried to archive that forum again ... same results. Do you think this is a fixable problem, or am I plum out of luck on this? |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 01 December 2002 : 18:52:32
|
The code shown has a problem, regardless of the fact that the database may also had a problem (I don't know whether it had or not, taking your word for it). Anyway you need to fix that code to solve it, running the DBS file won't fix it.
I'm moving this to the Help: Mod Implementation forum, since this is a mod related problem. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
richfed
Average Member
United States
999 Posts |
Posted - 01 December 2002 : 19:25:48
|
I checked the code on admin_forums.asp, and had one bit slightly out of place:
,T_SIG,T_EVENT_DATE,T_ISEVENT,T_MESSAGE - I had the 2 event items at the end. But, running the archive function again made no difference. Same error.
This particular forum had Events in it, unlike the other ones that I had archived ... perhaps that's the trouble? I don't know ... will continue to check my code ...
Red1 ... any ideas on this? |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 01 December 2002 : 19:39:16
|
There are 4 instances of code on that file, all are above line 602. I checked them all & they're good. The line to which you refer, I think, is line 575:
strsqlvalues = strsqlvalues & ", '" & drs("T_EVENT_DATE") & "', " & drs("T_ISEVENT") & " "
That's correct ... according to the readme.
Hmmm ... |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 01 December 2002 : 20:15:06
|
Well, I think so ...
This seems like a two part problem.
One, how to fix the code so that it no longer happens, and two, how to fix my database so that topic.asp & the archives reflect what should be seen to the visitor.
What's the easiest way to fix my current database? Is it a matter of copy & pasting? Or, more involved? I'm thinking the replies are already archived & I need to move the topics to them, but that's unfamiliar territory. Ruirib, you can e-mail me, if you'd like, or should I repost that question in the Access 2000 Database section?
I realize that if I can do that it won't solve my problem, but at least it will fix the damage to date! |
Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1] |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 01 December 2002 : 20:21:20
|
| What is the DB problem? Better start a new topic for that one, but if it's MOD related, better post in this forum again. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 01 December 2002 20:21:42 |
|
|
|
red1
Junior Member
355 Posts |
|
|
Topic |
|
|
|
Topic Locked
