Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Latest omega alpha build revved the db version so it is no longer supported by the addon #1988

Closed
xconverge opened this issue Sep 11, 2023 · 43 comments · Fixed by #2013 or #2015
Closed

Comments

@xconverge
Copy link

xconverge commented Sep 11, 2023

https://kodi.tv/article/kodi-omega-alpha-3/

Pretty sure this isnt working right/supported correctly. It also doesn't handle the rev nicely because the old db was still there. When I manually cleared them I got the "this addon doesnt support this db" error which was nice

mdarcy:/sdcard/Android/data/org.xbmc.kodi/files/.kodi/userdata/Database $ ls -la
total 5084
drwxrwx--x  3 u0_a97 sdcard_rw    4096 2023-09-10 17:28 .
drwxrwx--x 10 u0_a97 sdcard_rw    4096 2023-09-10 17:25 ..
-rw-rw----  1 u0_a97 sdcard_rw    6148 2023-05-31 21:24 .DS_Store
-rw-rw----  1 u0_a97 sdcard_rw    4096 2023-05-31 21:24 ._.DS_Store
-rw-rw----  1 u0_a97 sdcard_rw 2048000 2023-09-10 17:00 Addons33.db
drwxrwx--x  2 u0_a97 sdcard_rw    4096 2023-05-31 21:24 CDDB
-rw-rw----  1 u0_a97 sdcard_rw   32768 2023-01-16 13:19 Epg16.db
-rw-rw----  1 u0_a97 sdcard_rw  225280 2023-05-31 21:24 MyMusic82.db
-rw-rw----  1 u0_a97 sdcard_rw  376832 2023-09-10 17:28 MyVideos122.db
-rw-rw----  1 u0_a97 sdcard_rw   53248 2023-09-10 17:28 TV43.db
-rw-rw----  1 u0_a97 sdcard_rw 1523712 2023-09-10 17:26 Textures13.db
-rw-rw----  1 u0_a97 sdcard_rw   20480 2022-11-24 12:40 ViewModes6.db
-rw-rw----  1 u0_a97 sdcard_rw  442368 2023-09-10 17:23 plex-copy.db
-rw-rw----  1 u0_a97 sdcard_rw  442368 2023-09-10 17:25 plex.db

xbmc/xbmc#23346

@booleangit
Copy link

Thanks! It would be really nice if this could be merged. 👍

@KyleSanderson
Copy link

Ah jeez - was wondering why this completely broken. Thank you for the PR.

@xconverge
Copy link
Author

21 a3 also drove me crazy due to xbmc/xbmc#23765, so much so I went back to 20. So I would advise anyone who wants to apply/use this patch to use a nightly after 9/19 (tonight at the time of this posting) either way.

@GG-76
Copy link

GG-76 commented Sep 21, 2023

Is there any way to run the PlexKodiConnect on Kodi Omega at the moment? Editing variables.py doesn't work for me :(

@KyleSanderson
Copy link

Is there any way to run the PlexKodiConnect on Kodi Omega at the moment? Editing variables.py doesn't work for me :(

You need to delete the old database manually. The script is bugged and looks for the old one first.

@GG-76
Copy link

GG-76 commented Sep 22, 2023

@KyleSanderson please what is the file? thank you.

@BaukeZwart
Copy link

@GG-76 what isn't working, installing PKC or getting the db loaded?
Installing the modified PKC and doing a db reset from the PKC config menu fixed it for me.

@GG-76
Copy link

GG-76 commented Sep 22, 2023

@BaukeZwart I guess I don't understand. What is modifed PKC and where can I find it? i installed the latest version of kodi omega and PKC 3.8.1 from the library and it still says unsupported version. I didn't see anywhere that there was a modified version available for download.

@BaukeZwart
Copy link

You can't find it, you need to make the change yourself.

@GG-76
Copy link

GG-76 commented Sep 22, 2023

@BaukeZwart and how? i try edit variables.py but its not working :/

@BaukeZwart
Copy link

That worked for me.

@GG-76
Copy link

GG-76 commented Sep 22, 2023

@BaukeZwart I don't know what the correct procedure is, but I have a clean install of kodi, then PKC, then edited the file, run kodi, error message, reset DB, run kodi again, but still the same error message :/

@BaukeZwart
Copy link

Downloaded and unpacked PKC, edit and zip again.

Downloaded and install the following Plugins:

https://github.com/croneter/plugin.video.plexkodiconnect.movies/tree/python3

https://github.com/croneter/plugin.video.plexkodiconnect.tvshows/tree/python3

Install the modified PKC.zip

If all that goes without errors you should be good to go.

@GG-76
Copy link

GG-76 commented Sep 22, 2023

@BaukeZwart i see, ok thanks

edit: I followed the exact procedure and still the same result... Now I don't understand what the problem is...

@GG-76
Copy link

GG-76 commented Sep 28, 2023

