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: Database: MS SQL Server
 Upgrade from 3.4 to 3.4.04 errors
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

aberbotimue
Starting Member

United Kingdom
41 Posts

Posted - 04 April 2004 :  20:33:30  Show Profile  Visit aberbotimue's Homepage  Send aberbotimue a Yahoo! Message
Hi guys..

I have just run the setup.asp and it gave me this lot

quote:

Upgraded: Added default values for new fields in CONFIG table
Upgraded: T_STICKY field value updated in the TOPICS table
Upgraded: Added default values for new fields in CONFIG table
Error: 80040E14 Cannot alter column 'T_MESSAGE' because it is 'ntext'.
strUpdateSql: ALTER TABLE BRANDED_A_TOPICS ALTER COLUMN T_MESSAGE NTEXT NULL
Error: 80040E14 Cannot alter column 'T_MESSAGE' because it is 'ntext'.
strUpdateSql: ALTER TABLE BRANDED_TOPICS ALTER COLUMN T_MESSAGE NTEXT NULL
Upgraded: T_SUBJECT Field has been changed
Upgraded: T_SUBJECT Field has been changed
Error: 80040E14 Cannot alter column 'R_MESSAGE' because it is 'ntext'.
strUpdateSql: ALTER TABLE BRANDED_A_REPLY ALTER COLUMN R_MESSAGE NTEXT NULL
Error: 80040E14 Cannot alter column 'R_MESSAGE' because it is 'ntext'.
strUpdateSql: ALTER TABLE BRANDED_REPLY ALTER COLUMN R_MESSAGE NTEXT NULL
Upgraded: Added default values for new fields in CONFIG table

The Upgrade has been completed without errors !




Now clearly, there are errors, and even if the upgrades work, may this come and bite me later in the day, when the users all come back, and start doing stuff again..??

can anyone explain what the errors are, even if they arn't croitical?

My prefixes in config.asp are

table branded_
members brand_
filter bran_

Cheers




Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 04 April 2004 :  20:44:15  Show Profile  Visit HuwR's Homepage
it is just saying that the fields it was trying to change to ntext were already ntext, so the errors don't matter.
Go to Top of Page

aberbotimue
Starting Member

United Kingdom
41 Posts

Posted - 04 April 2004 :  21:46:55  Show Profile  Visit aberbotimue's Homepage  Send aberbotimue a Yahoo! Message
Thanx

From a usability point of view, is it worth saying as much in the upgrade instructions/readme file??

N

Nathan
Duct tape is like the force, it has a dark side and a light side, and holds the universe together

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