object-type resource - cant create new / broken after rename

[Matthias Busch]

if anyone else needs help with that... here is the sql command:

mysql -p
[enter root password]
use kolab;

dont just copy paste the UPDATEs, please verify you are indeed selecting 
the right id:

SELECT * FROM resource_types;

and read/understand the output...


to fix the items:

for single items (car, confroom, projector, tickets)

UPDATE `kolab`.`resource_types` SET `attributes` = 
'{"auto_form_fields":{"cn":{"data":["cn"]},"kolabtargetfolder":{"data":["cn"]},"mail":{"data":["cn"]}},"fields":{"objectclass":["top","kolabsharedfolder","mailrecipient"],"kolabfoldertype":["event"]},"form_fields":{"acl":{"type":"imap_acl","optional":true},"cn":[],"ou":{"type":"select"},"owner":{"type":"list","autocomplete":true,"optional":true}}}' 
WHERE `resource_types`.`id` =2;

for me, single items are from id=2 to id=5


fix the resource collection:

UPDATE `kolab`.`resource_types` SET `attributes` = 
'{"auto_form_fields":{"mail":{"data":["cn"]}},"fields":{"objectclass":["top","groupofuniquenames","kolabgroupofuniquenames"]},"form_fields":{"cn":[],"ou":{"type":"select"},"uniquemember":{"type":"list","autocomplete":true,"optional":true}}}' 
WHERE `resource_types`.`id` =1;


this worked for me. hope it helps...