Cases can not be saved v. 6.1.2

[vuohe]

Hi!

I have a problem on creating cases. When trying to create case there is some kind of database failure and I don't know what to do but post the log for this so if anyone smarter than me can lead me to right track?

Log for the mentioned error:

Tue Feb 15 11:35:21 2011 [2747][1][FATAL] Query Failed:
INSERT into cases set id='5ac19cb0-bbcb-af21-edc6-4d5a48871100', name='Testi', date_entered='2011-02-15 09:35:21', date_modified='2011-02-15 09:35:21', modified_user_id='1', created_by='1', description=null, deleted='0', assigned_user_id='1', type='Product', status='Assigned', priority='P2', resolution=null, account_id='e9140d54-3b36-1361-be0a-4d53c302bb5a':
MySQL error 1062: Duplicate entry '0' for key 'casesnumk'

[vuohe]

I fount the problem, there is a case number -field missing in the case -form and therefore sugar tries to save null or zero value to database. However in the database this field is defined so that its not allowed to be empty and therefore saving fails.

Which do you think is the correct way to fix the problem. To set cases_num field in the database to autoincrement or try to add related field to cases -form?

[andopes]

It seems to be an issue on sequence at cases table. This sequence manage the case_number, which is an auto increment number.
Accomplish these tasks:
Repair cases table according to this doc.
Go to Admin -> Repair -> Repair Database

Cheers

[vuohe]

Thank You very much! This helped to fix the problem !