Unable to upgrade database (1 Viewer)

[mm1352000]

Okay try:

mysql -u MediaPortal -D MpTvDb -p

That will prompt for your password, which is MediaPortal (case sensitive). If that lets you through then you can skip step 3 and go straight to step 4.

 

[mm1352000]

got MySQL Workbench installed and working and can access MP SQL files

I can't direct you with Workbench as I've never used it...

All I'm trying to gauge is:
1. Whether the SoftwareEncoder table exists.
2. What the version number is in the Version table.

For (1) you can:
- you can connect to the database via command line and run the query in step 4
- you can connect to the database via Workbench and visually check whether the table is in the table list
- browse to the ProgramData\MySQL\data folder again and see if there are 3 SoftwareEncoder files there

For (2) you need to be able to run the last query in my earlier post (select * from Version; ), which means you need to connect to the database either via the command line or with Workbench.

mm

 

[porky996t]

Sorry didn't notice the page 2....

I just added a note to say that I have now installed Workbench and can access all the MySQL files. Is this an easier way to modify anything?


SoftwareEncoder table is not listed under mptvdb and the version number is 57

 

[mm1352000]

Does the "ChannelLinkageMap" table have a "displayName" column?

select displayName from ChannelLinkageMap;

 

[porky996t]

Does the "ChannelLinkageMap" table have a "displayName" column?

Yes it does, but there are no entries at all, under any of the four columns in the table.

 

[mm1352000]

Yes it does, but there are no entries at all, under any of the four columns in the table.

Right, that is okay. That confirms that the 52nd upgrade script was executed.

53 (the first script for 1.2.0a) wasn't executed otherwise we'd have expected the SoftwareEncoder table to exist.
54 - does the Card table have a stopgraph column (select stopgraph from Card; ) ?
55 - does the PendingDeletion table exist (select * from PendingDeletion; )?
56 - does the TuningDetail table have pcrPid, videoPid or audioPid columns (select pcrPid, videoPid, audioPid from TuningDetail; )?
57 - does the Channel table have name or freetoair columns (select name, freetoair from Channel; )?

mm

[Edit: did you ever try to upgrade to either 1.2.0a or 1.2.0b with this database?]

 

[porky996t]

54 - does the Card table have a stopgraph column (select stopgraph from Card; ) ? - YES
55 - does the PendingDeletion table exist (select * from PendingDeletion; )? - YES
56 - does the TuningDetail table have pcrPid, videoPid or audioPid columns (select pcrPid, videoPid, audioPid from TuningDetail; )? - NO
57 - does the Channel table have name or freetoair columns (select name, freetoair from Channel; )? - NO


Thanks,


M.

 

[Seidelin]

Should we move this thread to support forum, since it does not appear to be a bug in MP, but rather a slightly corrupted database?

 

[porky996t]

I'd agree Seidelin. Feel free.....


@MM

[Edit: did you ever try to upgrade to either 1.2.0a or 1.2.0b with this database?]

No, stayed on 1.1.3 as it was very stable for me and worked like a charm.

 

[mm1352000]

So it appears like only one script - the 53rd - hasn't been executed, and that is now causing the 58th to fail. Since you don't have older logs and since we now have all those details from you I don't think there is anything more that can be learned from your current database, but we might be able to learn why/if the 53rd failed (or was just never attempted). The 53rd script is attached. Please try to execute it and see what happens. After this has executed, everything should run smoothly.

*Thanks* for your help and patience!