Reply to thread

Message

<blockquote data-quote="RoChess" data-source="post: 1062621" data-attributes="member: 18896">You more then likely corrupted the SQLite movingpictures.db3 database. Easy way to check/verify.&nbsp;<ol>
<li data-xf-list-type="ol">Download SQLite commandline tool at: <a href="https://sqlite.org/2014/sqlite-shell-win32-x86-3080300.zip" target="_blank">https://sqlite.org/2014/sqlite-shell-win32-x86-3080300.zip</a></li>
<li data-xf-list-type="ol">Unzip sqlite3.exe from the ZIP file</li>
<li data-xf-list-type="ol">Start -&gt; All Programs -&gt; Team MediaPortal -&gt; &quot;User Files&quot; shortcut</li>
<li data-xf-list-type="ol">Hold down SHIFT key and right click on the &quot;database&quot; folder and select &quot;Open command window here&quot;</li>
<li data-xf-list-type="ol">Double ckick to open the &quot;database&quot; folder inside Windows explorer</li>
<li data-xf-list-type="ol">Move or copy sqlite3.exe into this folder (or place it in a folder accessible by PATH environment)</li>
<li data-xf-list-type="ol">Go back to the command window and type in: sqlite3.exe movingpictures.db3 &quot;PRAGMA integrity_check;&quot;&nbsp; [ENTER]</li>
</ol>If you do not get the simple response back of 'ok', but some error, then unless you made backups, start crying, wipe tears away and rename movingpictures.db3 to movingpictures.corrupt (or simply delete it) and start over fresh. Now if you have been smart and made backups simply restore the last one and resume. Each time you upgrade MovPic automatic backups are made, so be sure to check for subfolders inside the &quot;database&quot; folder (I just hope your 'upgrade' attempt to &quot;fix&quot; things did not overwrite a valid backup with a copy of the corrupted one).&nbsp;With a lot of SQL knowledge and a lot of time you might be able to repair a corrupted database, but even Moving-Pictures developers suggest a fresh start is easier.&nbsp;PS: For the future, start considering an automatic backup/restore system that scans for database corruption. I've made the script I use myself available at: <a href="https://forum.team-mediaportal.com/threads/corrupted-database.120376/#post-1014075" target="_blank">https://forum.team-mediaportal.com/threads/corrupted-database.120376/#post-1014075</a></blockquote>

[QUOTE="RoChess, post: 1062621, member: 18896"] You more then likely corrupted the SQLite movingpictures.db3 database. Easy way to check/verify. [LIST=1] [*]Download SQLite commandline tool at: [URL='https://sqlite.org/2014/sqlite-shell-win32-x86-3080300.zip'][B]https://sqlite.org/2014/sqlite-shell-win32-x86-3080300.zip[/B][/URL] [*]Unzip sqlite3.exe from the ZIP file [*]Start -> All Programs -> Team MediaPortal -> "User Files" shortcut [*]Hold down SHIFT key and right click on the "database" folder and select "Open command window here" [*]Double ckick to open the "database" folder inside Windows explorer [*]Move or copy sqlite3.exe into this folder (or place it in a folder accessible by PATH environment) [*]Go back to the command window and type in: [B]sqlite3.exe movingpictures.db3 "PRAGMA integrity_check;"[/B] [ENTER] [/LIST] If you do not get the simple response back of '[B]ok[/B]', but some error, then unless you made backups, start crying, wipe tears away and rename movingpictures.db3 to movingpictures.corrupt (or simply delete it) and start over fresh. Now if you have been smart and made backups simply restore the last one and resume. Each time you upgrade MovPic automatic backups are made, so be sure to check for subfolders inside the "database" folder (I just hope your 'upgrade' attempt to "fix" things did not overwrite a valid backup with a copy of the corrupted one). With a lot of SQL knowledge and a lot of time you might be able to repair a corrupted database, but even Moving-Pictures developers suggest a fresh start is easier. PS: For the future, start considering an automatic backup/restore system that scans for database corruption. I've made the script I use myself available at: [URL='https://forum.team-mediaportal.com/threads/corrupted-database.120376/#post-1014075'][B]https://forum.team-mediaportal.com/threads/corrupted-database.120376/#post-1014075[/B][/URL] [/QUOTE]

Verification