by Opacus

Full CalDAV bi-directional sync for SugarCRM. Use your native calendar on your favorite device to synchronise calls, meetings and tasks. Works with Apple (iOS), Android, and Thunderbird/Lightning.

Cancel at any time!
Free Trial

#1862 - Problem when activate license

Closed Bug? created by nordestinnovazione a year ago

Hi,
I've installed Activities Sync module for SugarCRM and when I insert the License key it remain in status "Waiting".
I did a Quick repair and I got this error:

/* Table : principals /
/
COLUMNS/
/
MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'int' [len] => '11' [auto_increment] => '1' /
/
VARDEF - id - ROW[name] => 'id' [type] => 'integer' [auto_increment] => '1' [dbType] => 'integer' [len] => '' [required] => 'true' /
/
INDEXES /
ALTER TABLE principals modify COLUMN id integer NOT NULL auto_increment;
/
Table : calendars /
/
COLUMNS/
/
MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'int' [len] => '11' [auto_increment] => '1' /
/
VARDEF - id - ROW[name] => 'id' [type] => 'integer' [auto_increment] => '1' [dbType] => 'integer' [len] => '' [required] => 'true' /
/
MISMATCH WITH DATABASE - ctag - ROW [name] => 'ctag' [type] => 'int' [len] => '11' /
/
VARDEF - ctag - ROW[name] => 'ctag' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' /
/
MISMATCH WITH DATABASE - calendarorder - ROW [name] => 'calendarorder' [type] => 'int' [len] => '11' /
/
VARDEF - calendarorder - ROW[name] => 'calendarorder' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' /
/
INDEXES /
ALTER TABLE calendars modify COLUMN id integer NOT NULL auto_increment, modify COLUMN ctag integer NULL , modify COLUMN calendarorder integer NULL ;
/
Table : calendarobjects /
/
COLUMNS/
/
MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'int' [len] => '11' [auto_increment] => '1' /
/
VARDEF - id - ROW[name] => 'id' [type] => 'integer' [auto_increment] => '1' [dbType] => 'integer' [len] => '' [required] => 'true' /
/
MISMATCH WITH DATABASE - calendarid - ROW [name] => 'calendarid' [type] => 'int' [len] => '11' /
/
VARDEF - calendarid - ROW[name] => 'calendarid' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' /
/
MISMATCH WITH DATABASE - lastmodified - ROW [name] => 'lastmodified' [type] => 'int' [len] => '11' /
/
VARDEF - lastmodified - ROW[name] => 'lastmodified' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' /
/
INDEXES /
ALTER TABLE calendarobjects modify COLUMN id integer NOT NULL auto_increment, modify COLUMN calendarid integer NULL , modify COLUMN lastmodified integer NULL ;
/
Table : groupmembers /
/
COLUMNS/
/
MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'int' [len] => '11' [auto_increment] => '1' /
/
VARDEF - id - ROW[name] => 'id' [type] => 'integer' [auto_increment] => '1' [dbType] => 'integer' [len] => '' [required] => 'true' /
/
MISMATCH WITH DATABASE - principal_id - ROW [name] => 'principal_id' [type] => 'int' [len] => '11' /
/
VARDEF - principal_id - ROW[name] => 'principal_id' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' /
/
MISMATCH WITH DATABASE - member_id - ROW [name] => 'member_id' [type] => 'int' [len] => '11' /
/
VARDEF - member_id - ROW[name] => 'member_id' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' /
/
INDEXES /
ALTER TABLE groupmembers modify COLUMN id integer NOT NULL auto_increment, modify COLUMN principal_id integer NULL , modify COLUMN member_id integer NULL ;
/
Table : locks /
/
COLUMNS/
/
MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'int' [len] => '11' [auto_increment] => '1' /
/
VARDEF - id - ROW[name] => 'id' [type] => 'integer' [auto_increment] => '1' [dbType] => 'integer' [len] => '' [required] => 'true' /
/
MISMATCH WITH DATABASE - timeout - ROW [name] => 'timeout' [type] => 'int' [len] => '11' /
/
VARDEF - timeout - ROW[name] => 'timeout' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' /
/
MISMATCH WITH DATABASE - created - ROW [name] => 'created' [type] => 'int' [len] => '11' /
/
VARDEF - created - ROW[name] => 'created' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' /
/
MISMATCH WITH DATABASE - scope - ROW [name] => 'scope' [type] => 'int' [len] => '11' /
/
VARDEF - scope - ROW[name] => 'scope' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' /
/
MISMATCH WITH DATABASE - depth - ROW [name] => 'depth' [type] => 'int' [len] => '11' /
/
VARDEF - depth - ROW[name] => 'depth' [type] => 'integer' [dbType] => 'integer' [len] => '' [required] => '' /
/
INDEXES */
ALTER TABLE locks modify COLUMN id integer NOT NULL auto_increment, modify COLUMN timeout integer NULL , modify COLUMN created integer NULL , modify COLUMN scope integer NULL , modify COLUMN depth integer NULL ;

If I try to execute the query to the db it doesn't change, I always get this error every time I launch a Quick Repair.

I hope you can help me.
Best Regards.

  1. nordestinnovazione member avatar

    nordestinnovazione Purchased

    a year ago

    Could you please give me a feedback with this issue? Same problem on a customer instance.

  2. Opacus member avatar

    Opacus Provider

    a year ago

    Does your server have access to communicate with external servers? The licensing routine needs to validate with the Sugar Outfitters licensing server.

  3. nordestinnovazione member avatar

    nordestinnovazione Purchased

    a year ago

    I tried on a different server and I was able to go on with the activation process but the db error persists.
    Although everything seems ok on that instance from a functional point of view.
    So I tried to install on a third server (The production one) and I faced a new issue. User can only see their calendar but cannot edit/create events from thunderbird/android.
    This is a big issue for us because it is the main reason we were going to buy your solution.
    Can you please help us to solve it?

    We are on Suitecrm 7.1.4

  4. Opacus member avatar

    Opacus Provider

    a year ago

    Hi,

    So on the Production Server, the Calendar was viewable, but you could not make any changes to it?

    Which version of Thunderbird/Lightning were you using?

  5. Opacus member avatar

    Opacus Provider

    3 months ago

    Apologies for the delay. We have a new version now which may solve your problem.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "Fantastic Product. The support from Opacus was amazing. Basically for the price I could not think of a single thing that should/could be improved."

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.