2011-05-31, 08:54
I'm running XBMC on the ATV2 (4.2.2) with the latest nightly build. Before I updated to the nightly build, I had no issue with it connecting to my SQLServer which was running the latest stable build.
After that, the ATV2 was unable to connect. Upon sifting through the logs, it was unable to upgrade the database to the latest version. I have the ATV2 configured to only have select access to all the tables, with exceptions to watch/unwatched tables and the resume table. This hasn't been an issue until now.
After some research, I figured I had to upgrade the SQLServer to the latest nightly build. I upgraded the SQLServer to the latest nightly build, dropped the databases and rebuilt them. I added my sources, updated the library on the host, and was all set.
Now however, I still cannot connect to the database on the ATV. This is the entry I receive right before I get the dreaded "Cannot connect to database" error.
After some more research, I found some posts that were quite dated informing me that the ATV2 Databases and the Main Build databases were mismatched, and this was big on the to-do list to fix. There was some talk about a SQL query you could run to change the database version and spoof the ATV2 into connecting. This query appears to be outdated as I ran it, and it didn't change a thing.
I'm new the SQL, and I'm not sure how to query the set to tell me what version it is, and I'm not sure what version it's supposed to be, or even if this is really the case. Any help on the matter would be greatly appreciated.
ATV2 Log: http://pastebin.com/MsStYwx3
SQL Log: http://pastebin.com/zkYZh1qa
Link to Database mismatch post: http://forum.xbmc.org/showthread.php?tid=95238
After that, the ATV2 was unable to connect. Upon sifting through the logs, it was unable to upgrade the database to the latest version. I have the ATV2 configured to only have select access to all the tables, with exceptions to watch/unwatched tables and the resume table. This hasn't been an issue until now.
After some research, I figured I had to upgrade the SQLServer to the latest nightly build. I upgraded the SQLServer to the latest nightly build, dropped the databases and rebuilt them. I added my sources, updated the library on the host, and was all set.
Now however, I still cannot connect to the database on the ATV. This is the entry I receive right before I get the dreaded "Cannot connect to database" error.
Code:
Can't open the database xbmc_video as it is a NEWER version than what we were expecting?After some more research, I found some posts that were quite dated informing me that the ATV2 Databases and the Main Build databases were mismatched, and this was big on the to-do list to fix. There was some talk about a SQL query you could run to change the database version and spoof the ATV2 into connecting. This query appears to be outdated as I ran it, and it didn't change a thing.
I'm new the SQL, and I'm not sure how to query the set to tell me what version it is, and I'm not sure what version it's supposed to be, or even if this is really the case. Any help on the matter would be greatly appreciated.
ATV2 Log: http://pastebin.com/MsStYwx3
SQL Log: http://pastebin.com/zkYZh1qa
Link to Database mismatch post: http://forum.xbmc.org/showthread.php?tid=95238
