Please help; Differences found between database and vardefs

[dekleinemedia]

Hi,

I have made a logic hook for my module "Acc_Accounts"
This logic_hook contains a auto_increment for my "acc_number".

When i want to repair and rebuild my custom module "Acc_Accounts" i get the following error;

/* Table : acc_accounts */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - acc_number - ROW [name] => 'acc_number' [type] => 'int' [len] => '4' [auto_increment] => '1' */
/* VARDEF - acc_number - ROW[required] => 'true' [name] => 'acc_number' [vname] => 'LBL_ACC_NUMBER' [type] => 'int' [massupdate] => '0' [duplicate_merge] => 'disabled' [dbType] => 'int' [len] => '11' */
/* INDEXES */
ALTER TABLE acc_accounts modify column acc_number int(11) NOT NULL ;

This is my "vardefs.php" file

 $dictionary['Acc_Accounts'] = array(
    'table'=>'acc_accounts',
    'audited'=>true,
    'fields'=>array (
  'acc_number' => 
  array (
    'required' => true,
    'name' => 'acc_number',
    'vname' => 'LBL_ACC_NUMBER',
    'type' => 'int',
    'massupdate' => 0,
    'duplicate_merge' => 'disabled',
  ), 
  

And in my screenshot you can see how i have set my DB so that the field "acc_number" auto increase (don't know if this is the right way to do it?)

What am i doing wrong?

Please help me ! Thankss

[SugarDev.net]

auto increment is something that Sugar should do for you. Do not make any changes to the database structure in phpmyadmin as Sugar will not tolerate it. Foei!

http://www.sugarcrm.com/wiki/index.php?title=Int

[dekleinemedia]

auto increment is something that Sugar should do for you. Do not make any changes to the database structure in phpmyadmin as Sugar will not tolerate it. Foei!

http://www.sugarcrm.com/wiki/index.php?title=Int

Okay, thanks it won't happen again