sql err deleting company account

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hello everybody,

im new to suiteCRM.

I try to delete complete company account an get that err msg in the log (i.e. deleting populated sample data)

[FATAL] Error updating table: cases: Query Failed: UPDATE cases
SET name=‘Warning message when using the wrong browser’,date_modified=‘2015-09-03 06:43:49’,modified_user_id=‘1’,created_by=‘1’,description=NULL,assigned_user_id=‘seed_max_id’,type=NULL,status=‘Pending Input’,priority=‘P3’,resolution=NULL,work_log=NULL,account_id=’’,state=‘Open’,contact_created_by_id=’’
WHERE cases.id = ‘dffedb7a-ab57-61b0-d452-55e5822c20b9’ AND deleted=0: MySQL error 1054: Unknown column ‘contact_created_by_id’ in ‘field list’

Accounts still active, nothing is deleted.

If there is a way to inactivate/hide accounts from regular users, that will be fine for me too.

any suggestions?

Thanks in advance

Lars

2

Run a Quick Repair & Rebuild in Admin -> Repair. Execute changes.

If you navigate to Admin -> Studio -> Cases -> Fields, are there any ‘null’ values?

Thanks,

Will.