YAFLogo

leiao
  • leiao
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
13 years ago
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
13 years ago
HI All...

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

CHeers

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
13 years ago
That's a bug... I have to remember to fix that.
leiao
  • leiao
  • 52.4% (Neutral)
  • YAF Forumling Topic Starter
13 years ago
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