Umbraco currently has a minimum SQL version of 2008. Plumber is using the OFFSET/FETCH in the ORDER BY clause which is SQL2012 and later.
It should be somewhere in the documentation that Plumber has a higher requirement than Umbraco itself. Might have saved me a few minutes of looking at the source code!
I'm getting a lot of errors at the moment, hopefully they'll go away once I've migrated the DB.
Minimum SQL 2012?
Hi Nathan,
Umbraco currently has a minimum SQL version of 2008. Plumber is using the OFFSET/FETCH in the ORDER BY clause which is SQL2012 and later.
It should be somewhere in the documentation that Plumber has a higher requirement than Umbraco itself. Might have saved me a few minutes of looking at the source code!
I'm getting a lot of errors at the moment, hopefully they'll go away once I've migrated the DB.
Regards,
Tim
I'm now on SQL 2012 and investigating Plumber properly. As expected, my initial errors have gone away.
Tim
Hi Tim
Sorry for the slow reply - my host broke my email, and neglected to tell me, so missed the notifications for your posts.
I'd like to keep SQL requirements inline with Umbraco, so will review this.
EDIT: Have resolved this, will have a patch release out soon, hopefully with your other issues addressed as well.
is working on a reply...