Failed to create database - initial installation (1 Viewer)

[idiamant]

MediaPortal Version: 1.10 RC1
MediaPortal Skin:
Windows Version: Windows 7 Ultimate
CPU Type: Quad Core Q6600
HDD: 500GB
Memory: 2GB
Motherboard:
Video Card: Nvidia Gforce 8800GT
Video Card Driver:
Sound Card:
Sound Card AC3:
Sound Card Driver:
1. TV Card: Hauppauge PVR 150
1. TV Card Type:
1. TV Card Driver:
2. TV Card:
2. TV Card Type:
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:
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote:
TV:
TV - HTPC Connection:



Hi!
I am trying to install the Media Portal 1.10 RC1, and getting an error during the initial running of the TV Server configuration.
I have configured the database server to connect to, and for some reason it says it failed to create database. Then I tried again, and it said it failed to upgrade database.
I have tried to drop the database from the mysql, and let it recreate it, but still gives me the same messages.
what's the cause for it, and how do I solve it?
This is a computer where mysql was already installed, and is used for other stuff as well, so I didn't install the mysql from mediaportal's installation.


Thanks,

Ido

 

[rtv]

AW: Failed to create database - initial installation

Without logs you won't receive any help...
Likely your mysql isn't configured for case insensitive table names

 

[idiamant]

Re: AW: Failed to create database - initial installation

Hi,

Attached the log file:

Ido Diamant [text] Paste - A9WiWakn - Pastebin.com

The log says the following error inside:

2010-02-23 17:55:04.629227 [SetupTv(1)]: Exec SQL: CREATE TABLE `Schedule` (`id_Schedule` int(11) NOT NULL auto_increment,`idChannel` int(11) NOT NULL,`scheduleType` int(11) NOT NULL,`programName` varchar(256) NOT NULL,`startTime` datetime NOT NULL,`endTime` datetime NOT NULL,`maxAirings` int(11) NOT NULL,`priority` int(11) NOT NULL,`directory` varchar(1024) NOT NULL,`quality` int(11) NOT NULL,`keepMethod` int(11) NOT NULL,`keepDate` datetime NOT NULL,`preRecordInterval` int(11) NOT NULL,`postRecordInterval` int(11) NOT NULL,`canceled` datetime NOT NULL,`recommendedCard` int(11) NOT NULL,PRIMARY KEY (`id_Schedule`),KEY `FK_Schedule_Channel` (`idChannel`),KEY `IDX_Schedule_ScheduleType` (`scheduleType`),KEY `IDX_Schedule_ProgramName` (`programName`),KEY `IDX_Schedule_StartTime` (`startTime`),KEY `IDX_Schedule_EndTime` (`endTime`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
2010-02-23 17:55:04.629227 [SetupTv(1)]: ********* SQL statement failed! *********
2010-02-23 17:55:04.629227 [SetupTv(1)]: ********* Error reason: BLOB/TEXT column 'programName' used in key specification without a key length
2010-02-23 17:55:04.629227 [SetupTv(1)]: ********* Error code: 1170 *********

Thanks,

Ido