@croneter Hi, when will the working version work with Kodi Omega be released please? thank you.

@TheRealBix
Copy link

For god sake thanks for the fix, I almost lost my sanity between the investigation and pkc installation...

@GG-76
Copy link

GG-76 commented Oct 1, 2023

For god sake thanks for the fix, I almost lost my sanity between the investigation and pkc installation...

Does the manual fix work for you too? I'm probably the only one who doesn't :/ I'm already pissed off.

Can someone please share with me the already modified PKC zip, because I'm probably stupid if I can't modify it so that it works...

@xconverge
Copy link
Author

For god sake thanks for the fix, I almost lost my sanity between the investigation and pkc installation...

Does the manual fix work for you too? I'm probably the only one who doesn't :/ I'm already pissed off.

Can someone please share with me the already modified PKC zip, because I'm probably stupid if I can't modify it so that it works...

  1. edit /addons/plugin.video.plexkodiconnect/resources/lib/variables.py to add 122 for kodi 21 like this
  SUPPORTED_VIDEO_DB = {
      19: (119, ),
      20: (119, 120, 121),
      21: (121, 122, ),
  }
  1. Delete /userdata/Database/MyVideos121.db if it exists (I just did rm -rf MyVideos*.db)
  2. Restart kodi
  3. Wait for plexkodiconenct to sync the new database

I have been running like this with no issues since alpha3 came out, but I suggest using a nightly instead of alpha 3

@TheRealBix
Copy link

I did reset the database through pkc (last red setting if I remember)
I imagine it starts by deleting the 121.db first ? Anyway it's working for me yep. Just don't mess up with the edit, that's all.

A bit out of subject but why do you suggest the nightly over alpha3 ?

@xconverge
Copy link
Author

I did reset the database through pkc (last red setting if I remember) I imagine it starts by deleting the 121.db first ? Anyway it's working for me yep. Just don't mess up with the edit, that's all.

A bit out of subject but why do you suggest the nightly over alpha3 ?

see my message above #1988 (comment)

@GG-76
Copy link

GG-76 commented Oct 1, 2023

I have a different situation. I have a clean install of Kodi alpha 3, a clean install of PKC and it creates /userdata/Database/MyVideos122.db and I do anything with it, it always says unsupported version...

@xconverge
Copy link
Author

I have a different situation. I have a clean install of Kodi alpha 3, a clean install of PKC and it creates /userdata/Database/MyVideos122.db and I do anything with it, it always says unsupported version...

Then you probably did not do step 1 correctly of editing variables.py

Sorry, I would just stay on alpha 2 (or just 20.2...) until this gets merged if you continue to have problems.

@GG-76
Copy link

GG-76 commented Oct 1, 2023

I guess I don't understand how I didn't edit variable.py correctly. it probably doesn't even work :D I copied exactly this code and rewrote it in the original... I've done it 20 times already, so what can I do wrong???? I think the problem must be somewhere else, when the db is already 122 after the first installation, even before the modification...

@TheRealBix
Copy link

TheRealBix commented Oct 2, 2023

Where are Kodi nighties btw ? All omega folders seems empty either for Android or windows

edit : nvm they are under "master" folder which is used for current developed branch

@GG-76
Copy link

GG-76 commented Oct 4, 2023

I am forced to go back to Nexus because Omega Alpha 3 causes a lot more errors compared to previous versions and a lot of things that used to work for me stopped working, it is no longer usable for me... It not unfortunately only about PKC,,,

@geropan
Copy link

geropan commented Oct 24, 2023

For god sake thanks for the fix, I almost lost my sanity between the investigation and pkc installation...

Does the manual fix work for you too? I'm probably the only one who doesn't :/ I'm already pissed off.
Can someone please share with me the already modified PKC zip, because I'm probably stupid if I can't modify it so that it works...

  1. edit /addons/plugin.video.plexkodiconnect/resources/lib/variables.py to add 122 for kodi 21 like this
  SUPPORTED_VIDEO_DB = {
      19: (119, ),
      20: (119, 120, 121),
      21: (121, 122, ),
  }
  1. Delete /userdata/Database/MyVideos121.db if it exists (I just did rm -rf MyVideos*.db)
  2. Restart kodi
  3. Wait for plexkodiconenct to sync the new database

I have been running like this with no issues since alpha3 came out, but I suggest using a nightly instead of alpha 3

Just to add to this, on beta 1 the music database has also changed, so there is a further modification needed to the variables.py file:

SUPPORTED_MUSIC_DB = {
    19: (82, ),
    20: (82, ),
    21: (83, ),
}

@xconverge
Copy link
Author

For god sake thanks for the fix, I almost lost my sanity between the investigation and pkc installation...

