Railway•2y ago

Can't access STRAPI admin panel, error in deploy logs

I'm new at this so please forgive me if I've done some dumb mistake here. I'm stuck with no longer being able to access the admin panel for my Strapi CMS. Looking around I found a repeating error in the deployment logs. Can you give me a hint on where I should go to resolve this issue?

[2023-01-25 15:07:55.302] error: select distinct "t1"."role_order", "t0".*, "t1"."user_id" from "admin_roles" as "t0" left join "admin_users_roles_links" as "t1" on "t0"."id" = "t1"."role_id" where ("t1"."user_id" in ($1)) order by "t1"."role_order" asc - column t1.role_order does not exist
error: select distinct "t1"."role_order", "t0".*, "t1"."user_id" from "admin_roles" as "t0" left join "admin_users_roles_links" as "t1" on "t0"."id" = "t1"."role_id" where ("t1"."user_id" in ($1)) order by "t1"."role_order" asc - column t1.role_order does not exist
at Parser.parseErrorMessage (/app/node_modules/pg-protocol/dist/parser.js:287:98)
at Parser.handlePacket (/app/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/app/node_modules/pg-protocol/dist/parser.js:39:38)
at Socket.<anonymous> (/app/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (node:events:513:28)
at Socket.emit (node:domain:489:12)
at addChunk (node:internal/streams/readable:315:12)
at readableAddChunk (node:internal/streams/readable:289:9)
at Socket.Readable.push (node:internal/streams/readable:228:10)
at TCP.onStreamRead (node:internal/stream_base_commons:190:23)

[2023-01-25 15:07:55.302] error: select distinct "t1"."role_order", "t0".*, "t1"."user_id" from "admin_roles" as "t0" left join "admin_users_roles_links" as "t1" on "t0"."id" = "t1"."role_id" where ("t1"."user_id" in ($1)) order by "t1"."role_order" asc - column t1.role_order does not exist
error: select distinct "t1"."role_order", "t0".*, "t1"."user_id" from "admin_roles" as "t0" left join "admin_users_roles_links" as "t1" on "t0"."id" = "t1"."role_id" where ("t1"."user_id" in ($1)) order by "t1"."role_order" asc - column t1.role_order does not exist
at Parser.parseErrorMessage (/app/node_modules/pg-protocol/dist/parser.js:287:98)
at Parser.handlePacket (/app/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/app/node_modules/pg-protocol/dist/parser.js:39:38)
at Socket.<anonymous> (/app/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (node:events:513:28)
at Socket.emit (node:domain:489:12)
at addChunk (node:internal/streams/readable:315:12)
at readableAddChunk (node:internal/streams/readable:289:9)
at Socket.Readable.push (node:internal/streams/readable:228:10)
at TCP.onStreamRead (node:internal/stream_base_commons:190:23)

Project ID: e3bfa2ba-a4dc-4187-89d7-60753388fe10 deployment ID: 48331ca

2 Replies

Percy•2y ago

Project ID: e3bfa2ba-a4dc-4187-89d7-60753388fe10

Percy•2y ago

It seems that the issue is related to the Content Security Policy directive, which is preventing the connection to the admin page. The thread on the Discord channel may provide more help.

⚠️ experimental feature

Gaming

Programming

Can't access STRAPI admin panel, error in deploy logs