Paging through "viewed messages" in campaign sub panel - causes database error

Hi Everyone

Ive been working for a few weeks with suiteCRM and its great - so much customisation! I have come across what I think is a bug. Its probably an easy fix when you know where to look!!

So I’m hoping that someone can point me in the right direction?

When I press the right arrow to page through the results of message views in campaign sub panel - I get this error message in the log. It appears that its the sort order (ORDER BY .id) that causes the issue as if I sort a column of data it works fine!

My error log is below:

Fri May  7 14:25:34 2021 [13080][1][FATAL] Error retrieving Campaign list:  Query Failed:DECLARE 
@topCount INT SET @topCount = 20 SELECT TOP (@topCount) * FROM
(SELECT ROW_NUMBER() OVER (ORDER BY .id) AS row_number,  campaign_log.*  FROM 
campaign_log WHERE campaign_log.campaign_id = N'ecdb1b35-f8d9-4ef6-3e07-608bb74b00d1' 
AND campaign_log.deleted=0 AND activity_type=N'viewed' AND archived=0 )
AS a
WHERE row_number > 100::: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The multi-part 
identifier ".id" could not be bound.`Preformatted text`

I think I’ve fixed it for all those that have the same error.

Change this file:

In the arrays change:

sort order >


sort order > id

There are a few with this condition I just changed them all.