by AppJetty

If you are a SuiteCRM owner, you can provide users with field-level access in your CRM through SuiteCRM Field Level Access Control. Our plugin enables the admin to display only relevant field data to users who have been assigned roles.

Includes a 30 day guarantee
Try it Now

#1771 - MS SQL Server 2012 support

Closed Installation created by hectorhcg Verified Purchase 7 months ago

I've just finished installation of the module and it was correct (100%) but when I enter to the Administration section I only see labels intead of module options and configurations. My SuiteCRM setup (version 7.10.9 ) runs on a MS SQL Server 2012 without any problems. But when I see suitecrm.log I see this error message:

Mon Feb 18 09:01:40 2019 [3648][1][FATAL] Query Failed:IF NOT EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[access_control_fields]') AND type in (N'U'))
            CREATE TABLE IF NOT EXISTS access_control_fields ([id] varchar(36) NOT NULL ,[name] nvarchar(255) NULL ,
            [date_entered] datetime NULL ,[date_modified] datetime NULL ,[modified_user_id] varchar(36) NULL ,
            [created_by] varchar(36) NULL ,[description] nvarchar(max) NULL ,[deleted] bit DEFAULT '0' NULL ,
            [category] nvarchar(100) NULL ,[aclaccess] int NULL ,[role_id] varchar(36) NULL );::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword 'IF'.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'access_control_fields'.

  1. hectorhcg member avatar

    hectorhcg Verified Purchase

    7 months ago

    screenshot.png

  2. Biztech member avatar

    AppJetty Provider

    7 months ago

    Dear Hector,

    Greetings from Appjetty!

    We have checked the issue and resolved it. Also have updated the new zip package in the store.

    Please download the updated package and re-install the new zip file to the CRM.

    Kindly find the below-mentioned steps to re-install the plugin:

    1. Navigate to the Administration page and click on ‘Module Loader’ to install the package.

    2. As you have already installed the Field Level Access Control plugin, First you may have to uninstall the existing one from the system.

    3. Click on the Uninstall button beside the Field Level Access Control in the Installed Plugin section.

    4. After Successful Uninstallation, please click on Delete Package button beside the Field Level Access Control plugin the module loader page.

    5. Browse the new zip file and click on ‘Upload’ button under Module Loader screen. After uploading the package, click on the ‘Install’ button to install the package.

    6. Click on ‘Commit’ button to finish the installation. After successful installation, you can see ‘Field Level Access Control’ Plug-in in the Installed plug-in list on Module Loader page.

    7. Please do repair and rebuilt the CRM system from Administration > Repair > Quick Repair & Rebuilt. If You found any SQL query at the end of repair page then please execute it.

    Hope this helps! Let us know in case of any concern.

    Kind Regards,
    AppJetty.

  3. hectorhcg member avatar

    hectorhcg Verified Purchase

    7 months ago

    I did so and it worked. Thank you!

    • Biztech member avatar

      AppJetty Provider

      7 months ago

      Dear Hector,

      You're welcome!

      If you need any assistance/information regarding the plugin. Feel free to approach us.

      We would be happy to assist you.

      Have a great time ahead!

      Kind Regards,
      AppJetty.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...