[LRGM]

Hi all,

I have been unable to scrape a few recent additions to my TV library, and after doing a bit of research on here I can see I have a corrupt db.

The part from the log that is concerning me as follows

15:20:59 T:144547840 DEBUG: GetVideoDetails: Reading episode 'http://thetvdb.com/api/1D62F2F90030C444/series/74582/all/en.zip' using The TVDB scraper (file: '/var/mobile/Library/Preferences/XBMC/addons/metadata.tvdb.com', content: 'tvshows', version: '1.5.2')
15:21:00 T:144547840 DEBUG: scraper: GetEpisodeDetails returned <?xml version="1.0" encoding="utf-8" standalone="yes"?><details><uniqueid>148870</uniqueid><plot>April O'Neil, ace reporter for Channel 6, investigates recent break-ins, allegedly by Ninjas, which have resulted in the thefts of numerous technologies, however, a chance encounter with a gang of theives soon leads her to a bigger story when she is saved from the criminals by four Ninja trained, mutated Turtles.

The Turtles take April back to their lair, and, after getting better acquainted, April learns they are good hearted mutants, they decide to investigate the thefts together, and their efforts lead them into an encounter with the mysterious ninjas, The Foot Clan, and thier leader, Shredder</plot><credits>Patti Howeth</credits><credits>David Wise</credits><director>Yoshikatsu Kasai</director><actor><name>Cam Clarke</name></actor><actor><name>Jennifer Darling</name></actor><actor><name>Pat Fraley</name></actor><title>Turtle Tracks</title><season>1</season><episode>1</episode><thumb>http://thetvdb.com/banners/episodes/74582/148870.jpg</thumb><aired>1987-12-10</aired><rating>9.0</rating><runtime>30</runtime></details>
15:21:00 T:144547840 DEBUG: VideoInfoScanner: Adding new item to tvshowsmb://NAS/Kids_TV/Teenage Mutant Ninja Turtles/Season 1/Teenage Mutant Ninja Turtles (1987).S01E01.Turtle Tracks.mp4
15:21:00 T:144547840 ERROR: SQL: The database disk image is malformed
Query: insert into tvshowlinkepisode (idShow,idEpisode) values (39,221)
15:21:00 T:144547840 ERROR: AddEpisode (smb://NAS/Kids_TV/Teenage Mutant Ninja Turtles/Season 1/Teenage Mutant Ninja Turtles (1987).S01E01.Turtle Tracks.mp4) failed
15:21:00 T:144547840 DEBUG: GetEpisodeId (smb://NAS/Kids_TV/Teenage Mutant Ninja Turtles/Season 1/Teenage Mutant Ninja Turtles (1987).S01E01.Turtle Tracks.mp4), query = select idEpisode from episode where idFile=1088
15:21:00 T:144547840 DEBUG: CAnnouncementManager - Announcement: OnRemove from xbmc
15:21:00 T:144547840 DEBUG: GOT ANNOUNCEMENT, type: 8, from xbmc, message OnRemove
15:21:00 T:144547840 ERROR: SQL: The database disk image is malformed
Query: insert into tvshowlinkepisode (idShow,idEpisode) values (39,221)
15:21:00 T:144547840 ERROR: AddEpisode (smb://NAS/Kids_TV/Teenage Mutant Ninja Turtles/Season 1/Teenage Mutant Ninja Turtles (1987).S01E01.Turtle Tracks.mp4) failed

Could someone clarify that if I wipe the db it will only wipe it for this profile, not the other 3 I have on the same installation and then please point me in the direction for some instructions on what to do to wipe the db, just the file locations and the like.

Additionally, I looked through the log and was intrigued to note that it has the user name and password for a password protected folder on my NAS (where I stash the gash) when it obvioulsy never been used in the "kids" profile - can anyone offer any insight please?

http://pastebin.com/8AwwzNGi

Thank you in advance

[Ned Scott]

userdata/profiles/PROFILENAME/databases/ Nuke the MyVideo DB ones for the profile you want.

Make sure to shut down the pi correctly, using a shutdown command, and not just disconnecting the power. This is the main reason why these corruptions happen.

[LRGM]

Although a frustrating solution, it forced me to have a clean out and get a few niggly items scraped correctly.

Thanks.