Problem with playlists and MySQL
#1
I have setup MySQL on a server with smb shares which is working fine. I can see all the movies when going in via files. The problem comes in when using smartplaylists. I have added a share on the server for playlists and have also tried using them locally with the same result. Playlists do not load anything. The error I am seeing in the logs is:

12:22:13 T:19004 DEBUG: CGUIMediaWindow::GetDirectory (special://profile/playlists/video/Kids TV.xsp)
12:22:13 T:19004 DEBUG: ParentPath = [special://videoplaylists/]
12:22:13 T:19004 ERROR: XFILE::CDirectory::GetDirectory - Error getting special://profile/playlists/video/Kids TV.xsp
12:22:13 T:19004 ERROR: CGUIMediaWindow::GetDirectory(special://profile/playlists/video/Kids TV.xsp) failed
12:22:13 T:19004 DEBUG: CGUIMediaWindow::GetDirectory (special://videoplaylists/)

My shared path on the server is \\MEDIACENTER\Kodi which then has playlists as a directory under it

The oddest thing is that if I edit a playlist, the changes are reflected on the server but the playlist still does not open

Here is my advancedsettings.xml:

<advancedsettings>
<loglevel>1</loglevel>
<videodatabase>
<type>mysql</type>
<host>192.168.1.210</host>
<port>3306</port>
<user>kodi</user>
<pass>password</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.210</host>
<port>3306</port>
<user>kodi</user>
<pass>password</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
<substitute>
<from>special://profile/playlists/</from>
<to>smb://mediacenter/kodi/playlists/</to>
</substitute>
</advancedsettings>

Anyone have any idea what I might be doing wrong?
Reply

Logout Mark Read Team Forum Stats Members Help
Problem with playlists and MySQL0