Local actors not added to the cache

[juliusknorr]

Steps to reproduce:

1. Create a new user
2. Login as that user
3. Open the social app

@daita Maybe we should try to avoid not null constraints for entries where it isn't really important to have a value?

An exception occurred while executing 'INSERT INTO `oc_social_cache_actors` (`id`, `account`, `type`, `local`, `following`, `followers`, `inbox`, `shared_inbox`, `outbox`, `featured`, `url`, `preferred_username`, `name`, `summary`, `public_key`, `source`, `creation`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin", "admin@local.dev.bitgrid.net", "Person", "1", "https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin\/following", "https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin\/followers", "https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin\/inbox", "https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/inbox", "https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin\/outbox", "", "https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin", "admin", "", "", "-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvHUFcWRKw4WaUYuz2OR2\nWX1kgJAqH8PylUnDzqeFDl7Qyled\/orowxGrbmQQP+xe6BqMZMOw9FJO5MWuNmdD\nB4YibM76XUVCrPY5VvuQysbbZlqO0Etp1oEKbfTK3RVITry5eEO4K9C9Iojo1O6m\ntygdKPgWVlWlwjByvN5wIw1Irb9kwl+yrN\/XxWSX6N2fXVgPl0mJQA58B6dmY\/DW\nqMX7h2JONpCpFHliAih6rykyUe+AWZ8fVH87R3A4+v9wK1zTpyXyBehYS2OYP6ik\nSOVkocYTSIr+bi6FwxzRVyAx5ltR5ZKByIDjCGoViISw\/J4Nh8VDWeqI4FU8wuBK\n1wIDAQAB\n-----END PUBLIC KEY-----\n", "{\"@context\":[\"https:\/\/www.w3.org\/ns\/activitystreams\",\"https:\/\/w3id.org\/security\/v1\"],\"id\":\"https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin\",\"type\":\"Person\",\"url\":\"https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin\",\"local\":true,\"aliases\":[\"https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin\",\"https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/users\/admin\"],\"preferredUsername\":\"admin\",\"name\":\"\",\"inbox\":\"https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin\/inbox\",\"outbox\":\"https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin\/outbox\",\"account\":\"admin@local.dev.bitgrid.net\",\"following\":\"https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin\/following\",\"followers\":\"https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin\/followers\",\"endpoints\":{\"sharedInbox\":\"https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/inbox\"},\"publicKey\":{\"id\":\"https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin#main-key\",\"owner\":\"https:\/\/local.dev.bitgrid.net\/index.php\/apps\/social\/@admin\",\"publicKeyPem\":\"-----BEGIN PUBLIC KEY-----\\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvHUFcWRKw4WaUYuz2OR2\\nWX1kgJAqH8PylUnDzqeFDl7Qyled\/orowxGrbmQQP+xe6BqMZMOw9FJO5MWuNmdD\\nB4YibM76XUVCrPY5VvuQysbbZlqO0Etp1oEKbfTK3RVITry5eEO4K9C9Iojo1O6m\\ntygdKPgWVlWlwjByvN5wIw1Irb9kwl+yrN\/XxWSX6N2fXVgPl0mJQA58B6dmY\/DW\\nqMX7h2JONpCpFHliAih6rykyUe+AWZ8fVH87R3A4+v9wK1zTpyXyBehYS2OYP6ik\\nSOVkocYTSIr+bi6FwxzRVyAx5ltR5ZKByIDjCGoViISw\/J4Nh8VDWeqI4FU8wuBK\\n1wIDAQAB\\n-----END PUBLIC KEY-----\\n\"}}", "2018-11-28 20:59:27"]:

SQLSTATE[HY000]: General error: 1364 Field 'icon_id' doesn't have a default value

[ArtificialOwl]

fixed ?

[juliusknorr]

Yes, works now. 👍