Bug SQL logic error
#1
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

Image

crash log

https://pastebin.com/8Ayy3Ei8
Reply
#2
Should probably post the actual log so Dan can see what happened
Reply
#3
(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.
Reply
#4
Will be back from vacation next week, then I can check it.
Reply
#5
(2018-09-18, 18:10)DanCooper Wrote: Will be back from vacation next week, then I can check it.
 ok thanks..
Reply
#6
bumped..

any update to this bug?
Reply
#7
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....
Reply
#8
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.
Reply
#9
(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
Reply
#10
(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."
Reply
#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..
Reply
#12
(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.
Reply

Logout Mark Read Team Forum Stats Members Help
SQL logic error0