When upgrading from mysql database version 56->57 the case of the table name is with lower case but should be upper case:
Reproduce:
Compile and install the mediaportal on case sensitive mysql database (Default). In last part of installation the database is created and upgraded. - crash.
Change file: ...\MediaPortal\TvEngine3\TVLibrary\SetupTv\57_upgrade_mysql_database.sql
From:
USE %TvLibrary%;
ALTER TABLE channel DROP COLUMN name;
ALTER TABLE channel DROP COLUMN freetoair;
UPDATE Version SET versionNumber=57;
To:
USE %TvLibrary%;
ALTER TABLE Channel DROP COLUMN name;
ALTER TABLE Channel DROP COLUMN freetoair;
UPDATE Version SET versionNumber=57;
Rgds
Søren Kristensen
Denmark
Reproduce:
Compile and install the mediaportal on case sensitive mysql database (Default). In last part of installation the database is created and upgraded. - crash.
Change file: ...\MediaPortal\TvEngine3\TVLibrary\SetupTv\57_upgrade_mysql_database.sql
From:
USE %TvLibrary%;
ALTER TABLE channel DROP COLUMN name;
ALTER TABLE channel DROP COLUMN freetoair;
UPDATE Version SET versionNumber=57;
To:
USE %TvLibrary%;
ALTER TABLE Channel DROP COLUMN name;
ALTER TABLE Channel DROP COLUMN freetoair;
UPDATE Version SET versionNumber=57;
Rgds
Søren Kristensen
Denmark