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: General / Classic ASP versions(v3.4.XX)
 3.4.06 to 3.4.07 database upgrade problem		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Gaisa
Starting Member

4 Posts
Posted - 09 September 2009 :  19:18:04  Show Profile
Hi, I've been trying to upgrade my database to 3.4.07, but came across a little hitch:

there are two critical errors and one minor one:
quote:
Error: 80040E21 Field 'M_ALLOWEMAIL' already exists in table 'FORUM_MEMBERS'.
strUpdateSql: ALTER TABLE FORUM_MEMBERS ADD M_ALLOWEMAIL smallint DEFAULT 0

quote:
Error: 80040E21 Field 'M_ALLOWEMAIL' already exists in table 'FORUM_MEMBERS_PENDING'.
strUpdateSql: ALTER TABLE FORUM_MEMBERS_PENDING ADD M_ALLOWEMAIL smallint DEFAULT 0

quote:
Error: 80040E14 Table 'FORUM_SPAM_MAIL' already exists.
strUpdateSql: CREATE TABLE FORUM_SPAM_MAIL ( SPAM_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , SPAM_SERVER text (255) NULL )



The database is currently access based (I plan to switch to mysql soon, but don't currently have the time to set everything up), have I missed something obvious?
Could you Email the reply to me as well please?
G
Edited by - Gaisa on 09 September 2009 19:36:16

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 09 September 2009 :  19:36:33  Show Profile  Send ruirib a Yahoo! Message
No, you should be fine. Those errors won't affect the normal working of the forum.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Gaisa
Starting Member

4 Posts
Posted - 10 September 2009 :  02:14:20  Show Profile
okay, most of the forum seems to work alright, but the email user option comes up with this:

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'cInt'

/forum/pop_mail.asp, line 68
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 10 September 2009 :  04:22:18  Show Profile  Send ruirib a Yahoo! Message
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=68482

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Gaisa
Starting Member

4 Posts
Posted - 10 September 2009 :  12:42:57  Show Profile
quote:
Originally posted by ruirib

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=68482


thanks! that worked a treat!
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.47 seconds. Powered By: Snitz Forums 2000 Version 3.4.07