Welcome Guest! To enable all features please Login or Register.
Options
View
Go to last post Go to first unread
Offline vzrus  
#1 Posted : Friday, December 29, 2017 9:23:08 AM(UTC)
vzrus


Rank: YAF Forumling

Reputation:

Joined: 2/9/2017(UTC)
Posts: 2
Russian Federation
Location: Moscow

FILE:
mssql/upgrade/tables.sql

ERROR:
Cannot alter or drop column 'Message' because it is enabled for Full-Text Search.

STATEMENT:
if exists (select top 1 1 from sys.columns where object_id = object_id('[dbo].[yaf_Message]'Wink and name = 'Message' and system_type_id = 99)
begin
alter table [dbo].[yaf_Message] alter column [Message] nvarchar(max)
end
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: FILE:
mssql/upgrade/tables.sql

ERROR:
Cannot alter or drop column 'Message' because it is enabled for Full-Text Search.

STATEMENT:
if exists (select top 1 1 from sys.columns where object_id = object_id('[dbo].[yaf_Message]'Wink and name = 'Message' and system_type_id = 99)
begin
alter table [dbo].[yaf_Message] alter column [Message] nvarchar(max)
end
Sponsor
Offline tha_watcha  
#2 Posted : Saturday, December 30, 2017 11:40:30 AM(UTC)
tha_watcha


Rank: YAF.NET Project Lead

Reputation:

Medals: Medal of Honor: Portal Puzzle Master: Portal Puzzle Master for DNNMedal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.DNN Master: DNN Module ManBug Killer Medal of Honor: Medal for being a kick-ass bug killer!Medal of Honor for the Support King: Support King! Amazing asset to the YAF.NET Community.

Joined: 3/6/2010(UTC)
Posts: 3,764
Germany

Thanks: 70 times
Was thanked: 1157 time(s) in 987 post(s)
Okay then you would need to drop the fulltext first. I added a check version 2.2.4.6 is online

https://github.com/YAFNE...YAF-v2.2.4.6-Upgrade.zip
Offline vzrus  
#3 Posted : Sunday, December 31, 2017 6:59:49 AM(UTC)
vzrus


Rank: YAF Forumling

Reputation:

Joined: 2/9/2017(UTC)
Posts: 2
Russian Federation
Location: Moscow

Thanks, Ingo.

Edited by user Sunday, December 31, 2017 7:04:15 AM(UTC)  | Reason: Not specified

Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error