2010-04-17, 09:52
charrua Wrote:Probably the errors are due to some SQL queries done from a script that it's trying to select from the tvshow view that doesn't exist in the db anymore. The issue is not related to XBMC MySQL feature, but with the script/s trying to access view/s that no longer exists in the db.
If that is the case it has to be the confluence skin as this is the instant after startup on a clean install.
Seems the import completed but something went wrong. Lots of entry for movies, none for tv and none of the library views work.
Will try to debug.
Edit: tried again and no tv table fo any sort is being created. can someone dump a .sql export of the xbmc_video database for me somewhere for me to compare cause I am thinking it should contain more tables than mine does
Edit2: I dumped the structure quickly here http://pastebin.com/k2iuTbkP you can see nothing tv related at all. from what i can see in the svn there should be tv versions of all the movie tables. confused
Edit3: Special thanks to firnsy. Turns out my choice of UTF-8 char-set was the issue. Changed to Latin1 and the import is going strong. Were a few hours in now estimate perhaps 6 more.
Edit4: well its 7 hours later and boy was I off the mark. re-estimate another 12 hours. not the fastest thing ever