[Bug] MediaPortal 1.3 beta Failed to update database (2 Viewers)

[findftp]

I have a clean windows 7 x64 with a completely uninstalled 1.2.3 version.
Upgrading gave the same error, so I did a complete uninstall with no avail.
Now I will try to uninstall mysql too.

 

[MaxMan23]

Me too.
I can watch TV, but if i try to open the tvsetup i got this message

 

[mm1352000]

Hello

Thank you for the reports and especially for the log files.
I've moved the thread to the MP 1.3 beta bug report section where it won't be missed.

It looks like the issue is here:

2012-12-15 05:42:39.193543 [SetupTv(1)]: ---- upgrade database schema ----
2012-12-15 05:42:39.199544 [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-15 05:42:39.200544 [SetupTv(1)]: ********* SQL statement failed! *********
2012-12-15 05:42:39.201544 [SetupTv(1)]: ********* Error reason: Duplicate column name 'channelNumber'
2012-12-15 05:42:39.201544 [SetupTv(1)]: ********* Error code: 1060 *********

Are you 100% sure you didn't attempt the update multiple times or install an unofficial version of the beta before it was released?

mm

 

[mm1352000]

@findftp
Do you also use a MySQL database?
Could you please also provide your log files so we can check if both of you are seeing the same problem.

Thanks,
mm

 

[MaxMan23]

...or install an unofficial version of the beta before it was released?

No
But you can help me anyway?

 

[mm1352000]

No
But you can help me anyway?

We do not provide support for upgrading from custom/unofficial builds because the DB state can't be guaranteed. Please keep this in mind before trying such builds in the future. It is sometimes hard to wait for the release, but it saves problems like this.

You need to run the following SQL query to revert the state of your database:

ALTER TABLE Channel DROP COLUMN ChannelNumber;

You can either use MySQL Workbench (or MySQL GUI Tools) or command in DOS prompt like:

mysql -u root -p -e "ALTER TABLE Channel DROP COLUMN ChannelNumber;" mptvdb

After that the upgrade should succeed.

Marking the thread as "no bug".

 

[MaxMan23]

Sorry again. It does not work for me.. (and i will never do this again )
Is your mysql version the same?

 

[mm1352000]

Ah, okay.
You're in the MySQL command prompt. That is good. You can just enter:

use MpTvDb;
ALTER TABLE Channel DROP COLUMN ChannelNumber;

No need for the "mysql -u ..." stuff

mm

 

[MaxMan23]

I tried bevor, but i got another error...
Maybe Versions conflict?

 

[mm1352000]

There are two commands. I think you got the first one wrong. It should be "use MpTvDb;". Note that the semi colon ( is important. After you enter that command press enter. Then enter the second command and press enter.