Posts: 17
Joined: Mar 2013
Reputation:
0
Kodi 15 is not upgrading the library on its own on mySQL 5.6 as the wiki stated. I've granted access for xbmc and kodi, and not sure what else to do.
Any help would be great. Thanks!
Posts: 4,146
Joined: Jan 2008
Reputation:
40
Could be everything without seeing what is logged. Please check your kodi.log for obvious entries.
Always read the
online manual (wiki),
FAQ (wiki) and search the forum before posting.
Do not PM or e-mail Team-Kodi members directly asking for support. Read/follow the
forum rules (wiki).
Please read the pages on
troubleshooting (wiki) and
bug reporting (wiki) before reporting issues.
Posts: 15
Joined: Nov 2014
Reputation:
0
I have the same problem, it seems in fact that the problem is that starting release 15, Kodi does not support "-" char in the database name.
My database was : <name>XBMC-video</name>
I've duplicated the old database XBMC-video90 under a new name KODIvideo90 and modified like that : <name>KODIvideo</name> and then restarted Kodi, it's now working, it's seems to be a bug with release 15 of Kodi (15.1 and 15.2 RC1 at least)
For information, Kodi created succesfully the database XBMC-video93 but did not create any table, and was unable to configure any source category.
Posts: 15
Joined: Nov 2014
Reputation:
0
In my case, the database with a dash in the name is correctly created with the dash, not with an underscore, but the database is *not* populated with any table, and Kodi seems unable to save any information (category, watched status,...). It's not only a problem when upgrading, the same problem occur with a new installation (i've created a new profile with a new database name including a dash). Tested on 4 different computers.
This problem does not occur with release 14 and before.
I do not know if this problem is windows specific, i'm only using windows release.
Posts: 449
Joined: May 2015
Reputation:
10
2015-09-06, 03:13
(This post was last modified: 2015-09-06, 03:31 by Redwingsfansfc.)
I didn't mention this before, my fault... But When moving to a newer version of kodi, the newer version will copy the data of the old database to a new database. The new database, to be used by the newer Kodi version, will have the same name followed by a 2 digit number.
So, the original database that one creates on the first install in MySQL
CREATE DATABASE kodi_video;
CREATE DATABASE kodi_music;
Then moved on by creating the DB with numerals per version when advanced settings is used and kodi is launched.
Therefore when you created your DB with a dash originally, it's been like that since. So windows problem? No. It has always been recommended that dashes, periods, spaces, etc not be used in MySQL DB names. Ergo your dash should be an underscore if you want the name separation.
I really have no idea what I am talking about. Proceed with caution. I confuse easily. And drink. A lot.
Posts: 17,855
Joined: Jan 2011
Reputation:
1,055
Milhouse
Retired Team-Kodi Member
Posts: 17,855
@antarex: are you using MySQL or MariaDB?
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Posts: 15
Joined: Nov 2014
Reputation:
0
I'm using mysql, and there is no problem with dash in database name for mysql, it's fully supported, but need to be quoted.
I know that the database name is appended with two digit representing the version number... my point is :
With version 14 and before of Kodi, a database name like "KODI-Video" worked flawlessly, with version 15 it's not working anymore, something changed in the code, the database is correctly created with the dash, but no table are created within. From my point of view, it's a bug with Kody and thus i report as much information i can to allow the debug.
Posts: 15
Joined: Nov 2014
Reputation:
0
Honnestly, i do not remember if i've updated the database from a previous release of Kodi and thus if the upgrade worked with v14, i just know that the database worked with v14, but it could work also with v15 if i create a new database...
I have already duplicated the database (easier with phpMyAdmin, there is a function to duplicate a database) then upgraded with a new name without dash, no problem for me, i just hope it could help other users.
Posts: 449
Joined: May 2015
Reputation:
10
2015-09-07, 18:18
(This post was last modified: 2015-09-07, 18:19 by Redwingsfansfc.)
Or if you are so terribly dependent on having a dash, though I don't know why...
Use the back tick and create the database
create database `kodi-my-video_db`;
I really have no idea what I am talking about. Proceed with caution. I confuse easily. And drink. A lot.