Posts: 36
Joined: Jul 2010
Reputation:
0
rubenm
Junior Member
Posts: 36
hi everyone.
[RANT]
so. ok. some filesystems mess up "special" characters. (you know, for chinese, there's nothing 'special' about the majority chinese characters, and me, i dont feel like an 'umlaut' is in any way weird.
now. pardon my french, but 1992 is long gone, so why the fuck would anyone do anything in anything but utf-8 (or utf-16)?
i mean, this is such an AWFUL thing to do.
really, i could hardly believe it.
no 'sorry, but until we figured out some potential problems, it's latin1 only' ... not even a 'it might be unsuitable for some of you, but there's no other way'
i mean, come on guys - latin1 doesnt even include russian or greek. let alone japanese, chinese, korean, thai. if you count all people in the world that DONT use latin1 characters on a day-to-day basis, than YOU are the fucking MINORITY ... by far.
[/RANT]
sorry. but euro/us centric stuff really bugs me.
Posts: 40
Joined: Jan 2011
Reputation:
1
Hi, would it be possible to have the database only take care of...
Stop watching a video and resume from same point in any room
Watched flags sync across all htpc's
leaving each media center to scan and store new content (thumbs posters fan-art etc) localy.
Would this not cut out the overhead/lag in load times. but keep the main advantages of having "flags" and "resume from same point" synced across xbmc's.
Posts: 107
Joined: Nov 2010
Reputation:
0
tormi
Senior Member
Posts: 107
Hi!
I just tried out this, not knowing multiple profiles was not supported. Giving me a headache at my end, but I have reverted my system to before my testing began.
Is there at all any sensible way to have multiple profiles in this setup? I DO need my own movies separated from my kids movies so without that possibility I have to skip this.
So can anybody explain to me how I setup MySQL database sharing and multiple user profiles? I would be very appreciative.
If not is there any other systems like XBMC out there with this supported? I really don't want to switch but I'd like to have my watched status changed + possibility to resume playback from one HTPC to another.
Posts: 35
Joined: Apr 2010
Reputation:
0
I have 290 movies and it takes about 10 seconds to load. It's not 13 minutes, but I guess some kind of intelligent buffer have to be implemented.
Posts: 4
Joined: Feb 2011
Reputation:
0
2011-02-20, 01:47
(This post was last modified: 2011-02-21, 00:48 by malibu66.)
I am having a problem setting up XBMC with a central database and was wondering if anyone could help. Basically when I configure MySQL, sources won't scan into my library. When I go back to sqlite it works fine again.
I've connected from the XBMC machine to mysql with mysql workbench using the xbmc user that I created and I can connect and see that XBMC created tables in the DBs. I'm no stranger to MySQL and I think everything is ok connection-wise.
XBMC system:
windows 7, XBMC 10.0 r35647
MySQL system:
SUSE 10, mysql 5.1
Contents of my advancedsettings.xml:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>6.6.0.6</host>
<port>3306</port>
<user>xbmc_parents</user>
<pass>****</pass>
<name>xbmc_parents_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>6.6.0.6</host>
<port>3306</port>
<user>xbmc_parents</user>
<pass>****</pass>
<name>xbmc_parents_music</name>
</musicdatabase>
</advancedsettings>
Can anyone help? Thanks.
--------------------
EDIT: An interesting finding... XBMC 10 doesn't seem to be fully creating the database schema. I turned on the debug logging and took a peek and it seems that the tvshow tables are missing.
Here are the tables that I have in my video database:
+------------------------------+
| Tables_in_xbmc_parents_video |
+------------------------------+
| actorlinkmovie |
| actors |
| bookmark |
| country |
| countrylinkmovie |
| directorlinkmovie |
| genre |
| genrelinkmovie |
| movie |
| path |
| settings |
| stacktimes |
| version |
| writerlinkmovie |
+------------------------------+
+------------------------------+
| Tables_in_xbmc_parents_music |
+------------------------------+
| album |
| albuminfo |
| albuminfosong |
| artist |
| artistinfo |
| content |
| discography |
| exartistalbum |
| exartistsong |
| exgenrealbum |
| exgenresong |
| genre |
| karaokedata |
| path |
| song |
| thumb |
| version |
+------------------------------+
Here are my errors:
14:49:12 T:3772 M:909455360 ERROR: SQL: The table does not exist
Query: select count(1) from tvshow
14:49:12 T:3772 M:909426688 ERROR: CVideoDatabase::HasContent failed
-----
I also seem to have errors for table songview... Ok let me just grep out the missing table errors and list some of the tables I see:
tvshow
songview
musicvideo
... hm that is all I see. enough to prevent anything from working.
Perhaps songview is a stored view? Still it is not there.
Also I have a missing 'actorlinktvshow' table.. I have now just tried to use my root user and running into the same problem.
I have dropped the schemas, recreated, and restarted xbmc several times.
------
EDIT:
I turned on query log for my server and the problem may be related to the following:
4 Query CREATE TRIGGER tgrAlbumInfo AFTER delete ON albuminfo FOR EACH ROW BEGIN delete from albuminfosong where albuminfosong.idAlbumInfo=old.idAlbumInfo; END
4 Query rollback
When I tried to run this CREATE TRIGGER it indeed failed. MySQL seems to have a problem with BEGIN and END around one statement. I ran the following query fine:
CREATE TRIGGER tgrAlbumInfo AFTER delete ON albuminfo FOR EACH ROW delete from albuminfosong where albuminfosong.idAlbumInfo=old.idAlbumInfo;