toanbily
  •  toanbily
  • 57.8% (Neutral)
  • YAF Forumling Topic Starter
2009-05-09T17:28:44Z
Hello,
1. After install yaf forum using VS2008, SQL2005. I'm login as admin but it have an error as attach picture 1.
UserPostedImage



2. When i create new boards, it have an error as attach picture 2.
UserPostedImage
Sponsor
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2009-05-10T03:17:01Z
Turn "Trace" off in your web config as it conflicts with the AJAX. Not sure about the board issue.
toanbily
  •  toanbily
  • 57.8% (Neutral)
  • YAF Forumling Topic Starter
2009-05-10T04:19:29Z
Thanks Jab,
I have turn off "Trace mode" and it's ok.
But in second picture, I can't create new board. Pls view picture and help me.

I'm login as admin and start by step: "Admin -> Boards -> New Board -> Complete field and then click Save"

UserPostedImage


herman_herman
2009-05-10T05:42:55Z
toanbily wrote:

Thanks Jab,
I have turn off "Trace mode" and it's ok.
But in second picture, I can't create new board. Pls view picture and help me.

I'm login as admin and start by step: "Admin -> Boards -> New Board -> Complete field and then click Save"

UserPostedImage




Same error here.Not able to create a new Board!
toanbily
  •  toanbily
  • 57.8% (Neutral)
  • YAF Forumling Topic Starter
2009-05-10T18:31:59Z
Hi all, bugs of this error here:
In yaf_board_create Stored Procedure have script:

INSERT INTO [dbo].[yaf_Forum] ([CategoryID],[Name],[Description],[SortOrder],[NumTopics],[NumPosts],[Flags])
VALUES (@CategoryID,'Test Forum','A test forum',1,0,0,4)
--All new forum in create board have same name: 'Test Forum'
SET @ForumID = SCOPE_IDENTITY()


But in Database -> [yaf_Forum] table: (1.9.3 version)

CONSTRAINT [PK_yaf_Forum] PRIMARY KEY CLUSTERED
(
[ForumID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY],
CONSTRAINT [IX_yaf_Forum] UNIQUE NONCLUSTERED
(
[ParentID] ASC,
[Name] ASC --//Same name not allowed in one Forum (parent - child)

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
=========================================

Change with follow the script to alter DB:

ALTER TABLE [dbo].[yaf_Forum] DROP CONSTRAINT [IX_yaf_Forum]
ALTER TABLE [dbo].[yaf_Forum] ADD CONSTRAINT [IX_yaf_Forum] UNIQUE NONCLUSTERED
(
[CategoryID] ASC,
[Name] ASC
)

Or fix script before install in source:
File: YetAnotherForum.NET\install\mssql\constrainst.sql

if not exists(select 1 from dbo.sysindexes where id=object_id('[{databaseOwner}].[{objectQualifier}Forum]') and name='IX_{objectQualifier}Forum')
alter table [{databaseOwner}].[{objectQualifier}Forum] add constraint IX_{objectQualifier}Forum unique nonclustered (ParentID,Name) --Changed ParentID to CategoryID here
go


But after change [yaf_Forum] table's struct. Have a bugs in code when create a new forum with same name in a Category: (turn off CustomError mode)

File: DBAccess.cs
Line 462
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_yaf_Forum'. Cannot insert duplicate key in object 'dbo.yaf_Forum'.
Cannot insert the value NULL into column 'ForumID', table 'yafnet193.dbo.yaf_ForumAccess'; column does not allow nulls. INSERT fails.


GerritJan123
2009-09-28T07:06:42Z
Hi all,

I'm currently using 1.9.3 and having trouble to create a new board. So if i'm logged in as administrator and navigate to 'Host->Boards' and click 'New Board' and hit 'Save' button after naming the to-be-created board, it simply doesn't! Also, it does not give me any feedback / trace / error.

Any idea what's going on? I'm a developer, so don't be scared to let me modify some code..

Thanks in advance.

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

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved