[SOLVED] Total Videos = Inaccurate

[cajunkyard]

Bug Description: - A member has 20 uploaded videos.  On the cpanel it says they have 30.  I deleted 10 of their videos.

[crankydog]

I have this problem too. Nobody has offered any insights yet...

http://phpmotion.com/forum/index.php?topic=1050.0

[oac]

I have this problem too. Nobody has offered any insights yet...

http://phpmotion.com/forum/index.php?topic=1050.0

I just have

[crankydog]

Thanks, OAC -- when do you sleep? 

I'll look through the files, but I'm a hacker. If anyone has time to find the right line, I'd appreciate it!

In the meantime I'll check manage.php and siteadmin/inner_management.htm

[oac]

Thanks, OAC -- when do you sleep? 

Sleep what is that? I'll try and find which lines you need to change when I get some spare time I've got the new theme to finish first 

[AL]

Just checking any updates on fixing this......Any Ideas ........

[cajunkyard]

For now, we need to manually enter our phpmyadmin and delete it from their. 

[AL]

  thats just sad

[frankie]

I thought I posted a fix for this a while ago.
I must have forgot, but I solved this sometime back.

Here is the fix:

The problem/bug is in maintain.php
after a member or admin deletes a video, it gets
marked 'pendingdelete' in the database.
Then when your in the admin page maintain
and go to System Maintenance, you see
"Deleted video awaiting removal from server"
so when you click to "delete completely"
the script does this:
//set file to "deleted" in database
$sql = "UPDATE videos SET approved ='deleted' WHERE indexer = $video_id";
@mysql_query($sql);
So they are still records in the database, but they are marked deleted,
but all querys to the video table will still show them as a video record.

open maintain.php
look for:
//set file to "deleted" in database
$sql = "UPDATE videos SET approved ='deleted' WHERE indexer = $video_id";
@mysql_query($sql);

change to:
//delete videos by $video_id (deleted)
$sql = "DELETE FROM videos WHERE indexer = $video_id";
@mysql_query($sql);

then the video records are actually deleted from the database
and all the errors / problems are solved.

cheers........

Bug Description: - A member has 20 uploaded videos.  On the cpanel it says they have 30.  I deleted 10 of their videos.

[Artist3d]

Thank you Frankie
These archived solutions are invaluable and just want you to know - still appreciated many months later!