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

#5205 - database collation

Closed Bug? created by jasminkreutz Verified Purchase 9 months ago

HI there.

I have a fresh installed suiteCRM 7.14.2 on php8.2 and mariadb 10.11. My whole database is utf8mb4_general_ci and all plugins I installed use automatically this collation.

My Problem is that Field Level Access does not use it. I have no ideas why, but somehow the access_controll_fields table is created with "utf8mb3_general_ci". Of cours thay dont work together...
unfortunately they break the whole system. No module is shown properly when the modul is installed... how to fix it?

  1. Biztech member avatar

    AppJetty Provider Affiliate

    9 months ago

    Hello Jasmin,

    Thank you for contacting us!

    We appreciate your patience while we're looking into your concern.

    We will soon update you over your email for the same.

    Feel free to reach out if you have any further questions or concerns in the meantime.

    Kind Regards, AppJetty Support

  2. jasminkreutz member avatar

    jasminkreutz Verified Purchase

    8 months ago

    why do you close it? I still have the problem... and since my request you did not update the plugin it is still 1.3.19. so please help.

    • Biztech member avatar

      AppJetty Provider Affiliate

      8 months ago

      Hello Jamis,

      We have emailed you regarding the issue and followed up, but unfortunately, we haven't heard back from you, so we have closed this case.

      If you're still experiencing the problem, please revert back to us at "[email protected]".

      Hope this clarifies things! We look forward to receiving your email.

  3. Biztech member avatar

    AppJetty Provider Affiliate

    8 months ago

    Hello Jamsin,

    We have mistakenly sent the wrong email. Please consider this correct email: "[email protected]".

  4. jasminkreutz member avatar

    jasminkreutz Verified Purchase

    8 months ago

    I did not receive any email from you. I just received the info you closed the case. Can you send it again? What should i send you?

    • Biztech member avatar

      AppJetty Provider Affiliate

      8 months ago

      Hello Jasmin,

      Apologies for the inconvenience. Here's the email content:

      Kindly follow the steps outlined below to resolve the issue:

      1. Navigate to Administrator -> Locale.
      2. In the 'Database Collation' section, check the collation.
        • If it is 'utf8mb4_general_ci,' simply click on the 'Save' button.
        • If the collation is not 'utf8mb4_general_ci,' please set it accordingly.

      If the issue still persists or you encounter difficulties with the steps, kindly email us at "[email protected]", and we can arrange a quick AnyDesk session to assist you further.

      Please let us know if you need further assistance.

  5. jasminkreutz member avatar

    jasminkreutz Verified Purchase

    8 months ago

    I already have the database (the local settings) set to utf8mb4_general_ci. I have some other plugins in my installation none have had the problems so i guess it must be sometinng related to this plugin.

    Any other idea?

  6. Biztech member avatar

    AppJetty Provider Affiliate

    8 months ago

    Hello Jasmin,

    We have addressed the issue and provided you with an updated package via email. Please check your inbox and let us know if everything is working as expected.

    We hope this information resolves your concern! If you have any further questions or need assistance, please feel free to reach out to us.

    Best regards, AppJetty Support

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