RC3 Failed to upgrade the database. (1 Viewer)

[MrAlan]

TV-Server Version: TVE3
MediaPortal Version: 1.0 RC2
MediaPortal Skin: XFace 1.6
Windows Version: WindowsXP SP3
CPU Type: Intel Q6600 2.4GHz
HDD: Samsung 640GB
Memory: 2GB DDR2 800
Motherboard: Gigabyte GA-EG45M-DS2H
Video Card: Onboard
Video Card Driver:
Sound Card: Onboard
Sound Card AC3: Optical Out
Sound Card Driver:
1. TV Card: Hauppauge Nova-T 500
1. TV Card Type: DVB-T
1. TV Card Driver:
2. TV Card: Hauppauge Nova-S Plus
2. TV Card Type: DVB-S
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: PowerDVD8
MPEG2 Audio Codec: AC3Filter
h.264 Video Codec: PowerDVD8
Satelite/CableTV Provider: Optus D1
HTPC Case: Antec Fusion
Cooling:
Power Supply:
Remote: Microsoft MCE Remote
TV: Sony Bravia
TV - HTPC Connection: Sub-D

I've just removed RC2 and installed RC3 on my HTPC. I run a separate MySQL server. Since installing RC3 I now get the error message: Failed to upgrade the database. Whenever I run Tv-Server Configuration.

It connected fine at the --configure-db stage, and created a new database and tables successfully.

It's showing up the error in the tv.log file which I have attached.

Any help would be greatly appreciated, in the meantime it seems I have no choice but to revert back to RC2.

 

[rtv]

2008-10-11 17:44:27.703125 [SetupTv]: ---- upgrade database schema ----
2008-10-11 17:44:27.703125 [SetupTv]: Exec SQL: USE MpTvDbRC3;ALTER TABLE `card`ADD COLUMN `preload` bit(1) NOT NULL;UPDATE `Version` SET `versionNumber`=39;
2008-10-11 17:44:27.703125 [SetupTv]: ********* SQL statement failed! *********
2008-10-11 17:44:27.703125 [SetupTv]: ********* Error reason: #42S02Table 'MpTvDbRC3.card' doesn't exist

Do you use an external DB server running Linux? Looks like it is configured to be case sensitive which doesn't work for MP.

 

[MrAlan]

Yes, Thanks. I have changed my MySQL server to be case insensitive and it appears to be working now.