This is how the call trace looks like:
#0 DBQueryError->__construct(INSERT INTO fo_sharing_table (group_id,object_id) VALUES ('','36') ON DUPLICATE KEY UPDATE fo_sharing_table.group_id=fo_sharing_table.group_id;, 1366, Incorrect integer value: '' for column 'group_id' at row 1) called at [/var/www/htdocs/environment/library/database/adapters/AbstractDBAdapter.class.php:395]
#1 AbstractDBAdapter->prepareAndExecute(INSERT INTO fo_sharing_table (group_id,object_id) VALUES ('','36') ON DUPLICATE KEY UPDATE fo_sharing_table.group_id=fo_sharing_table.group_id;, ) called at [/var/www/htdocs/environment/library/database/adapters/AbstractDBAdapter.class.php:278]
#2 AbstractDBAdapter->execute(INSERT INTO fo_sharing_table (group_id,object_id) VALUES ('','36') ON DUPLICATE KEY UPDATE fo_sharing_table.group_id=fo_sharing_table.group_id;, ) called at [/var/www/htdocs/environment/library/database/DB.class.php:145]
#3 DB::execute(INSERT INTO fo_sharing_table (group_id,object_id) VALUES ('','36') ON DUPLICATE KEY UPDATE fo_sharing_table.group_id=fo_sharing_table.group_id;) called at [/var/www/htdocs/application/functions.php:1287]
#4 massiveInsert(fo_sharing_table, Array ([0] => group_id,[1] => object_id), Array ([0] => Array ([0] => ,[1] => 36)), 100, ON DUPLICATE KEY UPDATE fo_sharing_table.group_id=fo_sharing_table.group_id;) called at [/var/www/htdocs/application/models/sharing_table/SharingTables.class.php:25]
#5 SharingTables->populateGroups(Array ([0] => ), 36) called at [/var/www/htdocs/application/models/ContentDataObjects.class.php:1306]
#6 ContentDataObjects::addObjToSharingTable(36, 1, 0) called at [/var/www/htdocs/application/models/ContentDataObject.class.php:1373]
#7 ContentDataObject->addToSharingTable() called at [/var/www/htdocs/application/models/DimensionObject.class.php:44]
#8 DimensionObject->addToSharingTable() called at [/var/www/htdocs/application/controllers/MemberController.class.php:935]
#9 MemberController->saveMember(Array ([dimension_id] => 2,[name] => ffff,[object_type_id] => 1,[parent_member_id] => 0,[color] => 0,[description] => ), Member Object ([] => ,[] => Array (),[] => ,[] => 1,[] => ,[] => ,[] => 1,[] => Array ([dimension_id] => 2,[name] => ffff,[object_type_id] => 1,[parent_member_id] => 0,[color] => 0,[description] => ,[depth] => 1,[object_id] => 36,[id] => 31),[] => Array ([0] => dimension_id,[1] => name,[2] => object_type_id,[3] => parent_member_id,[4] => color,[5] => description,[6] => depth,[7] => object_id,[8] => id),[] => Array ([id] => ),[] => Members Object ([] => members,[] => Array (),[] => Member,[] => 1),[] => Array ([0] => id,[1] => created_on,[2] => created_by_id,[3] => updated_on,[4] => updated_by_id),[] => ,[] => ,[] => )) called at [/var/www/htdocs/application/controllers/MemberController.class.php:478]
#10 MemberController->add() called at [/var/www/htdocs/environment/classes/controller/Controller.class.php:76]
#11 Controller->execute(add) called at [/var/www/htdocs/environment/classes/controller/PageController.class.php:62]
#12 PageController->execute(add) called at [/var/www/htdocs/environment/classes/Env.class.php:129]
#13 Env::executeAction(member, add) called at [/var/www/htdocs/init.php:177]
#14 require(/var/www/htdocs/init.php) called at [/var/www/htdocs/index.php:7]
#15 require(/var/www/htdocs/index.php) called at [/var/www/htdocs/public/index.php:9]
Later edit:
I found that `fo_contact_member_permissions` was missing 'workspace' type_id permission and now i can add new workspaces. (hint from ContentDataObjects.class.php:1291)
So there is certainly something wrong happening during the install process.
What do you guys think?