[Approved] Fix MySQL Case Sensitive (1 Viewer)

esdk

New Member
April 16, 2011
1
1
Denmark Denmark
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
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

OP Similar threads Forum Replies Date
framug [solved] Some changes/fix in MP1 configuration client and server Submit: code patches (MediaPortal/TV-Server/etc.) 14
framug [Approved] Fix Irtrans config bug Submit: code patches (MediaPortal/TV-Server/etc.) 4
W [solved] [FIXED] Survivor season 40 not automatically matching My TVSeries 1
P [solved] ATSC subtitles not fixed yet? General 2
framug [Rejected] Fix PowerScheduler plugin for MP2 single seat Submit: Code Patches 9
M [Pending] Fix for Inconsistent date display in TV Guide Submit: code patches (MediaPortal/TV-Server/etc.) 1
doskabouter [Proposal] Merge PR Fix for source directory with spaces MediaPortal 1 15
CyberSimian Fixes for Amped aMPed 5
CyberSimian Fixes for Amped skin MediaPortal 1 10
I [solved] Connection to TV Server MySQL General Support 8
vapourEyes Maria DB instead of MySQL MediaPortal 1 Talk 0
azzuro [WiP] MP1-5019: Replace MySQL with MariaDB MediaPortal 1 40
R Problems accessing MySQL database remotely MediaPortal 1 Talk 0
W Setup data connection - mySQL connection failed Installation, configuration support 1
doskabouter No guide info added due to a MYSQL deadlock Electronic Program Guide 1
CyberSimian Is MySQL misconfigured? MediaPortal 1 5
D Full fuctional htpc - Silverstone Case - Digital Devices Cine S2 - SSD - IR Remote For Sale 1
doskabouter 1.23.0 MatroskaTagInfo uses the wrong casing for tags Bugreports 27
A TV Channel Combination - case issue Television (MyTV frontend and TV-Server) 0
azzuro [MP2-753] Fanart for previous item displayed in some cases Archive 3
Top Bottom