500 server error when clicking on project in web interface.
ya...that lines up with 1.0.1...
did i miss a migration step in there somewhere?
my keys attributes is:
[
{
"$id": "projectId",
"type": "string",
"size": 255,
"required": false,
"signed": true,
"array": false,
"filters": []
},
{
"$id": "name",
"type": "string",
"size": 255,
"required": true,
"signed": true,
"array": false,
"filters": []
},
{
"$id": "scopes",
"type": "string",
"size": 255,
"required": true,
"signed": true,
"array": true,
"filters": []
},
{
"$id": "secret",
"type": "string",
"size": 512,
"required": true,
"signed": true,
"array": false,
"filters": [
"encrypt"
]
},
{
"$id": "projectInternalId",
"key": "projectInternalId",
"type": "string",
"size": 255,
"required": false,
"default": null,
"signed": true,
"array": false,
"format": "",
"formatOptions": [],
"filters": []
},
{
"$id": "expire",
"key": "expire",
"type": "datetime",
"size": 0,
"required": false,
"default": null,
"signed": false,
"array": false,
"format": "",
"formatOptions": [],
"filters": [
"datetime"
]
},
{
"$id": "accessedAt",
"key": "accessedAt",
"type": "datetime",
"size": 0,
"required": false,
"default": null,
"signed": false,
"array": false,
"format": "",
"formatOptions": [],
"filters": [
"datetime"
]
},
{
"$id": "sdks",
"key": "sdks",
"type": "string",
"size": 255,
"required": true,
"default": null,
"signed": true,
"array": true,
"format": "",
"formatOptions": [],
"filters": []
}
]
you can see it has sdks
if you were on 1.0.1, you shouldn't have missed any migration step....it makes no sense why your attributes metadata is missing some attributes...
i see, mine is missing SDK
ok, it sounds like i should probly spin up a new version
and my issue is due to missing attributes in the metadata
ideally, yes...but we can try to fix...
how have you been doing the migration? what exact command?
i feel bad for taking up so much of your time as it is, i really appreciate you being willing to help me out with this issue.
docker-compose -f /docker/docker-compose2.yml exec appwrite migrate
kk you can try backing up your data (so you can rollback if something goes wrong) and then run...
docker-compose -f /docker/docker-compose2.yml exec appwrite migrate version=1.0.3
absolutely, fortunately this is on a VM, so i will take a snapshot and run that shortly
Ok, migrate has completed
i checked the attributes by running:
docker exec -it appwrite-mariadb sh -c 'mysql -uroot -p$MYSQL_ROOT_PASSWORD $MYSQL_DATABASE -e "select * from _console__metadata where name = \"keys\";"'
and it still does not show sdk
what was the output?
here you are
Migrating Collection "keys"
[PDO] MySQL connection restarted
'accessedAt' from keys: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'accessedAt'
[PDO] MySQL connection restarted
'sdks' from keys: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'sdks'
😑
lol
i guess you could manually try to update your keys attributes to be this
and then you may need to restart the appwrite container
ok, i can look into that, im hopeless when it comes to DB which is why im using appwrite
but i will give that a try and let you know the results
