Adapter error when using skip

[ionutchirvasa]

No matter what blueprint API I use I get when using skip without populate=false the adapter throws an error!

Sample request:

Fails: http://localhost:1337/api/audit?skip=1
Works: http://localhost:1337/api/audit?skip=1&populate=false

I event tried this wit a model that has no relations set up and I get the same error.

I attached the error I receive from the server.
Adapter error.txt

Edit:
The issue is related with the generated sql query; it's missing the sorting column(please see row 2: (ORDER BY ).
SELECT TOP 1 * FROM ( SELECT ROW_NUMBER() OVER(ORDER BY ) as row#, [audit].[createdAt], [audit].[updatedAt], [createdBy].[createdAt] as [createdBy.createdAt], [createdBy].[updatedAt] as [createdBy.updatedAt], [createdBy].[id] as [createdBy.id], [createdBy].[firstName] as [createdBy.firstName], [createdBy].[lastName] as [createdBy.lastName], [createdBy].[photo] as [createdBy.photo], [createdBy].[email] as [createdBy.email], [createdBy].[username] as [createdBy.username], [createdBy].[createdBy] as [createdBy.createdBy], [createdBy].[departmentID] as [createdBy.departmentID], [audit].[id], [audit].[newValue], [audit].[oldValue], [audit].[modelID], [audit].[modelName] FROM [audit] WITH (NOLOCK) left outer join [user] as [createdBy] on [createdBy].[id] = [audit].[createdBy] ) as completeDataSet where row# > 1 FOR JSON PATH

   Workaround:
   Explicitly specifying the sort param in the URL solves the issue:
   http://localhost:1337/api/audit?skip=1&sort=id

[acraileanu]

@davepreston: potential fix - acraileanu@a4d9905