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/tables.sql
ERROR:
Invalid column name 'name'.
Invalid column name 'value'.
STATEMENT:
-- Only remove User table columns if version is 30+
IF EXISTS (SELECT ver FROM (SELECT CAST(CAST(value as nvarchar(255)) as int) as ver FROM [dbo].[yaf_Registry] WHERE name = 'version') reg WHERE ver > 30)
BEGIN
if exists(select 1 from syscolumns where id=object_id('[dbo].[yaf_User]') and name='Gender')
begin
alter table [dbo].[yaf_User] drop column Gender
end
if exists(select 1 from syscolumns where id=object_id('[dbo].[yaf_User]') and name='Location')
begin
alter table [dbo].[yaf_User] drop column Location
end
if exists(select 1 from syscolumns where id=object_id('[dbo].[yaf_User]') and name='HomePage')
begin
alter table [dbo].[yaf_User] drop column HomePage
end
if exists(select 1 from syscolumns where id=object_id('[dbo].[yaf_User]') and name='MSN')
begin
alter table [dbo].[yaf_User] drop column MSN
end
if exists(select 1 from syscolumns where id=object_id('[dbo].[yaf_User]') and name='YIM')
begin
alter table [dbo].[yaf_User] drop column YIM
end
if exists(select 1 from syscolumns where id=object_id('[dbo].[yaf_User]') and name='AIM')
begin
alter table [dbo].[yaf_User] drop column AIM
end
if exists(select 1 from syscolumns where id=object_id('[dbo].[yaf_User]') and name='ICQ')
begin
alter table [dbo].[yaf_User] drop column ICQ
end
if exists(select 1 from syscolumns where id=object_id('[dbo].[yaf_User]') and name='RealName')
begin
alter table [dbo].[yaf_User] drop column RealName
end
if exists(select 1 from syscolumns where id=object_id('[dbo].[yaf_User]') and name='Occupation')
begin
alter table [dbo].[yaf_User] drop column Occupation
end
if exists(select 1 from syscolumns where id=object_id('[dbo].[yaf_User]') and name='Interests')
begin
alter table [dbo].[yaf_User] drop column Interests
end
if exists(select 1 from syscolumns where id=object_id('[dbo].[yaf_User]') and name='Weblog')
begin
alter table [dbo].[yaf_User] drop column Weblog
end
if exists(select 1 from syscolumns where id=object_id('[dbo].[yaf_User]') and name='WeblogUrl')
begin
alter table [dbo].[yaf_User] drop column WeblogUrl
alter table [dbo].[yaf_User] drop column WeblogUsername
alter table [dbo].[yaf_User] drop column WeblogID
end
END