No more TV data available? (1 Viewer)

[pbb]

I noticed today, that the TV Guide in MediaPortal says "No data available" for all channels! Only a few programs that started yesterday before midnight and continued into today, are shown. (I cannot scroll further back than midnight.)

I've re-run WebEPG.exe manually, and the produced TVguide.xml (in the xmltv directory) looks ok, following is one program item:

  <programme start="20070326170000" stop="20070326180000" channel="animalplanet.com">
    <title>Dyrepolitiet i Houston (22)</title>
    <desc>Dokumentarserie. Vi følger dyrepolitiet i Houston, Texas som jobber med å bekjempe og forhindre dyremishandling.</desc>
    <episode-num>22</episode-num>
  </programme>

But the programs from the TVguide.xml don't show up in the TV Guide. The weird thing is even, the ones that do show up in TV Guide (the ones around last midnight) aren't in the xml file!

Does this mean TV Guide keeps yet another file for maintaining the program infos? And that this file might be corrupt?

I am using MP SVN 12802 (MP needs an "About" box, idiocy of having to re-start MP and check a transparent box that automatically disappears again to see the version number...), and the \WebEPG\Grabbers\NO\2-fredag_dagbladet_no.xml grabber.

I even tried one of the Swedish grabbers for the Swedish channels, but no change. The TVguide.xml updates nicely, but there is no change in the TV Guide inside MP.

Any ideas what can be wrong?

UPDATE:

This is really weird! Now I opened TV Guide while TVGuide.xml was just updated, and I slowly see the channel information being filled. (That is, while scrolling back and forth through the channel list, more and more channels show program info.) And all of a sudden, all channels show "No data available" again! This does support my suspicion of a corruption somewhere, but how can I find out? The xml file loads fine in Internet Explorer and Firefox, so you would think it is valid...

 

[pbb]

Any ideas anyone? MediaPortal now even seems to crash when I open the TV Guide.

From MediaPortal.log:

2007-03-28 23:40:09.593750 [Info.][MPMain]: window:MediaPortal.GUI.TV.GUITVGuide init
2007-03-28 23:40:09.843750 [Info.][MPMain]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from channel,tblPrograms,genre where genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'TV2 Zebra'  and ( (tblPrograms.iEndTime>='20070328233000' and tblPrograms.iEndTime <='20070329012900')  or (tblPrograms.iStartTime>='20070328233000' and tblPrograms.iStartTime <= '20070329012900' )  or (tblPrograms.iStartTime<='20070328233000' and tblPrograms.iEndTime >= '20070329012900') ) order by iStartTime
2007-03-28 23:40:09.843750 [Info.][MPMain]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from channel,tblPrograms,genre where genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'TV2 Zebra'  and ( (tblPrograms.iEndTime>='20070328233000' and tblPrograms.iEndTime <='20070329012900')  or (tblPrograms.iStartTime>='20070328233000' and tblPrograms.iStartTime <= '20070329012900' )  or (tblPrograms.iStartTime<='20070328233000' and tblPrograms.iEndTime >= '20070329012900') ) order by iStartTime stack:   at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
   at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)
   at SQLite.NET.SQLiteClient.Execute(String query)
   at MediaPortal.TV.Database.TVDatabase.GetProgramsPerChannel(String strChannel1, Int64 iStartTime, Int64 iEndTime, List`1& progs) select * from channel,tblPrograms,genre where genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'TV2 Zebra'  and ( (tblPrograms.iEndTime>='20070328233000' and tblPrograms.iEndTime <='20070329012900')  or (tblPrograms.iStartTime>='20070328233000' and tblPrograms.iStartTime <= '20070329012900' )  or (tblPrograms.iStartTime<='20070328233000' and tblPrograms.iEndTime >= '20070329012900') ) order by iStartTime
2007-03-28 23:40:09.843750 [Info.][MPMain]: opening tvdatabase
2007-03-28 23:40:14.781250 [Info.][2]: dbs:close:TVDatabaseV21.db3

 

[NickName]

Hi pbb,

Try opening the configuration program and going to the TV guide section. Click the button labeled something like "Remove all programs from database".
When you reopen the TV guide in Mediaportal it will automatically load the new data and that should be all fixed.

Hope that helps,

Nick Name.

 

[pbb]

Thanks for the suggestion, I hadn't thought about that option!
However, it didn't help, the config program freezes when I try that. Over the course of 10 minutes, alternating the processor is being maxed out, the programs starts consuming up to 800 MB of memory, and the harddisk is maxed outcausing all other programs to also freeze...

Here's a snippet from Configuration.log:

2007-03-31 16:21:21.875000 [Info.][Config Main]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete frm tblPrograms
2007-03-31 16:21:21.875000 [ERROR][Config Main]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete frm tblPrograms
2007-03-31 16:21:21.984375 [Info.][Config Main]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete frm tblPrograms stack:   at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
   at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)
   at SQLite.NET.SQLiteClient.Execute(String query)
   at MediaPortal.TV.Database.TVDatabase.RemovePrograms()
2007-03-31 16:21:21.984375 [ERROR][Config Main]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete frm tblPrograms stack:   at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
   at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)
   at SQLite.NET.SQLiteClient.Execute(String query)
   at MediaPortal.TV.Database.TVDatabase.RemovePrograms()
2007-03-31 16:21:21.984375 [Info.][Config Main]: opening tvdatabase
2007-03-31 16:21:22.640625 [Info.][2]: dbs:close:TVDatabaseV21.db3

Clearly something wrong with the database....

Ah, and my program database is not only thing wrong I see -- this forum here gets an error 500 (Internal Server Error) whenever I write the words "delete" and "from" after eachother! Can you image that? That is why my log mentions the weird "delete frm"... That should be "from"...