Thread
:
[ANNOUNCE] cuteTube-QML - A feature-rich YouTube client
View Single Post
cooperpeng
2012-03-22 , 06:47
Posts: 30 | Thanked: 3 times | Joined on Jun 2010
#
1745
Hi I have some bad download item in transfer list.
Now, I fix it. If you want to delete it, follow below.
open X Terminal
sqlite3 /home/user/cuteTube-QML/cuteTube-QML.sqlite
sqlite> .database
seq name file
--- --------------- ----------------------------------------------------------
0 main /home/user/cuteTube-QML/cuteTube-QML.sqlite
sqlite> .tables
downloads
sqlite> select * from downloads;
|||0|0|0|0|0|0
|||0|0|0|0|0|0
|||0|0|0|0|0|0
|||0|0|0|0|0|0
|||0|0|0|0|0|0
|||0|0|0|0|0|0
|||0|0|0|0|0|0
|||0|0|0|0|0|0
sqlite> .schema
CREATE TABLE downloads (videoId TEXT UNIQUE, title TEXT, thumbnail TEXT, convertToAudio INTEGER, youtube INTEGER, dailymotion INTEGER, youporn INTEGER, xvideos INTEGER, xhamster INTEGER);
sqlite> .explain
sqlite> select * from downloads where dailymotion=0;
vide title thum conv yout dailymotion yo xvideos xhamster
---- ------------- ---- ---- ---- ------------- -- ------------- ----------
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
sqlite> delete from downloads where dailymotion=0;
sqlite> select * from downloads;
sqlite>.quit
So that fail download items are discard.
Quote & Reply
|
cooperpeng
View Public Profile
Send a private message to cooperpeng
Find all posts by cooperpeng