Dharma MySQL bugs
#1
When using dharma-rc1 on windows 7, i have been having tons of issues with mysql implementation. It does not properly import files, mark files as watched, and refuses to update any tv shows.

What it seems like is the sql queries keep trying to add stuff each time instead of selecting the old one. for instance take this as an example. this is what the debug log looks like when trying to mark an episode as watched. (this also happens when importing a video dataset, making it so that only one file from a path gets imported).

Code:
02:13:18 T:9864 M:1705775104   DEBUG: CWinEventsWin32::WndProcWindow is active
02:13:18 T:9864 M:1705762816   DEBUG: CWinEventsWin32::WndProcWindow gained focus
02:13:22 T:9864 M:1705820160   DEBUG: SDLKeyboard: scancode: 17, sym: 119, unicode: 119, modifier: 0
02:13:22 T:9864 M:1705820160   DEBUG: CApplication::OnKey: 61527 pressed, action is ToggleWatched
02:13:22 T:9864 M:1705652224   DEBUG: Mysql execute: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'W:\\TV Shows\\24\\Season 1\\','','')
02:13:22 T:9864 M:1705652224   ERROR: SQL: Undefined MySQL error: Code (1062)
                                            Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'W:\\TV Shows\\24\\Season 1\\','','')
02:13:22 T:9864 M:1705652224   ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'W:\\TV Shows\\24\\Season 1\\','',''))
02:13:22 T:9864 M:1705652224   DEBUG: CGUIMediaWindow::GetDirectory (videodb://2/2/2/1/)
02:13:22 T:9864 M:1705652224   DEBUG:   ParentPath = [videodb://2/2/2/1/]
02:13:22 T:6916 M:1705652224   DEBUG: thread start, auto delete: 1
02:13:22 T:6916 M:1705652224   DEBUG: CVideoDatabase::GetStackedTvShowList query: select idShow from tvshow where c00 like (select c00 from tvshow where idShow=2) order by idShow
02:13:22 T:6916 M:1705652224   DEBUG: CVideoDatabase::GetEpisodesByWhere query: select * from episodeview where idShow = 2 and (c12=1 or (c12=0 and (c15=0 or c15=1)))
02:13:22 T:6916 M:1705648128   DEBUG: Time for actual SQL query = 1
02:13:22 T:6916 M:1705648128   DEBUG: Time to retrieve episodes from dataset = 1
02:13:22 T:9864 M:1705648128   DEBUG: WindowVideoNav::GetDirectory
02:13:22 T:9864 M:1705631744   DEBUG: Saving fileitems [videodb://2/2/2/1/]
02:13:22 T:9864 M:1705631744   DEBUG:   -- items: 2, sort method: 22, ascending: true
02:13:22 T:9864 M:1705631744 WARNING: XFILE::CVideoDatabaseDirectory::GetLabel - Unknown nodetype requested 12
02:13:22 T:3240 M:1705631744   DEBUG: thread start, auto delete: 0
02:13:22 T:3240 M:1705631744   DEBUG: Thread 3240 terminating
02:13:23 T:9864 M:1705918464   DEBUG: CWinEventsWin32::WndProcWindow is active
02:13:23 T:9864 M:1705918464   DEBUG: CWinEventsWin32::WndProcWindow lost focus

EDIT:

I think i may have found the source of my problem: i am using local windows directory letters, instead of the smb:// syntax.
Reply

Logout Mark Read Team Forum Stats Members Help
Dharma MySQL bugs0