Author |
Topic  |
|
Seph
Starting Member
13 Posts |
Posted - 23 June 2003 : 18:09:32
|
Well everything looks right, I just can't post any polls, events or messages :S. I think its something wrong with my post_info.asp
Here the error I get:
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/shadesofwar/forum/post_info.asp, line 977
and heres a link to the .txt version of my post_info.asp file:
http://www.sonsofdarkness.co.uk/post_info.txt
Can you figure out whats wrong? im lost
Heres a link to the forum in question: http://www.sonsofdarkness.co.uk/shadesofwar/forum
Ignore the domain name [:d] |
|
Seph
Starting Member
13 Posts |
Posted - 25 June 2003 : 07:32:45
|
Err.. can anyone help me? :S |
 |
|
Tam
New Member

Sweden
56 Posts |
Posted - 25 June 2003 : 09:25:14
|
Before the my_Conn.Execute-line on 977, do a
response.write strSql
response.end
and copy/paste the line you get here, it will be a lot easier to see whats wrong with the sql-string. Basically, the errormessage means you try to insert too many or too few values in the database.
|
 |
|
Seph
Starting Member
13 Posts |
Posted - 26 June 2003 : 11:42:07
|
Ok I tried that, and this came up instead of the error message
INSERT INTO FORUM_TOPICS (FORUM_ID, CAT_ID, T_SUBJECT, T_MESSAGE, T_ISPOLL, T_POLLSTATUS, 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_ARCHIVE_FLAG, T_REPLIES, T_UREPLIES, T_EVENT_DATE, T_ISEVENT) VALUES (4, 3, 'Test', 'this is a test', 0, 1, 1, '20030626162903', 1, 0 , '20030626162903', 1 , '81.107.199.50', 0 , 0 , 1 , 0 )
Any ideas? :S |
 |
|
Tam
New Member

Sweden
56 Posts |
Posted - 26 June 2003 : 12:03:18
|
Above line 977, find a line saying :
strSql = strSql & ", T_EVENT_DATE"
comment it out make it look like this:
'strSql = strSql & ", T_EVENT_DATE"
and see if it works
|
 |
|
Seph
Starting Member
13 Posts |
Posted - 26 June 2003 : 12:28:52
|
Nope didn't work, this came up
INSERT INTO FORUM_TOPICS (FORUM_ID, CAT_ID, T_SUBJECT, T_MESSAGE, T_ISPOLL, T_POLLSTATUS, 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_ARCHIVE_FLAG, T_REPLIES, T_UREPLIES, T_ISEVENT) VALUES (4, 3, 'Test', 'this is a test', 0, 1, 1, '20030626171546', 1, 0 , '20030626171546', 1 , '81.107.199.50', 0 , 0 , 1 , 0 ) |
 |
|
Tam
New Member

Sweden
56 Posts |
Posted - 26 June 2003 : 12:49:45
|
quote: Originally posted by Seph
Nope didn't work, this came up
INSERT INTO FORUM_TOPICS (FORUM_ID, CAT_ID, T_SUBJECT, T_MESSAGE, T_ISPOLL, T_POLLSTATUS, 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_ARCHIVE_FLAG, T_REPLIES, T_UREPLIES, T_ISEVENT) VALUES (4, 3, 'Test', 'this is a test', 0, 1, 1, '20030626171546', 1, 0 , '20030626171546', 1 , '81.107.199.50', 0 , 0 , 1 , 0 )
You tried it after removing the 2 lines I posted earlier? If not, comment out or remove
response.write strSql response.end
and try again.
|
 |
|
Seph
Starting Member
13 Posts |
Posted - 26 June 2003 : 12:55:08
|
Just done that, comes up with
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/shadesofwar/forum/post_info.asp, line 977
|
 |
|
Tam
New Member

Sweden
56 Posts |
Posted - 26 June 2003 : 13:06:14
|
Try removing these 3 lines above my_conn.execute at 977:
strSql = strSql & ", 1 "
strSQL = strSQL & ", 0 "
strSql = strSql & ")"
and add these instead:
strSql = strSql & ", 1 "
strSQL = strSQL & ", 0 "
strSQL = strSQL & ", 0 "
strSQL = strSQL & "," & IsEvent
strSql = strSql & ")"
If this won't work, I am pretty much out of ideas :( |
 |
|
Seph
Starting Member
13 Posts |
Posted - 26 June 2003 : 13:07:17
|
Do I keep
'strSql = strSql & ", T_EVENT_DATE"
commented out? |
 |
|
Seph
Starting Member
13 Posts |
Posted - 26 June 2003 : 13:10:49
|
I tried both ways with no luck:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/shadesofwar/forum/post_info.asp, line 980
Anyone else have any ideas?  |
 |
|
Tam
New Member

Sweden
56 Posts |
Posted - 26 June 2003 : 13:13:27
|
When you say "new event calender mod", you mean the one released 06/04/2003 at snitzbitz.com? |
Edited by - Tam on 26 June 2003 13:13:37 |
 |
|
Seph
Starting Member
13 Posts |
Posted - 26 June 2003 : 13:26:36
|
Yeah, why? |
 |
|
Seph
Starting Member
13 Posts |
Posted - 27 June 2003 : 10:20:04
|
If you want something done do it yourself 
I worked it out |
 |
|
|
Topic  |
|
|
|