Had Some Update Issues

I’m in a bit of a bind. i did some updates to peertube some months ago, from a ~1year old version to 6.1. and being a bit of a noob, i didn’t follow the important update instructions (like renaming certain directories) perfectly.

so now, i have a bunch of older videos where there’s nothing but on the audio left on them:
image
is there a way, even a hard way, to fix this? i did rename the /var/www/peertube/storage/videos to /storage/web-videos and moved the files from the older folder to the new folder (there are now about 10 total files in there) but it didn’t seem to help. is there some other thing i can do to fix this? i’ll be more careful with reading the notes on the next update…

Hey pwal! It looks like your PeerTube update turned into a “Where’s the Video?” mystery. :man_detective::film_projector: It’s like your files decided to play hide-and-seek! Check if the database is still searching for them in their old hiding spots. And next time, treat the update instructions like a treasure map—every detail is a clue! Good luck with your digital treasure hunt, and here’s hoping your videos reappear with a funny reply! :joy::mag:

yeah i learned that now :slight_smile:

gee thanks :stuck_out_tongue_winking_eye:

is there a bit of a blue you can give me how to check that? what tool do you use to query the database service?

As a last resort, if Peertube has really lost the link between the peertube video and the video files, there is a CLI tool to add a video file.

But there might be a simpler solution (maybe wait for Chocobozzz to see this post before attempting any operation, he knows the best Peertube internals).

i’m guessing chocobozzzz has more important things to do than look into a noob mistake i made :stuck_out_tongue:
my next idea was to go find the video file, and then the audio file, and see if putting them into the same folder under storage/streaming-playlists/hls and see if that will make it find it.

It thought you already tried this after this discussion.

Yes, you can try this.
But before doing it, check your server logs when you load the video. I guess it could have some errors, with the missing file paths (so you can easily find where to put the files).

You could also try to read the database, see if the missing files are still listed.
To do so, first get the video ID. There are multiple ways to do it.
For example, check your browser network console when you load the video, search for the API request that load video metadata. See this screenshot:

You can also search the video UUID directly in the database (in the « video » table).

Here, for one of your video, the id is 126.

Then you can use this query in the database:

select * from "videoFile" where "videoId" = 125;

If there is only one result, your database has no more the information, and putting back the files will not be enough (using the CLI could help, see my previous response).

If there are multiple resolution, you have a chance for it to work!

Hi,

Information displayed in the admin page comes from the database. So in this specific case PeerTube is not aware of different files than the « Audio only » resolution. Are you sure there were video versions before? And that you you didn’t delete some resolutions?

hey chocobozz, thank you for stopping by. now that you mention it, i did change the VOD transcoding settings to include/disinclude certain resolutions. would that cause it to go back and delete these resolutions from existing videos? because that’s the only settings i changed.

barring that, i was going to wait until weekend here to follow through with mr. livingston’s advice step by step and see if that solves it