| Author |
 Topic  |
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
 Posted - 26 August 2002 : 18:47:42
|
hi all,
i get this error when i submit a new topic.
(i put the response.write strsql in and got this)
INSERT INTO FORUM_TOPICS (FORUM_ID, CAT_ID, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_LAST_POST, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_DATE, T_STATUS, T_IP, T_STICKY, T_SIG, T_POSTS, T_ARCHIVE_FLAG, T_REPLIES, T_UREPLIES) VALUES (1, 1, 'ghh', 'hh', 2, '20020826233725', 2, 0 , '20020826233725', 1 , '62.30.192.1', 0 , 1 , 1, 1, 1 , 0 , 0 )
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/mad/post_info.asp, line 846
strSql = strSql & ", " & (rs("M_POSTS") + 1)
strSql = strSql & ", " & (rs("M_POSTS") + 1)
strSql = strSql & ", 1 "
strSQL = strSQL & ", 0 "
strSQL = strSQL & ", 0 "
strSql = strSql & ")"
response.write strsql
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords <===line 846
if Err.description <> "" then
err_Msg = "There was an error = " & Err.description
else
err_Msg = "Updated OK"
end if
plz help
thankx
MaD2ko0l |
© 1999-2010 MaD2ko0l |
Edited by - Davio on 27 August 2002 04:02:10 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 August 2002 : 18:53:33
|
Is that a modded file? There are some fields I do not have and there is a repeated line right at the top of the code you posted...
Anyway if this is a modded file, the post should have gone into the Mod implementation forum. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 26 August 2002 : 18:53:51
|
and when replyign to a message i get this error
INSERT INTO FORUM_REPLY (TOPIC_ID, FORUM_ID, CAT_ID, R_AUTHOR, R_DATE , R_IP, R_STATUS, R_SIG, R_POSTS, R_MESSAGE) VALUES (1, 1, 1, 2, '20020826234503', '62.30.192.1', 1, 1 , 'test')
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/mad/post_info.asp, line 985
strSql = strSql & ", " & "'" & txtMessage & "'"
strSql = strSql & ")"
response.write strsql
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords <=== line 985
' DEM --> Do not update totals on topics and forums database if post is moderated...Added if and end if
if Moderation = "No" then
|
© 1999-2010 MaD2ko0l |
|
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 26 August 2002 : 18:56:39
|
hold on a sec i have installed 3 mods
active users
hotkey
post stamp
it may be the post stamp mod
sorry for postign in the wrong place
thankx
MaD2ko0l |
© 1999-2010 MaD2ko0l |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 26 August 2002 : 19:57:04
|
ok the 1st error was due to wot u said duplicate line
the 2nd one was a bit more challenging.
i had to chnage a number from 22 to 23 i think...i either didnt see it in the readme or they forgot ot chnage it in the read me.
thankx for ur help
MaD2ko0l |
© 1999-2010 MaD2ko0l |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
snaayk
Senior Member
USA
1061 Posts |
Posted - 27 August 2002 : 09:23:49
|
quote:
Originally posted by MaD2ko0l
i had to chnage a number from 22 to 23 i think...i either didnt see it in the readme or they forgot ot chnage it in the read me.
Its in there. Its because of the array. |
|
|
| |
Topic |
|
|
|
Topic Locked
.