When i try to setup jetanother forum following the guide step, I got the serious problem
I install in ISS 7
Jetanotherforum: 1.9.6.1
Database mssqlserver 2008
The Error message is :
Server Error in '/' Application.
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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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
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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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 top 1 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]
YAF.Classes.Data.LegacyDb.system_initialize_executescripts(String script, String scriptFile, Boolean useTransactions) +1532
YAF.Install._default.ExecuteScript(String scriptFile, Boolean useTransactions) +295
YAF.Install._default.UpgradeDatabase(Boolean fullText) +99
YAF.Install._default.Wizard_NextButtonClick(Object sender, WizardNavigationEventArgs e) +559
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +586
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +52
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3707
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Please help me solves it
Thanks and best regards
Edited by moderator
8 years ago
|
Reason: Not specified