by SuiteCRM

Official SuiteCRM Outlook Plugin v4 has arrived - Compatible with the Outlook Web App or Outlook 2016+ connected to Office365 or Exchange Server 2016. A complete rebuild developed and maintained by SuiteCRM developers, the addon retains previous functionality while massively improves performance, reliability and stability!

Cancel at any time!
Free Trial

#4643 - Database failure

Closed Installation created by danieltyas Verified Purchase a year ago

When adding user to the outlook plugin. I get the following message:

Screenshot 2023-01-05 at 16.29.19.png

Error: Database failure. Please refer to suitecrm.log for details.when trying to add a user.

Any advice please? we are currently testing the outlook plugin for 30days before buying 12 licenses

Kind Regards

Dan

  1. suitecrm member avatar

    SuiteCRM Provider Affiliate

    a year ago

    Please ensure you have ran a Quick Repair and Rebuild on the instance and applied any database changes which are shown at the end of that process.

    • danieltyas member avatar

      danieltyas Verified Purchase

      a year ago

      Thank you for your quick reply, do you have any documentation how to do that? sorry I'm new to suiteCRM

  2. danieltyas member avatar

    danieltyas Verified Purchase

    a year ago

    error in log:

    MySQL error 1250: Table 'users' from one of the SELECTs cannot be used in global ORDER clause Thu Jan 5 16:26:57 2023 [874008][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.

  3. danieltyas member avatar

    danieltyas Verified Purchase

    a year ago

    Thu Jan 5 16:15:26 2023 [873878][1][FATAL] Query Failed: UPDATE users SET sa_outlook_is_licensed = 1 WHERE deleted=0 AND sa_outlook_is_licensed != 0: MySQL error 1054: Unknown column 'sa_outlook_is_licensed' in 'where clause'

    • suitecrm member avatar

      SuiteCRM Provider Affiliate

      a year ago

      https://store.suitecrm.com/docs/SuiteCRM-official-outlook-plugin/plugin-installation

      Please see the last part of step one

      1. Run a Quick Repair and Rebuild on the instance.
  4. danieltyas member avatar

    danieltyas Verified Purchase

    a year ago

    I have done that with no effect:

    Screenshot 2023-01-05 at 17.07.14.png

    Screenshot 2023-01-05 at 17.07.02.png

  5. danieltyas member avatar

    danieltyas Verified Purchase

    a year ago

    You'll be glad to here I have fixed the database error, it was a mysql call error and required alteration to SugarBean.php

    I'm am now having trouble on the outlook like, after entering all the credentials it gives me an unknown error when submitting and I am sure the credentials are correct

  6. danieltyas member avatar

    danieltyas Verified Purchase

    a year ago

    Jus to let you know it was a permissions issue on the private.key. Resolved now.

  7. danieltyas member avatar

    danieltyas Verified Purchase

    a year ago

    Its a battle.... but we're getting there.

    Screenshot 2023-01-05 at 22.29.11.png

    see above the rather ironic message that the athentication is successfull, but when I click archive it brings up the unable to connect to suitecrm message.

    Any ideas please? I'm so close!

  8. danieltyas member avatar

    danieltyas Verified Purchase

    a year ago

    when accessing https://crm.domain.co.uk/Api/access_token

    Screenshot 2023-01-05 at 22.51.22.png

  9. danieltyas member avatar

    danieltyas Verified Purchase

    a year ago

    Please reply when you can, I'm so close! I'm looking to buy 11 licenses for starters, but I have to see it work first, thank you in advance

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "How to enable "Sync to outlook" checkbox? I follow the instruction and display on Edit/Detail view. The "Sync to outlook" checkbox appear in the pane..." - Yathit

    Read More Reviews