Adding new custom field than i get error in repair database

[akkimca]

hi all
i m new in surgar crm and i m using sugarcrm 5.1
and i m geting error while adding a new custom field in sugar..

i do this steps:
=> define new field in module and than in Admin panel i do repair database than i got this error
/*MISSING INDEX IN DATABASE - idx_QUOTE_name -index ROW */
ALTER TABLE quotes add column q_name varchar(50) NULL , ADD INDEX idx_QUOTE_name (name);

so anyone tell me y this error is coming and what the steps to remove this type of error while doing repair database option ?????

thanx in advanced

[genius786]

Hello,

This error is produce due to change in your database side. So Please check it out ur vadefs combination with database. check you QUOTES table.



Best Regards,

[akkimca]

hi...

thanx.. my question is there is any functionality that directly add the change field in the database ???

if i dont want this type of error while running repair database so is there any method or code ????

pls help me...

thanx in advance