Bug - SQL logic error - Printable Version

Bug SQL logic error - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116)
+---- Forum: Ember Media Manager (https://forum.kodi.tv/forumdisplay.php?fid=195)
+---- Thread: Bug SQL logic error (/showthread.php?tid=335658)

SQL logic error - madmax2 - 2018-09-18

Hi

There is still an annoying bug that is still not fixed

To repeat the bug.

1.
When there is a list of movies already showing in the list
then we move some of the movies to another location

2.
Click on the movie that was moved but still showing in the movie list in ember.

3. Click update library.

it will crash ember with SQL bug

crash log

https://pastebin.com/8Ayy3Ei8

RE: SQL logic error - komplex - 2018-09-18

Should probably post the actual log so Dan can see what happened

RE: SQL logic error - madmax2 - 2018-09-18

(2018-09-18, 16:33)komplex Wrote: Should probably post the actual log so Dan can see what happened

I updated the post with the crash log

Also it is easy to repeat the bug yourself

I have updated the first post, so you can repeat the bug to see for yourself.

SQL logic error - DanCooper - 2018-09-18

Will be back from vacation next week, then I can check it.

RE: SQL logic error - madmax2 - 2018-09-19

(2018-09-18, 18:10)DanCooper Wrote: Will be back from vacation next week, then I can check it.

ok thanks..

RE: SQL logic error - madmax2 - 2019-01-11

bumped..

any update to this bug?

RE: SQL logic error - Lurvig - 2022-02-09

Hey Guys,

I wanted to ask if the bug has been fixed in the meantime or if there is at least a workaround to avoid it?
Because in my installed version (1.11.1) it pops up and then closes ember.

Thx....

RE: SQL logic error - DanCooper - 2022-02-10

An "SQL logic error" can have an unlimited amount of reasons. I think the madmax2 bug has been fixed, but maybe there are other bugs with the same error message. I need a log file (.\Ember Media Manager\Logs) to check where the error happens.

RE: SQL logic error - madmax2 - 2022-02-11

(2022-02-10, 00:08)DanCooper Wrote: An "SQL logic error" can have an unlimited amount of reasons. I think the madmax2 bug has been fixed, but maybe there are other bugs with the same error message. I need a log file (.\Ember Media Manager\Logs) to check where the error happens.

Was hopeful this would be fixed ...

but I don't think it is fixed..
because I just got an SQL error just now after updating the library (ie same steps as mention in original post on how to recreate the error).

EMM version = 1.11.1 x64

Log

https://pastebin.com/jT3gQNpb

Also update on how to reproduce the bug (just notice another way to get the bug).

1) Have some new movies (not scraped) in the scanned folder
2) Click update library to show those movies in the movie list in ember
3) Open explorer, move all the movies out to another location
4) move some new different movies (not scraped) e.g. at least 27 movies to the scan folder
5) click update library

RE: SQL logic error - DanCooper - 2022-02-11

(2022-02-11, 11:07)madmax2 Wrote: https://pastebin.com/jT3gQNpb

Pastebin tells me "Error, this is a private paste or is pending moderation. If this paste belongs to you, please login to Pastebin to view it."

RE: SQL logic error - madmax2 - 2022-02-11

(2022-02-11, 12:12)DanCooper Wrote:
(2022-02-11, 11:07)madmax2 Wrote: https://pastebin.com/jT3gQNpb
Pastebin tells me "Error, this is a private paste or is pending moderation. If this paste belongs to you, please login to Pastebin to view it."

Ah damn
For some reason pastebin is giving that error even if I post it as public listing
Also try posting it as guest get another error "no such post exist" etc..
I think the moderator is checking the paste before allowing it.

Try this one
http://controlc.com/7c19acb2

I think this bug occurs is because the movie tab listing is expecting the old movies in this list
but when you click update it scans in the new movies
but the last entry was still selected on the old movie list so it throws the exception..

ie it expects the last movie entry to be there (to display the images/info in the right side window/panel) but is not physically there anymore.

Or something like that..

RE: SQL logic error - Klojum - 2022-02-11

(2022-02-11, 15:33)madmax2 Wrote: Try this one

FYI, you can also use Kodi's own paste service. It has some 60 days of retention. The link is just above the 'Post Reply' button.