Error upgrading in message_delete on SQL 2005 · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

parkerseal
65% (Friendly)
YAF Camper Topic Starter

9 years ago

Just in case there's anyone else still using SQL 2005 (must have a word with my ISP!):

The 2.2.2.0 upgrade procedure errors in upgrade/mssql/procedures.sql on the line

    declare @Posted datetime = (select Posted from ...

SQL 2005 doesn't support this "declare and initialise" syntax, so it needs to be changed to:

    declare @Posted datetime
    set @Posted = (select Posted from ...

Edited by user 9 years ago | Reason: add version

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

Similar Topics

SQL Server DB error when upgrading to latest YAF version (YAF Issues & Bugs Discussion) by johnk 11 years ago
What's the connection for SQL 2005 on my local machine? (YAF General) by xuanvu 16 years ago
First Time Install Woes version 1.9.5.5 on SQL 2005 (YAF Installation/Setup) by PhilN 13 years ago
YAF v1.9.1.8 using lot of RAM for MS SQL service(2005) (YAF General) by abcd 15 years ago
SQL error (YAF Issues & Bugs Discussion) by tommyboy10 11 years ago

Users browsing this topic

Important Information: