Trying to setup Dharma 10.1 for multi-user mysql mode having issues.
#1
I have a MySQL installed and working correctly, I installed Dharma on what will be my main "server" node.

I started it up once then quit and created the advancedsettings.xml file and restarted added a source set to "smb://192.168.1.4/TV/" and told it to run automated scan, it created the tables and looks like to started to scan but doesn't quit finish and I cannot enable library mode.

If I remove the %APPDATA/ROAMING/XBMC directory and setup with the local DB and add the source it chews thru all the TV shows fine and library mode is a option.

What in the hell am I doing wrong here?
Reply
#2
Tried to export from file mode, add advancedsettings.xml and then restart and reimport, nothing shows in library mode, disable it, my TV source is there and once again Library mode is grayed out.

Also try to "manually add to library" to no avail.
Reply
#3
Ok tried something else, I created the user account in mysql and added the grants. Started xbmc to generate the profile, closed it and then threw in the advancedsettings.xml and restarted. It created the DB's, however when i went to add a show I get this in the XBMC log. It seems to me it is not creating something that it expects to be there. Really lost on this.

Code:
23:02:33 T:6908 M:4294967295   ERROR: CVideoDatabase::HasContent failed
23:03:28 T:6452 M:4294967295  NOTICE: VideoInfoScanner: Starting scan ..
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select tvshowlinkpath.idShow from path,tvshowlink
path where path.strPath like 'smb://192.168.1.4/TV/Alphas/' and path.idPath=tvshowlinkpath.idPath
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddTvShow (smb://192.168.1.4/TV/Alphas/) faile
d
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select idStudio from studio where strStudio like
'Syfy'
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddToTable (Syfy) failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from actorlinktvshow where idActor=1 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddLinkToActor failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from actorlinktvshow where idActor=2 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddLinkToActor failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from actorlinktvshow where idActor=3 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddLinkToActor failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from actorlinktvshow where idActor=4 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddLinkToActor failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from actorlinktvshow where idActor=5 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddLinkToActor failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from actorlinktvshow where idActor=6 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddLinkToActor failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from actorlinktvshow where idActor=1 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddLinkToActor failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from actorlinktvshow where idActor=2 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddLinkToActor failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from actorlinktvshow where idActor=3 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddLinkToActor failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from actorlinktvshow where idActor=4 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddLinkToActor failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from actorlinktvshow where idActor=5 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddLinkToActor failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from actorlinktvshow where idActor=6 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddLinkToActor failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from genrelinktvshow where idGenre=1 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddToLinkTable failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from genrelinktvshow where idGenre=2 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddToLinkTable failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from genrelinktvshow where idGenre=3 and
idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddToLinkTable failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: select * from studiolinktvshow where idStudio=-1
and idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::AddToLinkTable failed
23:03:29 T:6452 M:4294967295   ERROR: SQL: The table does not exist
                                            Query: update tvshow set c00='Alphas',c01='Alphas is an
action-packed thriller about five ordinary people who are brought together to form one extraordinary
team of Alphas -- people with the unique power to stretch the capabilities of the human mind giving
them superhuman physical and mental abilities.',c02='',c03='',c04='8.200000',c05='2011-07-11',c06='
<thumb>http://thetvdb.com/banners/graphical/210841-g.jpg</thumb><thumb>http://thetvdb.com/banners/gr
aphical/210841-g3.jpg</thumb><thumb>http://thetvdb.com/banners/graphical/210841-g2.jpg</thumb><thumb
>http://thetvdb.com/banners/posters/210841-8.jpg</thumb><thumb>http://thetvdb.com/banners/posters/21
0841-1.jpg</thumb><thumb>http://thetvdb.com/banners/posters/210841-3.jpg</thumb><thumb>http://thetvd
b.com/banners/posters/210841-2.jpg</thumb><thumb>http://thetvdb.com/banners/posters/210841-6.jpg</th
umb><thumb>http://thetvdb.com/banners/posters/210841-4.jpg</thumb><thumb>http://thetvdb.com/banners/
posters/210841-5.jpg</thumb><thumb>http://thetvdb.com/banners/posters/210841-7.jpg</thumb><thumb typ
e=\"season\" season=\"-1\">http://thetvdb.com/banners/posters/210841-8.jpg</thumb><thumb type=\"seas
on\" season=\"-1\">http://thetvdb.com/banners/posters/210841-1.jpg</thumb><thumb type=\"season\" sea
son=\"-1\">http://thetvdb.com/banners/posters/210841-3.jpg</thumb><thumb type=\"season\" season=\"-1
\">http://thetvdb.com/banners/posters/210841-2.jpg</thumb><thumb type=\"season\" season=\"-1\">http:
//thetvdb.com/banners/posters/210841-6.jpg</thumb><thumb type=\"season\" season=\"-1\">http://thetvd
b.com/banners/posters/210841-4.jpg</thumb><thumb type=\"season\" season=\"-1\">http://thetvdb.com/ba
nners/posters/210841-5.jpg</thumb><thumb type=\"season\" season=\"-1\">http://thetvdb.com/banners/po
sters/210841-7.jpg</thumb>',c07='',c08='Action and Adventure / Drama / Science-Fiction',c09='',c10='
<episodeguide><url cache=\"210841.xml\">http://www.thetvdb.com/api/1D62F2F90030C444/series/210841/al
l/en.zip</url></episodeguide>',c11='<fanart url=\"http://thetvdb.com/banners/\"><thumb dim=\"1920x10
80\" colors=\"\" preview=\"_cache/fanart/original/210841-5.jpg\">fanart/original/210841-5.jpg</thumb
><thumb dim=\"1920x1080\" colors=\"\" preview=\"_cache/fanart/original/210841-3.jpg\">fanart/origina
l/210841-3.jpg</thumb><thumb dim=\"1920x1080\" colors=\"|235,224,220|172,206,231|42,111,152|\" previ
ew=\"_cache/fanart/original/210841-10.jpg\">fanart/original/210841-10.jpg</thumb><thumb dim=\"1920x1
080\" colors=\"\" preview=\"_cache/fanart/original/210841-12.jpg\">fanart/original/210841-12.jpg</th
umb><thumb dim=\"1920x1080\" colors=\"\" preview=\"_cache/fanart/original/210841-8.jpg\">fanart/orig
inal/210841-8.jpg</thumb><thumb dim=\"1920x1080\" colors=\"\" preview=\"_cache/fanart/original/21084
1-11.jpg\">fanart/original/210841-11.jpg</thumb><thumb dim=\"1920x1080\" colors=\"\" preview=\"_cach
e/fanart/original/210841-4.jpg\">fanart/original/210841-4.jpg</thumb><thumb dim=\"1920x1080\" colors
=\"\" preview=\"_cache/fanart/original/210841-1.jpg\">fanart/original/210841-1.jpg</thumb><thumb dim
=\"1920x1080\" colors=\"\" preview=\"_cache/fanart/original/210841-6.jpg\">fanart/original/210841-6.
jpg</thumb><thumb dim=\"1920x1080\" colors=\"\" preview=\"_cache/fanart/original/210841-2.jpg\">fana
rt/original/210841-2.jpg</thumb><thumb dim=\"1920x1080\" colors=\"\" preview=\"_cache/fanart/origina
l/210841-7.jpg\">fanart/original/210841-7.jpg</thumb><thumb dim=\"1920x1080\" colors=\"\" preview=\"
_cache/fanart/original/210841-9.jpg\">fanart/original/210841-9.jpg</thumb><thumb dim=\"1920x1080\" c
olors=\"\" preview=\"_cache/fanart/original/210841-13.jpg\">fanart/original/210841-13.jpg</thumb><th
umb dim=\"1920x1080\" colors=\"\" preview=\"_cache/fanart/original/210841-14.jpg\">fanart/original/2
10841-14.jpg</thumb><thumb dim=\"1920x1080\" colors=\"\" preview=\"_cache/fanart/original/210841-15.
jpg\">fanart/original/210841-15.jpg</thumb><thumb dim=\"1920x1080\" colors=\"\" preview=\"_cache/fan
art/original/210841-17.jpg\">fanart/original/210841-17.jpg</thumb><thumb dim=\"1920x1080\" colors=\"
\" preview=\"_cache/fanart/original/210841-16.jpg\">fanart/original/210841-16.jpg</thumb></fanart>',
c12='210841',c13='TV-14',c14='Syfy',c15=''where idShow=-1
23:03:29 T:6452 M:4294967295   ERROR: CVideoDatabase::SetDetailsForTvShow (smb://192.168.1.4/TV/Alph
as/) failed
23:03:29 T:6452 M:4294967295  NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took
00:00
Reply
#4
Found a post which mentioned setting the DB char set to Latin1.

That did the trick and it is working correctly now.
Reply

Logout Mark Read Team Forum Stats Members Help
Trying to setup Dharma 10.1 for multi-user mysql mode having issues.0