Mysql Database import problem
Teuf92
Newbie
Posts: 2
#1
2010-08-28, 23:50
Hi all,

i'm using xbmc-r33240-Dharma and i got an issue with mysql database import .
In fact,

after playing with the advancedsettings.xml and adding sources, the scan start normally.
But , at the end , i've no items in the librairy, if i look on my mysql server i can see the xbmc_video database created , but only the table path is filled .
The log of xbmc figured some errors while importing .
for each movie i got those lines :

23:31:43 T:3880 M:4294967295 ERROR: SQL: The table does not exist
Query: select idFile from files where strFileName like 'ALICE au pays des merveilles FRENCH DVDRIP.avi' and idPath=281
23:31:43 T:3880 M:4294967295 ERROR: CVideoDatabase::GetFileId (smb://QNAPSERVER/# Movies/Movies [LD]/Alice au pays des merveilles/ALICE au pays des merveilles FRENCH DVDRIP.avi) failed
23:31:43 T:3880 M:4294967295 ERROR: SQL: The table does not exist
Query: select idFile from files where strFileName like 'ALICE au pays des merveilles FRENCH DVDRIP.avi' and idPath=281
23:31:43 T:3880 M:4294967295 ERROR: CVideoDatabase::GetFileId (smb://QNAPSERVER/# Movies/Movies [LD]/Alice au pays des merveilles/ALICE au pays des merveilles FRENCH DVDRIP.avi) failed
23:31:43 T:3880 M:4294967295 ERROR: SQL: The table does not exist
Query: select idFile from files where strFileName like 'ALICE au pays des merveilles FRENCH DVDRIP.avi' and idPath=281
23:31:43 T:3880 M:4294967295 ERROR: CVideoDatabase::GetFileId (smb://QNAPSERVER/# Movies/Movies [LD]/Alice au pays des merveilles/ALICE au pays des merveilles FRENCH DVDRIP.avi) failed
23:31:43 T:3880 M:4294967295 ERROR: SQL: The table does not exist
Query: select idFile from files where strFileName like 'ALICE au pays des merveilles FRENCH DVDRIP.avi' and idPath=281
23:31:43 T:3880 M:4294967295 ERROR: CVideoDatabase::AddFile unable to addfile ()
23:31:43 T:3880 M:4294967295 ERROR: SQL: The table does not exist
Query: select count(1) from tvshow
23:31:43 T:3880 M:4294967295 ERROR: CVideoDatabase::HasContent failed
23:31:43 T:3880 M:4294967295 ERROR: SQL: The table does not exist
Query: select count(1) from musicvideo
23:31:43 T:3880 M:4294967295 ERROR: CVideoDatabase::HasContent failed
23:31:43 T:3880 M:4294967295 ERROR: SQL: The table does not exist


did i made a mistake while configuring xbmc ?

thanks in advance for any help

Chris
Find
Reply
ZOiD
Junior Member
Posts: 13
#2
2010-08-30, 13:47
Quote:did i made a mistake while configuring xbmc ?
How did you configure your xbmc?
As you can see, there are some tables missing in the db.
Find
Reply
l2obban
Junior Member
Posts: 11
#3
2010-08-30, 22:47
I have the exact same problem, have tried some different nightly builds but can't make it work. Have also tried to delete the database and made xbmc remake the db, no difference. But nightly builds are nightly builds..
Find
Reply
jmarshall
Team-XBMC Developer
Posts: 26,215
#4
2010-08-30, 23:10
There'll be other errors way before then. I suggest removing the database and regenerating it.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.

Image
Find
Reply
charrua
Senior Member
Posts: 273
#5
2010-08-31, 22:22
Probably you haven't defined the correct collation in MySQL to begin with...
You can go here for troubleshooting tips and more info about XBMC and MySQL configuration.
Find
Reply
l2obban
Junior Member
Posts: 11
#6
2010-09-01, 19:32
charrua Wrote:Probably you haven't defined the correct collation in MySQL to begin with...
You can go here for troubleshooting tips and more info about XBMC and MySQL configuration.

Setting Latin1 as collation did the trick. Thanks! Smile
Find
Reply
charrua
Senior Member
Posts: 273
#7
2010-09-02, 03:09
l2obban Wrote:Setting Latin1 as collation did the trick. Thanks! Smile
You're welcome. Well done!
Find
Reply
benone
Newbie
Posts: 1
#8
2011-07-23, 15:12
I have exactly the same problem.

Already check my mysql again (both xbmc_video and xbmc_music dbs and all tables are with latin1 and latin1_general_ci).

XBMC seems to build the library but when I access tvshows or movies nothing shows up.

Another strange behavior (for me, at least Blush) is when i go to 'video->files' i can navigate to all files movies and tv shows. On movies, I can play any file, but on tv shows I cannot enter the season XX folder, therefore cannot play any show.

XBMC log keep showing:
Code:
12:06:19 T:1652 M:503156736   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM movieview LIMIT 1
12:06:19 T:1652 M:503156736   ERROR: CDatabase::GetSingleValue - failed to get value 'count(1)' from table 'movieview'
12:06:19 T:1652 M:503173120   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM movieview LIMIT 1
12:06:19 T:1652 M:503173120   ERROR: CDatabase::GetSingleValue - failed to get value 'count(playCount)' from table 'movieview'
12:06:19 T:1652 M:503173120   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM musicvideoview LIMIT 1
12:06:19 T:1652 M:503173120   ERROR: CDatabase::GetSingleValue - failed to get value 'count(1)' from table 'musicvideoview'
12:06:19 T:1652 M:503173120   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM musicvideoview LIMIT 1
12:06:19 T:1652 M:503173120   ERROR: CDatabase::GetSingleValue - failed to get value 'count(playCount)' from table 'musicvideoview'
12:06:19 T:1652 M:503173120   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount) FROM tvshowview LIMIT 1
12:06:19 T:1652 M:503173120   ERROR: CDatabase::GetSingleValue - failed to get value 'sum(watchedcount)' from table 'tvshowview'

and so on for all tables.

For reference, running XBMCSetup-20110719-1c250ec-master on windows 7.
mysql is on my NAS (buffalo linkstation - linux).
Find
Reply

Home
Search
Help
Logout Mark Read Team Forum Stats Members Help
Mysql Database import problem0