Does the manual fix work for you too? I'm probably the only one who doesn't :/ I'm already pissed off.
Can someone please share with me the already modified PKC zip, because I'm probably stupid if I can't modify it so that it works...

  1. edit /addons/plugin.video.plexkodiconnect/resources/lib/variables.py to add 122 for kodi 21 like this
  SUPPORTED_VIDEO_DB = {
      19: (119, ),
      20: (119, 120, 121),
      21: (121, 122, ),
  }
  1. Delete /userdata/Database/MyVideos121.db if it exists (I just did rm -rf MyVideos*.db)
  2. Restart kodi
  3. Wait for plexkodiconenct to sync the new database

I have been running like this with no issues since alpha3 came out, but I suggest using a nightly instead of alpha 3

Just to add to this, on beta 1 the music database has also changed, so there is a further modification needed to the variables.py file:

SUPPORTED_MUSIC_DB = {
    19: (82, ),
    20: (82, ),
    21: (83, ),
}

Ok I will make the change in my MR just in case @croneter pops up

@meinname
Copy link

meinname commented Dec 7, 2023

FYI: Kodi Omega is now at Version 123 for Video DB (idk where it is for music, as i only use it for movies)

@xconverge
Copy link
Author

FYI: Kodi Omega is now at Version 123 for Video DB (idk where it is for music, as i only use it for movies)

Updated my MR, it was at 124 as of today 💀

@doomwithdon
Copy link

FYI: Kodi Omega is now at Version 123 for Video DB (idk where it is for music, as i only use it for movies)

Updated my MR, it was at 124 as of today 💀

It's now revved to 127 last i checked on December 30th, 2023

@xconverge
Copy link
Author

Yea...FWIW you can find it here, and git blaming it gives you context on what changed along with the number change:

https://github.com/xbmc/xbmc/blob/master/xbmc/video/VideoDatabase.cpp#L6256

in a function called int CVideoDatabase::GetSchemaVersion() const

I will just update as I need to personally (probably sticking to betas and release candidates now, no more nightlies for me). There is also always the chance a DB change has breaking changes for plexkodiconnect that is more than a number change

I also am not infinitely far away from just using the plex frontend...

@doomwithdon
Copy link

I have tried updating the variables.py and deleting the db file but i keep getting the error. Anyways I am assuming once the final version is released, PKC will get updated with a compatible release version.

@croneter
Copy link
Owner

Fixed in PKC version 3.8.3 for Kodi Omega BETA. I do NOT support nightly versions - too much stuff breaks with these

@bokkoman
Copy link

bokkoman commented Feb 16, 2024

It seems the database is revved up to another version.
Suddenly my movies aren't visible anymore, but TV still is.
I don't know how to fix this.
The movies database name now is Movies131.db.

@xconverge
Copy link
Author

It seems the database is revved up to another version. Suddenly my movies aren't visible anymore, but TV still is. I don't know how to fix this. The movies database name now is Movies131.db.

you can try the beta of plexkodiconnect https://github.com/croneter/PlexKodiConnect/releases/tag/3.8.4

@bokkoman
Copy link

It seems the database is revved up to another version. Suddenly my movies aren't visible anymore, but TV still is. I don't know how to fix this. The movies database name now is Movies131.db.

you can try the beta of plexkodiconnect https://github.com/croneter/PlexKodiConnect/releases/tag/3.8.4

I have this version.
Im reinstalling it as we speak.

@bokkoman
Copy link

bokkoman commented Feb 16, 2024

It seems the database is revved up to another version. Suddenly my movies aren't visible anymore, but TV still is. I don't know how to fix this. The movies database name now is Movies131.db.

you can try the beta of plexkodiconnect https://github.com/croneter/PlexKodiConnect/releases/tag/3.8.4

Nah, it doesn't work anymore.
I'm on 21.0 beta 3 since yesterday.
MyVideos131.db is the new filename.

Editing variables.py doesn't work either.

@croneter
Copy link
Owner

@bokkoman try resetting the PKC database. In the PKC settings go to Advanced, then hit "Reset the Kodi database" (in red). Reset the database only, do not reset the PKC add-on itself

@bokkoman
Copy link

@bokkoman try resetting the PKC database. In the PKC settings go to Advanced, then hit "Reset the Kodi database" (in red). Reset the database only, do not reset the PKC add-on itself

I tried.
I also deleted all the databases.
Tried editing the variables.py.
Tried reinstalling.
Nothing worked. It's only the movies though, cause TV shows work fine.
I think it's the new beta that does something differently.

@croneter
Copy link
Owner

@bokkoman try re-installing Kodi completely from scratch

@bokkoman
Copy link

@bokkoman try re-installing Kodi completely from scratch

I'll do this.
But if that doesn't work, is there anything I can provide to fix it?

@bokkoman
Copy link

Just a heads up, the jellyfin plugin is broken as well because of beta 3.

@bokkoman
Copy link

Ok, this is confirmed broken.
Another issue thread.

jellyfin/jellyfin-kodi#808

@bokkoman bokkoman mentioned this issue Feb 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment