by Opacus

The Opacus Activities Sync allows for a full bi-directional synchronisation between SugarCRM and your native calendar on your favorite device to synchronise calls, meetings and tasks. Works with Apple (iOS), Android, Outlook and Thunderbird/Lightning.

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#1862 - Problem when activate license

Closed Bug? created by nordestinnovazione 9 years 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. Opacus member avatar

    Opacus Provider

    9 years ago

  2. Opacus member avatar

    Opacus Provider

    8 years ago

  3. Opacus member avatar

    Opacus Provider

    7 years ago

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "The program was working great for about 2 months and then it quit working. We have attempted to contact them numerous times and no one is responding. ..." - senia

    Read More Reviews