#3738 - does not work with MSsql part 2
for some reason my post was cut here is the log Fri Jul 16 11:20:59 2021 [465ee86b-b620-8ee9-c5b5-5cdc4ae4e78b][FATAL] Query Failed:SELECT * FROM recycle_bin_relationship_records WHERE parrent_id=N'F7DB14B2-C601-4305-8511-F8AC2CCB7783' LIMIT 1::: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'. Fri Jul 16 11:20:59 2021 [465ee86b-b620-8ee9-c5b5-5cdc4ae4e78b][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
mssql does not use the "limit" keyword the proper mssql statement would be SELECT TOP 1 * FROM recycle_bin_relationship_records WHERE parrent_id=N'F7DB14B2-C601-4305-8511-F8AC2CCB7783'
so the top keyword is the right one and it is not located at the same position in the query...
Other add-ons of interest
Glances - Integrate SuiteCRM with all your apps
The simplest way to work™. Glances integrates SuiteCRM with all your favorite workplace apps, acting as your go-to hub for real-time customer insights and personal tasks.
Trash Bin For SuiteCRM
Recover deleted data from CRM with Trash Bin for SuiteCRM. It restores data from different modules that you or your users have deleted. SuiteCRM Trash Bin stores all types of deleted records from your CRM. If you ever need to retrive deleted data, you can do so easily from the Trash Bin.
Tired of having to delete Contacts and related Activities by hand when deleting Account records? deletePLUS puts you in control of what records are deleted AND which of the related records are deleted. Available from the Accounts, Contacts and Opportunities Actions menu - fully configurable