cannot add channels (using 150mce) (1 Viewer)

jjnz1

Portal Member
May 31, 2005
5
0
Area: Media Portal Program
MediaPortal Version: 0.2.0.0 RC2 (2006-01-28)
MediaPortal Skin: Project X
Windows Version: Windows XP (SP2)
.NET CLR Version: 2.0.50727
DirectX Version: 4.09.00.0904 (9.0c)
Audio Codec: InterVideo Audio Decoder
Video Codec: InterVideo Video Decoder
CPU Type: AMD Athlon XP 2500+
Memory: 511 MB
Motherboard: A7V600 (ASUSTeK Computer INC.)
TV Card Model: hauppague 150mce
TV Card Type: Hardware
TV Card Driver: 2.0.30.23074
Video Card Model: Nvidia Geforce 6600 (256 MB)
Video Card Driver: 7.8.0.1
Video Card Resolution: 1024x768
Video Render Type: VMR9
Audio Card Model: Creative EMU10K1 Audio Processor (WDM)
Audio Card Driver: 5.12.2.290
Synopsis::

Everytime i try and add a tv channel using configure.exe, i go through the process of entering in the tv station info and click ok but i cant seem to get the channel info to stay on the screen. even if i click add epg channels it comes back saying added 6 channels 900 programs but there is still no channel info on the screen.
same if i try and autotune. it says it found a channel, i click add as new channel enter the info and stil nothing comes up in the channel list..

this is my error.log file to date..

1/29/2006 12:54:25 PM SQL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: grabEpg query:ALTER TABLE channel ADD COLUMN grabEpg Integer
1/29/2006 12:54:25 PM TVDatabase exception err:confused:QL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: grabEpg query:ALTER TABLE channel ADD COLUMN grabEpg Integer stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.TV.Database.TVDatabase.UpdateFromPreviousVersion()
at MediaPortal.TV.Database.TVDatabase.Open()
1/29/2006 12:54:25 PM SQL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:no such column: channel.epgLastUpdate query:select channel.idChannel,channel.iChannelNr,channel.frequency,channel.strChannel,channel.bExternal,channel.Visible,channel.scrambled,channel.ExternalChannel,channel.standard,channel.Country,channel.iSort,tblDVBCMapping.strProvider,tblDVBSMapping.sProviderName,tblDVBTMapping.strProvider,tblATSCMapping.strProvider,channel.grabEpg,channel.epgHours,channel.epgLastUpdate from channel left join tblDVBCMapping on tblDVBCMapping.iLCN=channel.idChannel left join tblDVBTMapping on tblDVBTMapping.iLCN=channel.idChannel left join tblDVBSMapping on tblDVBSMapping.idChannel=channel.idChannel left join tblATSCMapping on tblATSCMapping.iLCN=channel.idChannel order by tblDVBCMapping.strProvider, tblDVBTMapping.strProvider, tblDVBSMapping.sProviderName, tblATSCMapping.strProvider,channel.strChannel
1/29/2006 12:54:25 PM TVDatabase exception err:confused:QL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:no such column: channel.epgLastUpdate query:select channel.idChannel,channel.iChannelNr,channel.frequency,channel.strChannel,channel.bExternal,channel.Visible,channel.scrambled,channel.ExternalChannel,channel.standard,channel.Country,channel.iSort,tblDVBCMapping.strProvider,tblDVBSMapping.sProviderName,tblDVBTMapping.strProvider,tblATSCMapping.strProvider,channel.grabEpg,channel.epgHours,channel.epgLastUpdate from channel left join tblDVBCMapping on tblDVBCMapping.iLCN=channel.idChannel left join tblDVBTMapping on tblDVBTMapping.iLCN=channel.idChannel left join tblDVBSMapping on tblDVBSMapping.idChannel=channel.idChannel left join tblATSCMapping on tblATSCMapping.iLCN=channel.idChannel order by tblDVBCMapping.strProvider, tblDVBTMapping.strProvider, tblDVBSMapping.sProviderName, tblATSCMapping.strProvider,channel.strChannel stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.TV.Database.TVDatabase.GetChannelsByProvider(ArrayList& channels)
1/29/2006 12:54:25 PM SQL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: grabEpg query:ALTER TABLE channel ADD COLUMN grabEpg Integer
1/29/2006 12:54:25 PM TVDatabase exception err:confused:QL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: grabEpg query:ALTER TABLE channel ADD COLUMN grabEpg Integer stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.TV.Database.TVDatabase.UpdateFromPreviousVersion()
at MediaPortal.TV.Database.TVDatabase.Open()
1/29/2006 12:54:25 PM SQL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:no such column: channel.epgLastUpdate query:select channel.idChannel,channel.iChannelNr,channel.frequency,channel.strChannel,channel.bExternal,channel.Visible,channel.scrambled,channel.ExternalChannel,channel.standard,channel.Country,channel.iSort,tblDVBCMapping.strProvider,tblDVBSMapping.sProviderName,tblDVBTMapping.strProvider,tblATSCMapping.strProvider,channel.grabEpg,channel.epgHours,channel.epgLastUpdate from channel left join tblDVBCMapping on tblDVBCMapping.iLCN=channel.idChannel left join tblDVBTMapping on tblDVBTMapping.iLCN=channel.idChannel left join tblDVBSMapping on tblDVBSMapping.idChannel=channel.idChannel left join tblATSCMapping on tblATSCMapping.iLCN=channel.idChannel order by tblDVBCMapping.strProvider, tblDVBTMapping.strProvider, tblDVBSMapping.sProviderName, tblATSCMapping.strProvider,channel.strChannel
1/29/2006 12:54:25 PM TVDatabase exception err:confused:QL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:no such column: channel.epgLastUpdate query:select channel.idChannel,channel.iChannelNr,channel.frequency,channel.strChannel,channel.bExternal,channel.Visible,channel.scrambled,channel.ExternalChannel,channel.standard,channel.Country,channel.iSort,tblDVBCMapping.strProvider,tblDVBSMapping.sProviderName,tblDVBTMapping.strProvider,tblATSCMapping.strProvider,channel.grabEpg,channel.epgHours,channel.epgLastUpdate from channel left join tblDVBCMapping on tblDVBCMapping.iLCN=channel.idChannel left join tblDVBTMapping on tblDVBTMapping.iLCN=channel.idChannel left join tblDVBSMapping on tblDVBSMapping.idChannel=channel.idChannel left join tblATSCMapping on tblATSCMapping.iLCN=channel.idChannel order by tblDVBCMapping.strProvider, tblDVBTMapping.strProvider, tblDVBSMapping.sProviderName, tblATSCMapping.strProvider,channel.strChannel stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.TV.Database.TVDatabase.GetChannelsByProvider(ArrayList& channels)
1/29/2006 12:54:25 PM SQL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: grabEpg query:ALTER TABLE channel ADD COLUMN grabEpg Integer
1/29/2006 12:54:25 PM TVDatabase exception err:confused:QL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: grabEpg query:ALTER TABLE channel ADD COLUMN grabEpg Integer stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.TV.Database.TVDatabase.UpdateFromPreviousVersion()
at MediaPortal.TV.Database.TVDatabase.Open()
1/29/2006 12:54:51 PM failed filter:ffdshow raw video filter not found
1/29/2006 12:54:51 PM failed filter:ffdshow raw video filter not fo

