leiao
  •  leiao
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
2009-11-11T23:58:41Z
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
  •  leiao
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
2009-11-12T00:16:43Z
HI All...

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

CHeers
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2009-11-12T00:20:44Z
That's a bug... I have to remember to fix that.
leiao
  •  leiao
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
2009-11-12T04:06:00Z
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

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