Silverstripe Version: 4.1.2
Hi there. I manage a SilverStripe installation (4.1.2) installed on Windows Server 2016, IIS 10 with a connected MSSQL database.
There have been no issues up until today with the files tab allowing the viewing and uploading of images. An internal team use the CMS pages to add content and ‘insert images’. When they attempt to do so, the following error is produced (it also produces when going direct to the ‘Files’ tab).
Couldn't run query: SELECT DISTINCT "File_Live"."ID", "File_Live"."Name" AS "_SortColumn0" FROM "File_Live" WHERE ("File_Live"."ID" IN (?, ?, ?, ?, ?, ?)) AND (("File_Live"."ID" NOT IN (?, ?, ?, ?, ?, ?) OR "File_Live"."ID" IS NULL)) ORDER BY "_SortColumn0" ASC IMSSP, -52, Tried to bind parameter number 2101. SQL Server supports a maximum of 2100 parameters.
Please note, there are hundreds more '?'s than I have pasted here. I have looked around the forums and found little in the way of reference for this error. I understand this error may be caused by the query returning too many values but from what I can see this query is part of the core functionality of SilverStripe? Also the fact I have changed nothing on my side and it randomly stopped working has left me unable to know where to start looking.
Any info or advice would be greatly appreciated. Thank you for your time.