[Bug] MediaPortal 1.3 beta Failed to update database (1 Viewer)

[Mouch.net]

I'm having the exact same error as MaxMan23 after upgarding from 1.3.0 Alpha (no custom build here)

What makes you so sure it is exactly the same. Please provide log files so we can check!

I'm seeing the same SQL error:

2012-12-17 15:47:36.654477 [SetupTv(1)]: ---- SetupTv v1.2.200.0 is starting up on Windows 7 ( Service Pack 1 ) [6.1.7601.65536]
2012-12-17 15:47:36.757483 [SetupTv(1)]: ---- check connection with database ----
2012-12-17 15:47:37.560529 [SetupTv(1)]: SetupDatabaseForm: Added dependency for TvService - MySQL
2012-12-17 15:47:37.644534 [SetupTv(1)]: ---- check if database needs to be updated/created ----
2012-12-17 15:47:37.737539 [SetupTv(1)]: ---- upgrade database schema ----
2012-12-17 15:47:37.850546 [SetupTv(1)]:  Exec SQL: USE MpTvDb;ALTER TABLE `Channel` ADD COLUMN `channelNumber` int(11) NOT NULL DEFAULT 10000;UPDATE Channel c set c.channelNumber = (SELECT t.channelNumber FROM TuningDetail t WHERE t.idChannel = c.idChannel ORDER BY t.idTuning limit 1);UPDATE Version SET versionNumber=61;
2012-12-17 15:47:37.941551 [SetupTv(1)]:  ********* SQL statement failed! *********
2012-12-17 15:47:38.003554 [SetupTv(1)]:  ********* Error reason: Duplicate column name 'channelNumber'
2012-12-17 15:47:38.084559 [SetupTv(1)]:  ********* Error code: 1060 *********

I removed the column per SQL console successfully and it was then created again without error:

2012-12-17 15:56:04.310514 [SetupTv(1)]: ---- SetupTv v1.2.200.0 is starting up on Windows 7 ( Service Pack 1 ) [6.1.7601.65536]
2012-12-17 15:56:04.386518 [SetupTv(1)]: ---- check connection with database ----
2012-12-17 15:56:04.541527 [TvClient-TvHome: HeartBeat transmitter thread(88)]: TCP connect took : 12
2012-12-17 15:56:04.607531 [TvClient-TvHome: HeartBeat transmitter thread(88)]: RemoteControl - Connected
2012-12-17 15:56:04.952550 [SetupTv(1)]: SetupDatabaseForm: Added dependency for TvService - MySQL
2012-12-17 15:56:05.034555 [SetupTv(1)]: ---- check if database needs to be updated/created ----
2012-12-17 15:56:05.118560 [SetupTv(1)]: ---- upgrade database schema ----
2012-12-17 15:56:05.204565 [SetupTv(1)]:  Exec SQL: USE MpTvDb;ALTER TABLE `Channel` ADD COLUMN `channelNumber` int(11) NOT NULL DEFAULT 10000;UPDATE Channel c set c.channelNumber = (SELECT t.channelNumber FROM TuningDetail t WHERE t.idChannel = c.idChannel ORDER BY t.idTuning limit 1);UPDATE Version SET versionNumber=61;

SetupTV stopped with an error again though, which is probably the same that happened while upgrading:

2012-12-17 15:56:35.373290 [SetupTv(1)]:  ********* SQL statement failed! *********
2012-12-17 15:56:35.435294 [SetupTv(1)]:  ********* Error reason: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
2012-12-17 15:56:35.498297 [SetupTv(1)]:  ********* Error code: 0 *********

 

[mm1352000]

Thanks Mouch.net

That timeout error is possibly the issue. How many channels do you have in your DB?

mm

 

[Mouch.net]

Thanks Mouch.net

That timeout error is possibly the issue. How many channels do you have in your DB?

mm

Not sure about the amount of used channels (I would say about 30), but the channel table has 3476 lines...

I tried to increase the Timeout in Gentle.config from 30 to something higher, but it doesn't seem to have any effect.

So I executed all the SQL commands in the console... The update of the channelNumber took about 70seconds. Everything seem to work fine now

 

[benrom]

Hello !
I have the same problem : I tried to update from 1.2.3 to 1.3 beta, it failed, then I uninstalled, cleaned my PC, but now still there are no traces of MP nor MySQl, every attempt to install MP 1.2.3 fails, when the tv server tries to start and I get this message (see picture).
I'm on Win8 64bits

Can anyone help me?
Ben.

 

[Guzzi]

Hi mm1352000,
I just upgraded my TV-Server to 1.3beta and had an issue with the upgrade script, using MSSQL:

