YAFLogo

motcongau
  • motcongau
  • 55.4% (Neutral)
  • YAF Forumling Topic Starter
8 years ago
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
Sponsor

sunita83
  • sunita83
  • 51.2% (Neutral)
  • YAF Forumling
8 years ago
Even i am looking for installation
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
8 years ago
Originally Posted by: motcongau 

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



Did the error also occur when you install the latest version of YAF?

motcongau
  • motcongau
  • 55.4% (Neutral)
  • YAF Forumling Topic Starter
8 years ago
It still got many serious error message " when i try latest version
Line 111:
Line 112:
Line 113:
Line 114:
Line 115:
"

oh my god too difficult to deploy jetanotherforum

I think that the good technology or good solution will userfriendly to the users, i don't think it' is too dificult to deploys like that
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
8 years ago
Are you using the recommended.web.config?

And did you follow the install guide?
https://github.com/YAFNET/YAFNET/wiki/Installation 
motcongau
  • motcongau
  • 55.4% (Neutral)
  • YAF Forumling Topic Starter
8 years ago
I am using IIS 7, MS SQL SERVER 2008

I do like install guide:

Rename: app.config (Copy to main folder jetanotherforum)

Type : Localhost/install/default.aspx and it display web interface to config

I config it connect to database successfully

But when at the final step : when i click the button next to upgrade the database

(Clicking next will upgrade your database to the latest version )


I got the The Error message

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'Wink reg WHERE ver > 30)
BEGIN
if exists (select top 1 1 from syscolumns where id=object_id('[dbo].[yaf_User]'Wink and name='Gender'Wink
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]'Wink and name='Location'Wink
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]'Wink and name='HomePage'Wink
begin
alter table [dbo].[yaf_User] drop column HomePage
end


Please help me

I really want to deploy a forum using .NET Technology


Thanks and best regards
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
8 years ago
Well the error message indicates that you are still using an old version and not the latest version 2.2.1 which you can found on the downloads page

https://github.com/YAFNET/YAFNET/releases/download/v2.2.1/YAF-v2.2.1.0-Install.zip 
motcongau
  • motcongau
  • 55.4% (Neutral)
  • YAF Forumling Topic Starter
8 years ago
When i install the version you give me 2.2.1

I still got the same problem

Database Connection Test

Test Database Connection
Connection Details Connection Succeeded

And then I Click Next button to

Initialize Database

Clicking "Next" will initialize your database to the latest version.

I got the same Error like old version 1.9.61

Server Error in '/' Application.

FILE:
mssql/install/providers/procedures.sql

ERROR:
Invalid column name 'ApplicationId'.

STATEMENT:
CREATE PROCEDURE [dbo].[yaf_prov_createapplication]
(
@ApplicationName nvarchar(256),
@ApplicationID uniqueidentifier OUTPUT
)
AS
BEGIN
SET @ApplicationID = (SELECT ApplicationID FROM [dbo].[yaf_prov_Application] WHERE ApplicationNameLwd=LOWER(@ApplicationName))

IF (@ApplicationID IS Null)
BEGIN
SELECT @ApplicationID = NEWID()
INSERT [dbo].[yaf_prov_Application] (ApplicationId, ApplicationName, ApplicationNameLwd)
VALUES (@ApplicationID, @ApplicationName, LOWER(@ApplicationName))
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/install/providers/procedures.sql

ERROR:
Invalid column name 'ApplicationId'.

STATEMENT:
CREATE PROCEDURE [dbo].[yaf_prov_createapplication]
(
@ApplicationName nvarchar(256),
@ApplicationID uniqueidentifier OUTPUT
)
AS
BEGIN
SET @ApplicationID = (SELECT ApplicationID FROM [dbo].[yaf_prov_Application] WHERE ApplicationNameLwd=LOWER(@ApplicationName))

IF (@ApplicationID IS Null)
BEGIN
SELECT @ApplicationID = NEWID()
INSERT [dbo].[yaf_prov_Application] (ApplicationId, ApplicationName, ApplicationNameLwd)
VALUES (@ApplicationID, @ApplicationName, LOWER(@ApplicationName))
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/install/providers/procedures.sql

ERROR:
Invalid column name 'ApplicationId'.

STATEMENT:
CREATE PROCEDURE [dbo].[yaf_prov_createapplication]
(
@ApplicationName nvarchar(256),
@ApplicationID uniqueidentifier OUTPUT
)
AS
BEGIN
SET @ApplicationID = (SELECT ApplicationID FROM [dbo].[yaf_prov_Application] WHERE ApplicationNameLwd=LOWER(@ApplicationName))

IF (@ApplicationID IS Null)
BEGIN
SELECT @ApplicationID = NEWID()
INSERT [dbo].[yaf_prov_Application] (ApplicationId, ApplicationName, ApplicationNameLwd)
VALUES (@ApplicationID, @ApplicationName, LOWER(@ApplicationName))
END
END]
YAF.Classes.Data.LegacyDb.system_initialize_executescripts(String script, String scriptFile, Boolean useTransactions) +1620
YAF.Core.Services.InstallUpgradeService.ExecuteScript(String scriptFile, Boolean useTransactions) +188
YAF.Types.Extensions.EnumerableExtensions.ForEach(IEnumerable`1 list, Action`1 action) +235
YAF.Core.Services.InstallUpgradeService.ExecuteInstallScripts(Boolean isAzureEngine) +205
YAF.Core.Services.InstallUpgradeService.UpgradeDatabase(Boolean fullText, Boolean upgradeExtensions) +331
YAF.Install._default.Wizard_NextButtonClick(Object sender, WizardNavigationEventArgs e) +1936
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

Thanks and best regards



tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
8 years ago
I see the problem now, your database is set to case senstive,

I upload an fixed version tomorrow which the updated SQL scripts, working in case sensitive mode.
motcongau
  • motcongau
  • 55.4% (Neutral)
  • YAF Forumling Topic Starter
8 years ago
Thanks When you post the new install version . Please inform me !. I will try to deploy


Best regards
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
8 years ago
Originally Posted by: motcongau 

Thanks When you post the new install version . Please inform me !. I will try to deploy


Best regards



unfortunately this affects more code then expected, meaning this will take longer then expected.

What you could do is change the Collation of the YAF Database from Latin1_General_CS_AS to Latin1_General_CI_AS. This can be done from the SQL Server Management Studio
motcongau
  • motcongau
  • 55.4% (Neutral)
  • YAF Forumling Topic Starter
8 years ago
Thanks You

But How can i deploy latest version of Jetanother forum

Can you tell me the platform

Window server (Version ? )
MS SQL server (Version ? )
IIS (Version ?)

Thanks and best regards
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
8 years ago
Originally Posted by: motcongau 

Thanks You

But How can i deploy latest version of Jetanother forum

Can you tell me the platform

Window server (Version ? )
MS SQL server (Version ? )
IIS (Version ?)


Thanks and best regards



Minimum Requirements are

Server
Windows 2008 Server

SQL Server
Microsoft SQL Server 2008

.NET Framework
4.0

IIS
IIS 7.0
motcongau
  • motcongau
  • 55.4% (Neutral)
  • YAF Forumling Topic Starter
8 years ago
Thanks you

I will try to deploy the lastest version on a new server

Best regards,
YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button