leiao
  • Posts: 4
  • Joined: 12/11/2009
Hi Guys..

Tried a new installation of 1.9.4 Beta3.
Was shown the following error.

FILE:
mssql/procedures.sql

ERROR:
Invalid column name 'IsDeleted'.

STATEMENT:
CREATE PROCEDURE [dbo].[yaf_pmessage_list](@FromUserID int=null,@ToUserID int=null,@UserPMessageID int=null) AS
BEGIN
SELECT PMessageID, UserPMessageID, FromUserID, FromUser, ToUserID, ToUser, Created, Subject, Body, Flags, IsRead, IsInOutbox, IsArchived, IsDeleted
FROM [dbo].[yaf_PMessageView]
WHERE ((@UserPMessageID IS NOT NULL AND UserPMessageID=@UserPMessageID) OR
(@ToUserID IS NOT NULL AND ToUserID = @ToUserID) OR (@FromUserID IS NOT NULL AND FromUserID = @FromUserID))
ORDER BY Created DESC
END

Any advice on the resolution?

Tks and CHeers
Sponsor
leiao
  • Posts: 4
  • Joined: 12/11/2009
HI All...

Managed to solve it.. re-did the SQL.

CHeers
Jaben
  • Posts: 2544
  • Joined: 09/10/2004
That's a bug... I have to remember to fix that.
leiao
  • Posts: 4
  • Joined: 12/11/2009
Tks Jaben.

ANyway.. I am trying to do a text align for the "Topic starter" to center like the rest. But can't seems to find the Css to change it.

Great forums btw.

CHeers
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.

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