´╗┐2012-12-27 04:18:56.169816 [SetupTv(1)]: ---- started in Deploy mode ----
2012-12-27 04:18:56.263567 [SetupTv(1)]: ---- SetupTv v1.2.200.0 is starting up on Windows XP ( Service Pack 3 ) [5.1.2600.196608]
2012-12-27 04:18:56.263567 [SetupTv(1)]: ---- check connection with database ----
2012-12-27 04:19:25.889136 [SetupTv(1)]: SetupDatabaseForm: Added dependency for TvService - SQLBrowser
2012-12-27 04:19:26.232893 [SetupTv(1)]: ---- SetupDatabaseForm: server = xtv-gmi-01, local = True
2012-12-27 04:19:26.764153 [SetupTv(1)]: ---- check if database needs to be updated/created ----
2012-12-27 04:19:27.686046 [SetupTv(1)]: ---- upgrade database schema ----
2012-12-27 04:19:28.826693 [SetupTv(1)]:  Exec SQL: USE MpTvDb;
2012-12-27 04:19:28.920444 [SetupTv(1)]:  Exec SQL: ALTER TABLE Channel ADD channelNumber INT NOT NULL CONSTRAINT [DF_Channel_ChannelNumber] DEFAULT 10000
2012-12-27 04:19:30.373597 [SetupTv(1)]:  Exec SQL: UPDATE Channel SET channelNumber = (SELECT TOP 1 t.channelNumber FROM TuningDetail AS t WHERE t.idChannel = channel.idChannel ORDER BY t.idTuning)
2012-12-27 04:19:33.608034 [SetupTv(1)]:  ********* SQL statement failed! *********
2012-12-27 04:19:33.608034 [SetupTv(1)]:  ********* Error reason: Cannot insert the value NULL into column 'channelNumber', table 'MpTvDb.dbo.Channel'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
2012-12-27 04:19:33.608034 [SetupTv(1)]:  ********* Error code: 515, Line: 1 *********
2012-12-27 04:19:33.608034 [SetupTv(1)]:  Exec SQL: UPDATE Version SET versionNumber=61

The current 61 script tries:

UPDATE Channel SET channelNumber = (SELECT TOP 1 t.channelNumber FROM TuningDetail AS t WHERE t.idChannel = channel.idChannel ORDER BY t.idTuning)

which is imho wrong. If I understand right, we want to duplicate the TuningDetails.channelNumber into the new Channel.channelNumber, right?
I think we should do something like:

UPDATE Channel
SET channelNumber = (SELECT TOP 1 t.channelNumber ORDER BY t.idTuning)
FROM TuningDetail as t INNER JOIN Channel as c
ON t.idChannel = c.idChannel

Does that make sense for you?

 

[pur_berger]

So - what is the solution for this - just did the Upgrade (or tried to do it) from 1.3.alpha and got also teh error:

2013-01-17 12:40:23.005926 [SetupTv(1)]: ---- started in Deploy mode ----
2013-01-17 12:40:23.011926 [SetupTv(1)]: ---- SetupTv v1.2.200.0 is starting up on Windows 7 ( Service Pack 1 ) [6.1.7601.65536]
2013-01-17 12:40:23.017927 [SetupTv(1)]: ---- check connection with database ----
2013-01-17 12:40:23.160935 [SetupTv(1)]: SetupDatabaseForm: Added dependency for TvService - MySQL
2013-01-17 12:40:23.165935 [SetupTv(1)]: ---- SetupDatabaseForm: server = Mediacenter, local = True
2013-01-17 12:40:23.168935 [SetupTv(1)]: ---- check if database needs to be updated/created ----
2013-01-17 12:40:23.175936 [SetupTv(1)]: ---- upgrade database schema ----
2013-01-17 12:40:23.183936 [SetupTv(1)]: Exec SQL: USE MpTvDb;ALTER TABLE `Channel` ADD COLUMN `channelNumber` int(11) NOT NULL DEFAULT 10000;UPDATE Channel c set c.channelNumber = (SELECT t.channelNumber FROM TuningDetail t WHERE t.idChannel = c.idChannel ORDER BY t.idTuning limit 1);UPDATE Version SET versionNumber=61;
2013-01-17 12:40:23.186936 [SetupTv(1)]: ********* SQL statement failed! *********
2013-01-17 12:40:23.188936 [SetupTv(1)]: ********* Error reason: Duplicate column name 'channelNumber'
2013-01-17 12:40:23.190937 [SetupTv(1)]: ********* Error code: 1060 *********
2013-01-17 12:40:29.165278 [SetupTv(1)]: ---- SetupTv v1.2.200.0 is starting up on Windows 7 ( Service Pack 1 ) [6.1.7601.65536]
2013-01-17 12:40:29.171279 [SetupTv(1)]: ---- check connection with database ----
2013-01-17 12:40:29.316287 [SetupTv(1)]: SetupDatabaseForm: Added dependency for TvService - MySQL
2013-01-17 12:40:29.319287 [SetupTv(1)]: ---- check if database needs to be updated/created ----
2013-01-17 12:40:29.328288 [SetupTv(1)]: ---- upgrade database schema ----
2013-01-17 12:40:29.337288 [SetupTv(1)]: Exec SQL: USE MpTvDb;ALTER TABLE `Channel` ADD COLUMN `channelNumber` int(11) NOT NULL DEFAULT 10000;UPDATE Channel c set c.channelNumber = (SELECT t.channelNumber FROM TuningDetail t WHERE t.idChannel = c.idChannel ORDER BY t.idTuning limit 1);UPDATE Version SET versionNumber=61;
2013-01-17 12:40:29.340288 [SetupTv(1)]: ********* SQL statement failed! *********
2013-01-17 12:40:29.342288 [SetupTv(1)]: ********* Error reason: Duplicate column name 'channelNumber'
2013-01-17 12:40:29.344289 [SetupTv(1)]: ********* Error code: 1060 *********

 

[elliottmc]

Which log is this error in?

 

[pur_berger]

Which log is this error in?

TV Server install log

 

[elliottmc]

Which log is this error in?

TV Server install log

I don't see anything like that in my logs, but I have done several installs since updating to beta so perhaps this is expected.

 

[pur_berger]

Which log is this error in?

TV Server install log

I don't see anything like that in my logs, but I have done several installs since updating to beta so perhaps this is expected.

I would say it's the same error as guzzi (post above) has - coming from 1.3 alpha and I can't access TV server config (failed to upgrade the Database) still tv server is working.