Adult Script Pro Community Forums

The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!

You are not logged in.

#1 2012-07-15 17:42:34

xpornclub
Member
From: California
Registered: 2012-01-01
Posts: 445
Website

Delete all failed/upload error/clear converting videos

Can we get an option to delete all the videos that failed to convert, or still show converting. I have more videos that say that than active videos, it would be nice if we could clear all the failed ones at once.

Offline

#2 2012-07-15 18:36:04

THS
Member
Registered: 2012-02-02
Posts: 313
Website

Re: Delete all failed/upload error/clear converting videos

Chances are they converted and just didn't get updated.  If thats the case just run a sql query and update their status.

Offline

#3 2012-07-15 21:12:54

ful2fun.com
Member
From: Usa
Registered: 2011-09-16
Posts: 1,049
Website

Re: Delete all failed/upload error/clear converting videos

I Have Same Problem Its Says Converting but not changing Status And Not Even converted To Mobile............ But We Can Change Status To Active It Will Work But in Mobile It Will not Till Is Not converted to MP4........




ful2fun.com
livesexpirates.com


Pharmacy, wholesale prices - worldwide shipping.

Offline

#4 2012-07-15 22:15:18

xpornclub
Member
From: California
Registered: 2012-01-01
Posts: 445
Website

Re: Delete all failed/upload error/clear converting videos

The problem is that I have thousands of those that did that from uploading a csv file and it would take forever to delete them all.

Offline

#5 2012-07-16 06:46:07

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: Delete all failed/upload error/clear converting videos

Search for the videos (Admin -> Video -> Manage -> Search) and select the Converting status and then delete them (from the left dropdonw).


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#6 2012-07-17 00:19:04

xpornclub
Member
From: California
Registered: 2012-01-01
Posts: 445
Website

Re: Delete all failed/upload error/clear converting videos

I have 528309 videos and only about 14.5k are good videos, this will take me years to clear out those...   lol i don't even know how it got that crazy out of control.

Offline

#7 2012-07-17 00:39:12

Mitomind
Member
Registered: 2012-06-27
Posts: 166

Re: Delete all failed/upload error/clear converting videos

Best advice is to not upload such a large csv file... unless you have multiple servers to handle a large load.  Also, make sure you tweak your server so things don't time out.  Some processes, by default, time-out in like 60 seconds.  If you have a dedicated or a VPS server you can go in and extend those times so that the server will process all of your requests. 

It might also be good to get a program like:  Toad for MySQL 6.3 Freeware which is a FREE MySql database tool.  Basically connects to your database and allows you to work with the database on your computer.  You can open up all the tables... find the table you want to delete rows from and delete them in mass.  I haven't played around with ASP enough - at all - yet, so I can't tell you exactly what to do.  But if there's a table for 'videos' and each 'video' has an approved '1' or not approved '0' then sort the table (like a spreadsheet) and select and delete all the '0' videos. 

Hope this helps!

FYI - learning how to manipulate the db is key to running a website.  Also, you can inject a regular spreadsheet into MySql in a minute and have XXXX categories or XXXXX whatever.  Nice for adding a spreadsheet of let's say... pornstars.

Last edited by Mitomind (2012-07-17 00:42:38)

Offline

#8 2012-07-20 00:34:26

xpornclub
Member
From: California
Registered: 2012-01-01
Posts: 445
Website

Re: Delete all failed/upload error/clear converting videos

can I change the template adv_search.tpl to this

<div class="optional">
                                <label for="display" class="search">Display</label>
                                <select name="display" id="display">
                                <option value="10"<?php if ($this->option['display'] == '10'): echo ' selected="selected"'; endif; ?>>10</option>
                                <option value="20"<?php if ($this->option['display'] == '20'): echo ' selected="selected"'; endif; ?>>20</option>
                                <option value="30"<?php if ($this->option['display'] == '30'): echo ' selected="selected"'; endif; ?>>30</option>
                               <option value="500"<?php if ($this->option['display'] == '500'): echo ' selected="selected"'; endif; ?>>500</option>
                                       <option value="100"<?php if ($this->option['display'] == '100'): echo ' selected="selected"'; endif; ?>>100</option>                                                       
<option value="200"<?php if ($this->option['display'] == '200'): echo ' selected="selected"'; endif; ?>>200</option>                   
                                                          <option value="900"<?php if ($this->option['display'] == '900'): echo ' selected="selected"'; endif; ?>>9000</option>                               <option value="5000"<?php if ($this->option['display'] == '5000'): echo ' selected="selected"'; endif; ?>>5000</option>
                                </select>

Offline

#9 2012-07-20 06:25:09

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: Delete all failed/upload error/clear converting videos

Yes, you can, however 5000 will take a long time to load.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

Board footer

Powered by FluxBB