#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.
9 years ago
9 years ago
9 years ago
8 years ago
7 years ago