Hall of Fame

[leen12]

hey

i noticed the other day some videos from various channels in my site are showing under a certain channel i though i must have added them in the wrong channel in the first place so i tried to edit them,

turns out they are in the correct channel but multiple channels are appearing under the second channel i have and random videos are showing instead of videos that should be in that channel..

sorry ino that probably sounds stupid im not sure how to explain it correctly,

[Marius]

I didn't understand anything

If you have

main channel
- child 1
- child 2

The video from child 1 and child 2 will also show in the main channel.

So if you place a video in child 2, it will show in child 2 and main channel.

This is what got you confused?

[leen12]

no i have no child channels just main channels,

ok il try again,

i have cars, extreme and fails, animations, movies, and stuff like that,

in extreme and fails i see videos from music, movies, gaming, animations and cars

they are all main channels with no child channels

[Marius]

Did you check in which category the videos actually are? Under "Details & embed"

[leen12]

yes they are in the wrong sections,

music, cars, animations and music all are in extreme and fails

[Marius]

So basically you are telling me "extreme and fails" also contains this categories, even if they are not it's childs, right?

[Marius]

Code Select Expand

WHERE ".DB_PREFIX."videos.category in (SELECT cat_id from ".DB_PREFIX."channels where cat_id = '".$channel->cat_id."' or child_of = '".$channel->cat_id."' )

I don't really see an error in the code 

[leen12]

yes that is correct

im not sure why

here is a link so you can confirm
http://www.viralwire.co.uk/video/29412/nate-dogg-why-legendado-pt-br-hd/

should be in music but its under extreme and fails

[Marius]

I see it has music a category.
I see it in music category.
I don't see it under extreme and fails.
Which page of extreme and fails is it on?

[leen12]

it is 3 or 4 pages down in the extreme and fails section

[Marius]

You couldn't pick one on the first page?

[Marius]

Ok, I saw it...but can't explain it..happens the same in all channels?

[Marius]

Nope, I've browsed games and it seems fine till the end....

[leen12]

lol sorry none of the videos on first page are wrong,

im not sure i took a quick look in other sections and cannot see anything yet,

i think its just the second channel, or the extreme and fails channel

i will let you know if i see it anywhere else

[Marius]

It's a bit weird it happens to only one channel...do this, edit it's id to a bigger one, like from 2 to 22 so we can check wtf is the issue (via phpmyadmin).

Also update videos.

Code Select Expand

update vibe_videos set category = '22' where category = '2'

[leen12]

ok i did that,

seems to be fine now,

no videos look out of place and cannot see the videos from music etc..

[leen12]

so should i now leave it as 22? i actually moved them all back as after i moved them if i click extreme and fails it is not found,

let me know please thanks

[Marius]

Clear cache via Moderator -> Tools -> Clean cache

[Marius]

I guess you already moved them as extreme has again id 2

[leen12]

yea i did that last night as i did not want to leave my site with invalid links for anyone who visited.

edit

yea clean cache did the job all is working fine now videos are as 22 and extreme and fails are as 22

thanks for the help mario

[Marius]

You just had to clear cache as it was cached with id 2 in menu