TVEngine3 Snapshot: 08-20-2007 11-30h Revision 15605 (2 Viewers)

MediaPortal-Bot

Worlds greatest bot!
March 26, 2007
3,715
180
Home Country
Germany Germany
General Infos:

Please visit our Wiki-Guide before you try out this engine.
We also provide some tutorial videos which show how to install and configure the TV-Server and TV-Client.

MediaPortal TVEngine3 Capabilities:

- seperate front/backend
- supports multiple frontends
- supports multiple backends (master/slave servers)
- analog/atsc/dvb-c/dvb-s/dvb-t support
- recording to mpeg-2 program stream (.mpg)
- mpeg-2 transport stream timeshifting
- multi tuner support of course
- epg / mhw grabbing right from the DVB stream
- network streaming via rtsp
- teletext grabbing

- ci / cam support for firedtv, twinhan and technotrend
- placeshifting
- TV Movie Clickfinder EPG import


MediaPortal TVEngine3 Requirements:

- latest MediaPortal SVN-Build Wiki-Guide --> Download
- Microsoft SQL Server 2005 Express Edition ---> Download
- additional (but recommened) SQL Server Management Studio Express ---> Download
 

MediaPortal-Bot

Worlds greatest bot!
March 26, 2007
3,715
180
Home Country
Germany Germany
Changelog since last snapshot:

SetupTV 20/08/2007 [11:28:08] gemx added: Fixed creation of MySQL database


===> click here to download <===

This thread is open to everyone to provide feedback for this particular snapshot.
If you found or confirm a bug please still open a single thread with full details in the Bugsection
 

hoppy

Portal Pro
March 10, 2006
65
0
Cambridge, UK
A database upgrade has taken place again and I managed to import an old export.xml and keep my old recordings. I'm using MySQL as there are better tools for backup/restore than in SQl Server as far as I'm concerned.

Firstly, backup the TvLibrary DB using MySQL Administrator (you only need to do this if you want to keep your old recordings).

Make sure you have an export.xml from a previous svn. Install the latest SVN and run the TVServer Configuration and let it nuke your DB.

Open you export.xml in notepad or similar and use the replace all function to replace:

Code:
FreeToAir="True">

With:
Code:
FreeToAir="True" DisplayName="channel">

And:
Code:
FreeToAir="False">

With:
Code:
FreeToAir="False" DisplayName="channel">

Now use the import tool in the TVServer configuration tool. You'll notice that all the channels are called "channel", not good. To fix this you'll need to use the MySQL Query Browser or the SQL Server admin tool to run the following sql on the TvLibrary db:

Code:
update channel set displayname = name

Restart the TVServer configuration tool and you should not have your channels and schedules back. I had to remap my cards to the channels, but this is a dodle compared to re-scanning everything.

To finish off and get your recordings back, open MySQL administrator and click the restore option on the left.
Click "Open a backup file" and open the backup you made at the start.
Click the "Restore Content" tab and then click "Analyze Backup File Content".
Close the dialogue once it has finished and uncheck every table apart from "recording" (quick way is to click TvLibrary at the top, then click recording :))
Now click Start Restore

And that is it :) Your back to where you started from. Don't know if anyone knows SQL Server well enough to explain how to keep the recordings if your using that DB?
 

tontsa

Retired Team Member
  • Premium Supporter
  • April 7, 2007
    108
    17
    Home Country
    Finland Finland
    upgrading from previous tv-server with mysql

    Hi,

    Still the:
    Unable to upgrade database: Value cannot be null. Parameter name: stream

    After you click ok it will proceed to ask if I wanna upgrade the db. Then it's "ok" as in
    you get a fresh start (empty db).

    Also when export.xml format changes and there's attributes added the import shouldn't fail.. instead it
    should default to some safe default values. Or atleast ask user if he really wants to import with missing info.
     

    m.woessner

    Portal Member
    November 8, 2006
    32
    3
    Home Country
    Germany Germany
    Database Upgrade

    Hello,

    how does TVEngineV3 detect that a database upgrade is needed?

    As I see it, the only difference is the new column "DisplayName" in table "Channel".

    It is easy for me to add and populate that using SQL Server Management Studio Express.

    Problem is, I do not know, how I can "tell" TVEngine that no upgrade is needed.

    Where is that information stored?

    Best regards,
    Markus
     

    gemx

    Retired Team Member
  • Premium Supporter
  • October 31, 2006
    1,972
    539
    Home Country
    Germany Germany
    1. Use the last snapshot (the bug should be already solved)
    2. SELET versionNumber FROM version (the actual version number is 30. That is what SetupTV looks for)
     

    Users who are viewing this thread

    Top Bottom