<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On 27 October 2014 07:53, Anthony Giggins <span dir="ltr"><<a href="mailto:seven@seven.dorksville.net" target="_blank">seven@seven.dorksville.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On 27 October 2014 06:31, Scott Bickford <span dir="ltr"><<a href="mailto:bic1ster@gmail.com" target="_blank">bic1ster@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">I have upgraded from Mythdora 12.25 to Fedora 20 and MythTV .27-3. <div><br></div><div>To restore my old database, I shutdown the .25 MySQL database server and copied the mythconverg directory to the new box. </div><div><br></div><div>I started mythtv-setup and let it upgrade the database. </div><div><br></div><div>Now the Front End is showing quite a few recording files as X or missing.</div><div><br></div><div>I get this on the backend log:</div><div><br></div><div><div>ProcessRequest programinfo.cpp:2358 (GetPlaybackURL) - ProgramInfo(3030_20130930223000.mpg): GetPlaybackURL: '3030_20130930223000.mpg' should be local, but it can not be found.</div></div><div><br></div><div>I changed the ip from 192.168.1.3 to 192.168.1.4 in mythtv-setup.</div><div><br></div><div>I tried deleting the storage groups and recreating them. I compared the data from the mysql dump and the new database. They are actually the same.</div><div><br></div><div>I double checked the permissions on the two storage groups. I have one local to the OS and a second drive. In some cases those with X on them, they appear deleted(watched). While in others, they are ok and do not have a X. Some recordings (recent) are actually missing/no meta data (hard to determine if the file is there or not). There seems to be a three week period where there's no recordings. <br><br></div><div>I ran the find_orphans.py and it found370 files that were on disk, but not in the database. For these I realized I just deleted them in the FE as they had an X on them (as some I thought i had watched and deleted). Also, there are some 400+ files that do not have have a db entry. Both storage groups are listed here. There was a python error:<br><br></div><div>return str(round(s,1))+('B ', 'KB', 'MB', 'GB)[o]<br>indexerror: tuple index out of range<br><br><br></div><div>Any hints on troubleshooting files that are not in the db (yet they show up in .25 MythFrontend?<br><br></div></div></blockquote><div><br></div></div></div><div>You really should have done a backup and restore<br><br><a href="https://www.mythtv.org/wiki/Database_Backup_and_Restore" target="_blank">https://www.mythtv.org/wiki/Database_Backup_and_Restore</a><br><br></div><div>Additionally you need to load the time zone tables in MySQL (As per the 0.26 release notes <a href="https://www.mythtv.org/wiki/Release_Notes_-_0.26#Prerequisite_Changes" target="_blank">https://www.mythtv.org/wiki/Release_Notes_-_0.26#Prerequisite_Changes</a> )<br><br><a href="https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables" target="_blank">https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables</a> <br></div></div><br></div><div class="gmail_extra">Cheers,<br><br></div><div class="gmail_extra">Anthony<br></div></div>
</blockquote></div><br></div><div class="gmail_extra">From you other post it appears your database upgrade did not complete successfully,<br></div><div class="gmail_extra"><br>Mythdora had an automated backup running to <span class="">/storage/<em>dorabackup (By Default) I think you may be able to use this to restore.<br><br></em></span></div><div class="gmail_extra"><span class=""><em>Anthony<br></em></span></div></div>