Reply to thread

Message

Solved it with help in the following article: https://forum.team-mediaportal.com/threads/moving-pictures-scans-new-movies-indefinitely-unhandled-error-in-mediascanner.107859/

Cause; Corrupt field in SQL Database.

Solution:
1. Download SQL Lite browser
2. Open database; C:\ProgramData\Team MediaPortal\MediaPortal\database\movingpictures.db3
3. Go to the tab "Browse Data"
4. Set Table to "Settings"
5. Search for the Entry "Regular Expression Noise Filter". After this line there will probably be some Chinese or Weird characters.
6. Description should be: A regular expression that removes common used keywords from the folder/filename.
7. Grouping should be: |Movie Importer|Tweaks|
8. Value should be: (([$\{\[]|\b)((576|720|1080)[pi]|dir(ectors )?cut|dvd([r59]|rip|scr(eener)?)|(avc)?hd|wmv|ntsc|pal|mpeg|dsr|r[1-5]|bd[59]|dts|ac3|blu(-)?ray|[hp]dtv|stv|hddvd|xvid|divx|x264|dxva|(?-i)FEST[Ii]VAL|L[iI]M[iI]TED|[WF]S|PROPER|REPACK|RER[Ii]P|REAL|RETA[Ii]L|EXTENDED|REMASTERED|UNRATED|CHRONO|THEATR[Ii]CAL|DC|SE|UNCUT|[Ii]NTERNAL|[DS]UBBED)([\]$\}]|\b)(-[^\s]+$)?)
9. String should be: STRING

<blockquote data-quote="EricSnijders" data-source="post: 1095026" data-attributes="member: 147307">Solved it with help in the following article: <a href="https://forum.team-mediaportal.com/threads/moving-pictures-scans-new-movies-indefinitely-unhandled-error-in-mediascanner.107859/" target="_blank">https://forum.team-mediaportal.com/threads/moving-pictures-scans-new-movies-indefinitely-unhandled-error-in-mediascanner.107859/</a>Cause; Corrupt field in SQL Database.Solution:1. Download SQL Lite browser2. Open database; C:\ProgramData\Team MediaPortal\MediaPortal\database\movingpictures.db33. Go to the tab &quot;Browse Data&quot;4. Set Table to &quot;Settings&quot;5. Search for the Entry &quot;Regular Expression Noise Filter&quot;. After this line there will probably be some Chinese or Weird characters.6. Description should be: A regular expression that removes common used keywords from the folder/filename.7. Grouping should be: |Movie Importer|Tweaks|8. Value should be: (([$\{\[]|\b)((576|720|1080)[pi]|dir(ectors )?cut|dvd([r59]|rip|scr(eener)?)|(avc)?hd|wmv|ntsc|pal|mpeg|dsr|r[1-5]|bd[59]|dts|ac3|blu(-)?ray|[hp]dtv|stv|hddvd|xvid|divx|x264|dxva|(?-i)FEST[Ii]VAL|L[iI]M[iI]TED|[WF]S|PROPER|REPACK|RER[Ii]P|REAL|RETA[Ii]L|EXTENDED|REMASTERED|UNRATED|CHRONO|THEATR[Ii]CAL|DC|SE|UNCUT|[Ii]NTERNAL|[DS]UBBED)([\]$\}]|\b)(-[^\s]+$)?)9. String should be: STRING</blockquote>

[QUOTE="EricSnijders, post: 1095026, member: 147307"] Solved it with help in the following article: [url]https://forum.team-mediaportal.com/threads/moving-pictures-scans-new-movies-indefinitely-unhandled-error-in-mediascanner.107859/[/url] Cause; Corrupt field in SQL Database. Solution: 1. Download SQL Lite browser 2. Open database; C:\ProgramData\Team MediaPortal\MediaPortal\database\movingpictures.db3 3. Go to the tab "Browse Data" 4. Set Table to "Settings" 5. Search for the Entry "Regular Expression Noise Filter". After this line there will probably be some Chinese or Weird characters. 6. Description should be: A regular expression that removes common used keywords from the folder/filename. 7. Grouping should be: |Movie Importer|Tweaks| 8. Value should be: (([$\{\[]|\b)((576|720|1080)[pi]|dir(ectors )?cut|dvd([r59]|rip|scr(eener)?)|(avc)?hd|wmv|ntsc|pal|mpeg|dsr|r[1-5]|bd[59]|dts|ac3|blu(-)?ray|[hp]dtv|stv|hddvd|xvid|divx|x264|dxva|(?-i)FEST[Ii]VAL|L[iI]M[iI]TED|[WF]S|PROPER|REPACK|RER[Ii]P|REAL|RETA[Ii]L|EXTENDED|REMASTERED|UNRATED|CHRONO|THEATR[Ii]CAL|DC|SE|UNCUT|[Ii]NTERNAL|[DS]UBBED)([\]$\}]|\b)(-[^\s]+$)?) 9. String should be: STRING [/QUOTE]