[egonzalez]

Hi guys,

I don't know where to look for a solution... need a hand here!


From the main menu i select the TV SERIES submenu and I get the list of all the TV Series I have and on the right I get the number of episodes... when I select one of them I go in and don't see any episodes there just the .. to go back.
This is happening with all my 27 TV Series.

I'm sure my library contains the tv series and episodes, I just checked in the DB....
Any ideas here?

Code:

sqlite> select * from episode where idShow=1;
idEpisode = 1
   idFile = 372
      c00 = Rites of Passage
      c01 = In 8th century Scandinavia, Ragnar Lothbrok is a warrior and a farmer who dreams of finding riches by bucking the tradition of raiding to the east. Ragnar has been working in secret on a project that will turn the Viking world on its head. But first Ragnar must convince the leader of his community, the powerful Earl Haraldson, who is none too happy to share in the renown that this journey could bring to Ragnar if it's successful.
      c02 =
      c03 = 7.600000
      c04 = Michael Hirst
      c05 = 2013-03-03
      c06 = <thumb>http://thetvdb.com/banners/episodes/260449/4383243.jpg</thumb>
      c07 =
      c08 =
      c09 = 2700
      c10 = Johan Renck
      c11 =
      c12 = 1
      c13 = 1
      c14 =
      c15 = -1
      c16 = -1
      c17 = -1
      c18 = /home/pot/smb/Serie TV/Vikings/Vikings.S01E01.iTALiAN.SUBBED.HDTV.XviD-GaNNiCO.avi
      c19 = 156
      c20 = 4383243
      c21 =
      c22 =
      c23 =
   idShow = 1

idEpisode = 2
......

[artrafael]

Welcome to the XBMC forums.

Have you already watched these episodes? If so, open the slide-out menu on the left while on the list of your TV series and verify the "Hide watched" option is not enabled (i.e., the radio button for this option should be grey).

[ddeeds]

The issue is with XBMC and sqlite 3.8.1 (which was just updated in Arch a few days ago).

There are two different methods to fix the problem:

HOW-TO:Share libraries using MySQL

Or...

1. Install downgrade from AUR.

2. Stop XBMC

Code:

systemctl stop xbmc.service

3. Enter the following command:

Code:

downgrade sqlite

4. Select sqlite-3.8.0.2-1-x86_64.pkg.tar.xz

5. Restart XBMC

Code:

systemctl start xbmc.service

[egonzalez]

ddeeds your post made the magic...

I'm running arch arm on a raspberry b so I couldn't use the downgrade tool successfully..

So after few google help I solved like this... posting in case someone else has the same problem.



Get the package from here:

sqlite-3.8.0.2-1-armv6h.pkg.tar.xz

on your rasp do the following:

Code:

#pacman -U sqlite-3.8.0.2-1-armv6h.pkg.tar.xz

Ad the following string to your ignore list on pacman.conf or create it:

Code:

IgnorePkg   = sqlite

In this way you won't get the updates for that package:

Code:

# pacman -Suy
:: Synchronizing package databases...
core is up to date
extra is up to date
community is up to date
alarm is up to date
aur is up to date
:: Starting full system upgrade...
warning: sqlite: ignoring package upgrade (3.8.0.2-1 => 3.8.1-1)
there is nothing to do