[2019-10-15 09:07:47] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'IDX_CREATED_BY_NUMBER' doesn't exist in table 'note'; GET /api/v1/Stream?after=2019-10-15+08%3A59%3A26&maxSize=&offset=0&orderBy=number&order=desc; line: 132, file: /home/site/wwwroot/application/Espo/ORM/DB/Mapper.php [] []
[2019-10-15 09:07:49] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'IDX_CREATED_BY_NUMBER' doesn't exist in table 'note'; GET /api/v1/Stream?after=2019-10-15+08%3A59%3A26&maxSize=&offset=0&orderBy=number&order=desc; line: 132, file: /home/site/wwwroot/application/Espo/ORM/DB/Mapper.php [] []
[2019-10-15 09:07:50] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'IDX_CREATED_BY_NUMBER' doesn't exist in table 'note'; GET /api/v1/Stream?after=2019-10-15+08%3A59%3A26&maxSize=&offset=0&orderBy=number&order=desc; line: 132, file: /home/site/wwwroot/application/Espo/ORM/DB/Mapper.php [] []
[2019-10-15 09:08:14] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'IDX_CREATED_BY_NUMBER' doesn't exist in table 'note'; GET /api/v1/Stream?after=2019-10-15+08%3A59%3A26&maxSize=&offset=0&orderBy=number&order=desc; line: 132, file: /home/site/wwwroot/application/Espo/ORM/DB/Mapper.php [] []
[2019-10-15 09:08:46] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'IDX_CREATED_BY_NUMBER' doesn't exist in table 'note'; GET /api/v1/Stream?after=2019-10-15+08%3A59%3A26&maxSize=&offset=0&orderBy=number&order=desc; line: 132, file: /home/site/wwwroot/application/Espo/ORM/DB/Mapper.php [] []
[2019-10-15 09:09:16] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'IDX_CREATED_BY_NUMBER' doesn't exist in table 'note'; GET /api/v1/Stream?after=2019-10-15+08%3A59%3A26&maxSize=&offset=0&orderBy=number&order=desc; line: 132, file: /home/site/wwwroot/application/Espo/ORM/DB/Mapper.php [] []
[2019-10-15 09:09:19] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'IDX_CREATED_BY_NUMBER' doesn't exist in table 'note'; GET /api/v1/Stream?after=2019-10-15+08%3A59%3A26&maxSize=&offset=0&orderBy=number&order=desc; line: 132, file: /home/site/wwwroot/application/Espo/ORM/DB/Mapper.php [] []
[2019-10-15 09:09:40] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'IDX_CREATED_BY_NUMBER' doesn't exist in table 'note'; GET /api/v1/Stream?after=2019-10-15+08%3A59%3A26&maxSize=&offset=0&orderBy=number&order=desc; line: 132, file: /home/site/wwwroot/application/Espo/ORM/DB/Mapper.php [] []
[2019-10-15 09:09:47] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'IDX_CREATED_BY_NUMBER' doesn't exist in table 'note'; GET /api/v1/Stream?after=2019-10-15+08%3A59%3A26&maxSize=&offset=0&orderBy=number&order=desc; line: 132, file: /home/site/wwwroot/application/Espo/ORM/DB/Mapper.php [] []
[2019-10-15 09:10:03] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'IDX_CREATED_BY_NUMBER' doesn't exist in table 'note'; GET /api/v1/Stream?after=2019-10-15+08%3A59%3A26&maxSize=&offset=0&orderBy=number&order=desc; line: 132, file: /home/site/wwwroot/application/Espo/ORM/DB/Mapper.php [] []
[2019-10-15 09:10:14] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'IDX_CREATED_BY_NUMBER' doesn't exist in table 'note'; GET /api/v1/Stream?after=2019-10-15+08%3A59%3A26&maxSize=&offset=0&orderBy=number&order=desc; line: 132, file: /home/site/wwwroot/application/Espo/ORM/DB/Mapper.php [] []
[2019-10-15 09:10:18] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 1176 Key 'IDX_CREATED_BY_NUMBER' doesn't exist in table 'note'; GET /api/v1/Stream?after=2019-10-15+08%3A59%3A26&maxSize=&offset=0&orderBy=number&order=desc; line: 132, file: /home/site/wwwroot/application/Espo/ORM/DB/Mapper.php [] []
[2019-10-15 09:10:48] Espo.WARNING: E_WARNING: Error while sending QUERY packet. PID=431 {"code":2,"message":"Error while sending QUERY packet. PID=431","file":"/home/site/wwwroot/application/Espo/ORM/DB/Mapper.php","line":82,"context":{"entity":"[object] (Espo\\Entities\\User: {\"id\":null,\"fields\":{\"id\":{\"dbType\":\"varchar\",\"len\":24,\"type\":\"id\"},\"name\":{\"type\":\"varchar\",\"notStorable\":true,\"select\":\"TRIM(CONCAT(IFNULL(user.first_name, ''), ' ', IFNULL(user.last_name, '')))\",\"where\":{\"LIKE\":\"(user.first_name LIKE {value} OR user.last_name LIKE {value} OR CONCAT(user.first_name, ' ', user.last_name) LIKE {value} OR CONCAT(user.last_name, ' ', user.first_name) LIKE {value})\",\"=\":\"(user.first_name = {value} OR user.last_name = {value} OR CONCAT(user.first_name, ' ', user.last_name) = {value} OR CONCAT(user.last_name, ' ', user.first_name) = {value})\"},\"orderBy\":\"user.first_name {direction}, user.last_name\"},\"deleted\":{\"type\":\"bool\",\"default\":false},\"isAdmin\":{\"type\":\"bool\",\"notNull\":true,\"fieldType\":\"bool\",\"default\":false},\"userName\":{\"type\":\"varchar\",\"len\":50,\"fieldType\":\"varchar\"},\"type\":{\"type\":\"varchar\",\"len\":24,\"index\":true,\"default\":\"regular\",\"fieldType\":\"varchar\"},\"password\":{\"type\":\"password\",\"len\":150,\"fieldType\":\"password\"},\"passwordConfirm\":{\"type\":\"password\",\"len\":150,\"notStorable\":true,\"fieldType\":\"password\"},\"authMethod\":{\"type\":\"varchar\",\"len\":24,\"fieldType\":\"varchar\"},\"apiKey\":{\"type\":\"varchar\",\"len\":100,\"fieldType\":\"varchar\"},\"secretKey\":{\"type\":\"varchar\",\"len\":100,\"notStorable\":true,\"fieldType\":\"varchar\"},\"salutationName\":{\"type\":\"varchar\",\"fieldType\":\"varchar\",\"len\":255},\"firstName\":{\"type\":\"varchar\",\"len\":100,\"default\":\"\",\"fieldType\":\"varchar\"},\"lastName\":{\"type\":\"varchar\",\"len\":100,\"default\":\"\",\"fieldType\":\"varchar\"},\"isActive\":{\"type\":\"bool\",\"notNull\":true,\"default\":true,\"fieldType\":\"bool\"},\"isPortalUser\":{\"type\":\"bool\",\"notNull\":true,\"fieldType\":\"bool\",\"default\":false},\"isSuperAdmin\":{\"type\":\"bool\",\"notNull\":true,\"default\":false,\"fieldType\":\"bool\"},\"title\":{\"type\":\"varchar\",\"len\":100,\"fieldType\":\"varchar\"},\"position\":{\"type\":\"varchar\",\"len\":100,\"notStorable\":true,\"where\":{\"LIKE\":{\"leftJoins\":[[\"teams\",\"teamsPosition\"]],\"sql\":\"teamsPositionMiddle.role LIKE {value}\",\"distinct\":true},\"=\":{\"leftJoins\":[[\"teams\",\"teamsPosition\"]],\"sql\":\"teamsPositionMiddle.role = {value}\",\"distinct\":true},\"<>\":{\"leftJoins\":[[\"teams\",\"teamsPosition\"]],\"sql\":\"teamsPositionMiddle.role <> {value}\",\"distinct\":true},\"IS NULL\":{\"leftJoins\":[[\"teams\",\"teamsPosition\"]],\"sql\":\"teamsPositionMiddle.role IS NULL\",\"distinct\":true},\"IS NOT NULL\":{\"leftJoins\":[[\"teams\",\"teamsPosition\"]],\"sql\":\"teamsPositionMiddle.role IS NOT NULL\",\"distinct\":true}},\"fieldType\":\"varchar\"},\"emailAddress\":{\"type\":\"email\",\"notStorable\":true,\"fieldType\":\"email\",\"select\":{\"sql\":\"emailAddresses.name\",\"leftJoins\":[[\"emailAddresses\",\"emailAddresses\",{\"primary\":1}]]},\"selectForeign\":{\"sql\":\"emailAddressUserForeign.name\",\"leftJoins\":[[\"EntityEmailAddress\",\"emailAddressUserForeignMiddle\",{\"emailAddressUserForeignMiddle.entityId:\":\"{alias}.id\",\"emailAddressUserForeignMiddle.primary\":1}],[\"EmailAddress\",\"emailAddressUserForeign\",{\"emailAddressUserForeign.id:\":\"emailAddressUserForeignMiddle.emailAddressId\"}]]},\"where\":{\"LIKE\":\"user.id IN (\\n                                SELECT entity_id\\n                                FROM entity_email_address\\n                                JOIN email_address ON email_address.id = entity_email_address.email_address_id\\n                                WHERE\\n                                    entity_email_address.deleted = 0 AND entity_email_address.entity_type = 'User' AND\\n                                    email_address.deleted = 0 AND email_address.lower LIKE {value}\\n                            )\",\"=\":{\"leftJoins\":[[\"emailAddresses\",\"emailAddressesMultiple\"]],\"sql\":\"emailAddressesMultiple.lower = {value}\",\"distinct\":true},\"<>\":{\"leftJoins\":[[\"emailAddresses\",\"emailAddressesMultiple\"]],\"sql\":\"emailAddressesMultiple.lower <> {value}\",\"distinct\":true},\"IN\":{\"leftJoins\":[[\"emailAddresses\",\"emailAddressesMultiple\"]],\"sql\":\"emailAddressesMultiple.lower IN {value}\",\"distinct\":true},\"NOT IN\":{\"leftJoins\":[[\"emailAddresses\",\"emailAddressesMultiple\"]],\"sql\":\"emailAddressesMultiple.lower NOT IN {value}\",\"distinct\":true},\"IS NULL\":{\"leftJoins\":[[\"emailAddresses\",\"emailAddressesMultiple\"]],\"sql\":\"emailAddressesMultiple.lower IS NULL\",\"distinct\":true},\"IS NOT NULL\":{\"leftJoins\":[[\"emailAddresses\",\"emailAddressesMultiple\"]],\"sql\":\"emailAddressesMultiple.lower IS NOT NULL\",\"distinct\":true}},\"orderBy\":{\"sql\":\"emailAddresses.lower {direction}\",\"leftJoins\":[[\"emailAddresses\",\"emailAddresses\",{\"primary\":1}]]}},\"phoneNumber\":{\"type\":\"phone\",\"notStorable\":true,\"fieldType\":\"phone\",\"select\":{\"sql\":\"phoneNumbers.name\",\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbers\",{\"primary\":1}]]},\"selectForeign\":{\"sql\":\"phoneNumberUserForeign.name\",\"leftJoins\":[[\"EntityPhoneNumber\",\"phoneNumberUserForeignMiddle\",{\"phoneNumberUserForeignMiddle.entityId:\":\"{alias}.id\",\"phoneNumberUserForeignMiddle.primary\":1}],[\"PhoneNumber\",\"phoneNumberUserForeign\",{\"phoneNumberUserForeign.id:\":\"phoneNumberUserForeignMiddle.phoneNumberId\"}]]},\"where\":{\"LIKE\":\"user.id IN (\\n                                SELECT entity_id\\n                                FROM entity_phone_number\\n                                JOIN phone_number ON phone_number.id = entity_phone_number.phone_number_id\\n                                WHERE\\n                                    entity_phone_number.deleted = 0 AND entity_phone_number.entity_type = 'User' AND\\n                                    phone_number.deleted = 0 AND phone_number.name LIKE {value}\\n                            )\",\"=\":{\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbersMultiple\"]],\"sql\":\"phoneNumbersMultiple.name = {value}\",\"distinct\":true},\"<>\":{\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbersMultiple\"]],\"sql\":\"phoneNumbersMultiple.name <> {value}\",\"distinct\":true},\"IN\":{\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbersMultiple\"]],\"sql\":\"phoneNumbersMultiple.name IN {value}\",\"distinct\":true},\"NOT IN\":{\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbersMultiple\"]],\"sql\":\"phoneNumbersMultiple.name NOT IN {value}\",\"distinct\":true},\"IS NULL\":{\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbersMultiple\"]],\"sql\":\"phoneNumbersMultiple.name IS NULL\",\"distinct\":true},\"IS NOT NULL\":{\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbersMultiple\"]],\"sql\":\"phoneNumbersMultiple.name IS NOT NULL\",\"distinct\":true}},\"orderBy\":{\"sql\":\"phoneNumbers.name {direction}\",\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbers\",{\"primary\":1}]]}},\"token\":{\"type\":\"varchar\",\"notStorable\":true,\"fieldType\":\"varchar\",\"len\":255},\"authTokenId\":{\"type\":\"varchar\",\"notStorable\":true,\"fieldType\":\"varchar\",\"len\":255},\"authLogRecordId\":{\"type\":\"varchar\",\"notStorable\":true,\"fieldType\":\"varchar\",\"len\":255},\"ipAddress\":{\"type\":\"varchar\",\"notStorable\":true,\"fieldType\":\"varchar\",\"len\":255},\"acceptanceStatus\":{\"type\":\"varchar\",\"notExportable\":true,\"notStorable\":true,\"fieldType\":\"varchar\",\"len\":255},\"acceptanceStatusMeetings\":{\"type\":\"varchar\",\"notExportable\":true,\"notStorable\":true,\"relation\":\"meetings\",\"fieldType\":\"varchar\",\"len\":255},\"acceptanceStatusCalls\":{\"type\":\"varchar\",\"notExportable\":true,\"notStorable\":true,\"relation\":\"calls\",\"fieldType\":\"varchar\",\"len\":255},\"teamRole\":{\"type\":\"varchar\",\"notStorable\":true,\"fieldType\":\"varchar\",\"len\":255},\"sendAccessInfo\":{\"type\":\"bool\",\"notNull\":true,\"notStorable\":true,\"fieldType\":\"bool\",\"default\":false},\"gender\":{\"type\":\"varchar\",\"default\":\"\",\"fieldType\":\"varchar\",\"len\":255},\"createdAt\":{\"type\":\"datetime\",\"notNull\":false,\"fieldType\":\"datetime\"},\"modifiedAt\":{\"type\":\"datetime\",\"notNull\":false,\"fieldType\":\"datetime\"},\"lastAccess\":{\"type\":\"datetime\",\"notNull\":false,\"notStorable\":true,\"fieldType\":\"datetime\"},\"emailAddressIsOptedOut\":{\"type\":\"bool\",\"notNull\":true,\"notStorable\":true,\"fieldType\":\"bool\",\"select\":\"emailAddresses.opt_out\",\"where\":{\"= TRUE\":{\"sql\":\"emailAddresses.opt_out = true AND emailAddresses.opt_out IS NOT NULL\",\"leftJoins\":[[\"emailAddresses\",\"emailAddresses\",{\"primary\":1}]]},\"= FALSE\":{\"sql\":\"emailAddresses.opt_out = false OR emailAddresses.opt_out IS NULL\",\"leftJoins\":[[\"emailAddresses\",\"emailAddresses\",{\"primary\":1}]]}},\"orderBy\":\"emailAddresses.opt_out {direction}\",\"default\":false},\"phoneNumberIsOptedOut\":{\"type\":\"bool\",\"notNull\":true,\"notStorable\":true,\"fieldType\":\"bool\",\"select\":\"phoneNumbers.opt_out\",\"where\":{\"= TRUE\":{\"sql\":\"phoneNumbers.opt_out = true AND phoneNumbers.opt_out IS NOT NULL\",\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbers\",{\"primary\":1}]]},\"= FALSE\":{\"sql\":\"phoneNumbers.opt_out = false OR phoneNumbers.opt_out IS NULL\",\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbers\",{\"primary\":1}]]}},\"orderBy\":\"phoneNumbers.opt_out {direction}\",\"default\":false},\"emailAddressData\":{\"type\":\"text\",\"notStorable\":true,\"notExportable\":true},\"phoneNumberData\":{\"type\":\"text\",\"notStorable\":true,\"notExportable\":true},\"phoneNumberNumeric\":{\"type\":\"varchar\",\"notStorable\":true,\"notExportable\":true,\"where\":{\"LIKE\":\"user.id IN (\\n                                SELECT entity_id\\n                                FROM entity_phone_number\\n                                JOIN phone_number ON phone_number.id = entity_phone_number.phone_number_id\\n                                WHERE\\n                                    entity_phone_number.deleted = 0 AND entity_phone_number.entity_type = 'User' AND\\n                                    phone_number.deleted = 0 AND phone_number.numeric LIKE {value}\\n                            )\",\"=\":{\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbersNumericMultiple\"]],\"sql\":\"phoneNumbersNumericMultiple.numeric = {value}\",\"distinct\":true},\"<>\":{\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbersNumericMultiple\"]],\"sql\":\"phoneNumbersNumericMultiple.numeric <> {value}\",\"distinct\":true},\"IN\":{\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbersNumericMultiple\"]],\"sql\":\"phoneNumbersNumericMultiple.numeric IN {value}\",\"distinct\":true},\"NOT IN\":{\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbersNumericMultiple\"]],\"sql\":\"phoneNumbersNumericMultiple.numeric NOT IN {value}\",\"distinct\":true},\"IS NULL\":{\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbersNumericMultiple\"]],\"sql\":\"phoneNumbersNumericMultiple.numeric IS NULL\",\"distinct\":true},\"IS NOT NULL\":{\"leftJoins\":[[\"phoneNumbers\",\"phoneNumbersNumericMultiple\"]],\"sql\":\"phoneNumbersNumericMultiple.numeric IS NOT NULL\",\"distinct\":true}}},\"defaultTeamId\":{\"dbType\":\"varchar\",\"len\":24,\"type\":\"foreignId\",\"index\":true,\"attributeRole\":\"id\",\"fieldType\":\"link\",\"notNull\":false},\"defaultTeamName\":{\"type\":\"foreign\",\"notStorable\":false,\"attributeRole\":\"name\",\"fieldType\":\"link\",\"relation\":\"defaultTeam\",\"foreign\":\"name\"},\"teamsIds\":{\"type\":\"jsonArray\",\"notStorable\":true,\"isLinkMultipleIdList\":true,\"relation\":\"teams\",\"isUnordered\":true,\"attributeRole\":\"idList\",\"fieldType\":\"linkMultiple\",\"isLinkStub\":false},\"teamsNames\":{\"type\":\"jsonObject\",\"notStorable\":true,\"isLinkMultipleNameMap\":true,\"attributeRole\":\"nameMap\",\"fieldType\":\"linkMultiple\",\"isLinkStub\":false},\"teamsColumns\":{\"type\":\"jsonObject\",\"notStorable\":true,\"columns\":{\"role\":\"userRole\"},\"attributeRole\":\"columnsMap\"},\"rolesIds\":{\"type\":\"jsonArray\",\"notStorable\":true,\"isLinkMultipleIdList\":true,\"relation\":\"roles\",\"isUnordered\":true,\"attributeRole\":\"idList\",\"fieldType\":\"linkMultiple\",\"isLinkStub\":false},\"rolesNames\":{\"type\":\"jsonObject\",\"notStorable\":true,\"isLinkMultipleNameMap\":true,\"attributeRole\":\"nameMap\",\"fieldType\":\"linkMultiple\",\"isLinkStub\":false},\"portalsIds\":{\"type\":\"jsonArray\",\"notStorable\":true,\"isLinkMultipleIdList\":true,\"relation\":\"portals\",\"isUnordered\":true,\"attributeRole\":\"idList\",\"fieldType\":\"linkMultiple\",\"isLinkStub\":false},\"portalsNames\":{\"type\":\"jsonObject\",\"notStorable\":true,\"isLinkMultipleNameMap\":true,\"attributeRole\":\"nameMap\",\"fieldType\":\"linkMultiple\",\"isLinkStub\":false},\"portalRolesIds\":{\"type\":\"jsonArray\",\"notStorable\":true,\"isLinkMultipleIdList\":true,\"relation\":\"portalRoles\",\"isUnordered\":true,\"attributeRole\":\"idList\",\"fieldType\":\"linkMultiple\",\"isLinkStub\":false},\"portalRolesNames\":{\"type\":\"jsonObject\",\"notStorable\":true,\"isLinkMultipleNameMap\":true,\"attributeRole\":\"nameMap\",\"fieldType\":\"linkMultiple\",\"isLinkStub\":false},\"contactId\":{\"dbType\":\"varchar\",\"len\":24,\"type\":\"foreignId\",\"index\":true,\"attributeRole\":\"id\",\"fieldType\":\"link\",\"notNull\":false},\"contactName\":{\"type\":\"foreign\",\"notStorable\":false,\"attributeRole\":\"name\",\"fieldType\":\"link\",\"relation\":\"contact\",\"foreign\":[\"firstName\",\" \",\"lastName\"]},\"accountsIds\":{\"type\":\"jsonArray\",\"notStorable\":true,\"isLinkMultipleIdList\":true,\"relation\":\"accounts\",\"isUnordered\":true,\"attributeRole\":\"idList\",\"fieldType\":\"linkMultiple\",\"isLinkStub\":false},\"accountsNames\":{\"type\":\"jsonObject\",\"notStorable\":true,\"isLinkMultipleNameMap\":true,\"attributeRole\":\"nameMap\",\"fieldType\":\"linkMultiple\",\"isLinkStub\":false},\"accountId\":{\"dbType\":\"varchar\",\"len\":24,\"type\":\"foreignId\",\"index\":\"account\",\"attributeRole\":\"id\",\"fieldType\":\"link\",\"notStorable\":true,\"notNull\":false},\"accountName\":{\"type\":\"varchar\",\"notStorable\":true,\"attributeRole\":\"name\",\"fieldType\":\"link\"},\"portalId\":{\"dbType\":\"varchar\",\"len\":24,\"type\":\"foreignId\",\"index\":\"portal\",\"attributeRole\":\"id\",\"fieldType\":\"link\",\"notStorable\":true,\"notNull\":false},\"portalName\":{\"type\":\"varchar\",\"notStorable\":true,\"attributeRole\":\"name\",\"fieldType\":\"link\"},\"avatarId\":{\"dbType\":\"varchar\",\"len\":24,\"type\":\"foreignId\",\"index\":false,\"notNull\":false},\"avatarName\":{\"type\":\"foreign\",\"relation\":\"avatar\",\"foreign\":\"name\"},\"createdById\":{\"dbType\":\"varchar\",\"len\":24,\"type\":\"foreignId\",\"index\":true,\"attributeRole\":\"id\",\"fieldType\":\"link\",\"notNull\":false},\"createdByName\":{\"type\":\"foreign\",\"notStorable\":false,\"attributeRole\":\"name\",\"fieldType\":\"link\",\"relation\":\"createdBy\",\"foreign\":[\"firstName\",\" \",\"lastName\"]},\"dashboardTemplateId\":{\"dbType\":\"varchar\",\"len\":24,\"type\":\"foreignId\",\"index\":true,\"attributeRole\":\"id\",\"fieldType\":\"link\",\"notNull\":false},\"dashboardTemplateName\":{\"type\":\"foreign\",\"notStorable\":false,\"attributeRole\":\"name\",\"fieldType\":\"link\",\"relation\":\"dashboardTemplate\",\"foreign\":\"name\"},\"reportEmailSendingIds\":{\"type\":\"jsonArray\",\"notStorable\":true,\"isLinkStub\":true},\"reportEmailSendingNames\":{\"type\":\"jsonObject\",\"notStorable\":true,\"isLinkStub\":true},\"targetListsIds\":{\"type\":\"jsonArray\",\"notStorable\":true,\"isLinkStub\":true},\"targetListsNames\":{\"type\":\"jsonObject\",\"notStorable\":true,\"isLinkStub\":true},\"tasksIds\":{\"type\":\"jsonArray\",\"notStorable\":true,\"isLinkStub\":true},\"tasksNames\":{\"type\":\"jsonObject\",\"notStorable\":true,\"isLinkStub\":true},\"notesIds\":{\"type\":\"jsonArray\",\"notStorable\":true,\"isLinkStub\":true},\"notesNames\":{\"type\":\"jsonObject\",\"notStorable\":true,\"isLinkStub\":true},\"emailsIds\":{\"type\":\"jsonArray\",\"notStorable\":true,\"isLinkStub\":true},\"emailsNames\":{\"type\":\"jsonObject\",\"notStorable\":true,\"isLinkStub\":true},\"callsIds\":{\"type\":\"jsonArray\",\"notStorable\":true,\"isLinkStub\":true},\"callsNames\":{\"type\":\"jsonObject\",\"notStorable\":true,\"isLinkStub\":true},\"meetingsIds\":{\"type\":\"jsonArray\",\"notStorable\":true,\"isLinkStub\":true},\"meetingsNames\":{\"type\":\"jsonObject\",\"notStorable\":true,\"isLinkStub\":true},\"preferencesId\":{\"type\":\"varchar\",\"notStorable\":true},\"preferencesName\":{\"type\":\"varchar\",\"notStorable\":true}},\"relations\":{\"emailAddresses\":{\"type\":\"manyMany\",\"entity\":\"EmailAddress\",\"relationName\":\"entityEmailAddress\",\"midKeys\":[\"entityId\",\"emailAddressId\"],\"conditions\":{\"entityType\":\"User\"},\"additionalColumns\":{\"entityType\":{\"type\":\"varchar\",\"len\":100},\"primary\":{\"type\":\"bool\",\"default\":false}}},\"phoneNumbers\":{\"type\":\"manyMany\",\"entity\":\"PhoneNumber\",\"relationName\":\"entityPhoneNumber\",\"midKeys\":[\"entityId\",\"phoneNumberId\"],\"conditions\":{\"entityType\":\"User\"},\"additionalColumns\":{\"entityType\":{\"type\":\"varchar\",\"len\":100},\"primary\":{\"type\":\"bool\",\"default\":false}}},\"avatar\":{\"type\":\"belongsTo\",\"entity\":\"Attachment\",\"key\":\"avatarId\",\"foreignKey\":\"id\",\"foreign\":null},\"reportEmailSending\":{\"type\":\"manyMany\",\"entity\":\"Report\",\"relationName\":\"reportUser\",\"key\":\"id\",\"foreignKey\":\"id\",\"midKeys\":[\"userId\",\"reportId\"],\"foreign\":\"emailSendingUsers\"},\"targetLists\":{\"type\":\"manyMany\",\"entity\":\"TargetList\",\"relationName\":\"targetListUser\",\"key\":\"id\",\"foreignKey\":\"id\",\"midKeys\":[\"userId\",\"targetListId\"],\"foreign\":\"users\",\"additionalColumns\":{\"optedOut\":{\"type\":\"bool\"}}},\"tasks\":{\"type\":\"hasMany\",\"entity\":\"Task\",\"foreignKey\":\"assignedUserId\",\"foreign\":\"assignedUser\"},\"accounts\":{\"type\":\"manyMany\",\"entity\":\"Account\",\"relationName\":\"AccountPortalUser\",\"key\":\"id\",\"foreignKey\":\"id\",\"midKeys\":[\"userId\",\"accountId\"],\"foreign\":\"portalUsers\"},\"contact\":{\"type\":\"belongsTo\",\"entity\":\"Contact\",\"key\":\"contactId\",\"foreignKey\":\"id\",\"foreign\":\"portalUser\"},\"notes\":{\"type\":\"manyMany\",\"entity\":\"Note\",\"relationName\":\"noteUser\",\"key\":\"id\",\"foreignKey\":\"id\",\"midKeys\":[\"userId\",\"noteId\"],\"foreign\":\"users\"},\"emails\":{\"type\":\"manyMany\",\"entity\":\"Email\",\"relationName\":\"emailUser\",\"key\":\"id\",\"foreignKey\":\"id\",\"midKeys\":[\"userId\",\"emailId\"],\"foreign\":\"users\",\"additionalColumns\":{\"isRead\":{\"type\":\"bool\",\"default\":false},\"isImportant\":{\"type\":\"bool\",\"default\":false},\"inTrash\":{\"type\":\"bool\",\"default\":false},\"folderId\":{\"type\":\"varchar\",\"default\":null,\"maxLength\":24}}},\"calls\":{\"type\":\"manyMany\",\"entity\":\"Call\",\"relationName\":\"callUser\",\"key\":\"id\",\"foreignKey\":\"id\",\"midKeys\":[\"userId\",\"callId\"],\"foreign\":\"users\",\"additionalColumns\":{\"status\":{\"type\":\"varchar\",\"len\":\"36\",\"default\":\"None\"}}},\"meetings\":{\"type\":\"manyMany\",\"entity\":\"Meeting\",\"relationName\":\"meetingUser\",\"key\":\"id\",\"foreignKey\":\"id\",\"midKeys\":[\"userId\",\"meetingId\"],\"foreign\":\"users\",\"additionalColumns\":{\"status\":{\"type\":\"varchar\",\"len\":\"36\",\"default\":\"None\"}}},\"preferences\":{\"type\":\"hasOne\",\"entity\":\"Preferences\",\"foreignKey\":\"id\",\"foreign\":null},\"dashboardTemplate\":{\"type\":\"belongsTo\",\"entity\":\"DashboardTemplate\",\"key\":\"dashboardTemplateId\",\"foreignKey\":\"id\",\"foreign\":null},\"portalRoles\":{\"type\":\"manyMany\",\"entity\":\"PortalRole\",\"relationName\":\"portalRoleUser\",\"key\":\"id\",\"foreignKey\":\"id\",\"midKeys\":[\"userId\",\"portalRoleId\"],\"foreign\":\"users\"},\"portals\":{\"type\":\"manyMany\",\"entity\":\"Portal\",\"relationName\":\"portalUser\",\"key\":\"id\",\"foreignKey\":\"id\",\"midKeys\":[\"userId\",\"portalId\"],\"foreign\":\"users\"},\"roles\":{\"type\":\"manyMany\",\"entity\":\"Role\",\"relationName\":\"roleUser\",\"key\":\"id\",\"foreignKey\":\"id\",\"midKeys\":[\"userId\",\"roleId\"],\"foreign\":\"users\"},\"createdBy\":{\"type\":\"belongsTo\",\"entity\":\"User\",\"key\":\"createdById\",\"foreignKey\":\"id\",\"foreign\":null},\"teams\":{\"type\":\"manyMany\",\"entity\":\"Team\",\"relationName\":\"teamUser\",\"key\":\"id\",\"foreignKey\":\"id\",\"midKeys\":[\"userId\",\"teamId\"],\"foreign\":\"users\",\"additionalColumns\":{\"role\":{\"type\":\"varchar\",\"len\":100}}},\"defaultTeam\":{\"type\":\"belongsTo\",\"entity\":\"Team\",\"key\":\"defaultTeamId\",\"foreignKey\":\"id\",\"foreign\":null}}})","id":"system","params":{"whereClause":{"id":"system"}},"sql":"SELECT user.id AS `id`, TRIM(CONCAT(IFNULL(user.first_name, ''), ' ', IFNULL(user.last_name, ''))) AS `name`, user.deleted AS `deleted`, user.is_admin AS `isAdmin`, user.user_name AS `userName`, user.type AS `type`, user.password AS `password`, user.auth_method AS `authMethod`, user.api_key AS `apiKey`, user.salutation_name AS `salutationName`, user.first_name AS `firstName`, user.last_name AS `lastName`, user.is_active AS `isActive`, user.is_portal_user AS `isPortalUser`, user.is_super_admin AS `isSuperAdmin`, user.title AS `title`, emailAddresses.name AS `emailAddress`, phoneNumbers.name AS `phoneNumber`, user.gender AS `gender`, user.created_at AS `createdAt`, user.modified_at AS `modifiedAt`, emailAddresses.opt_out AS `emailAddressIsOptedOut`, phoneNumbers.opt_out AS `phoneNumberIsOptedOut`, user.default_team_id AS `defaultTeamId`, defaultTeam.name AS `defaultTeamName`, user.contact_id AS `contactId`, TRIM(CONCAT(contact.first_name, ' ', contact.last_name)) AS `contactName`, user.avatar_id AS `avatarId`, avatar.name AS `avatarName`, user.created_by_id AS `createdById`, TRIM(CONCAT(createdBy.first_name, ' ', createdBy.last_name)) AS `createdByName` FROM `user` LEFT JOIN `attachment` AS `avatar` ON user.avatar_id = avatar.id LEFT JOIN `contact` AS `contact` ON user.contact_id = contact.id LEFT JOIN `user` AS `createdBy` ON user.created_by_id = createdBy.id LEFT JOIN `team` AS `defaultTeam` ON user.default_team_id = defaultTeam.id LEFT JOIN `entity_email_address` AS `emailAddressesMiddle` ON user.id = emailAddressesMiddle.entity_id AND emailAddressesMiddle.deleted = '0' AND emailAddressesMiddle.primary = '1' AND emailAddressesMiddle.entity_type = 'User' LEFT JOIN `email_address` AS `emailAddresses` ON emailAddresses.id = emailAddressesMiddle.email_address_id AND emailAddresses.deleted = '0' LEFT JOIN `entity_phone_number` AS `phoneNumbersMiddle` ON user.id = phoneNumbersMiddle.entity_id AND phoneNumbersMiddle.deleted = '0' AND phoneNumbersMiddle.primary = '1' AND phoneNumbersMiddle.entity_type = 'User' LEFT JOIN `phone_number` AS `phoneNumbers` ON phoneNumbers.id = phoneNumbersMiddle.phone_number_id AND phoneNumbers.deleted = '0' WHERE user.id = 'system' AND user.deleted = '0'"}} []
[2019-10-15 09:10:48] Espo.ERROR: Fault to rebuild database schema. Details: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away [] []
[2019-10-15 09:10:48] Espo.ERROR: Database rebuild failure, details: Error while rebuilding database. See log file for details.. [] []
[2019-10-15 09:11:39] Espo.WARNING: E_WARNING: Declaration of Espo\Modules\Crm\Services\Opportunity::massConvertCurrency($field, $targetCurrency, $params, $baseCurrency, $rates) should be compatible with Espo\Services\Record::massConvertCurrency($params, string $targetCurrency, string $baseCurrency, $rates, ?array $fieldList = NULL) {"code":2,"message":"Declaration of Espo\\Modules\\Crm\\Services\\Opportunity::massConvertCurrency($field, $targetCurrency, $params, $baseCurrency, $rates) should be compatible with Espo\\Services\\Record::massConvertCurrency($params, string $targetCurrency, string $baseCurrency, $rates, ?array $fieldList = NULL)","file":"/home/site/wwwroot/application/Espo/Modules/Crm/Services/Opportunity.php","line":0,"context":{"file":"/home/site/wwwroot/application/Espo/Modules/Crm/Services/Opportunity.php"}} []
[2019-10-15 09:12:58] Espo.ERROR: Hook class '\Espo\Hooks\Common\Webhook' does not exist. [] []