Back
Error 500 connecting to Github [Unknown attribute: "personalRefreshToken"]
I am trying to connect my self-hosted 1.7.4 instance to Github and am getting the following erorr:
TypeScript
[Error] Method: GET
[Error] URL: /v1/vcs/github/callback
[Error] Type: Utopia\Database\Exception\Structure
[Error] Message: Invalid document structure: Unknown attribute: "personalRefreshToken"
[Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Database.php
[Error] Line: 3653```
I reviewed the SQL database of a fresh installation of 1.7.4 and noted that _console_installations had three columns (personalAccessToken, personalAccessTokenExpiry and personalRefreshToken) that my production instance did not have. I created the columns in my production instance with the error still occurring.
Is there somewhere else that the attribute needs to be defined to get things working? -- This may be related to having forgotten to complete a migration somewhere in the 1.6.x branch. Is there anyway to check the overall health of the database schema? In one of the previous issues I was having, there were also some columns missing in the _console_rules table.
Thanks!
TL;DR
Error message "Invalid document structure: Unknown attribute: 'personalRefreshToken' " is appearing when trying to connect a self-hosted 1.7.4 instance to Github. The missing attribute can be added to the SQL database, but issue still persists. To check the overall health of the database schema and address missing columns, possibly due to incomplete migration from the 1.6.x branch, validate tables like _console_installations and _console_rules for consistency.