New Fields Won't Save, MySQL ERROR 7

[joshr84]

I'm having issues with new fields in the contacts table. The fields appear in the edit and detail views but when I edit them the changes aren't saved. I tried doing a Quick Repair and Rebuild and got this script under "Differences found between database and vardefs":

/*Checking Custom Fields for module : Contacts */
/*MISSING IN DATABASE - emergency_contact_name_1_c -  ROW*/
alter table contacts_cstm add column emergency_contact_name_1_c varchar(255)  NULL ;
/*MISSING IN DATABASE - emergency_contact_name_2_c -  ROW*/
alter table contacts_cstm add column emergency_contact_name_2_c varchar(255)  NULL ;
/*MISSING IN DATABASE - emergency_contact_number_1_c -  ROW*/
alter table contacts_cstm add column emergency_contact_number_1_c varchar(255)  NULL ;
/*MISSING IN DATABASE - emergency_contact_number_2_c -  ROW*/
alter table contacts_cstm add column emergency_contact_number_2_c varchar(255)  NULL ;
/*MISSING IN DATABASE - birthday_c -  ROW*/
alter table contacts_cstm add column birthday_c date  NULL ;
/*MISSING IN DATABASE - employment_start_date_c -  ROW*/
alter table contacts_cstm add column employment_start_date_c date  NULL ;

I executed that and it said: Database failure. Please refer to sugarcrm.log for details.

Went to the log and found this line: 06/22/11 15:24:39 [3008][58b75b52-11c1-a219-5e04-4d92215b6e8f][FATAL] MySQL error 7: Error on rename of '.\sugarcrm\contacts_cstm.MYI' to '.\sugarcrm\#sql2-8ec-12.MYI' (Errcode: 13)

Any help understanding what could cause this would be GREATLY appreciated. Thanks!

[rafael.q.g@hotmail.com]

The error when you try to save the field is happens because the columns: emergency_contact_number_2_c, emergency_contact_number_1_c, and the others are not on table created contacts_cstm.

The error that happens on repair/rebuild could be some database/table limitation on your mysql server, like space, access rights, or some other limitation.

If reading the logs you are not able to solve the issue from repair/rebuild, a possible way to solve it (not very elegant) is to create this columns directly on your database. Then when you save these fields from your edit view, probably no error will happen anymore and the input values will be saved.

[kbrill]

The error 7 isnt the important part, it's the error 13 at the end

kbrill@kbrill-Latitude-D630:/opt/lampp$ bin/perror 13
OS error code  13: Permission denied

It means that mysql didnt have full permissions on that file. Check your permissions and you should be able to fix this one.

Once its fixed then run the repair and it will add the fields to the table.