NextPVR Forums
  • ______
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public NextPVR Support Legacy (v4.x and earlier) v
« Previous 1 … 143 144 145 146 147 … 433 Next »
Problem deleting recordings

Problem deleting recordings
sub
Offline

Administrator

NextPVR HQ, New Zealand
Posts: 106,789
Threads: 769
Joined: Nov 2003
#41
2016-02-15, 07:46 PM
You can, but they wont be causing any issues being there.
Handy.Man
Offline

Senior Member

Montréal, Québec, Canada
Posts: 423
Threads: 41
Joined: Oct 2012
#42
2016-02-15, 07:58 PM
Now I have to find how to delete them ...
no as simple as selecting the line and pressing Delete !
Server : NextPVR 4.2.3 Intel Core2 Quad Q6600 @2.4GHz 8GB Win7Pro, Hauppauge HVR-2250 Dual Tuner, DIAMOND ATI Theater HD 750 USB TV Tuner, Homemade fractal antenna, SchedulesDirect EPG.
Client : NextPVR 4.2.3 Intel I7-2600K @4.5GHz 8GB, Radeon HD6800, Win7Pro
mvallevand
Online

Posting Freak

Ontario Canada
Posts: 53,119
Threads: 957
Joined: May 2006
#43
2016-02-15, 08:17 PM
They are also the history for duplicate recordings, in general better to keep them.

Martin
Handy.Man
Offline

Senior Member

Montréal, Québec, Canada
Posts: 423
Threads: 41
Joined: Oct 2012
#44
2016-02-15, 09:23 PM
I guess the easiest thing to do is to flush the table with:

sqlite3.exe "npvr.db3" "DELETE FROM PLAYBACK_POSITION"
Server : NextPVR 4.2.3 Intel Core2 Quad Q6600 @2.4GHz 8GB Win7Pro, Hauppauge HVR-2250 Dual Tuner, DIAMOND ATI Theater HD 750 USB TV Tuner, Homemade fractal antenna, SchedulesDirect EPG.
Client : NextPVR 4.2.3 Intel I7-2600K @4.5GHz 8GB, Radeon HD6800, Win7Pro
Handy.Man
Offline

Senior Member

Montréal, Québec, Canada
Posts: 423
Threads: 41
Joined: Oct 2012
#45
2016-02-15, 09:56 PM
So I did Vacuum first, that removed 8000 rows in the PLAYBACK_POSITION table
Code:
sqlite3.exe" "npvr.db3" "VACUUM;"
followed by
Code:
sqlite3.exe" "npvr.db3" "DELETE FROM PLAYBACK_POSITION"
I will see if this help.
Server : NextPVR 4.2.3 Intel Core2 Quad Q6600 @2.4GHz 8GB Win7Pro, Hauppauge HVR-2250 Dual Tuner, DIAMOND ATI Theater HD 750 USB TV Tuner, Homemade fractal antenna, SchedulesDirect EPG.
Client : NextPVR 4.2.3 Intel I7-2600K @4.5GHz 8GB, Radeon HD6800, Win7Pro
mvallevand
Online

Posting Freak

Ontario Canada
Posts: 53,119
Threads: 957
Joined: May 2006
#46
2016-02-15, 11:56 PM
Handy.Man Wrote:So I did Vacuum first, that removed 8000 rows in the PLAYBACK_POSITION table
Code:
sqlite3.exe" "npvr.db3" "VACUUM;"
followed by
Code:
sqlite3.exe" "npvr.db3" "DELETE FROM PLAYBACK_POSITION"
I will see if this help.

I thought you wanted individual recordings to clear the history try

NextPVR.exe -removehistory

Martin
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)

Pages (5): « Previous 1 2 3 4 5


Possibly Related Threads…
Thread Author Replies Views Last Post
  Failed recordings won't delete Spid4567 3 2,548 2023-07-14, 10:13 PM
Last Post: ZeDoZ
  All my recordings start 90 sec early ncsercs 2 1,406 2022-03-19, 03:28 AM
Last Post: sub
  NPVR4 and MPC-HC problem The Solutor 29 7,338 2021-07-27, 03:45 PM
Last Post: The Solutor
  Wake - Sleep Interaction -> Failed Recordings mikeh49 48 15,070 2021-03-21, 11:21 PM
Last Post: careads
  Most recordings are zero bytes virtualpaul 4 2,118 2021-01-29, 12:55 PM
Last Post: virtualpaul
  Deleting itgreen9@gmail.com 3 1,320 2021-01-19, 02:54 AM
Last Post: itgreen9@gmail.com
  Problem locking on to a tuner? time_lord 7 3,146 2021-01-09, 12:06 PM
Last Post: Graham
  Recordings with Next PVR 4.2.5 (CL0116) have background music but no voice in record DavidF 4 2,152 2021-01-07, 08:47 AM
Last Post: sub
  EPG XMLTV problem DBHall 8 3,855 2021-01-01, 12:34 PM
Last Post: Graham
  Problem with Intel 4600 graphics driver pol098 1 1,481 2020-12-01, 12:44 PM
Last Post: romdl

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode