| Author |
 Topic  |
|
Cdemon
Starting Member
26 Posts |
 Posted - 07 May 2002 : 17:29:50
|
When members of my forum go to post,it comes up with this error...
Microsoft JET Database Engine error '80040e14'
The INSERT INTO statement contains the following unknown field name: 'C_STRMOVENOTIFY'. Make sure you have typed the name correctly, and try the operation again.
/gamequest/post_info.asp, line 653
I switched to Digitalrice hosting,but now I get this error..can someone help?Thanks.
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 May 2002 : 18:22:05
|
The line above that where there is 'C_STRMOVENOTIFY' should be commented. At least it is in my post_info.asp:
' strSql = strSql & ", C_STRMOVENOTIFY"
Just insert the single quote at the beginning of the line.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
Cdemon
Starting Member
26 Posts |
Posted - 07 May 2002 : 18:43:09
|
Well..I pasted that(which was already there)and it still didn't work...wonder what could be wrong???   
btw,here is a link to the text version of my post_info.asp just in case...
http://stonecold.digitalrice.com/post_info.txt
Also,if I modify like a forum setting(color) then it wont work.I hit REFRESH and it like messes up...?Whats this about?Man,I never used to have this much trouble with snitz... but the server I used to use has popups(7 host)that get realy annoying!
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 May 2002 : 18:52:21
|
The line I mentioned still isn't commented in your post_info.asp. Please add a single ' quote at the beginning of your line number 627.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 07 May 2002 18:53:25 |
|
|
|
Cdemon
Starting Member
26 Posts |
Posted - 07 May 2002 : 19:06:13
|
Well I tried it again,I put the line like this...
' strSql = strSql & ", C_STRMOVENOTIFY"
and this pops up...
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/gamequest/post_info.asp, line 653
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 May 2002 : 19:12:00
|
Replace the things you have between line 614 and 653 by these:
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_DATE"
strSql = strSql & ", T_STATUS"
if strIPLogging <> "0" then
strSql = strSql & ", T_IP"
end if
strSql = strSql & ", T_ARCHIVE_FLAG"
strSql = strSql & ") VALUES ("
strSql = strSql & Forum_ID
strSql = strSql & ", " & Cat_ID
strSql = strSql & ", '" & txtSubject & "'"
strSql = strSql & ", '" & txtMessage & "'"
strSql = strSql & ", " & rs("MEMBER_ID")
strSql = strSql & ", '" & DateToStr(strForumTimeAdjust) & "'"
strSql = strSql & ", " & rs("MEMBER_ID")
strSql = strSql & ", '" & DateToStr(strForumTimeAdjust) & "'"
if Request.Form("lock") = 1 then
strSql = strSql & ", 0 "
else
if Moderation = "Yes" then
strSql = strSql & ", 2 "
else
strSql = strSql & ", 1 "
end if
end if
if strIPLogging <> "0" then
strSql = strSql & ", '" & Request.ServerVariables("REMOTE_ADDR") & "'"
end if
strSql = strSql & ", 1 "
strSql = strSql & ")"
my_Conn.Execute (strSql)
Don't forget to keep a backup of your current file.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Cdemon
Starting Member
26 Posts |
Posted - 07 May 2002 : 19:49:17
|
Thanks man!That worked  !
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Cdemon
Starting Member
26 Posts |
Posted - 07 May 2002 : 20:20:54
|
Well,I was out looking for bugs on my forum when I registered as TEST and password as something else....*ahem*..but anyway,when i registered,this poped up...
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
/gamequest/inc_mail.asp, line 55
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
but...yea,there is a but,I was still registered.I could post and everything..wonder whats wrong?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 May 2002 : 20:28:35
|
I'd say check your email configuration. Probably still using the values for your old host...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Cdemon
Starting Member
26 Posts |
Posted - 07 May 2002 : 22:15:00
|
LOL..its always something man...well..my forum was doing good..got some members,few admin friends and all..made some forums,added main image.But,one of my friends informed me that when he went to try to make a new topic,there was an error.I checked it out,and the forum spat this at me..
Please don't attempt to edit the URL
to gain access to locked Forums/Categories.
Whats this mean?the forum wasn't locked or anything...hmmm?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 May 2002 : 22:24:03
|
A link to your forum, please.
Also what Snitz version are you using?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Cdemon
Starting Member
26 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 May 2002 : 07:33:08
|
Do one thing please. Temporarily replace your post.asp by one downloaded from a Snitz and see if that error still appears.
Also, can you open the Access DB, open the FORUM_CATEGORY table and tell me the values of the CAT_STATUS field for each of your categories?
Do the same for the FORUM_FORUM table and let me me know the values of the F_STATUS fields.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 08 May 2002 07:42:58 |
|
|
|
Cdemon
Starting Member
26 Posts |
Posted - 08 May 2002 : 17:09:44
|
Well...how do I open the access database?What program?And,the post.asp that I started with is the same one that I downloaded from snitz...
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 May 2002 : 17:14:14
|
quote:
Well...how do I open the access database?What program?And,the post.asp that I started with is the same one that I downloaded from snitz...
Access is the program to use.
Maybe the problem was with your faulty post_info.asp, but only after you tell me what I asked of you can conclusions be drawn.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Topic |
|
Topic Locked
. You are welcome.