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
 Error with new admin_mod_dbsetup.asp
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

sumo
Junior Member

USA
121 Posts

Posted - 16 April 2001 :  12:33:27  Show Profile  Visit sumo's Homepage  Send sumo an AOL message
I get these errors when testing out one of my own database modification files:

Adding Column C_STREXCHANGESERVER...
ALTER TABLE FORUM_CONFIG ADD C_STREXCHANGESERVER int NOT NULL
-2147217900 | The total row size (9299) for table 'FORUM_CONFIG' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.
Adding Column C_STREXCHANGESERVERADDR...
ALTER TABLE FORUM_CONFIG ADD C_STREXCHANGESERVERADDR nvarchar (255) NOT NULL
-2147217900 | The total row size (9807) for table 'FORUM_CONFIG' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.
Adding Column C_STREXCHANGESERVER_CN...
ALTER TABLE FORUM_CONFIG ADD C_STREXCHANGESERVER_CN nvarchar (50) NOT NULL
-2147217900 | The total row size (9397) for table 'FORUM_CONFIG' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.
Adding Column C_STREXCHANGESERVER_OU...
ALTER TABLE FORUM_CONFIG ADD C_STREXCHANGESERVER_OU nvarchar (255) NOT NULL
-2147217900 | The total row size (9807) for table 'FORUM_CONFIG' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.
Adding Column C_STREXCHANGESERVER_O...
ALTER TABLE FORUM_CONFIG ADD C_STREXCHANGESERVER_O nvarchar (255) NOT NULL
-2147217900 | The total row size (9807) for table 'FORUM_CONFIG' exceeds the maximum number of bytes per row (8060). Rows that exceed the maximum number of bytes will not be added.

--------------------------------------------------------------------------------

Here's the database setup file I'm using:

MS Exchange Server MOD 2.0
[ALTER]
CONFIG
ADD#C_STREXCHANGESERVER#int##
ADD#C_STREXCHANGESERVERADDR#varchar (255)##
ADD#C_STREXCHANGESERVER_CN#varchar (50)##
ADD#C_STREXCHANGESERVER_OU#varchar (255)##
ADD#C_STREXCHANGESERVER_O#varchar (255)##
[END]

Is there anything wrong with what I'm doing? I don't understand the errors that I'm getting from SQL Server.

Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 16 April 2001 :  17:04:19  Show Profile  Visit HuwR's Homepage
This is one of two errors,

either your field names are too large (unlikely) or
there are now too many fields in your config table.

Try using the forum_mods table to store your variables rather than using config

Go to Top of Page

sumo
Junior Member

USA
121 Posts

Posted - 17 April 2001 :  09:03:10  Show Profile  Visit sumo's Homepage  Send sumo an AOL message
quote:

This is one of two errors,

either your field names are too large (unlikely) or
there are now too many fields in your config table.

Try using the forum_mods table to store your variables rather than using config



This is testing on a fresh copy of the database. Using a "test" forum to do the installation first. I will try to set it up with the other config table. Is that what you use in the next version?

Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 17 April 2001 :  13:08:05  Show Profile  Visit HuwR's Homepage
quote:

quote:

This is one of two errors,

either your field names are too large (unlikely) or
there are now too many fields in your config table.

Try using the forum_mods table to store your variables rather than using config



This is testing on a fresh copy of the database. Using a "test" forum to do the installation first. I will try to set it up with the other config table. Is that what you use in the next version?

Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/



No, it was a table introduced by Animedj's Mod commander MOD

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