Database Issues [Windows]
#1
it seems to only load one movie and loads tv shows but not episodes for the tv shows,the schemas get created on opening xbmc, here is a section of the debug log. any suggestions to try?

DEBUG: Mysql execute: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'k:\\movies\\','','')
01:13:13 T:348 M:422072320 DEBUG: Mysql execute: insert into files (idFile,idPath,strFileName) values(NULL, 1, '8MM.avi')
01:13:13 T:348 M:422072320 DEBUG: Mysql execute: insert into movie (idMovie, idFile) values (NULL, 1)
01:13:13 T:348 M:422064128 DEBUG: Mysql execute: insert into actors (idActor, strActor, strThumb) values( NULL, 'Joel Schumacher','')
01:13:13 T:348 M:422055936 DEBUG: Mysql execute: insert into genre (idGenre, strGenre) values( NULL, 'Thriller')
01:13:13 T:348 M:422043648 DEBUG: Mysql execute: insert into studio (idStudio, strStudio) values( NULL, 'Columbia Pictures Corporation')
01:13:13 T:348 M:422035456 DEBUG: Mysql execute: insert into genrelinkmovie (idGenre,idMovie) values(1,1)
01:13:13 T:348 M:422027264 DEBUG: Mysql execute: insert into directorlinkmovie (idDirector,idMovie) values(1,1)
01:13:13 T:348 M:422019072 DEBUG: Mysql execute: insert into studiolinkmovie (idStudio,idMovie) values(1,1)
01:13:13 T:348 M:422019072 DEBUG: Mysql execute: insert into actors (idActor, strActor, strThumb) values( NULL, 'Andrew Kevin Walker','')
01:13:13 T:348 M:422010880 DEBUG: Mysql execute: insert into writerlinkmovie (idWriter,idMovie) values(2,1)
01:13:13 T:348 M:422010880 DEBUG: Mysql execute: insert into actors (idActor, strActor, strThumb) values( NULL, 'Nicolas Cage','')
01:13:13 T:348 M:421998592 DEBUG: Mysql execute: insert into actorlinkmovie (idActor, idMovie, strRole) values(3,1,'Tom Welles')
01:13:13 T:348 M:421994496 DEBUG: Mysql execute: insert into actors (idActor, strActor, strThumb) values( NULL, 'Joaquin Phoenix','')
01:13:13 T:348 M:421994496 DEBUG: Mysql execute: insert into actorlinkmovie (idActor, idMovie, strRole) values(4,1,'Max California')
01:13:13 T:348 M:421994496 DEBUG: Mysql execute: insert into actors (idActor, strActor, strThumb) values( NULL, 'James Gandolfini','')
01:13:13 T:348 M:421994496 DEBUG: Mysql execute: insert into actorlinkmovie (idActor, idMovie, strRole) values(5,1,'Eddie Poole')
01:13:13 T:348 M:421957632 DEBUG: Mysql execute: update movie set c00='8MM',c01='A small, seemingly innocuous plastic reel of film leads surveillance specialist Tom Welles down an increasingly dark and frightening path. With the help of the streetwise Max, he relentlessly follows a bizarre trail of evidence to determine the fate of a complete stranger. As his work turns into obsession, he drifts farther and farther away from his wife, family and simple life as a small-town PI.',c02='',c03='',c04='7',c05='6.800000',c06='Andrew Kevin Walker',c07='1999',c08='<thumb preview=\"http://hwcdn.themoviedb.org/posters/eea/4bc9209d017a3c57fe00ceea/8mm-mid.jpg\">http://hwcdn.themoviedb.org/posters/eea/4bc9209d017a3c57fe00ceea/8mm-original.jpg</thumb><thumb preview=\"http://hwcdn.themoviedb.org/posters/ef4/4bc920a0017a3c57fe00cef4/8mm-mid.png\">http://hwcdn.themoviedb.org/posters/ef4/4bc920a0017a3c57fe00cef4/8mm-original.png</thumb><thumb preview=\"http://hwcdn.themoviedb.org/posters/084/4cabc2317b9aa1152d000084/8mm-mid.jpg\">http://hwcdn.themoviedb.org/posters/084/4cabc2317b9aa1152d000084/8mm-original.jpg</thumb><thumb preview=\"http://hwcdn.themoviedb.org/posters/eef/4bc9209e017a3c57fe00ceef/8mm-mid.jpg\">http://hwcdn.themoviedb.org/posters/eef/4bc9209e017a3c57fe00ceef/8mm-original.jpg</thumb><thumb preview=\"http://hwcdn.themoviedb.org/posters/2c9/4bed216d017a3c37a10002c9/8mm-mid.jpg\">http://hwcdn.themoviedb.org/posters/2c9/4bed216d017a3c37a10002c9/8mm-original.jpg</thumb><thumb preview=\"http://hwcdn.themoviedb.org/posters/ee5/4bc9209d017a3c57fe00cee5/8mm-mid.jpg\">http://hwcdn.themoviedb.org/posters/ee5/4bc9209d017a3c57fe00cee5/8mm-original.jpg</thumb>',c09='tt0134273',c10='',c11='123',c12='Rated R',c13='0',c14='Thriller',c15='Joel Schumacher',c16='8MM',c17='',c18='Columbia Pictures Corporation',c19='',c20='<fanart><thumb preview=\"http://hwcdn.themoviedb.org/backdrops/ee1/4bc9209d017a3c57fe00cee1/8mm-poster.jpg\">http://hwcdn.themoviedb.org/backdrops/ee1/4bc9209d017a3c57fe00cee1/8mm-original.jpg</thumb><thumb preview=\"http://hwcdn.themoviedb.org/backdrops/edd/4bc9209c017a3c57fe00cedd/8mm-poster.jpg\">http://hwcdn.themoviedb.org/backdrops/edd/4bc9209c017a3c57fe00cedd/8mm-original.jpg</thumb></fanart>',c21='United States of America' where idMovie=1
01:13:13 T:348 M:421937152 DEBUG: Mysql commit transaction
01:13:13 T:348 M:421928960 DEBUG: Mysql execute: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'k:\\movies\\','','')
01:13:13 T:348 M:421928960 ERROR: SQL: Undefined MySQL error: Code (1062)
Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'k:\\movies\\','','')
01:13:13 T:348 M:421912576 ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'k:\\movies\\','',''))
01:13:13 T:348 M:421625856 DEBUG: VideoInfoScanner: Adding new item to movies:k:\movies\100 women.avi
01:13:13 T:348 M:421625856 DEBUG: Mysql Start transaction
01:13:13 T:348 M:421625856 DEBUG: Mysql execute: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'k:\\movies\\','','')
01:13:13 T:348 M:421621760 ERROR: SQL: Undefined MySQL error: Code (1062)
Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'k:\\movies\\','','')
01:13:13 T:348 M:421621760 ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'k:\\movies\\','',''))
01:13:13 T:348 M:421621760 DEBUG: Mysql commit transaction
01:13:13 T:348 M:421646336 DEBUG: Mysql execute: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'k:\\movies\\','','')
01:13:13 T:348 M:421646336 ERROR: SQL: Undefined MySQL error: Code (1062)
Query: insert into path (idPath, strPath, strContent, strScraper) values (NULL,'k:\\movies\\','','')
01:13:13 T:348 M:421642240 ERROR: CVideoDatabase::AddPath unable to addpath (insert into path (idPath, strPath, strContent, strScraper) values (NULL,'k:\\movies\\','',''))
01:13:13 T:348 M:421392384 DEBUG: VideoInfoScanner: Adding new item to movies:k:\movies\A Low Down Dirty Shame.avi
01:13:13 T:348 M:421380096 DEBUG: Mysql Start transaction
Reply

Logout Mark Read Team Forum Stats Members Help
Database Issues [Windows]0