I have two installations of Sugar Community Edition 5.2.0.i. One installation is local running under WampServer. The other is what I will call my soon to be production site that is hosted by MediaTemple. On my hosted installation I have problems when I click on Admin/Repair/Quick Repair And Rebuild/All Modules/ and then click on the repair button. After going through almost all the steps of the rebuild process near the very bottom I get the following message"
" Differences found between database and vardefs
The following script will sync the database structure with the structure defined in the vardefs. You have the option of exporting this script and then running it against your database using external database management tools, or to allow the administration module to run the script..........................................."
I then in the box have approximately 800 lines of messages that are along the lines of the following:
/* Table : relationships */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'varchar' [len] => '36' */
/* VARDEF - id - ROW[name] => 'id' [vname] => 'LBL_ID' [type] => 'char' [required] => 'true' [dbType] => 'id' [len] => '36' */
/* INDEXES */
ALTER TABLE relationships modify column id char(36) NOT NULL ;
/* Table : acl_roles */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - id - ROW [name] => 'id' [type] => 'varchar' [len] => '36' */
/* VARDEF - id - ROW[name] => 'id' [vname] => 'LBL_ID' [required] => 'true' [type] => 'char' [reportable] => '' [comment] => 'Unique identifier' [dbType] => 'id' [len] => '36' */
/*MISMATCH WITH DATABASE - date_entered - ROW [name] => 'date_entered' [type] => 'datetime' [default] => '0000-00-00 00:00:00' */.................................................. .................................................. .................................................. ............................................
At the bottom of the box I click on execute, it completes the process and says the following:
"Database tables are synced with vardefs"
I have exactly the same behavior the next time I run the repair process.
Is this something that I should be concerned about ??????
Please note that I do not get this behavior with all those errors on my local WampServer Installation.


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks