+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: XBMC General Help and Support (/forumdisplay.php?fid=111)
+---- Forum: Windows support (/forumdisplay.php?fid=59)
+---- Thread: 2 XBMC PCs and 1 Database on the shared NAS (/showthread.php?tid=70603)
- sladinki007 - 2010-09-20 06:42
* sladinki007 grumbles
seems that the beta screwed up my mysql library
not that the upgrade broke something or so
just after a rescan of all my inventory
i can't seem to make the library mode work
i see all the info but when i click on a movie to play then it can enter the folder
weird .....
i moved my mysql to a linux box ubuntu server x64 10.4.1 since it is much faster then running mysql on a w7 x64 machine
could it be some permission issue? most of the movies are on windows boxes...
nothing usefull in the logs
and if i put the mysql off and run the sqlite db then everything works as usual
bit lost here to what the issue can be
was hoping somehow it was a known issue but seems it is my setup
UPDATE
mmm i thought about the latin1 option when i setup the new database but the collate thingie i forgot
so after dropping DB and setting new DB with the commandline a bit back in this thread is all well again
I wish the developpers could look into it to have more standard settings allowed in mysql and to have the backslash thingie resolved in mysql
but guess they are focussing now to bring a stable release
- rottenrocky - 2010-09-20 13:26
avus m3 Wrote:I have a quick question about using the centralized DB setup. I have it working on my machines being able to resume paused play in another room etc. One problem I have is I added a few episodes of different shows and it's not adding them?? I selected to update library (have it update on startup as well) but it doesn't add the show episodes. Everything works besides not able to add episodes. Any ideas?
I was having this problem with my setup as well. I looked at the xbmc.log and found there was a scrape error because the tvshow.xml was missing the episode guide information. After some research I found that if you use Ember Media Manager, you need to set it up with XBMC's API key to get it to properly generate the tvshow.xml, so new episodes will scrape.
If you don't use Ember, or tvshow.xml files, check your xbmc.log for scrape errors. It could be that the file name can't be resolved by whatever scraper you are using.
RR
- superflip - 2010-09-20 23:26
can you tell me more about that backslash issue (I couldn't find anything about that).
This could be a hint to my problem. Everytime I tried to insert a movie into my MySQL database I get the following error message in my log:
23:24:58 T:2364 M:4294967295 ERROR: CVideoDatabase::GetNavCommon failed
23:24:58 T:2364 M:4294967295 ERROR: XFILE::CDirectory::GetDirectory - Error getting videodb://1/1/
- myrison - 2010-09-21 05:13
videodb://1/1/ means the MovieGenre's page of your library. Just a wild guess, but it looks like maybe the tables in your database are screwed up... have you tried removing the entire db and starting over to let XBMC recreate all of the default tables?
- superflip - 2010-09-21 08:29
I've just installed the new database - so this is a fresh database generated by the same XBMC instance. I took the guide from: Lifehacker.com to set it up.
The only difference is, that MySQL database was already installed for MP TV server on this machine, but I cannot imagine how this might be a difference (especially when I set up permissions properly)
- superflip - 2010-09-21 22:17
so, I have several missing tables (in comparison to database wiki), especially the files table. I tried to create it by my own and I forward a small step forward, but it doesn't work again.
Here are my last log entries:
Code:
21:54:57 T:2256 M:1065914368 ERROR: SQL: The table does not exist
Query: select count(1) from musicvideo
21:54:57 T:2256 M:1065914368 ERROR: CVideoDatabase::HasContent failed
21:55:57 T:2028 M:1057935360 NOTICE: -->Python Interpreter Initialized<--
21:55:58 T:2256 M:1056440320 ERROR: SQL: The table does not exist
Query: select * from movieview order by idMovie desc limit 4
21:55:58 T:2256 M:1056432128 ERROR: CVideoDatabase::GetArbitraryQuery failed
21:55:58 T:2256 M:1056407552 ERROR: SQL: The table does not exist
Query: select * from episodeview order by idepisode desc limit 4
21:55:58 T:2256 M:1056407552 ERROR: CVideoDatabase::GetArbitraryQuery failed
22:10:38 T:2256 M:1069391872 ERROR: SQL: Undefined MySQL error: Code (1048)
Query: insert into files (idFile,idPath,strFileName) values(NULL, 2, 'test.test-xvid.avi')
22:10:38 T:2256 M:1069391872 ERROR: CVideoDatabase::AddFile unable to addfile ()
22:10:38 T:2256 M:1069387776 ERROR: SQL: Undefined MySQL error: Code (1048)
Query: insert into files (idFile,idPath,strFileName) values(NULL, 2, 'test.test-xvid.avi')
22:10:38 T:2256 M:1069387776 ERROR: CVideoDatabase::AddFile unable to addfile ()
22:10:38 T:2256 M:1069387776 ERROR: SQL: The table does not exist
Query: select count(1) from tvshow
22:10:38 T:2256 M:1069387776 ERROR: CVideoDatabase::HasContent failed
22:10:38 T:2256 M:1069387776 ERROR: SQL: The table does not exist
Query: select count(1) from musicvideo
22:10:38 T:2256 M:1069387776 ERROR: CVideoDatabase::HasContent failedMy question now is, if I can download the databse schema and a file, which creates to appropriate tables for me.
- rottenrocky - 2010-09-21 23:21
You shouldn't have to import the schema. I was having the same problem as you and I dropped the schema and then re-created the db with the specs in this thread (Latin1 something or other) and ALL the tables were created properly on the next run of XBMC.
When I just created a DB with the MYSQL defaults, only about 2/3rds of the tables were created.
RR
- sladinki007 - 2010-09-22 13:39
Hey Superflip
you need this command to create the db
CREATE DATABASE xbmc_music CHARACTER SET latin1 COLLATE latin1_general_ci;
or
CREATE DATABASE xbmc_video CHARACTER SET latin1 COLLATE latin1_general_ci;
once you created these then xbmc will populate the tables and it will work
i forgot last time the collate command and had also problems
- mellowd - 2010-09-22 20:17
It's been a while since I last posted.
I'm getting a new Revo 3610 this weekend, and I'll continue to use my 3600 in the bedroom.
I did manage to get this all working with a svn of the Camelot release.
Will Dharma give the option of doing a remote SQL database without it being an advanced setting? If not, will I be able to eventually move my current Camelot database to my server and allow Dharma to use it?
Basically, I don't want to have to start my database from scratch again.
Any ideas?
- superflip - 2010-09-22 21:18
Hey sladinki007 and rottenrocky! - many thanks - no it works.
I already guessed that somewhere in this veryyyy loooong thread the answer is given. But I had no keywords for searching.
So, thanks again for helping.
regards,
superflip