Differences found between database and vardefs (CE 5.2.0a)

[erop]

While playing with installing and uninstalling custom module I faced with a small issue. After Admin -> Repair -> Quick Repair and Rebuild I had Differences found between database and vardefs message and a script displayed. After executing script it returns Database tables are synced with vardefs. But some time ago I found that this sequence remained. Does this indicates existing problems with database or something like this? Should it be corrected? Which way?

[genius786]

Hi,

You can eliminate this difference by you self by adding some changes in vardefs then may be this problem is never come again.



Best regards,

[nvdp2002]

By addin what changes ?

[erop]

By addin what changes ?

You mean what custom module did I use?

[nvdp2002]

no sorry i was refering what genious786 said. I got a huge script after doing a repair. All about the vardefs. I tried running it but it could not run because of the indexing tables. Below is a small piece of the script. But at line 190 i get

Msg 5074, Level 16, State 1, Line 190
The index 'idx_lead_del_stat' is dependent on column 'status'.
Msg 4922, Level 16, State 9, Line 190
ALTER TABLE ALTER COLUMN status failed because one or more objects access this column.

at 190 in the scrips it says

ALTER TABLE leads ALTER COLUMN status nvarchar(100) NULL ;

/* Table : relationships */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - relationship_name - ROW [name] => 'relationship_name' [type] => 'nvarchar' [len] => '300' */
/* VARDEF - relationship_name - ROW[name] => 'relationship_name' [vname] => 'LBL_RELATIONSHIP_NAME' [type] => 'nvarchar' [required] => 'true' [len] => '150' [importable] => 'required' [dbType] => 'varchar' */
ALTER TABLE relationships ALTER COLUMN relationship_name nvarchar(150) NOT NULL ;

/*MISMATCH WITH DATABASE - lhs_module - ROW [name] => 'lhs_module' [type] => 'nvarchar' [len] => '200' */
/* VARDEF - lhs_module - ROW[name] => 'lhs_module' [vname] => 'LBL_LHS_MODULE' [type] => 'nvarchar' [required] => 'true' [len] => '100' [dbType] => 'varchar' */
ALTER TABLE relationships ALTER COLUMN lhs_module nvarchar(100) NOT NULL ;

/*MISMATCH WITH DATABASE - lhs_table - ROW [name] => 'lhs_table' [type] => 'nvarchar' [len] => '128' */
/* VARDEF - lhs_table - ROW[name] => 'lhs_table' [vname] => 'LBL_LHS_TABLE' [type] => 'nvarchar' [required] => 'true' [len] => '64' [dbType] => 'varchar' */
ALTER TABLE relationships ALTER COLUMN lhs_table nvarchar(64) NOT NULL ;

/*MISMATCH WITH DATABASE - lhs_key - ROW [name] => 'lhs_key' [type] => 'nvarchar' [len] => '128' */
/* VARDEF - lhs_key - ROW[name] => 'lhs_key' [vname] => 'LBL_LHS_KEY' [type] => 'nvarchar' [required] => 'true' [len] => '64' [dbType] => 'varchar' */
ALTER TABLE relationships ALTER COLUMN lhs_key nvarchar(64) NOT NULL

[nvdp2002]

What changes would one need to make to get rid of the vardif error that comes up everytime ?

[SugarDev.net]

I'm not familiar with nvarchar fields in SugarCRM. What's your sugar edition?

[nvdp2002]

same as you 5.2.a. Every time i run a quick repair and rebuild i get the messade that the vardef and something else dont match . then it gives me a script to run, which i run from within sugar. It then gives me the msg that verdeffs now match. but if i run the quick rebuild and repair again i get the same error message about the vardeffs not matching

[hmojica]

I'm having the exact same problem as well for the same version of Sugar (5.2.a). I would really appreciate any type of advice for this, because I can't seem to get these database mismatch messages to go away, and I would really appreciate it if I could.

[ssmeredith]

I just had this same problem in 5.1CE and I followed the same as above steps and then had the error on the home page, then blank page coming up for login. Can't get in now unless I SSH/Ftp. No help there...not uness I know how to fix.

I went in my hosting panel and did a db check and repair and that came back clean. So ......?

At first I had an error relating to:

Custom/Module/Leads/Ext/Vardefs/vardefs.ext.php

Then I ran the quick fix and repair and the error became:

Custom/Module/Users/Ext/Vardefs/vardefs.ext.php

I think the original error appearing on the front end was Teams...

So now site is down and I'm waitin' for the complainin' and rightly so.

Any help FAST would be greatly appreciated.

M