and this is a section of my mediaportal.log

1/29/2006 12:54:25 PM AddTable: tblEPGMapping
1/29/2006 12:54:25 PM SQL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: grabEpg query:ALTER TABLE channel ADD COLUMN grabEpg Integer
1/29/2006 12:54:25 PM TVDatabase exception err:confused:QL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:duplicate column name: grabEpg query:ALTER TABLE channel ADD COLUMN grabEpg Integer stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.TV.Database.TVDatabase.UpdateFromPreviousVersion()
at MediaPortal.TV.Database.TVDatabase.Open()
1/29/2006 12:54:25 PM tvdatabase opened
1/29/2006 12:54:25 PM video device moniker :mad:device:pnp:\\?\pci#ven_4444&dev_0016&subsys_88010070&rev_01#3&61aaa01&0&58#{65e8773d-8f56-11d0-a3b9-00a0c9223196}\{9b365890-165f-11d0-a195-0020afd156e4}
1/29/2006 12:54:25 PM captureDeviceDeviceName:mad:device:pnp:\\?\pci#ven_4444&dev_0016&subsys_88010070&rev_01#3&61aaa01&0&58
1/29/2006 12:54:25 PM FindInstance:mad:device:pnp:\\?\pci#ven_4444&dev_0016&subsys_88010070&rev_01#3&61aaa01&0&58
1/29/2006 12:54:25 PM key:confused:YSTEM\CurrentControlSet\Enum\pci\ven_4444&dev_0016&subsys_88010070&rev_01\3&61aaa01&0&58
1/29/2006 12:54:25 PM serviceName:hcwPP2
1/29/2006 12:54:25 PM key:confused:YSTEM\CurrentControlSet\Services\hcwPP2\Enum
1/29/2006 12:54:25 PM Number of cards:1
1/29/2006 12:54:25 PM card#0=PCI#VEN_4444&DEV_0016&SUBSYS_88010070&REV_01#3&61aaa01&0&58
1/29/2006 12:54:25 PM using card:#0
1/29/2006 12:54:25 PM Using card#0
1/29/2006 12:54:25 PM filter tvtuner='Hauppauge WinTV PVR PCI II TvTuner' check:True
1/29/2006 12:54:25 PM filter tvaudio='Hauppauge WinTV PVR PCI II TvAudio' check:True
1/29/2006 12:54:25 PM filter crossbar='Hauppauge WinTV PVR PCI II Crossbar' check:True
1/29/2006 12:54:25 PM filter capture='Hauppauge WinTV PVR PCI II Capture' check:True
1/29/2006 12:54:25 PM filter encoder='Hauppauge WinTV PVR PCI II Encoder' check:True
1/29/2006 12:54:25 PM LoadSectionSettings() done
1/29/2006 12:54:25 PM Load settings:TV Channel Groups
1/29/2006 12:54:25 PM LoadSectionSettings()
1/29/2006 12:54:25 PM SQL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:no such column: channel.epgLastUpdate query:select channel.idChannel,channel.iChannelNr,channel.frequency,channel.strChannel,channel.bExternal,channel.Visible,channel.scrambled,channel.ExternalChannel,channel.standard,channel.Country,channel.iSort,tblDVBCMapping.strProvider,tblDVBSMapping.sProviderName,tblDVBTMapping.strProvider,tblATSCMapping.strProvider,channel.grabEpg,channel.epgHours,channel.epgLastUpdate from channel left join tblDVBCMapping on tblDVBCMapping.iLCN=channel.idChannel left join tblDVBTMapping on tblDVBTMapping.iLCN=channel.idChannel left join tblDVBSMapping on tblDVBSMapping.idChannel=channel.idChannel left join tblATSCMapping on tblATSCMapping.iLCN=channel.idChannel order by tblDVBCMapping.strProvider, tblDVBTMapping.strProvider, tblDVBSMapping.sProviderName, tblATSCMapping.strProvider,channel.strChannel
1/29/2006 12:54:25 PM TVDatabase exception err:confused:QL:TVDatabaseV21.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:no such column: channel.epgLastUpdate query:select channel.idChannel,channel.iChannelNr,channel.frequency,channel.strChannel,channel.bExternal,channel.Visible,channel.scrambled,channel.ExternalChannel,channel.standard,channel.Country,channel.iSort,tblDVBCMapping.strProvider,tblDVBSMapping.sProviderName,tblDVBTMapping.strProvider,tblATSCMapping.strProvider,channel.grabEpg,channel.epgHours,channel.epgLastUpdate from channel left join tblDVBCMapping on tblDVBCMapping.iLCN=channel.idChannel left join tblDVBTMapping on tblDVBTMapping.iLCN=channel.idChannel left join tblDVBSMapping on tblDVBSMapping.idChannel=channel.idChannel left join tblATSCMapping on tblATSCMapping.iLCN=channel.idChannel order by tblDVBCMapping.strProvider, tblDVBTMapping.strProvider, tblDVBSMapping.sProviderName, tblATSCMapping.strProvider,channel.strChannel stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.TV.Database.TVDatabase.GetChannelsByProvider(ArrayList& channels)
1/29/2006 12:54:25 PM opening tvdatabase
1/29/2006 12:54:25 PM AddTable: tblversion
1/29/2006 12:54:25 PM AddTable: channel
1/29/2006 12:54:25 PM AddTable: tblPrograms
1/29/2006 12:54:25 PM AddTable: genre
1/29/2006 12:54:25 PM AddTable: recording
1/29/2006 12:54:25 PM AddTable: canceledseries
 

FlipGer

Retired Team Member
  • Premium Supporter
  • April 27, 2004
    2,658
    115
    47
    Leipzig, Germany
    Home Country
    Germany Germany
    Hi,

    had this also once. When using a CVS the UpdateFromPreviousVersion() function fails.

    Please try the following:
    - goto /Team Media Portal/MediaPortal/docs/
    - run SQLite Database Browser
    - open /MedaiaPortal/database/TVDatabaseV21.db3
    - goto "Browse Data"
    - select "tblversion" (should be automaticaly the first)
    - increase "idVersion" by one. Eg. from 5 to 6 by doubleclicking the value
    - "Apply Changes"
    - save and close

    Run Configure again.

    HTH, Flip.
     

    Users who are viewing this thread

    Top Bottom