Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Help with the New Event Calender Mod
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Seph
Starting Member

13 Posts

Posted - 23 June 2003 :  18:09:32  Show Profile
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  Show Profile
Err.. can anyone help me? :S
Go to Top of Page

Tam
New Member

Sweden
56 Posts

Posted - 25 June 2003 :  09:25:14  Show Profile  Visit Tam's Homepage
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.
Go to Top of Page

Seph
Starting Member

13 Posts

Posted - 26 June 2003 :  11:42:07  Show Profile
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
Go to Top of Page

Tam
New Member

Sweden
56 Posts

Posted - 26 June 2003 :  12:03:18  Show Profile  Visit Tam's Homepage
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


Go to Top of Page

Seph
Starting Member

13 Posts

Posted - 26 June 2003 :  12:28:52  Show Profile
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 )
Go to Top of Page

Tam
New Member

Sweden
56 Posts

Posted - 26 June 2003 :  12:49:45  Show Profile  Visit Tam's Homepage
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.
Go to Top of Page

Seph
Starting Member

13 Posts

Posted - 26 June 2003 :  12:55:08  Show Profile
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
Go to Top of Page

Tam
New Member

Sweden
56 Posts

Posted - 26 June 2003 :  13:06:14  Show Profile  Visit Tam's Homepage
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 :(
Go to Top of Page

Seph
Starting Member

13 Posts

Posted - 26 June 2003 :  13:07:17  Show Profile
Do I keep

'strSql = strSql & ", T_EVENT_DATE"

commented out?
Go to Top of Page

Seph
Starting Member

13 Posts

Posted - 26 June 2003 :  13:10:49  Show Profile
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?
Go to Top of Page

Tam
New Member

Sweden
56 Posts

Posted - 26 June 2003 :  13:13:27  Show Profile  Visit Tam's Homepage
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
Go to Top of Page

Seph
Starting Member

13 Posts

Posted - 26 June 2003 :  13:26:36  Show Profile
Yeah, why?
Go to Top of Page

Seph
Starting Member

13 Posts

Posted - 27 June 2003 :  10:20:04  Show Profile
If you want something done do it yourself

I worked it out
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.92 seconds. Powered By: Snitz Forums 2000 Version 3.4.07