home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
General Support
TV Recordings Database trashed (MP1.4 recordings list is empty)
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Tim Sherrill" data-source="post: 1023521" data-attributes="member: 140267"><p><span style="font-family: 'courier new'"><span style="font-family: 'tahoma'">That did find a problem in the recording table, but I still don't get any recordings listed.</span> </span></p><p> </p><p><span style="font-family: 'courier new'">C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqlcheck mptvdb --auto-repair -e -</span></p><p><span style="font-family: 'courier new'">u root -p</span></p><p><span style="font-family: 'courier new'">Enter password: ***********</span></p><p><span style="font-family: 'courier new'">mptvdb.canceledschedule OK</span></p><p><span style="font-family: 'courier new'">mptvdb.card OK</span></p><p><span style="font-family: 'courier new'">mptvdb.cardgroup OK</span></p><p><span style="font-family: 'courier new'">mptvdb.cardgroupmap OK</span></p><p><span style="font-family: 'courier new'">mptvdb.channel OK</span></p><p><span style="font-family: 'courier new'">mptvdb.channelgroup OK</span></p><p><span style="font-family: 'courier new'">mptvdb.channellinkagemap OK</span></p><p><span style="font-family: 'courier new'">mptvdb.channelmap OK</span></p><p><span style="font-family: 'courier new'">mptvdb.conflict OK</span></p><p><span style="font-family: 'courier new'">mptvdb.diseqcmotor OK</span></p><p><span style="font-family: 'courier new'">mptvdb.favorite OK</span></p><p><span style="font-family: 'courier new'">mptvdb.groupmap OK</span></p><p><span style="font-family: 'courier new'">mptvdb.history</span></p><p><span style="font-family: 'courier new'">warning : 1 client is using or hasn't closed the table properly</span></p><p><span style="font-family: 'courier new'">status : OK</span></p><p><span style="font-family: 'courier new'">mptvdb.keyword OK</span></p><p><span style="font-family: 'courier new'">mptvdb.keywordmap OK</span></p><p><span style="font-family: 'courier new'">mptvdb.pendingdeletion OK</span></p><p><span style="font-family: 'courier new'">mptvdb.personaltvguidemap OK</span></p><p><span style="font-family: 'courier new'">mptvdb.program OK</span></p><p><span style="font-family: 'courier new'">mptvdb.radiochannelgroup OK</span></p><p><span style="font-family: 'courier new'">mptvdb.radiogroupmap OK</span></p><p><span style="font-family: 'courier new'">mptvdb.recording</span></p><p><span style="font-family: 'courier new'">warning : Table is marked as crashed</span></p><p><span style="font-family: 'courier new'">error : Size of indexfile is: 12288 Should be: 19456</span></p><p><span style="font-family: 'courier new'">error : Size of datafile is: 12060 Should be: 12444</span></p><p><span style="font-family: 'courier new'">error : Corrupt</span></p><p><span style="font-family: 'courier new'">mptvdb.satellite OK</span></p><p><span style="font-family: 'courier new'">mptvdb.schedule OK</span></p><p><span style="font-family: 'courier new'">mptvdb.server OK</span></p><p><span style="font-family: 'courier new'">mptvdb.setting OK</span></p><p><span style="font-family: 'courier new'">mptvdb.softwareencoder OK</span></p><p><span style="font-family: 'courier new'">mptvdb.timespan OK</span></p><p><span style="font-family: 'courier new'">mptvdb.tuningdetail OK</span></p><p><span style="font-family: 'courier new'">mptvdb.tvmoviemapping OK</span></p><p><span style="font-family: 'courier new'">mptvdb.version OK</span></p><p> </p><p><span style="font-family: 'courier new'">Repairing tables</span></p><p><span style="font-family: 'courier new'">mptvdb.recording OK</span></p></blockquote><p></p>
[QUOTE="Tim Sherrill, post: 1023521, member: 140267"] [FONT=courier new][FONT=tahoma]That did find a problem in the recording table, but I still don't get any recordings listed.[/FONT] [/FONT] [FONT=courier new]C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqlcheck mptvdb --auto-repair -e -[/FONT] [FONT=courier new]u root -p[/FONT] [FONT=courier new]Enter password: ***********[/FONT] [FONT=courier new]mptvdb.canceledschedule OK[/FONT] [FONT=courier new]mptvdb.card OK[/FONT] [FONT=courier new]mptvdb.cardgroup OK[/FONT] [FONT=courier new]mptvdb.cardgroupmap OK[/FONT] [FONT=courier new]mptvdb.channel OK[/FONT] [FONT=courier new]mptvdb.channelgroup OK[/FONT] [FONT=courier new]mptvdb.channellinkagemap OK[/FONT] [FONT=courier new]mptvdb.channelmap OK[/FONT] [FONT=courier new]mptvdb.conflict OK[/FONT] [FONT=courier new]mptvdb.diseqcmotor OK[/FONT] [FONT=courier new]mptvdb.favorite OK[/FONT] [FONT=courier new]mptvdb.groupmap OK[/FONT] [FONT=courier new]mptvdb.history[/FONT] [FONT=courier new]warning : 1 client is using or hasn't closed the table properly[/FONT] [FONT=courier new]status : OK[/FONT] [FONT=courier new]mptvdb.keyword OK[/FONT] [FONT=courier new]mptvdb.keywordmap OK[/FONT] [FONT=courier new]mptvdb.pendingdeletion OK[/FONT] [FONT=courier new]mptvdb.personaltvguidemap OK[/FONT] [FONT=courier new]mptvdb.program OK[/FONT] [FONT=courier new]mptvdb.radiochannelgroup OK[/FONT] [FONT=courier new]mptvdb.radiogroupmap OK[/FONT] [FONT=courier new]mptvdb.recording[/FONT] [FONT=courier new]warning : Table is marked as crashed[/FONT] [FONT=courier new]error : Size of indexfile is: 12288 Should be: 19456[/FONT] [FONT=courier new]error : Size of datafile is: 12060 Should be: 12444[/FONT] [FONT=courier new]error : Corrupt[/FONT] [FONT=courier new]mptvdb.satellite OK[/FONT] [FONT=courier new]mptvdb.schedule OK[/FONT] [FONT=courier new]mptvdb.server OK[/FONT] [FONT=courier new]mptvdb.setting OK[/FONT] [FONT=courier new]mptvdb.softwareencoder OK[/FONT] [FONT=courier new]mptvdb.timespan OK[/FONT] [FONT=courier new]mptvdb.tuningdetail OK[/FONT] [FONT=courier new]mptvdb.tvmoviemapping OK[/FONT] [FONT=courier new]mptvdb.version OK[/FONT] [FONT=courier new] [/FONT] [FONT=courier new]Repairing tables[/FONT] [FONT=courier new]mptvdb.recording OK[/FONT] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
TV Recordings Database trashed (MP1.4 recordings list is empty)
Contact us
RSS
Top
Bottom