Video database issues Kodi
#1
Weird everything I wrote got deleted when I posted.

Long story short, I've been getting this error since Kodi came out, no matter which version I use, I have windows 8, 7 and Firetv and stick.

XBMC 13.2 works perfectly fine with my synology NFS shares and phpmyadmin and mariaDB for sql

09:54:29 T:10036 ERROR: SQL: Undefined MySQL error: Code (1060)
Query: ALTER TABLE path ADD idParentPath integer
09:54:29 T:10036 ERROR: Exception updating database xbmc_video91 from version 78 to 91
09:54:29 T:10036 ERROR: Error updating database xbmc_video91 from version 78 to 91
09:54:29 T:10036 DEBUG: Mysql rollback transaction
09:54:29 T:10036 NOTICE: Old database found - updating from version 90 to 91
09:54:32 T:10036 ERROR: SQL: Can't create database for copy: 'xbmc_video90' (1007)
09:54:32 T:10036 ERROR: Unable to copy old database xbmc_video90 to new version xbmc_video91
09:54:32 T:10036 NOTICE: Running database version TV29
09:54:32 T:10036 NOTICE: Running database version Epg10
Reply
#2
Any help its really appreciated.

I've deleted the user, re-created it, assign it full permissions to all databases
Reply
#3
Could be that there is an issue with your old database. I do not know if that is the case, but see this thread of another user who initially had database upgrade issues. What if you backup your database files then remove them, then Run Kodi allowing it to create new database files. Will it work then?
Reply
#4
I wanted to avoid deleting the databases but that "solved" the issue I guess, I still couldnt get the regular version of kodi to work, only Beta or alpha were able to connect to the SQL database.

I renamed my databases and had kodi create new ones from scratch which took about 2 days... once it was finished, I set up advancesettings and sources in my other devices and they all read the database correctly.
Reply

Logout Mark Read Team Forum Stats Members Help
Video database issues Kodi0