[fixed] [SOLVED]Latest SVN - TVServer DB exceptions (1 Viewer)

[OnkelChris]

AW: Latest SVN - TVServer DB exceptions

[SetupTv(1)]:   Exec SQL: ALTER TABLE Program   DROP COLUMN notify
.
.
.
Exec SQL: ALTER TABLE Program   DROP COLUMN notify
[SetupTv(1)]:   ********* SQL statement failed! *********
[SetupTv(1)]:   ********* Error reason: Fehler bei ALTER TABLE DROP COLUMN, da die 'notify'-Spalte in der 'Program'-Tabelle nicht vorhanden ist.
[SetupTv(1)]:   ********* Error code: 4924, Line: 1 *********
[SetupTv(1)]:   Exec SQL: ALTER TABLE TuningDetail   DROP COLUMN pcrPid
[SetupTv(1)]:   ********* SQL statement failed! *********
[SetupTv(1)]:   ********* Error reason: Das Index-Objekt 'IX_TuningDetail_idChannel' ist vom Spalte-Objekt 'pcrPid' abhängig.
Fehler bei ALTER TABLE DROP COLUMN pcrPid, da mindestens ein Objekt auf diese Spalte zugreift.
[SetupTv(1)]:   ********* Error code: 5074, Line: 1 *********
[SetupTv(1)]:   Exec SQL: ALTER TABLE TuningDetail   DROP COLUMN videoPid
[SetupTv(1)]:   Exec SQL: ALTER TABLE TuningDetail   DROP COLUMN audioPid
[SetupTv(1)]:   Exec SQL: UPDATE Version SET versionNumber=56
.
.
.
[SetupTv(1)]:   Exec SQL: ALTER TABLE channel DROP COLUMN "name"
[SetupTv(1)]:   ********* SQL statement failed! *********
[SetupTv(1)]:   ********* Error reason: Das Index-Objekt 'IX_Channel_IsTV' ist vom Spalte-Objekt 'name' abhängig.
Fehler bei ALTER TABLE DROP COLUMN name, da mindestens ein Objekt auf diese Spalte zugreift.
[SetupTv(1)]:   ********* Error code: 5074, Line: 1 *********
[SetupTv(1)]:   Exec SQL: ALTER TABLE channel DROP COLUMN "freetoair"
[SetupTv(1)]:   Exec SQL: UPDATE Version SET versionNumber=57

ok... i get it now a bit... it is deleting the "notify" column... then it tries this again -> 1st fail... then tries to drop "pcrPid" but there is a dependency on "IX_TuningDetail_idChannel" -> 2nd fail... and on deleting "name" there is a dependency on IX_Channel_IsTV -> 3rd fail...

why is this just happening on my installations? should fail on all or none

 

[romuz]

Re: Latest SVN - TVServer DB exceptions

Most of us use MySQL server
but you (if i checked correctly) use MS SQL server.
is not it?
if so then it could be a root of problem

 

[OnkelChris]

AW: Latest SVN - TVServer DB exceptions

yeah.. i am using sql server 2008 express... perhaps this is the root of the problem... but there must be a solution (atm i am fighting with the database and sql server management studio ^^)

 

[romuz]

Re: Latest SVN - TVServer DB exceptions

If you do it manually, Could you generate and upload commands executed in ms sql

 

[OnkelChris]

AW: Latest SVN - TVServer DB exceptions

got it

i only have to figure out, how to get the statements in the correct order... will report back


EDIT:
could someone please upload his mySQL database or better: a complete report which tables consists of which columns... don't know how the failures are handled in the MP scripts...

 

[OnkelChris]

AW: Latest SVN - TVServer DB exceptions

OK... Finally I did it.. here is the solution... does work without any failures in upgrading. due to the lack of a mySQL database I do not know if it is 100% correct. I only replaced the parts which ran into failures... So here it is for SVN 27200:

 

[romuz]

Re: Latest SVN - TVServer DB exceptions

MP works with different db types separately so it doesnt affect mysql. And thank you for sharing results

 

[OnkelChris]

AW: Re: Latest SVN - TVServer DB exceptions

MP works with different db types separately so it doesnt affect musql

yeah, but tvserver relies on the same tables and columns... i just wanted a original mySQL database in version 57 to compare with my database, so every table has the right columns

 

[Jay_UK]

Re: Latest SVN - TVServer DB exceptions

Hi there,

Weird..how come it worked for me ? (or am I being dumb and not seeing the failure???)

Looking at your SQL/patch...would not recreating indexes and droping columns cause the install to fail? (just curious)

Thanks,

J.

ps - Glad you sorted it

 

[romuz]

Re: Latest SVN - TVServer DB exceptions

now it should be the same, except the indexes )