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)
 V3.3: BUG+ FIX Forum Archive Problems		  Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

bdinicola
Starting Member

USA
14 Posts
Posted - 26 July 2001 :  10:05:54  Show Profile  Visit bdinicola's Homepage  Send bdinicola an AOL message  Send bdinicola an ICQ Message
Every time I try to create a topic upon submission I get this error:

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

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'F_ARCHIVE_SCHED'.

/forum/post_info.asp, line 881

Additionally, I have problems with virtually everything surrounding the Forum Archive tools.

Help!



Edited by - bdinicola on 26 July 2001 10:45:22

gor
Retired Admin

Netherlands
5511 Posts
Posted - 26 July 2001 :  11:17:22  Show Profile  Visit gor's Homepage


Oops, a typo with a wrong fix during bugtesting causes this.

The setup-files that create the table in SQL-Server and MySql in case of a new install name the field in FORUM_FORUM:
F_L_ARCHIVE_SCHED

While in the Access database, the upgrade-script and the page that handles all the storing of the data (post_info.asp) the field is referred to as:
F_ARCHIVE_SCHED

FIX

Edit these line in inc_create_forum_sql7.asp and inc_create_forum_sql6.asp:

strSql = strSql & "F_L_ARCHIVE_SCHED int NULL CONSTRAINT " & strTablePrefix & "SnitzC1027 DEFAULT 30, "

and
strSql = strSql & "F_L_DELETE_SCHED int NULL CONSTRAINT " & strTablePrefix & "SnitzC1029 DEFAULT 365, "


and/or these lines in inc_create_forum_myslq.asp:

strSql = strSql & "F_L_ARCHIVE_SCHED int (11) DEFAULT '30', "

[/code]
and

strSql = strSql & "F_L_DELETE_SCHED int (11) DEFAULT '365', "[/code]
[/code]

Quick Fix

Run the upgrade from Version 3.1 SR4 and ignore the runtime error you get (because CONFIG doesn't exist), it adds the two missing fields before that.

Pierre
Join a Snitz Mailinglist
Go to Top of Page

bdinicola
Starting Member

USA
14 Posts
Posted - 27 July 2001 :  08:56:14  Show Profile  Visit bdinicola's Homepage  Send bdinicola an AOL message  Send bdinicola an ICQ Message
quote:


Oops, a typo with a wrong fix during bugtesting causes this.


I also had problems with an incorrect line in post_info.asp. I removed the L_ from it and everything works great!

Thanks!
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.07 seconds. Powered By: Snitz Forums 2000 Version 3.4.07