Error 502 after Update

[goryn-clade]

Error 502 after Update

[ppfeufer]

Found it.

CCP_SSO_JWK_CLAIM was missing in my environment.ini. Would be nice to mention that somewhere ...

But now I get a new error ...

[samoneilll]

Hey, I'm sorry, I missed updating the environment.ini in the docker-compose project, I've fixed it now.

The second error you're getting there is because the Db schema for storing access tokens changed. Go to your /setup page and run the "fix columns/keys" task on the "PF" database, and then try to log in again.

Edit: There's also a step by step upgrade guide here:

https://github.com/goryn-clade/pathfinder-containers/wiki/v2.1.1----v2.1.4-Upgrade-Guide

[ppfeufer]

"fix columns/keys" is resulting in a foreign key constraint error ...

I nuked the DBs and rebuild them, working now ...

[samoneilll]

Okay, glad to hear it's working. Let me know if you run into any other issues.

[TyrHeimdalEVE]

The option (in /setup) to "Fix columns/keys" should fix both column types and foreign key constraints. You may have to run it multiple times.

In this specific case, character.esiAccessToken changed from varchar(256) to TEXT due to a change in length for tokens received from CCP's SSO API.

[samoneilll]

@ppfeufer I wonder if the foreign-key error you encoutered could be related to the issue you were having in #39. It would be interesting to know if you're still having that issue pasting structures after rebuilding the db.

[ppfeufer]

Good point, no that is solved as well with nuking and rebuilding the DB ...

[samoneilll]

Cool, I'm going to close both issues then. There's definitely still other issues with pasting structures, but we have an open issue for it already