2010-11-30, 11:16
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).
EDIT:
I think i may have found the source of my problem: i am using local windows directory letters, instead of the smb:// syntax.
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.