Recycle Bin

by Helfertech

Deleted a record by accident? Use Recycle Bin to undelete it.

Free 30 day trial
Try it Now

#3738 - does not work with MSsql part 2

Closed Installation created by Serge Pelletier 3 years ago

for some reason my post was cut here is the log Fri Jul 16 11:20:59 2021 [11864][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 [11864][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...

  1. saeed member avatar

    Helfertech Provider

    3 years ago

    Hi, We have uploaded our latest release and fixed the MySQL syntax issue. Please download it from our product page. Thank you.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • Supported Versions
  • 7.0.0 to 8.6.1
Rating

  • "A great feature that has saved our firm a lot of time and headaches. Thanks" - matt3

    Read More Reviews

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.

Featured

Dashboard Copy Manager

Administrators can copy dashboards from any user to any number of users, security groups, or roles. Save time logging in as individual users to set up their dashboards.

Rating
Featured

Duplicate Checker

Duplicate Checker helps to prevent duplicate records in your CRM for the Account, Contact and Lead modules. If your CRM has duplicate records then the wrong data can be displayed and used by your users. Stop the possibility of misleading information being used by your team by using Duplicate Checke...
Administration recycle restore delete deleted recover undelete undo recycling backup CRM SuiteCRM accidental deletes permanently store repack reuse safe trash soft delete reprocess recyclable lose waste rescue recycle bin take back reoccupy redeem save retook salvage repair remove