[mythtv-users] Records list not showing all recording?

[Bill Williamson]

First the pleasantries:
Ubuntu 11.11


bill at megatron:~$ mythbackend --version
Please attach all output as a file in bug reports.
MythTV Version : v0.25.2-15-g46cab93
MythTV Branch : fixes/0.25
Network Protocol : 72
Library API : 0.25.20120506-1
QT Version : 4.7.4
Options compiled in:
 linux profile use_hidesyms using_alsa using_oss using_pulse
using_pulseoutput using_backend using_bindings_perl
using_bindings_python using_bindings_php using_crystalhd using_dvb
using_firewire using_frontend using_hdhomerun using_ceton using_hdpvr
using_iptv using_ivtv using_joystick_menu using_libcec using_libcrypto
using_libdns_sd using_libxml2 using_lirc using_mheg using_opengl_video
using_qtwebkit using_qtscript using_qtdbus using_v4l2 using_x11
using_xrandr using_xv using_bindings_perl using_bindings_python
using_bindings_php using_mythtranscode using_opengl using_vaapi
using_vdpau using_ffmpeg_threads using_live using_mheg using_libass
using_libxml2



Symptoms:
-All Programs shows 1428 items
-Default + Deleted + Kiddie (my only 3 recording groups) show 1428
items added together
- "ls *.mpg | wc -l" in my recordings storage group shows 1977 files
- "mythname.pl --total" on the recording directory shows 1977 files
-find_orphans.py doesn't find any orphans
-mythweb shows 1977 files under recorded programs


CRUCIAL HINT:
-mythweb recorded programs "deleted" group shows 500+.  Mythfrontend
UI only shows ~5-10 of them.


How do I fix this?  Obviosuly there's a ton of deleted shows that
didn't really delete, and the frontend thinks they are "gone".  My
guess is that this happened because I was mass deleting some shows
using add to playlist->delete playlist.

Can I just do "delete from recorded where recgroup = 'Deleted'" in
mysql, then run find orphans again to blow them away?