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
 Problem upgrading from .03 to .04		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

dbullock
Starting Member

USA
7 Posts
Posted - 22 August 2004 :  19:42:36  Show Profile

I am trying to run the upgrade from 3.04.03 to 3.04.04 and I am getting the error below.

Is there a known fix for this?

Thanks,
Dan



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 FORUM_A_TOPICS ALTER COLUMN T_MESSAGE NTEXT NULL

Error: 80040E14 Cannot alter column 'T_MESSAGE' because it is 'ntext'.
strUpdateSql: ALTER TABLE FORUM_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 FORUM_A_REPLY ALTER COLUMN R_MESSAGE NTEXT NULL

Error: 80040E14 Cannot alter column 'R_MESSAGE' because it is 'ntext'.
strUpdateSql: ALTER TABLE FORUM_REPLY ALTER COLUMN R_MESSAGE NTEXT NULL

Upgraded: Added default values for new fields in CONFIG table

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 22 August 2004 :  19:50:45  Show Profile
Doesn't it still say completed at the end? Those fields are already converted..
Go to Top of Page

dbullock
Starting Member

USA
7 Posts
Posted - 22 August 2004 :  20:50:58  Show Profile
It says it says been completed without errors. But how can that be true if the lines above explicitly say "Error" ?

Thanks,
Dan
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 22 August 2004 :  22:22:09  Show Profile
because those things weren't necessary, the only errors you need to worry about are critical errors.
Go to Top of Page

dbullock
Starting Member

USA
7 Posts
Posted - 23 August 2004 :  05:31:44  Show Profile
Ok. Thanks for the help Richard!
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.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07