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 [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`