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

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 V33 BUG+FIX: Error posting #1		  Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Bytemaster
Starting Member

USA
3 Posts
Posted - 25 July 2001 :  16:20:20  Show Profile  Send Bytemaster an AOL message  Send Bytemaster a Yahoo! Message
I just installed the new 3.3 version on a server and get the following error when trying to post:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains the following unknown field name: 'C_STRMOVENOTIFY'. Make sure you have typed the name correctly, and try the operation again.

/board/post_info.asp, line 653

Thank you

e3stone
Average Member

USA
885 Posts
Posted - 25 July 2001 :  16:48:44  Show Profile  Send e3stone an AOL message
I get that error, as well. Haven't quite figured out what is causing it, though.

<-- Eric -->


InsideWaco.com
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts
Posted - 25 July 2001 :  17:07:59  Show Profile  Visit gor's Homepage
The Access database in the download-zipfile has a missing field in the table FORUM_TOPICS.

If you force an update of the database by running setup.asp?rc=3 the field should get added.

Pierre
Join a Snitz Mailinglist
Go to Top of Page

Bytemaster
Starting Member

USA
3 Posts
Posted - 25 July 2001 :  17:56:38  Show Profile  Send Bytemaster an AOL message  Send Bytemaster a Yahoo! Message
I am able to post replys, but I get the same error when creating new threads. The method above did not fix the problem.
Go to Top of Page

thephantomnl
New Member

Netherlands
66 Posts
Posted - 25 July 2001 :  17:59:03  Show Profile  Visit thephantomnl's Homepage  Send thephantomnl an ICQ Message
i have run every update (started at the bottem) an can post and reply the messages (when i don't delete the snitz test entry' s)
Go to Top of Page

Bytemaster
Starting Member

USA
3 Posts
Posted - 25 July 2001 :  18:10:15  Show Profile  Send Bytemaster an AOL message  Send Bytemaster a Yahoo! Message
Fixed it:

-- Go to Setup.ASP
-- Click on upgrade database (even though it says you don't need to)
-- Choose Snitz Forums 2000 V3.2 Service Release 4

The process reports with errors that tables already exist, etc, but it does add that one column that is needed and fixed the problem.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 25 July 2001 :  20:17:05  Show Profile  Visit HuwR's Homepage
go C_STRMOVENOTIFY should not be in FORUM_TOPICS, it is a config setting, the lines where it is inserting it in post_info shouldn't be there
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts
Posted - 26 July 2001 :  03:50:15  Show Profile  Visit gor's Homepage
My error, Huw is right, C_STRMOVENOTIFY shouldn't be in FORUM_TOPIC

If you allready have upgraded, please remove the field from FORUM_TOPIC
If you are using the Access database, or installed a fresh SQL Server/MySql database, you only have to edit post_info.asp (see below).
If you haven't allready upgraded and are planning to upgrade, change these lines in SETUP.ASP before upgrading (starting line: 1614):

		NewColumns5(8, Prefix)	 = strTablePrefix
		NewColumns5(8, FieldName) = "C_STRMOVENOTIFY"
		NewColumns5(8, TableName) = "TOPICS"
		NewColumns5(8, DataType_Access) = "SMALLINT"
		NewColumns5(8, DataType_SQL6) = "SMALLINT"
		NewColumns5(8, DataType_SQL7) = "SMALLINT"
		NewColumns5(8, DataType_MySQL) = "SMALLINT"
		NewColumns5(8, ConstraintAccess)  = "NOT NULL"
		NewColumns5(8, ConstraintSQL6)  = "NOT NULL CONSTRAINT " & strTablePrefix & "SnitzC1030 DEFAULT 1"
		NewColumns5(8, ConstraintSQL7)  = "NOT NULL CONSTRAINT " & strTablePrefix & "SnitzC1030 DEFAULT 1"
		NewColumns5(8, ConstraintMySQL)  = "DEFAULT '1' NOT NULL"

Though that still will add the field, that doesn't matter, we'll remove it with the next upgrade.

To get rid of the errormessage:

Edit post_info.asp by modifying the SQL statement starting line 627:

		'## Forum_SQL - Add new post to Topics Table
		strSql = "INSERT INTO " & strTablePrefix & "TOPICS (FORUM_ID"
		strSql = strSql & ", CAT_ID"
		strSql = strSql & ", T_SUBJECT"
		strSql = strSql & ", T_MESSAGE"
		strSql = strSql & ", T_AUTHOR"
		strSql = strSql & ", T_LAST_POST"
		strSql = strSql & ", T_LAST_POST_AUTHOR"
		strSql = strSql & ", T_DATE"
		strSql = strSql & ", T_STATUS"
		if strIPLogging <> "0" then
			strSql = strSql & ", T_IP"
		end if
		strSql = strSql & ", T_ARCHIVE_FLAG"
		strSql = strSql & ", C_STRMOVENOTIFY"
		strSql = strSql & ") VALUES ("
		strSql = strSql & Forum_ID
		strSql = strSql & ", " & Cat_ID
		strSql = strSql & ", '" & txtSubject & "'"
		strSql = strSql & ", '" & txtMessage & "'"
		strSql = strSql & ", " & rs("MEMBER_ID")
		strSql = strSql & ", '" & DateToStr(strForumTimeAdjust) & "'"
		strSql = strSql & ", " & rs("MEMBER_ID")
		strSql = strSql & ", '" & DateToStr(strForumTimeAdjust) & "'"
		if Request.Form("lock") = 1 then
				strSql = strSql & ", 0 "
		else
			if Moderation = "Yes" then
				strSql = strSql & ", 2 "
			else
				strSql = strSql & ", 1 "
			end if
		end if
		if strIPLogging <> "0" then
			strSql = strSql & ", '" & Request.ServerVariables("REMOTE_ADDR") & "'"
		end if
		strSql = strSql & ", 1 "
		strSql = strSql & ", 1 "
        	strSql = strSql & ")"




Pierre
Join a Snitz Mailinglist
Go to Top of Page

thephantomnl
New Member

Netherlands
66 Posts
Posted - 26 July 2001 :  04:18:20  Show Profile  Visit thephantomnl's Homepage  Send thephantomnl an ICQ Message
oke it seems to work. THANX!

Go to Top of Page

Methos
Starting Member

Canada
5 Posts
Posted - 27 July 2001 :  00:02:08  Show Profile
I followed the above instructions (ran setup.asp and edited post_info.asp) and now I get this error:

----------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] The field 'FORUM_TOPICS.C_STRMOVENOTIFY' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.

/forum/post_info.asp, line 653
----------

Also, even though default.asp shows that there's one post in the Test Forum, when I open the Test Forum, it says No Topics Found. See http://www.imethos.com/forum

BTW, I'm attempting to do a clean installation (not an upgrade).

Sharon
Go to Top of Page

Methos
Starting Member

Canada
5 Posts
Posted - 27 July 2001 :  00:27:21  Show Profile
I solved the problem by reuploading the database, i.e. removing the changes made when I ran setup.asp and upgraded the database.

However, the welcome message in the Test Forum still doesn't show up on the topic list even though I have "Show all open topics" but my other test posts do show up. But I can get to the welcome message by opening another message then clicking on the "Next topic" icon. Bizarre.

Sharon
Go to Top of Page

emican
Starting Member

2 Posts
Posted - 27 July 2001 :  10:13:33  Show Profile
Thank you so much! I have solved my problem!
Go to Top of Page

emican
Starting Member

2 Posts
Posted - 27 July 2001 :  10:13:53  Show Profile
Thank you so much! I have solved my problem!
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07