Mysql database support broken in r8871?
#1
I just upgraded to version r8871 and Mysql database support seems to be broken.
Log: http://pastebin.com/d7sxwTdJ

edit: The connection to the database is successfull, but after that xbmc is requesting a wrong database name. An other name than stated in the advancedsettings file. Looks like the name that is used when the internal xbmc database is used. MyVideos56.db
Reply
#2
xbmc is going to ignore the database name contained in the advanced config file: you have to allow the mysql user to create new database. Xbmc will create new database for each new schema release.
Reply
#3
Thanks for your answer.
I have given the xbmc user the rights to create a new database, and the video and the music database are created successfully. It also tried to upgrade my old databases, but that failed. After a rescan and a couple of hours I got it back.
The only problem now is that the TV (pvr) database isn't created correct. The database is there, but it only has 1 table in it called 'version'.
The log is filling with the folloing error message when I try to enable the tvheadend backend:
Code:
18:29:28 T:139854347073280   ERROR: SQL: The table does not exist
                                            Query: SELECT idClient FROM clients WHERE sUid = 'pvr.hts' LIMIT 1
18:29:28 T:139854347073280   ERROR: GetSingleValue - failed to get value 'idClient' from table 'clients'
18:29:28 T:139854347073280   ERROR: SQL: The table does not exist
                                            Query: INSERT INTO clients (sName, sUid) VALUES ('Tvheadend HTSP Client', 'pvr.hts');
18:29:28 T:139854347073280   ERROR: ExecuteQuery - failed to execute query 'INSERT INTO clients (sName, sUid) VALUES ('Tvheadend HTSP Client', 'pvr.hts');'
18:29:28 T:139854347073280   ERROR: PVR - AddClientToDb - can't add client 'Tvheadend HTSP Client' to the database
Does somone has a .sql file with the correct database structure so I can create these tables manually?
Reply
#4
Same here...
Reply

Logout Mark Read Team Forum Stats Members Help
Mysql database support broken in r8871?0