tvguide.xml already importing - but it isn't (1 Viewer)

[Helidath]

Went from 1.2.0 beta to 1.2.0 RC and now I am having the same issue; stuck on ' tvguide.xml, already importing... '

I went back and reinstalled mc2xml, remapped everything, dled a new tvguide.xml, all to no avail. Had no problem until now. Any ideas? same issue as above?

 

[mm1352000]

Hi Helidath

I'd say post the XML file along with logs (use the watchdog with option 3), else we'd just be guessing.

mm

 

[Helidath]

MM,
Here are the logs and xml file.

View attachment 88650

View attachment 88651

Shoulda posted em with my original ?. Sorry!

 

[mm1352000]

Hi Helidath

Looks to me like the program table in your database is the problem:

2011-09-12 22:06:37.774875 [MPMain(1)]: BusinessLayer: GetProgramsForAllChannels caused an Exception - Table '.\mptvdb\program' is marked as crashed and should be repaired, at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at TvDatabase.TvBusinessLayer.GetProgramsForAllChannels(DateTime startTime, DateTime endTime, List`1 channelList)

Let's fix that for a start and then see if it has resolved the issue. To fix it:

1. Open a terminal (AKA command line) on your TV Server PC by clicking start, type "cmd", hit enter.
2. Type cd C:\Program Files\MySQL\MySQL Server 5.1\bin (this should be the path to the bin subdirectory within your MySQL install folder) and hit return/enter.
3. Type mysqlcheck mptvdb --auto-repair -e -u root -p, and hit return/enter.
4. A password prompt should appear. The default password is MediaPortal (case sensitive).
5. Done - try an XMLTV import.

mm

 

[Helidath]

THANKS! MM your the man!

Worked, I now see the shows in the guide within MediaPortal as before. Only strange thing is that in the tv server config it still says
'tvguide.xml, already importing... ' but it's working fine within MediaPortal itself.

Thanks again, I really appreciate it. Was getting worried with fall shows about to start!

 

[hassegubben]

Many thanks. This solved my problem as well!