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 adding users to members list		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

os_soprano
Starting Member

16 Posts
Posted - 03 June 2002 :  20:54:16  Show Profile
ok i have a modded forum with pm active users avater mod and a few others is there a problem after adding these mods to mess with adding users to private forum in members list

im running the latest version of the post.asp
here is the error i get after i applied it i get this when i try to post

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

/forum/post_info.asp, line 774



Edited by - os_soprano on 03 June 2002 21:01:53

Nathan
Help Moderator

USA
7664 Posts
Posted - 03 June 2002 :  21:01:49  Show Profile  Visit Nathan's Homepage
If you download version 3.3.05 and use the post.asp file from that version you shouldn't have a problem anymore.

It might be benifical to upgrade your whole forum to 3.3.05 because of the security updates it contains.

Nathan Bales
Snitz Exchange | Do's and Dont's
Go to Top of Page

os_soprano
Starting Member

16 Posts
Posted - 03 June 2002 :  21:06:12  Show Profile
this is whats in my line 774
my_Conn.Execute (strSql)


Edited by - os_soprano on 03 June 2002 23:08:04
Go to Top of Page

Nathan
Help Moderator

USA
7664 Posts
Posted - 03 June 2002 :  21:24:01  Show Profile  Visit Nathan's Homepage
In post_info.asp, put these two lines above line 774

response.write strSql
response.end

Then post what the page spits out.

Nathan Bales
Snitz Exchange | Do's and Dont's
Go to Top of Page

os_soprano
Starting Member

16 Posts
Posted - 03 June 2002 :  23:04:05  Show Profile
OMG this is what i get

INSERT INTO FORUM_TOPICS (FORUM_ID, CAT_ID, T_SUBJECT, T_MESSAGE, answer1, answer2, answer3, answer4, answer5, answer6, answer7, answer8, T_ISPOLL, T_AUTHOR, T_LAST_VOTE, T_LAST_POST, T_LAST_POST_AUTHOR, T_DATE, T_STATUS, T_IP, T_ARCHIVE_FLAG, T_MSGICON, T_STICKY, T_TOPSTICKY) VALUES (3, 3, 'test', 'test

', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', 0, 3, '20020603225629', '20020603225629', 3, '20020603225629', 1 , '192.168.0.70', 1 , , 0 , 0 )




Edited by - os_soprano on 03 June 2002 23:05:08
Go to Top of Page

os_soprano
Starting Member

16 Posts
Posted - 04 June 2002 :  21:14:41  Show Profile
??? what next bro ......
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.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07