iv-org / invidious

Invidious is an alternative front-end to YouTube
https://invidious.io
GNU Affero General Public License v3.0
16.38k stars 1.83k forks source link

[Bug] relation "videos" does not exist (PQ::PQError) #3536

Closed QT31416 closed 1 year ago

QT31416 commented 1 year ago

Describe the bug I try to search for a video. I click on the thumbnail to watch any video, then this error occurs.

Steps to Reproduce Steps to reproduce the behavior:

  1. Go to ':3000' and search for any video
  2. Click on any video
  3. See error

Logs Title: relation "videos" does not exist (PQ::PQError) Date: 2023-01-04T10:33:18Z Route: /watch?v=_bkX5VkZg8U Version: 2023.01.01-865704d @ master

Backtrace

``` relation "videos" does not exist (PQ::PQError) from lib/pg/src/pq/connection.cr:202:22 in 'handle_error' from lib/pg/src/pq/connection.cr:184:9 in 'handle_async_frames' from lib/pg/src/pq/connection.cr:162:7 in 'read' from lib/pg/src/pq/connection.cr:157:7 in 'perform_query' from lib/db/src/db/statement.cr:93:9 in 'query:args' from lib/db/src/db/query_methods.cr:61:12 in 'select' from src/invidious/videos.cr:337:7 in 'get_video:region' from src/invidious/routes/watch.cr:63:15 in 'handle' from lib/kemal/src/kemal/route.cr:13:9 in '->' from src/invidious/helpers/handlers.cr:30:37 in 'call' from /usr/share/crystal/src/http/server/handler.cr:28:7 in 'call' from /usr/share/crystal/src/http/server/handler.cr:28:7 in 'call_next' from lib/kemal/src/kemal/filter_handler.cr:21:7 in 'call' from /usr/share/crystal/src/http/server/handler.cr:28:7 in 'call_next' from /usr/share/crystal/src/http/server/handler.cr:28:7 in 'call_next' from /usr/share/crystal/src/http/server/handler.cr:28:7 in 'call_next' from /usr/share/crystal/src/http/server/handler.cr:28:7 in 'call_next' from /usr/share/crystal/src/http/server/handler.cr:28:7 in 'call_next' from /usr/share/crystal/src/http/server/handler.cr:28:7 in 'call' from /usr/share/crystal/src/http/server/handler.cr:28:7 in 'call' from /usr/share/crystal/src/http/server/handler.cr:28:7 in 'call_next' from lib/kemal/src/kemal/init_handler.cr:12:7 in 'process' from /usr/share/crystal/src/http/server.cr:500:5 in '->' from /usr/share/crystal/src/fiber.cr:146:11 in 'run' from ??? ```

Screenshots image

Additional context

QT31416 commented 1 year ago

I tried deleting the:

  1. containers on portainer
  2. images on portainer
  3. network on portainer
  4. persistent volumes

Then I tried installing from scratch again, but it didn't work.

unixfox commented 1 year ago

We do not support portainer. Please install invidious the proper way using our documentation: https://docs.invidious.io/installation/#automated-installation

QT31416 commented 1 year ago

Yeah, sorry about that. Works like a charm now. Thank you!