Reply to thread

Message

<blockquote data-quote="RobNorthcott" data-source="post: 1281434" data-attributes="member: 57999">No I must admit I didn't try that because I got side-tracked fishing through the database again, and...FOUND IT (woohoo) <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />For anyone who's interested, or has a similar problem in the future...I was trying to narrow down where the crash was happening.&nbsp; It always seemed to be somewhere in the films starting with &quot;R&quot;, but each individual film in the list worked fine - the problem seemed to be &quot;between&quot; two of the entries.&nbsp; And indeed if I filtered on &quot;starts with R&quot; it would crash - any other start letter was fine.&nbsp; If I filtered by genre it worked fine for ANY genre.&nbsp; So that suggested the problem was to do with films starting with &quot;R&quot; and having no genre tags.&nbsp; So I fired up the SQLite editor and selected entries from the movie_info table starting with &quot;R&quot;...Turns out there were two entries with no genre tags, both relating to files that were not actually appearing in the list in the GUI.&nbsp; They were two Red Dwarf specials that I couldn't get MovingPictures to pick up any info for so I gave up.&nbsp; But it seems it had added some records to the database that were not complete.&nbsp; These didn't have enough info to actually appear in the list on-screen, but must have been in the SQL query result and crashed the GUI when it tried to process the &quot;invisible&quot; record.&nbsp; I deleted these records and any I could find with the same key in a couple of other tables and that seems to have fixed it.&nbsp; I can now scroll all the way through the list without it crashing.</blockquote>

[QUOTE="RobNorthcott, post: 1281434, member: 57999"] No I must admit I didn't try that because I got side-tracked fishing through the database again, and... FOUND IT (woohoo) :) For anyone who's interested, or has a similar problem in the future... I was trying to narrow down where the crash was happening. It always seemed to be somewhere in the films starting with "R", but each individual film in the list worked fine - the problem seemed to be "between" two of the entries. And indeed if I filtered on "starts with R" it would crash - any other start letter was fine. If I filtered by genre it worked fine for ANY genre. So that suggested the problem was to do with films starting with "R" and having no genre tags. So I fired up the SQLite editor and selected entries from the movie_info table starting with "R"... Turns out there were two entries with no genre tags, both relating to files that were not actually appearing in the list in the GUI. They were two Red Dwarf specials that I couldn't get MovingPictures to pick up any info for so I gave up. But it seems it had added some records to the database that were not complete. These didn't have enough info to actually appear in the list on-screen, but must have been in the SQL query result and crashed the GUI when it tried to process the "invisible" record. I deleted these records and any I could find with the same key in a couple of other tables and that seems to have fixed it. I can now scroll all the way through the list without it crashing. [/QUOTE]

Verification