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.
#1862 - Problem when activate license
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.
-
"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
10 years ago
Could you please give me a feedback with this issue? Same problem on a customer instance.
10 years ago
Does your server have access to communicate with external servers? The licensing routine needs to validate with the Sugar Outfitters licensing server.
10 years 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
10 years 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?
8 years ago
Apologies for the delay. We have a new version now which may solve your problem.