| Author |
 Topic  |
|
|
Gizmo3
Junior Member
130 Posts |
 Posted - 03 March 2006 : 11:55:24
|
I am getting this error now.
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/snitzforum/post_info.asp, line 1193
This is the line that is says iir wrong
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
I get this when i try to creat a new forum. I can creat the catagory ok but when go to creat a new forum in that catagorie I get that error.
Any ideas |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
Edited by - MarcelG on 03 March 2006 14:33:21 |
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 03 March 2006 : 12:40:42
|
What recent changes have you made to post_info.asp & the database?
also please don't put topic titles in capitals. im not sure this belongs in the mod forums either, if anything mod implementation. |
 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 03 March 2006 : 14:29:32
|
Just before that line, do this :
Response.Write strSQL
It will show you an insert statement that won't have the same number of fields and values. That is the problem you need to correct. |
|
|
|
Gizmo3
Junior Member
130 Posts |
Posted - 03 March 2006 : 16:17:45
|
Thanks for that info.
I put that code in so it looked like this
Response.Write strSQL
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
No the next page that coms up has this test on it and it does not post.
This code ( my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords )is in the file about 15 times should i add
( Response.Write strSQL ) before all of them.
INSERT INTO FORUM_FORUM (CAT_ID, F_STATUS, F_SUBJECT, F_DESCRIPTION, F_TYPE, F_L_ARCHIVE , F_ARCHIVE_SCHED , F_L_DELETE , F_DELETE_SCHED , F_SUBSCRIPTION, F_MODERATION, F_ORDER , F_DEFAULTDAYS , F_COUNT_M_POSTS , F_ALLOWEVENTS ) VALUES (8, 1 , 'vxcvxcv', 'xcvxcvxc', 0, '' , 30 , '' , 365 , 0, 0, 1 , 0, 1), 0
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/snitzforum/post_info.asp, line 1194
|
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
Edited by - Gizmo3 on 03 March 2006 16:39:46 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 March 2006 : 17:18:35
|
INSERT INTO FORUM_FORUM (CAT_ID, F_STATUS, F_SUBJECT, F_DESCRIPTION,
F_TYPE, F_L_ARCHIVE , F_ARCHIVE_SCHED , F_L_DELETE , F_DELETE_SCHED , F_SUBSCRIPTION, F_MODERATION, F_ORDER ,
F_DEFAULTDAYS , F_COUNT_M_POSTS , F_ALLOWEVENTS )
VALUES (8, 1 , 'vxcvxcv', 'xcvxcvxc', 0, '' , 30 , '' ,
365 , 0, 0, 1 , 0, 1), 0
You are adding a parameter after closing the statement (in red). There should be a line that needs to move one line up. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Gizmo3
Junior Member
130 Posts |
Posted - 03 March 2006 : 17:53:05
|
Found the problem
There is a code This code:
(%><!--#INCLUDE FILE="cal_post_info2.asp"--><%
This code comes with the Mod Event Calender. If you copy and past this code from the install instructions the code will not work. This part of the code goes all funny looking (--><%) It does it on both ends. If you type that code in your self it works fine. That was the problem
Thanks for all your help. |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
| |
Topic |
|
|
|
Topic Locked
