Thank you for the response, I've seen a few historical posts where people seem pissed about logs being posted but I suppose they are relevant at this point.
I alt tabbed back in to XBMC, turned on logging - went over to my videos, set the content and watched it fail. Then quit - so it should be a nice short log.
(FWIW: I suspect scanning is 'fine' - because it works without the MySQL component being set) - so who knows, maybe someone smart can decipher.
(I attempted posting the full 34k log - too big, I've cut it to the section I believe the problem may be in)
23:11:27 T:3144 DEBUG: CApplication:
rocessMouse: trying mouse action leftclick
23:11:28 T:3144 DEBUG: ------ Window Deinit (DialogContextMenu.xml) ------
23:11:28 T:3144 DEBUG: ------ Window Init (DialogContentSettings.xml) ------
23:11:28 T:3144 INFO: Loading skin file: DialogContentSettings.xml
23:11:30 T:3144 DEBUG: CApplication:
rocessMouse: trying mouse action leftclick
23:11:32 T:3144 DEBUG: Previous line repeats 1 times.
23:11:32 T:3144 INFO: XCURL:
llLibCurlGlobal::CheckIdle - Closing session to
http://feeds.feedburner.com (easy=001A2A08, multi=00AF78B8)
23:11:33 T:3144 DEBUG: CApplication:
rocessMouse: trying mouse action leftclick
23:11:35 T:3144 DEBUG: Previous line repeats 1 times.
23:11:35 T:3144 DEBUG: ------ Window Deinit (DialogContentSettings.xml) ------
23:11:35 T:3144 DEBUG: Previous line repeats 1 times.
23:11:35 T:3144 INFO: Loading skin file: DialogYesNo.xml
23:11:35 T:3144 DEBUG: ------ Window Init (DialogYesNo.xml) ------
23:11:37 T:3144 DEBUG: CApplication:
rocessMouse: trying mouse action leftclick
23:11:37 T:3144 DEBUG: ------ Window Deinit (DialogYesNo.xml) ------
23:11:37 T:3144 INFO: Loading skin file: DialogProgress.xml
23:11:37 T:3144 DEBUG: DialogProgress::StartModal called
23:11:37 T:3144 DEBUG: ------ Window Init (DialogProgress.xml) ------
23:11:37 T:3144 DEBUG: Mysql execute: update path set strContent = '', strScraper='', strHash='',strSettings='',useFolderNames=0,scanRecursive=0 where strPath like '%K:\\!sickbeard\\%'
23:11:37 T:3144 DEBUG: Mysql execute: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'K:\\!sickbeard\\','','')
23:11:37 T:3144 ERROR: SQL: Undefined MySQL error: Code (1062)
Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'K:\\!sickbeard\\','','')
23:11:37 T:3144 ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'K:\\!sickbeard\\','',''))
23:11:37 T:3144 DEBUG: ------ Window Init (DialogVideoScan.xml) ------
23:11:37 T:3144 INFO: Loading skin file: DialogVideoScan.xml
23:11:37 T:4836 DEBUG: Thread VIDEO::CVideoInfoScanner start, auto delete: 0
23:11:37 T:4836 NOTICE: VideoInfoScanner: Starting scan ..
23:11:37 T:4836 NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
23:11:37 T:4836 INFO: Video scan was stopped or finished ... restoring FindRemoteThumbs
23:11:37 T:4836 DEBUG: Thread VIDEO::CVideoInfoScanner 4836 terminating
23:11:37 T:3144 DEBUG: CGUIMediaWindow::GetDirectory (sources://video/)
23:11:37 T:3144 DEBUG: ParentPath = [sources://video/]
23:11:37 T:3164 DEBUG: Thread Background Loader start, auto delete: 0
23:11:37 T:3164 DEBUG: Thread Background Loader 3164 terminating
23:11:37 T:3144 DEBUG: ------ Window Deinit (DialogVideoScan.xml) ------
23:11:38 T:3144 DEBUG: ------ Window Deinit (DialogProgress.xml) ------
23:11:41 T:3144 DEBUG: CApplication:
rocessMouse: trying mouse action leftclick
23:11:41 T:3144 DEBUG: CGUIMediaWindow::GetDirectory ()
23:11:41 T:3144 DEBUG: ParentPath = []
23:11:41 T:5688 DEBUG: Thread Background Loader start, auto delete: 0
23:11:41 T:5688 DEBUG: Thread Background Loader 5688 terminating
23:11:42 T:3144 DEBUG: SDLKeyboard: scancode: 01, sym: 001b, unicode: 001b, modifier: 0
23:11:42 T:3144 DEBUG: CApplication::OnKey: escape (f01b) pressed, action is PreviousMenu
23:11:42 T:3144 DEBUG: CGUIWindowManager:
reviousWindow: Deactivate
23:11:42 T:3144 DEBUG: ------ Window Deinit (Pointer.xml) ------
23:11:42 T:3144 DEBUG: ------ Window Deinit (MyVideoNav.xml) ------
23:11:42 T:3144 DEBUG: CGUIWindowManager:
reviousWindow: Activate new
23:11:42 T:3144 DEBUG: ------ Window Init (Home.xml) ------
23:11:42 T:3144 INFO: Loading skin file: Home.xml
23:11:42 T:1492 DEBUG: CRecentlyAddedJob::UpdateMusic() - Running RecentlyAdded home screen update
23:11:42 T:3144 DEBUG: ------ Window Init (Pointer.xml) ------
23:11:42 T:1492 DEBUG: GetRecentlyAddedAlbumSongs() query: SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
23:11:42 T:1492 DEBUG: CMusicDatabase::GetRecentlyAddedAlbums query: select * from albumview order by idAlbum desc limit 10
23:11:42 T:1492 DEBUG: CRecentlyAddedJob::UpdateVideos() - Running RecentlyAdded home screen update
23:11:42 T:1492 DEBUG: CVideoDatabase::RunQuery took 1 ms for 0 items query: select * from movieview order by idMovie desc limit 10
23:11:42 T:1492 DEBUG: CVideoDatabase::RunQuery took 1 ms for 0 items query: select * from episodeview order by idEpisode desc limit 10
23:11:42 T:1492 DEBUG: CVideoDatabase::GetMusicVideosByWhere query = select * from musicvideoview order by idMVideo desc limit 10
23:11:42 T:1492 DEBUG: CVideoDatabase::GetMusicVideosByWhere time for actual SQL query = 2
23:11:42 T:1492 DEBUG: CRecentlyAddedJob::UpdateTotal() - Running RecentlyAdded home screen update
23:11:44 T:3144 DEBUG: CApplication:
rocessMouse: trying mouse action leftclick
23:11:44 T:3144 DEBUG: CApplication::ExecuteXBMCAction : Translating ActivateWindow(ShutdownMenu)
23:11:44 T:3144 DEBUG: CApplication::ExecuteXBMCAction : To ActivateWindow(ShutdownMenu)
23:11:44 T:3144 DEBUG: Activating window ID: 10111
23:11:44 T:3144 DEBUG: ------ Window Init (DialogButtonMenu.xml) ------
23:11:44 T:3144 INFO: Loading skin file: DialogButtonMenu.xml
23:11:44 T:3144 DEBUG: CApplication::ExecuteXBMCAction : Translating down
23:11:44 T:3144 DEBUG: CApplication::ExecuteXBMCAction : To down
23:11:46 T:3144 DEBUG: CApplication:
rocessMouse: trying mouse action leftclick
23:11:46 T:3144 DEBUG: CApplication::ExecuteXBMCAction : Translating XBMC.Quit()
23:11:46 T:3144 DEBUG: CApplication::ExecuteXBMCAction : To XBMC.Quit()
23:11:46 T:3144 DEBUG: CAnnouncementManager - Announcement: OnQuit from xbmc
23:11:46 T:3144 DEBUG: GOT ANNOUNCEMENT, type: 4, from xbmc, message OnQuit
23:11:46 T:732 DEBUG: Thread Jobworker 732 terminating (autodelete)