[Dennisreneholm]

Hi.

I'm using a shared mysql database.

I've recently upgraded to Jarvis, and first time i ran the new version, it took a loooong time for the database to be upgraded.
Which resulted in a corrupt database the first time, i then dropped it, and gave Jarvis time to recreate again, that worked fine.

However, i now discover that i can't change og delete any entries.
I can add new, the scraping is working as always, but if I try to edit, update or delete a TV show or movie, i can't.

I've done it while logging was enabled, log file here:
http://pastebin.com/kPe7FDYi

[DaVu]

If i read this:

13:18:23 T:4784 ERROR: SQL: [MyVideos99] Undefined MySQL error: Code (1227)
Query: delete from seasons where idShow=179
13:18:23 T:4784 ERROR: CVideoDatabase:eleteTvShow (179) failed

and google the error code (1227)...I found this:

Error: 1227 SQLSTATE: 42000 (ER_SPECIFIC_ACCESS_DENIED_ERROR)

See:

https://dev.mysql.com/doc/refman/5.5/en/...nied_error

So I guess it´s a permission thing?!

[Dennisreneholm]

I thought so too.

so i tried giving the user full priviligis on SQL server, made no differnce.

[Dennisreneholm]

This is making me crazy, i don't get it!

I tried going back to 15.2 to see if it was the newly created database that was broken, but same result.
I've tried creating a new user with full access to everything and connecting to the database with kodi with that user, same result.

Here's some screenshots of my sql setup.





I've made a swith to use the user m3d1a instead of xbmc, but it's the same result with either user.

[Dennisreneholm]

Not sure why, but I think some of the Tables are bound to the user they were created with.
I did make a new user, called m3d1a which Kodi now connects with, but if i change the password of the original user, xbmc, i can't delete or edit items.

I figured this out when i ran a new mysql database on my own PC instead, and noticed that i couldn't get into "Views"


When i try to enter, without the old user created, i get this error.


This error did not show on my current SQL server, but it's also a older version.

Any help on how to resolve this?
I would like to deny access with the old user, since it's not secure.

[bg_x]

Iv'e found the problem.in the my.cnf from your sqlserver the thread_stack must min. 256K then it works. Before I had only 128K and that was the reason I can't cahnge something.